EM故障，重新创建em

查看em端口

/home/oracle/app/product/10.2.0/install/portlist.ini

修改端口

emca -reconfig ports -dbcontrol_http_port 1159
emca -reconfig ports -agent_port 3939

emca -config dbcontrol db  //重新配置数据库控制

emca -repos recreate //删除重新配置资料库  

emca  -config dbcontrol db -repos create //安装EM数据库控制和资料库

emca -deconfig dbcontrol db -repos drop//删除数据库控制和资料库

手工删除历史痕迹

drop user SYSMAN cascade;

drop user MGMT_VIEW cascade;

drop role MGMT_USER;

drop public synonym MGMT_TARGET_BLACKOUTS;

drop public synonym SETEMVIEWUSERCONTEXT;

[oracle@localhost ~]$ emctl start dbconsole

TZ set to PRC
OC4J Configuration issue. /home/oracle/app/product/10.2.0/oc4j/j2ee/OC4J_DBConso
le_localhost.localdomain_hngdcrm not found.
[oracle@localhost ~]$ emca -config dbcontrol db  //配置EM


EMCA 开始于 2014-3-24 15:01:49
EM Configuration Assistant, 10.2.0.5.0 正式版
版权所有 (c) 2003, 2009, Oracle。保留所有权利。


输入以下信息:
数据库 SID: hngdcrm
2014-3-24 15:02:17 oracle.sysman.emcp.DatabaseChecks checkDbAvailabilityImpl
警告: ORA-01034: ORACLE not available


2014-3-24 15:02:17 oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
严重: 数据库实例不可用。

You have new mail in /var/spool/mail/oracle

//原因，数据库没起来

******************************************************************************************************************

[oracle@localhost ~]$ emca -config dbcontrol db


EMCA 开始于 2014-3-24 15:09:26
EM Configuration Assistant, 10.2.0.5.0 正式版
版权所有 (c) 2003, 2009, Oracle。保留所有权利。


输入以下信息:
数据库 SID: hngdcrm
监听程序端口号: 1521
SYS 用户的口令:
DBSNMP 用户的口令:
2014-3-24 15:09:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
警告: ORA-01017: invalid username/password; logon denied


2014-3-24 15:09:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
警告: ORA-01017: invalid username/password; logon denied


用户名/口令无效。
DBSNMP 用户的口令:
2014-3-24 15:10:05 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
警告: ORA-01017: invalid username/password; logon denied


2014-3-24 15:10:05 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
警告: ORA-01017: invalid username/password; logon denied


用户名/口令无效。
DBSNMP 用户的口令:

//用 alter user dbsnmp identified by oracle修改

***************************************************************************************************************************

SYS 用户的口令:
DBSNMP 用户的口令:
SYSMAN 用户的口令:
通知的电子邮件地址 (可选):
通知的发件 (SMTP) 服务器 (可选):
-----------------------------------------------------------------


已指定以下设置


数据库 ORACLE_HOME ................ /home/oracle/app/product/10.2.0


Local hostname ................ localhost.localdomain
监听程序端口号 ................ 1521
数据库 SID ................ hngdcrm
通知的电子邮件地址 ...............
通知的发件 (SMTP) 服务器 ...............


-----------------------------------------------------------------
是否继续? [是(Y)/否(N)]: y
2014-3-24 15:55:25 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 /home/oracle/app/product/10.2.0/cfgtoollogs/emca/hngdc


m/emca_2014-03-24_03-55-09-下午.log。
2014-3-24 15:55:25 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBCon


rol
警告: ORA-12541: TNS:no listener


2014-3-24 15:55:25 oracle.sysman.emcp.EMConfig perform
严重:


Database connection through listener failed. Fix the error and run EM Configura


ion Assistant again.


Some of the possible reasons may be:


1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service hngdcrm is not registered with listener. Register the datab


se service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is


et to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<vi


tual host>.
6) /etc/hosts does not have correct entry for hostname.


有关详细资料, 请参阅 /home/oracle/app/product/10.2.0/cfgtoollogs/emca/hngdcrm/e


ca_2014-03-24_03-55-09-下午.log 中的日志文件。
无法完成配置。 有关详细资料, 请参阅 /home/oracle/app/product/10.2.0/cfgtoollogs


emca/hngdcrm/emca_2014-03-24_03-55-09-下午.log 中的日志文件。
You have new mail in /var/spool/mail/oracle

************************************************************************************************************************************************

Oracle Enterprise Manager 10g is not running.