Chinaunix

标题: [紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台) [打印本页]

作者: net-wolf 时间: 2004-11-10 21:40
标题: [紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台)
Win2k sp4平台，内存 512M 硬盘空间足够。
sqlplus 确认数据库已经启动.
可是登录 http://localhost:5500/em 以sys用户登录后总是显示数据库状态为 down ?
我查看 alter_ORCL.log 没有发现任何错误信息。收集
$ORACLE_HOME\OC4J_DBConsole_IBM-Station_orcl\LOG 目录下和 $ORACLE_HOME\IBM-Station_orclSYSMAN\LOG 目录下的日志信息打包见附件，摘要信息如下

emoms.log 文件

----------------------------------------
2004-11-10 17:24:28,140 [HttpRequestHandler-18452466] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://IBM-Station:1830/emd/main)(ERROR = INTERNAL_ERROR)
2004-11-10 17:24:29,109 [OMSHeartbeatThread] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-Station)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2004-11-10 17:24:29,125 [NotificationMgrThread] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-Station)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2004-11-10 17:24:29,484 [XMLLoader0] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-Station)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2004-11-10 17:24:29,500 [PingHeartBeatRecorder] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-Station)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

2004-11-10 17:24:29,515 [Job Dispatcher Thread] ERROR conn.ConnectionService verifyRepositoryEx.391 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-Station)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

----------------------------------------

emagent.trc
----------------------------------------
SQL = " OCIServerAttach"...
LOGIN = dbsnmp/<

W>;@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM-Station)(PORT=1521))(CONNECT_DATA=(SID=orcl)))
2004-11-10 17:19:37 Thread-2276 ERROR vpxoci: ORA-12638: 身份证明检索失败
2004-11-10 17:19:37 Thread-2276 WARN vpxoci: Login 0x19c5d70 failed, error=ORA-12638: 身份证明检索失败
2004-11-10 17:19:37 Thread-2276 WARN TargetManager: Exception in computing dynamic properties of {orcl, oracle_database },MonitorConfigStatus::ORA-12638: 韬?唤璇佹槑妫

IBM-Station_orcl.rar.jpg

118.89 KB, 下载次数: 1338

oem 错误信息,扩展名改为 rar 即可解压缩。 http://bbs.chinaunix.net/forum/download.php?id=76032

作者: 1stdown 时间: 2004-11-11 00:11
标题: [紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台)
restart lsnrctl

and

make sure your OS user that has "run as batch job" privilage,

check it from "local security policy" in "control panel"

作者: net-wolf 时间: 2004-11-11 07:17
标题: [紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台)

原帖由 "1stdown" 发表：
restart lsnrctl

and

make sure your OS user that has "run as batch job" privilage,

check it from "local security policy" in "control panel"

谢谢！
lsnrctl 状态正常，sqlplus 可以通过 sqplus sys/sys@orcld 登录。
"run as batch job "权限已经赋予Administrator了。
我仔细看了看日志，好像是 sqlnet.ora 的问题，emagent无法连接数据库。今天再试试看。有个metalink帐号就好了。

作者: net-wolf 时间: 2004-11-11 21:31
标题: [紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台)
是 sqlnet.ora 的问题，把 NTS 改为 NONE ，然后
emctl stop dbconsole
emctl start dbconsole
即可。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)