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

2008-05-06 09:12:54 1.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

oracle共享服务器配置（ora-12523 tns 监听程序未找到适用于客户机连接的例程） oracle共享服务器配置（ora-12523 tns 监听程序未找到适用于客户机连接的例程）阅读详情

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

...全文

【原创工具 | OpenCV-CamCalib】一个基于 OpenCV 的自动化相机数据采集和标定程序一个基于OpenCV的自动化相机数据采集和标定程序。系统内置相机地址默认为 0。阅读详情

liulif

基础和管理 17,379 成员 95,111 内容

+ 关注 + 加入社区

切换为时间正序

cst4023 2008-05-06

打赏
举报

吧tnsnames.ora贴出来

liulif 2008-05-06

打赏
举报

其中的内容如下：
# 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)
)
)

suntree2007 2008-05-06

打赏
举报

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

liulif 2008-05-06

打赏
举报

# 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)
)
)

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

相关推荐