Home » Server Options » RAC & Failsafe » Re-config OEM DBcontrol in RAC 10g (10.2.0.1, Sun Sparc )
Re-config OEM DBcontrol in RAC 10g [message #436975] Wed, 30 December 2009 00:55 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

I've recreate cluster in 2 nodes - RAC 10gR2. So that, I did not start OEM following the customer request.

$ emctl status dbconsole
OC4J Configuration issue. /oracle/app/oracle/product/10.2.0/mbfdb/oc4j/j2ee/OC4J_DBConsole_mbfdb01_mbfdb1 not found.
$


And then, I tried to recreate the OEM with emca command

$ emca -displayConfig dbcontrol -cluster

STARTED EMCA at Dec 30, 2009 1:07:05 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database unique name: mbfdb

Do you wish to continue? [yes(Y)/no(N)]: yes
Dec 30, 2009 1:07:10 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-07-05-PM.log.
Dec 30, 2009 1:07:13 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database Control is not configured for this database.
Refer to the log file at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-07-05-PM.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-07-05-PM.log for more details.
$


And this is the logfile

$ more /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-07-05-PM.log
Dec 30, 2009 1:07:05 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-displayConfig' set to true
Dec 30, 2009 1:07:05 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'dbcontrol' set to true
Dec 30, 2009 1:07:05 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-cluster' set to true
Dec 30, 2009 1:07:05 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: ORACLE_HOME value: /oracle/app/oracle/product/10.2.0/mbfd
b
Dec 30, 2009 1:07:08 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: mbfdb
Dec 30, 2009 1:07:08 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value:
Dec 30, 2009 1:07:10 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value: yes
Dec 30, 2009 1:07:10 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LOG_FILE.
Dec 30, 2009 1:07:10 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2.0/mbfdb/
cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-07-05-PM.log.
Dec 30, 2009 1:07:10 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ASM_NODE_LIST.
Dec 30, 2009 1:07:10 PM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
CONFIG: Invalid Node/Sid List specified.

...skipping 1 line

CONFIG: All nodes are up. Nodes: [mbfdb01, mbfdb02]
Dec 30, 2009 1:07:11 PM oracle.sysman.emcp.ParamsManager getInaccessibleSidList
CONFIG: All nodes are up. Nodes: [mbfdb01, mbfdb02] Sids: [+ASM1, +ASM2]
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.util.ClusterUtil isShared
CONFIG: path: /oracle/app/oracle/product/10.2.0/mbfdb isOracleHome: true isShare
d: false
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.util.ClusterUtil isShared
CONFIG: Path Cache contents: {/oracle/app/oracle/product/10.2.0/mbfdb=false}
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.util.ClusterUtil isShared
CONFIG: OH Cache contents: {/oracle/app/oracle/product/10.2.0/mbfdb=false}
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SRC_OH.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_HOME value: /oracle/app/oracle/product/10.2.0/mbfdb
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter NODE_LIST.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
CONFIG: Invalid Node/Sid List specified.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
CONFIG: All nodes are up. Nodes: [mbfdb01, mbfdb02]

...skipping 1 line

CONFIG: All nodes are up. Nodes: [mbfdb01, mbfdb02] Sids: [mbfdb1, mbfdb2]
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID_LIST value: mbfdb1,mbfdb2
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: NODE_LIST value: mbfdb01,mbfdb02
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
CONFIG: No Global database unique name available. Will try to retrieve it from D
B itself
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: mbfdb1, oracleHome: /oracle/app/oracle/pr
oduct/10.2.0/mbfdb, and user:
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

...skipping 1 line

Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_DOMAIN value: neo.com.vn
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: mbfdb.neo.com.vn
Dec 30, 2009 1:07:12 PM oracle.sysman.emcp.util.ClusterUtil getHostName
CONFIG: Specified node: mbfdb01
Dec 30, 2009 1:07:13 PM oracle.sysman.emcp.util.ClusterUtil getHostName
CONFIG: Node: mbfdb01 Host: mbfdb01
Dec 30, 2009 1:07:13 PM oracle.sysman.emcp.util.ClusterUtil isCRSHomeInstantaite
d
CONFIG: Value of CRS_HOME in /oracle/app/oracle/product/10.2.0/mbfdb/sysman/conf
ig/emca.properties is /oracle/app/oracle/product/crs
Dec 30, 2009 1:07:13 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigu
red
CONFIG: Sid: mbfdb1 Host: mbfdb01 Node: mbfdb01 OH: /oracle/app/oracle/product/1
0.2.0/mbfdb isDBC: false
Dec 30, 2009 1:07:13 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database Control is not configured for this database.

...skipping 1 line

Dec 30, 2009 1:07:13 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Database Control is not configur
ed for this database.
        at oracle.sysman.emcp.EMDBPreConfig.performDisplayConfig(EMDBPreConfig.j
ava:3039)
        at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:257)
        at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:160)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:141)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.jav
a:479)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss
istant.java:1123)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.jav
a:463)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
$


$ emca -reconfig dbcontrol -cluster

STARTED EMCA at Dec 30, 2009 1:20:24 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database unique name: mbfdb
Database Control node name (optional): mbfdbcontrol
Agent SID list [comma separated] (optional): mbfdb1

Do you wish to continue? [yes(Y)/no(N)]: y
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-20-24-PM.log.
Dec 30, 2009 1:20:45 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database Control is not configured for this database.
Refer to the log file at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-20-24-PM.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-20-24-PM.log for more details.
$


