Error Configuring DBconsole in 2 node RAC cluster

[pkata]

hello all,

I have a problem configuring db console(OEM) in a 2 NODE RAC cluster with databases.

I used creating DBCA to create my databases which poped out a warning saying oracle enterprize manager couldn't be configured and can be configured later.

But later I tried configuring but nothing worked out.....


I got some results which might help you guyz in helping me out with these issue...





D:\oracle\product\10.2.0\prodfin\BIN>emca -displayConfig dbcontrol -cluster

STARTED EMCA at Mar 12, 2008 1:54:18 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: PRODFIN

Do you wish to continue? [yes(Y)/no(N)]: y
Mar 12, 2008 1:54:42 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\prodfin\cfgtoo
logs\emca\PRODFIN\emca_2008-03-12_01-54-18-PM.log.
Mar 12, 2008 1:54:44 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMe
sage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

PRODFIN1 sis-prod-db-3 sis-prod-db-3-priv.apu.edu
PRODFIN2 sis-prod-db-4 SIS-PROD-DB-4.fs.apu.edu


Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 12, 2008 1:54:44 PM


Please please any help help is really appreciated...

padma

[ebrian]

You can try running the following commands:

emca -deconfig dbcontrol db -repos drop -cluster
emca -config dbcontrol db -repos create -cluster

[pkata]

ebrain

Thanks for posting.

I followed the same as per your previous reply dropping and recreating the repository but it didn't work. Dropping was successful but while creating it could not I am posting the results I got so that guyz on the forum can help me better.


When I was recreating I ended up with an saying

CONFIG: PRKC-1125 : Failed to start service "OracleDBConsolePRODFIN2" on node "sis-prod-db-4", [null]


where sis-prod-db-4 is my remotenode (second node) in the cluster of 2 nodes

FYI this is cluster installation on WINDOWS SERVER 2003 64-bit
ebrain if you have noticed from my first post

INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

PRODFIN1 sis-prod-db-3 sis-prod-db-3-priv.apu.edu
PRODFIN2 sis-prod-db-4 SIS-PROD-DB-4.fs.apu.edu

DBCONTROL_UPLOAD_HOST for instance one that is PRODFIN1 is on the private and

DBCONTROL_UPLOAD_HOST for instance 2 that is PRODFIN2 is on the public

I see there is something worng there ..i guess the DBCONTROL_UPLOAD_HOST should be public host for both the instances but I am not sure why is that its picking up private host auomatically....do u think my network connection are messed or what I have no idea why is picking up private...




these are the results of dropping and recreate the repository


DROPING

D:\oracle\product\10.2.0\prodcrm\BIN>emca -deconfig dbcontrol db -repos drop -cl
uster

STARTED EMCA at Mar 14, 2008 9:14:43 AM
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: PRODFIN
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Mar 14, 2008 9:16:13 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\prodcrm\cfgtool
logs\emca\PRODFIN\emca_2008-03-14_09-14-43-AM.log.
Mar 14, 2008 9:16:16 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 14, 2008 9:16:49 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Mar 14, 2008 9:36:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 14, 2008 9:36:13 AM


RECREATING

D:\oracle\product\10.2.0\prodcrm\BIN>emca -config dbcontrol db -repos create -cl
uster

STARTED EMCA at Mar 14, 2008 9:39:06 AM
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: PRODFIN
Listener port number: 1521
Cluster name: PROD
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ D:\oracle\product\10.2.0\prodcrm ]: d:\oracle\product\10.2.0\a
sm
Invalid ORACLE_HOME.
ASM ORACLE_HOME [ D:\oracle\product\10.2.0\prodcrm ]: d:\oracle\product\100.2.0\
prodcrm
Invalid ORACLE_HOME.
ASM ORACLE_HOME [ D:\oracle\product\10.2.0\prodcrm ]: D:\oracle\product\10.2.0\p
rodcrm
ASM port [ 1521 ]: 1521
ASM user role [ SYSDBA ]: SYSDBA
ASM username [ SYS ]: SYS
ASM user password:
ASM user password: -------------------------------------------------------------
----

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\product\10.2.0\prodcrm

Database instance hostname ................ sis-prod-db-3-priv.apu.edu
Listener port number ................ 1521
Cluster name ................ PROD
Database unique name ................ PRODFIN
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ D:\oracle\product\10.2.0\prodcrm
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Mar 14, 2008 9:41:49 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\prodcrm\cfgtool
logs\emca\PRODFIN\emca_2008-03-14_09-39-06-AM.log.
Mar 14, 2008 9:41:57 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 14, 2008 9:55:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Mar 14, 2008 9:56:02 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFile
s
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\oc4j\j2ee\OC4J_DBConsole_sis-
prod-db-3_PRODFIN1 to remote nodes ...
Mar 14, 2008 9:56:02 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFile
s
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\oc4j\j2ee\OC4J_DBConsole_sis-
prod-db-4_PRODFIN2 to remote nodes ...
Mar 14, 2008 9:56:03 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\sis-prod-db-3_PRODFIN1 to rem
ote nodes ...
Mar 14, 2008 9:56:04 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\sis-prod-db-4_PRODFIN2 to rem
ote nodes ...
Mar 14, 2008 9:56:04 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 14, 2008 9:57:28 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at D:\oracle\product\10.2.0\prodcrm\cfgtoollogs\emca\PRODF
IN\emca_2008-03-14_09-39-06-AM.log for more details.
Could not complete the configuration. Refer to the log file at D:\oracle\product
\10.2.0\prodcrm\cfgtoollogs\emca\PRODFIN\emca_2008-03-14_09-39-06-AM.log for mor
e details.




Its sort or urgent if anyone can help its I'll greatly appreaciate it.

Thanks in Advance.
padma

[ebrian]

Does the log file mentioned in the error show any additional information?

Does cluvfy perform successfully? Is your host file set appropriately?

You may have to file an SR with Oracle.

[pkata]

SOrry for the late reply ebrain...cuaght up in patching the RAC cluster...but still I have the same problem.....Yes I did log a TAR with oracle...if I can resolve this issue I'll post it to the forum..

[divroro12]

Hey pkata, did u solve ur problem yet? i might have some suggestions, i.e. if the issue is still persistent...

[pkata]

Hey divroro12, I just resolved it over the weekend.....oracle helped me with that.....but still I am interested in knowing your sugesstion ...

I'll put down what I did to resolve the issue.......
1) I was basically a time zone issuse.....so I patched my 10.2.0.1 to 10.2.0.3 and updated my time zone version to version 3...

2) dropped the repository and recreated it again...I had problems dropping the repository...but finally I could.....

if you have something other than this do let me know.......

padma

[divroro12]

I had the same issue; what i did was i updated my time zone, but still had a lot of trouble recreating the repository; kept having errors.
I followed the below procedure to solve the problem:

1. SQL> alter user SYSMAN account lock;
2. SQL> drop user SYSMAN cascade;
3. SQL> alter user MGMT_VIEW account lock;
4. SQL> drop user MGMT_VIEW cascade;
5. $ emca -deconfig dbcontrol db -repos drop -cluster
6. $ emca -config dbcontrol db -repos create -cluster

Take care...