免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3161 | 回复: 3
打印 上一主题 下一主题

[紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台) [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-11-10 21:40 |只看该作者 |倒序浏览
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

论坛徽章:
0
2 [报告]
发表于 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"

论坛徽章:
0
3 [报告]
发表于 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帐号就好了。

论坛徽章:
0
4 [报告]
发表于 2004-11-11 21:31 |只看该作者

[紧急]OEM在10g下总是认为DB状态为 DOWN (Win2k平台)

是 sqlnet.ora 的问题 , 把 NTS 改为 NONE ,然后
emctl stop dbconsole
emctl start dbconsole
即可。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP