！！关于EMCA的奇怪问题，请高手看看！！！

xamhd

采用emca配置向导进行配置：
$ emca -config dbcontrol db -DBCONTROL_HTTP_PORT 5508 -AGENT_PORT 3940 -RMI_PORT 5524 -JMS_PORT 5545
STARTED EMCA at Nov 14, 2009 3:24:58 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: prmdb
Listener port number: 1521
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN user:  
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 ................ /opt/oracle/product/11gR1/db
Local hostname ................ H1010069
Listener port number ................ 1521
Database SID ................ prmdb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 14, 2009 3:25:17 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/prm/emca_2009_11_14_15_24_58.log.
Nov 14, 2009 3:25:20 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5545 is already in use.
Nov 14, 2009 3:25:20 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5524 is already in use.
Nov 14, 2009 3:25:20 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5508 is already in use.
Nov 14, 2009 3:25:20 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 3940 is already in use.
Nov 14, 2009 3:26:36 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /opt/oracle/cfgtoollogs/emca/prm/emca_2009_11_14_15_24_58.log for more details.
Could not complete the configuration. Refer to the log file at /opt/oracle/cfgtoollogs/emca/prm/emca_2009_11_14_15_24_58.log for more details.


日志如下：
$ more emca_2009_11_14_15_24_58.log
............
由于超限，所以省略了部分
CONFIG: SQLEngine connecting with SID: prmdb, oracleHome: /opt/oracle/product/11gR1/db, and user: SYSMAN
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Submitting dbms job: /opt/oracle/product/11gR1/db/sysman/admin/emdrep/sql/core/latest/admin/admin_submit_dbms_jobs.sql
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Successfully submitted dbms job
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocking mgmt view user account
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: view user sql: declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varc
har2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from
sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter us
er ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_cr
eds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_u
ser || ' identified by ' || view_user_pwd || ''; END IF; end;
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Starting execution: /opt/oracle/product/11gR1/db/sysman/admin/scripts/emca/emcaDbUtil /opt/oracle/product/11gR1/db/perl/lib:
/opt/oracle/product/11gR1/db/perl/lib/site_perl:/opt/oracle/product/11gR1/db/sysman/admin/scripts:/opt/oracle/product/11gR1/db/bin:
/opt/oracle/product/11gR1/db/perl/bin/perl /opt/oracle/product/11gR1/db/sysman/admin/scripts/emca/emcaDbUtil.pl /opt/oracle/product/
11gR1/db prmdb SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status v
archar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status f
rom sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter
user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user
_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || vie
w_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 0
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Execution of /opt/oracle/product/11gR1/db/sysman/admin/scripts/emca/emcaDbUtil /opt/oracle/product/11gR1/db/perl/lib:/opt/or
acle/product/11gR1/db/perl/lib/site_perl:/opt/oracle/product/11gR1/db/sysman/admin/scripts:/opt/oracle/product/11gR1/db/bin: /opt/or
acle/product/11gR1/db/perl/bin/perl /opt/oracle/product/11gR1/db/sysman/admin/scripts/emca/emcaDbUtil.pl /opt/oracle/product/11gR1/d
b prmdb SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2
(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys
.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user '
|| view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds
( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user
|| ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD  completed successfully
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Arguments passed /opt/oracle/product/11gR1/db prmdb SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_
user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); sele
ct account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status
like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIR
ED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_
pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 1 SYSMAN_PWD
Connecting to database prmdb in home /opt/oracle/product/11gR1/db with user "SYS" role "SYSDBA".
connected to database.
sql to execute declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30)
; begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba
_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' ||
view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( re
pos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || '
identified by ' || view_user_pwd || ''; END IF; end;
noOfParams to bind: 1.
sql execute successfully.
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Nov 14, 2009 3:25:21 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Nov 14, 2009 3:25:22 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: prmdb, oracleHome: /opt/oracle/product/11gR1/db, and user: SYSMAN
Nov 14, 2009 3:25:22 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Nov 14, 2009 3:26:36 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: ORA-12170: TNS:Connect timeout occurred
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12170: TNS:Connect timeout occurred
        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1771)
        at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2682)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:36
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:46
Nov 14, 2009 3:26:36 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
Refer to the log file at /opt/oracle/cfgtoollogs/emca/prm/emca_2009_11_14_15_24_58.log for more details.
Nov 14, 2009 3:26:36 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Listener is not up. Start the Listener and run EM Configuration Assistant again .
        at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2689)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:36
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:46
监听明明起来了，但系统提示未起！！
$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 14-NOV-2009 15:28:10
Copyright (c) 1991, 2008, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.84.200.41)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
Start Date                14-NOV-2009 15:16:25
Uptime                    0 days 0 hr. 11 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/11gR1/db/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/H1010069/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=130.84.200.41)(PORT=1521)))
Services Summary...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "prmdb" has 1 instance(s).
  Instance "prmdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$

[ 本帖最后由 xamhd 于 2009-11-14 16:39 编辑 ]

dingning239

SEVERE: Listener is not up. Start the Listener and run EM Configuration Assistant again .
建议楼主检查一下tnsname.ora文件，不行的话重新配置一下监听

renxiao2003

监听并没有正确的监听到你的ORACLE实例，有问题啊。

xamhd

$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 14-NOV-2009 15:28:10
Copyright (c) 1991, 2008, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.84.200.41)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
Start Date                14-NOV-2009 15:16:25
Uptime                    0 days 0 hr. 11 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/11gR1/db/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/H1010069/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=130.84.200.41)(PORT=1521)))
Services Summary...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "prmdb" has 1 instance(s).
  Instance "prmdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$