大家好!
请教大家一个问题,我在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后没有问题,测试其它的几个数据库也没有问题。
而且监听器好像也没有问题。
请大家指教。
请教大家一个问题,我在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后没有问题,测试其它的几个数据库也没有问题。
而且监听器好像也没有问题。
请大家指教。
# 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)
)
)
# 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)
)
)