又出问题了,发现访问EM时提示“Enterprise Manager 无法连接到数据库实例。下面列出了组件的状态”。其实这个问题不对解决,以下是方法。

1、重新配置em

emca -config dbcontrol db

2、按提示操作

STARTED EMCA at Sep 2, 2013 9:49:11 PM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:

Database SID: tsing (填写数据库的实例名,如果不知道可先登录数据库select instance_name from gv$instance;查询)

Database Control is already configured for the database tsing

You have chosen to configure Database Control for managing the database tsing

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: 1521

Password for SYS user:

Password for DBSNMP user: (输入DBSNMP用户密码,如果密码不对可先登录数据库用alter user DBSNMP identified by 密码 account unlock;修改密码)

Password for SYSMAN user: (同上)

Email address for notifications (optional):(回车

Outgoing Mail (SMTP) server for notifications (optional):(回车

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

You have specified the following settings

Database ORACLE_HOME ................ /ora/oracle/oracle/product/10.2.0/db_1

Database hostname ................ TAIXIN-HR

Listener port number ................ 1521

Database SID ................ tsing

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............

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

Do you wish to continue? [yes(Y)/no(N)]: Y

Sep 2, 2013 9:55:04 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /ora/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/emca/uqn_node1/emca_2013-09-02_09-49-11-PM.log.

Sep 2, 2013 9:55:05 PM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Sep 2, 2013 9:55:15 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Sep 2, 2013 9:56:59 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Sep 2, 2013 9:56:59 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is http://TAIXIN-HR:1158/em <<<<<<<<<<<

Enterprise Manager configuration completed successfully

FINISHED EMCA at Sep 2, 2013 9:56:59 PM

3、重新登录em看是否成功。