解析：Oracle 10g EM Database Console

新客网 XKER.COM 2007-08-10 来源： lll 收藏本文

症状：

进入EM控制台（http://172.19.111.38:1158/em）后，没有输入用户名和密码就直接登陆并显示数据库状态信息；

另外刚开始数据库监听没有起来，所以EM控制台显示信息也是说监听没有起来，后来监听起来了，EM控制台还是显示旧信息，刷新页面也那样。

问题原因和解决办法：

重启控制台服务后也没有效果：

$ emctl status dbconsole
$ emctl stop dbconsole        
$ emctl start dbconsole

可能时原先监听未成功启动过，或者由于我修改过监听端口（1521改成1528）造成的。

重建em资料库：

$ emctl stop dbconsole
$ emca -repos recreate
...
Enter the following information:
Database SID: orcl10
Listener port number: 1528
Password for SYS user: oracle10 
Password for SYSMAN user: oracle10 
Do you wish to continue? [yes(Y)/no(N)]: y
...
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 19, 2007 6:20:22 PM

配置dbcontrol：

$ emca -config dbcontrol db
Enter the following information:
Database SID: orcl10
Database Control is already 
configured for the database orcl10
You have chosen to configure 
Database Control for managing
the database orcl10
This will remove the existing configuration 
and the default settings and perform a fresh 
configuration
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1528
Password for SYS user: oracle10
Password for DBSNMP user: oracle10  
Password for SYSMAN user: oracle10 
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for 
notifications (optional): 
...
Do you wish to continue? [yes(Y)/no(N)]: y
...
Enterprise Manager configuration 
completed successfully
FINISHED EMCA at Apr 19, 2007 6:27:44 PM

上一篇：教你怎样把Oracle查询转换为SQL Server 下一篇：解析：不能忽视的Oracle 10g STATSPACK

【收藏】【评论】【推荐】【投稿】【打印】【关闭】