net8 assistant测试配置服务名报出没有监听器错误 要先把监听启动起来,c:\>lsnrctllsnrctl>start 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 建立好數據庫后,配置net8,并且測試通過就ok了 如果建立數據庫的時候沒有執行典型配置的話,會沒有監聽器,這個時候到net8 configuration assistant里面建立監聽器即可。 监听器启动正常的呀,查看listener日志: TNS-12502: TNS:监听器未从客户机收到 CONNECT_DATA 说明没客客户机连结 而客户端却出错说没有监听器。就是说服务端在监听,客户端也在请求但它们连结不上。捡查listener.ora文件和tnsnames.ora 文件应该也没什么问题的。listener.ora文件如下:# LISTENER.ORA Network Configuration File: C:\Oracle\iSuites\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 2481)) (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) ) )tnsnames.ora 文件如下:# TNSNAMES.ORA Network Configuration File: C:\Oracle\iSuites\network\admin\tnsnames.ora# Generated by Oracle configuration tools.TEST.ZJCWCO.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORADB) ) ) 执行一下:tnsping test.zjcwco.com看看能不能ping通?如果不通,说明泥的服务名配的有问题~ 用ipc可测试通过 TEST.ZJCWCO.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0)) ) (CONNECT_DATA = (SERVICE_NAME = oradb) ) ); 用tpc 就测试通不过了TEST.ZJCWCO.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORADB) ) ),不会是服务名问题吧。 求一最高效的sql语句 求一个sql计算:各班数学分数高于班级平均分的学生 oracle 9i 如何设置最小访问权限 如何用一条sql语句实现数据分列 请教高手一个查询语句应该怎么写 关于备份恢复 !!!!! 如何判断 是应用程序须改的还是触发器修改的 怎样修改一个表的列名? 请教关于查询问题 触发器如何书写,关于新增数据的导入导出? oracle莫名其妙出问题。请看 谁知道在哪能下载oracle8.1.6?谢谢了!
TNS-12502: TNS:监听器未从客户机收到 CONNECT_DATA 说明没客客户机连结 而客户端却出错说没有监听器。就是说服务端在监听,客户端也在请求但它们连结不上。捡查listener.ora文件和tnsnames.ora 文件应该也没什么问题的。listener.ora文件如下:
# LISTENER.ORA Network Configuration File: C:\Oracle\iSuites\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)tnsnames.ora 文件如下:
# TNSNAMES.ORA Network Configuration File: C:\Oracle\iSuites\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TEST.ZJCWCO.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORADB)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
); 用tpc 就测试通不过了TEST.ZJCWCO.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YuanY)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORADB)
)
)
,不会是服务名问题吧。