解决办法:
一、listener.ora 文件中
- # listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
- # Generated by Oracle configuration tools.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (SID_NAME = orcl) #网络上的服务名称
- (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) #这里一定要配置正确
- #(PROGRAM = extproc)
- (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
- )
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
- (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
- )
- )
- ADR_BASE_LISTENER = D:\app\Administrator
(PROGRAM = extproc) 把这句话注释掉重启监听服务就好了。
二、sqlnet.ora文件
修改oracle的网络配置文件,具体做法是:在oracle安装目录下搜索sqlnet.ora文件,一般在$\NETWORK\ADMIN目录下,
用记事本打开把文件中的一行:
SQLNET_AUTHENTICATION_SERVICES= (NTS)
修改为:
SQLNET_AUTHENTICATION_SERVICES= (NONE)同时修改监听器配置文件,具体做法是: 在oracle安装目录下搜索listener.ora文件,一般在$\NETWORK\ADMIN目录下,把主机名用ip地址代替,例如(ADDRESS = (PROTOCOL = TCP)(HOST = HBONLINE1)(PORT = 1523))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1523))。