June 26

Oracle 11g – DBConsole

Categories11gR1, 11gR2 Oracle RDBMS

Tagsemca dbconsole

Marco Gralike Written by:

2 Comments

  1. Getachew G
    August 2

    I happen to be looking for a document that details how to setup 11G DBconsole and got to your site. I found the posts to be very useful. But, before you typed your login password for the dbconsole, what process did you follow to get there? Can you share your setup process?

    Thank you.

  2. Marco Gralike
    August 5

    The following should be enough but check your Oracle documentation to be sure…

    Create the DBConsole Environment

    Create the repository via:

    1. emca -repos create

    Create the web part via:

    1. emca -config dbcontrol db

    Drop the DBConsole Environment

    Login to SQLPLUS as user SYS or SYSTEM, and drop the sysman account & management objects:

    A. Clean up the Db Console repository

    1. drop user sysman cascade;
    2. drop role MGMT_USER;
    3. drop user MGMT_VIEW cascade;
    4. drop public synonym MGMT_TARGET_BLACKOUTS;
    5. drop public synonym SETEMVIEWUSERCONTEXT;

    B. Export the correct values for the ORACLE_HOME and ORACLE_SID environment variables

    C. Change directories to the $ORACLE_HOME/bin directory

    D. Cleanup the External DB Console Configuration files by
    issuing:

    • emca -deconfig dbcontrol db -repos drop

    E. Recreate the DB Console Repository & external Configuration files by issuing:

    • emca -config dbcontrol db -repos create

Comments are closed.