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...
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
---------- ---------- ---------------------
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
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: -------------------------------------------------------------
----
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.
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..
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.......
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
Error Configuring DBconsole in 2 node RAC cluster
Reply With Quote
Bookmarks