How to drop emca repository manually

A. Drop the repository manually using following procedure. Stop the DB Console if not already stoped: $ORACLE_HOME/bin/emctl stop dbconsole Log on in sqlplus as sys user and run the following commands: a. drop user sysman cascade; b. drop role MGMT_USER; c. drop user MGMT_VIEW cascade; d. drop public synonym MGMT_TARGET_BLACKOUTS;. Both configuration files and repository objects can be deleted using a single command. Run the following command for a single-instance database: $ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop Run the following command for an Oracle RAC database: $ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop –cluster.  · In this syntax example: repository_host is the machine name where the Management Repository database is located. You have to reconfigure the same. For that we have to drop the existing configuration first. If it is a new database you can directly configure using emca. 1. Drop dbcontrol configuration 2. Create the OEM repository 3.

A. Drop the repository manually using following procedure. Stop the DB Console if not already stoped: $ORACLE_HOME/bin/emctl stop dbconsole Log on in sqlplus as sys user and run the following commands: a. drop user sysman cascade; b. drop role MGMT_USER; c. drop user MGMT_VIEW cascade; d. drop public synonym MGMT_TARGET_BLACKOUTS;. Well, its because the former DBA in my new company created the docs as follows: Setup database control 1. export ORACLE_HOSTNAME = www.doorway.ru 2. Copy the files from the once existing. a. $ORACLE_HOME/_ b. $ORACLE_HOME/_ 3. DBConsole repository can be dropped manually by executing following SQL statements. Step 1: Drop AQ related objects in the SYSMAN schema Logon SQLPLUS as user SYS SQL exec DBMS_www.doorway.ru_QUEUE_TABLE(queue_table='www.doorway.ru_NOTIFY_QTABLE',force=TRUE); Step 2: Drop the DB Control Repository Objects Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management objects.

We must run EMCA tool for reconfiguring the OEM database console. To do this, use the following commands. emca -deconfig dbcontrol db -repos drop. emca -config. Tip for Identifying the Oracle Home When Using the emctl Command emca -deconfig dbcontrol db [-repos drop] [-cluster] [-silent] [parameters]. Deconfig the dbcontrol emca -deconfig dbcontrol db -repos drop. Now the new dbcontrol can be created emca -config dbcontrol db -repos create.