ora:12505:TNS:侦听器当前不知道连接描述符中给出的SID(DBD错误:OCIServerAttach) [英] ora:12505:TNS: listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
问题描述
与实例的代理连接
状态
失败的
详细信息
ORA-12505:
Agent Connection to Instance
Status
Failed
Details
ORA-12505:
TNS:listener当前不知道连接描述符中给出的SID(DBD错误:OCIServerAttach)
TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
侦听器文件
listener.ora网络配置文件:
E:\ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ listener.ora
E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.52.209)(PORT = 1521))
)
)
ADR_BASE_LISTENER = E:\app\Administrator
tnsnames.ora 文件
tnsnames.ora网络配置文件:
tnsnames.ora Network Configuration File:
E:\ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ tnsnames.ora
E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
EDSS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.52.209)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = edss)
)
)
收听者状态
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-MAR-2014 09:06:11
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 16-MAR-2014 16:50:30
Uptime 0 days 16 hr. 15 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File e:\app\administrator\diag\tnslsnr\server\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.52.209)(PORT=1521)))
The listener supports no services
The command completed successfully
"Agent connection to instance status is failed. I could not find out where is the issue"
推荐答案
The lsnrctl status
command replied "The listener supports no services". There is a network listener running but it hasn't been told about any databases.
您需要向监听器中添加服务. ora文件.如下所示,将sid_list添加到您的listener.ora中,然后重新启动监听器.
You need to add services to your listener.ora file. Add a sid_list to your listener.ora like below, then restart the listener.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.52.209)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(GLOBAL_DBNAME=edss.your.domain.here)
(ORACLE_HOME=E:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME=edss)
)
)
ADR_BASE_LISTENER = E:\app\Administrator
这篇关于ora:12505:TNS:侦听器当前不知道连接描述符中给出的SID(DBD错误:OCIServerAttach)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!