25
Jun
10

Procedure to drop and recreate the dbconsole

Drop the repository manually using following procedure.
Connect to the database and execute following sql.

a. drop user sysman cascade;
b. drop role MGMT_USER;
c. drop user MGMT_VIEW cascade;
d. drop public synonym MGMT_TARGET_BLACKOUTS;
e. drop public synonym SETEMVIEWUSERCONTEXT;

Remove HOSTNAME_SID directory from $ORACLE_HOME from both the nodes using.

$rm -rf $ORACLE_HOME/<HOSTNAME_SID>
$rm -rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>
You would replace the values in the <> with the correct values.

Connect to server and set the environment for the database ORACLE_HOME
and ORACLE_SID

$ORACLE_HOME/bin/emca -config dbcontrol db -repos create


0 Responses to “Procedure to drop and recreate the dbconsole”



  1. Leave a Comment

Leave a comment


Its Mee :)


Welcome to My Blog:
In this Blog you will find the Oracle stuff which i came across and experienced as DBA. So would like to share with you all so that everyone gets benefited.

June 2010
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  

Blog Stats

  • 94,258 hits