求教oracle9i的监听进程不能解析在连接描述符中给出的SERVICE_NAME问题
各位高手,小弟服务器为2003,用oracle9i数据库,本来好好的,小弟昨天添加了一个监听listener1,结果提示冲突,等小弟启动listener1监听后发现原来的数据库监听不到了,提示“监听进程不能解析在连接描述符中给出的SERVICE_NAME问题”我把所有监听都删除了重新配置也不行,小弟研究了一下午也没有解决问题,但是通过这个监听监听其他服务器上的数据库可以成功,我对比了一下,都没有什么问题,请教高手我该怎么办,小弟拜谢~~
现监听为listener3
# LISTENER.ORA Network Configuration File: C:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
SID_LIST_LISTENER3 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ZHLDQZB)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = ZHLDQZB)
)
)
tnsnames.ora文件如下
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
BJZJW_218.8.245.6 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.8.245.6)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = BJZJW)
)
)
ZHLDQZB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZHLDQZB)
)
)
现在BJZJW可以连通,但是ZHLDQZB就连不同了,求高手给看看,谢谢了