代理连接到实例状态
失败的细节
ORA-12505:
TNS:监听器当前不知道连接描述符中给出的SID(DBD ERROR:OCIServerAttach)
监听器文件
listener.ora Network Configuration File:
E:\程序\管理\产品\ 11.2.0 \ dbhome_1 \网络\ 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网络配置文件:
E:\程序\管理\产品\ 11.2.0 \ dbhome_1 \网络\ 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"
2 回答
这个问题可能有多种原因:
最近我遇到了与Windows 7机器上的Oracle 11g类似的问题 . 我发现在
services.msc
中,OracleOraDb11g_home1ClrAgent
未启动且其启动类型设置为MANUAL .我将启动类型更改为AUTOMATIC并手动启动
OracleOraDb11g_home1ClrAgent
,之后我能够正确连接 .所以基本原因是
OraClrAgnt
没有运行 .由于其他原因,您可以查看this link .
lsnrctl status命令回复"The listener supports no services" . 有一个网络侦听器正在运行但尚未告知任何数据库 .
您需要为listener.ora file添加服务 . 像下面一样向你的listener.ora添加一个sid_list,然后重启监听器 .