Error Configuring DBconsole in 2 node RAC cluster
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Error Configuring DBconsole in 2 node RAC cluster

  1. #1
    Join Date
    Feb 2008
    Location
    California
    Posts
    10

    Post Error Configuring DBconsole in 2 node RAC cluster

    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

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    You can try running the following commands:

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

  3. #3
    Join Date
    Feb 2008
    Location
    California
    Posts
    10
    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

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    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.

  5. #5
    Join Date
    Feb 2008
    Location
    California
    Posts
    10
    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..

  6. #6
    Join Date
    Nov 2006
    Posts
    158
    Hey pkata, did u solve ur problem yet? i might have some suggestions, i.e. if the issue is still persistent...
    Regards,

    divroro12

  7. #7
    Join Date
    Feb 2008
    Location
    California
    Posts
    10
    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

  8. #8
    Join Date
    Nov 2006
    Posts
    158
    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...
    Regards,

    divroro12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width