$ cat /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-20-24-PM.log
Dec 30, 2009 1:20:24 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-reconfig' set to true
Dec 30, 2009 1:20:24 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'dbcontrol' set to true
Dec 30, 2009 1:20:24 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-cluster' set to true
Dec 30, 2009 1:20:24 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: ORACLE_HOME value: /oracle/app/oracle/product/10.2.0/mbfdb
Dec 30, 2009 1:20:26 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: mbfdb
Dec 30, 2009 1:20:36 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_NODE value: mbfdbcontrol
Dec 30, 2009 1:20:39 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_SID_LIST value: mbfdb1
Dec 30, 2009 1:20:39 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value:
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value: yes
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LOG_FILE.
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-20-24-PM.log.
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter NODE_LIST.
Dec 30, 2009 1:20:42 PM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
CONFIG: Invalid Node/Sid List specified.
Dec 30, 2009 1:20:43 PM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList
CONFIG: All nodes are up. Nodes: [mbfdb01, mbfdb02]
Dec 30, 2009 1:20:43 PM oracle.sysman.emcp.ParamsManager getInaccessibleSidList
CONFIG: All nodes are up. Nodes: [mbfdb01, mbfdb02] Sids: [mbfdb1, mbfdb2]
Dec 30, 2009 1:20:43 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID_LIST value: mbfdb1,mbfdb2
Dec 30, 2009 1:20:43 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: NODE_LIST value: mbfdb01,mbfdb02
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.util.ClusterUtil isShared
CONFIG: path: /oracle/app/oracle/product/10.2.0/mbfdb isOracleHome: true isShared: false
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.util.ClusterUtil isShared
CONFIG: Path Cache contents: {/oracle/app/oracle/product/10.2.0/mbfdb=false}
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.util.ClusterUtil isShared
CONFIG: OH Cache contents: {/oracle/app/oracle/product/10.2.0/mbfdb=false}
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SRC_OH.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_HOME value: /oracle/app/oracle/product/10.2.0/mbfdb
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: mbfdb1, oracleHome: /oracle/app/oracle/product/10.2.0/mbfdb, and user:
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_DOMAIN value: neo.com.vn
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: mbfdb.neo.com.vn
Dec 30, 2009 1:20:44 PM oracle.sysman.emcp.util.ClusterUtil getHostName
CONFIG: Specified node: mbfdb01
Dec 30, 2009 1:20:45 PM oracle.sysman.emcp.util.ClusterUtil getHostName
CONFIG: Node: mbfdb01 Host: mbfdb01
Dec 30, 2009 1:20:45 PM oracle.sysman.emcp.util.ClusterUtil isCRSHomeInstantaited
CONFIG: Value of CRS_HOME in /oracle/app/oracle/product/10.2.0/mbfdb/sysman/config/emca.properties is /oracle/app/oracle/product/crs
Dec 30, 2009 1:20:45 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: mbfdb1 Host: mbfdb01 Node: mbfdb01 OH: /oracle/app/oracle/product/10.2.0/mbfdb isDBC: false
Dec 30, 2009 1:20:45 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database Control is not configured for this database.
Refer to the log file at /oracle/app/oracle/product/10.2.0/mbfdb/cfgtoollogs/emca/mbfdb/emca_2009-12-30_01-20-24-PM.log for more details.
Dec 30, 2009 1:20:45 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Database Control is not configured for this database.
        at oracle.sysman.emcp.EMDBPreConfig.performReconfiguration(EMDBPreConfig.java:2784)
        at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:237)
        at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:160)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:141)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
$


Tablespace SYSAUX & user SYSMAN
sys@MBFDB> select username, account_status, default_tablespace tbs
  2  from dba_users
  3  where username='SYSMAN';

USERNAME     ACCOUNT_STATUS                   TBS
------------ -------------------------------- ------------------------------
SYSMAN       EXPIRED                          SYSAUX


Hope you help me to reinstall DBControl.

Thank you!

[Updated on: Wed, 30 December 2009 00:57]

Report message to a moderator

Re: Re-config OEM DBcontrol in RAC 10g [message #437051 is a reply to message #436975] Wed, 30 December 2009 09:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you tried to reset/change SYSMAN's password?
Re: Re-config OEM DBcontrol in RAC 10g [message #437076 is a reply to message #436975] Wed, 30 December 2009 23:04 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
@ebrian: No. I did not change anything. Let me say all about of:

1- The first time I've installed Oracle RAC 10g successfully, it (DB, OEM, ...) work as well as I expected. And I configured the OEM would be start automatically as long as CRS start any time. (I've done it by Metalink guide)

2- However, when the other dba group came and test, they asked me for making backup OCR & Voting disk to separate location. Those (OCR & Voting) were made by only one raw device (external choice). OKie, I reinstalled Cluster, everything was good, except OEM. It was not startup.

So, yesterday, I drop dbcontrol, dbInst as Note 39591.1 in Metalink. And one guru helped me to finish it, this was alright today. I'll ask him to feedback every step at here as soon as possible.

Thank you!
Previous Topic: One node RAC pause/hang/block on other node shutdown
Next Topic: RAC on HP-UX :Enabling and Disabling Service Guard Monitoring
Goto Forum:
  


Current Time: Tue Mar 19 04:20:03 CDT 2024