ORA-12523: TNS: 监听程序未找到适用于客户机连接的例程

[liulif]

大家好！
请教大家一个问题，我在Windows 2003 Server +SP2上安装了一个Oracle 9I的数据库，为了做备份与恢复试验，创建了TESTDB TESTDB2 TESTDB3 DCTDB这几个数据库实例，我在TESTDB中创建了一个用户BSWXWMS，下面有一张表Admin,里面放了一些用户信息，我用RMAN备份完后，将表ADMIN删除，然后再用RMAN恢复，但是很奇怪，我进入Sqlplusw /nolog -->Conn Sys/sys@testdb as sysdba后，报错：“ora-12523 TNS: 监听程序未找到适用于客户机连接的例程”,但是很奇怪，
我同样 Conn sys/sys@testdb2 as sysdba后没有问题，测试其它的几个数据库也没有问题。
而且监听器好像也没有问题。
请大家指教。

[liulif]

# TNSNAMES.ORA Network Configuration File: c:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP.BRIDGESTONEWX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.160)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

DCTDB.BRIDGESTONEWX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DCTDB)
)
)

TESTDB.BRIDGESTONEWX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.160)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB)
)
)

EXTPROC_CONNECTION_DATA.BRIDGESTONEWX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)

......
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

TESTDB2.BRIDGESTONEWX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.160)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB2)
)
)

[suntree2007]

把你的*:\oracle\ora92\network\admin\listener.ora文件的内容贴出来给我看下

[liulif]

其中的内容如下：
# LISTENER.ORA Network Configuration File: c:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.160)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TESTDB)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = TESTDB)
)
)

[cst4023]

吧tnsnames.ora贴出来