1:IP改动引起的。
tnsnames.ora内容如下
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.168.0.105)
)
)
listener.ora内容如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.105)(PORT = 1521))
)
tnsnames.ora内容如下
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.168.0.105)
)
)
listener.ora内容如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.105)(PORT = 1521))
)
)
TNS-12560:TNS:协议适配器错误
我用"netstat -aon|findstr 1521"查看,1521这个端口没有被使用
4:环境变量是否正确
1:注册表中
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/services/OracleOraDb11g_home1TNSListener
中的ImagePath改为:
D:/oracle_11g/product/11.1.0/db_1/BIN/TNSLSNR.EXE(之前后面的.EXE没有)
2:环境变量中
ORACLE_HOME改为:D:/oracle_11g/product/11.1.0/db_1(之前为空)