Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.
监听程序:LISTENER
选定协议:TCP
端口:1521
但还是不行,请问你是这样配置吗?还需要配置其他什么东西呢?请指教,谢谢。
解决方法:
1、如果是因为修改了NT的机器名,则把listener.ora文件中的host参数全部改为新的NT机器名,
重新启动OracleTNSListenr80服务即可。
例如:
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = NT_Name)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = NT_Name)(Port = 1526))
)
2。使用监听器实用程序:LSNRCTL80.exe
3。检查监听器参数文件:c:\orant\NET80\admin\listener.ora
4。检查监听器日志文件:c:\orant\NET80\log\listener.log
5。Tnsnames.ora文件配置错误,重新配置。
6。检查client 端 Tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hbpc)(PORT = 1521))
)
)
)# TNSNAMES.ORA Network Configuration File: E:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oraDB)
)
)