最近想学oracle,于是在自己的xp机器上装了一个oracle9i的客户端,可在连接sql*plus的时候老是提示ORA-12541: TNS:没有监听器的错误,我也在论坛里搜并看了很多同学的错误报告及热心网友的解答可还是不管用啊
listener.ora文件如下:
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tel-0ed859ecac0)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
)
tnsnames.ora内容如下:
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORA9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.77)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9)
)
)ORA9_192.168.8.77 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.77)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora9)
(SERVER = DEDICATED)
)
)
有老师说把主机名换成127.0.0.1,我试过了不行
还有说防火墙,我关了也不行,我已经反复重做了几遍监听程序的配置和本地Net服务名配置问题依旧,每次在配置本地Net服务名时的最后一步进行测试时也总是提示说ORA-12541: TNS:没有监听器!请高手指点下菜鸟,到底是怎么回事啊,连最基本的本地Net服务都通不过,555555555555555555
listener.ora文件如下:
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tel-0ed859ecac0)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
)
tnsnames.ora内容如下:
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORA9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.77)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9)
)
)ORA9_192.168.8.77 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.77)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora9)
(SERVER = DEDICATED)
)
)
有老师说把主机名换成127.0.0.1,我试过了不行
还有说防火墙,我关了也不行,我已经反复重做了几遍监听程序的配置和本地Net服务名配置问题依旧,每次在配置本地Net服务名时的最后一步进行测试时也总是提示说ORA-12541: TNS:没有监听器!请高手指点下菜鸟,到底是怎么回事啊,连最基本的本地Net服务都通不过,555555555555555555
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货