How to Drop and Recreate the DB Control Repository

Information in this article applies to:
Oracle Enterprise Manager 10g Release 1 (10.1)
Oracle Enterprise Manager 10g Release 1 (10.2)
So:

Goal:
Provide detailed instructions on how to remove and recreate the DB Control Repository in a 10g Database

1. Stop the DB Console if not already stoped: $ORACLE_HOME/bin/emctl stop dbconsole

On Unix Systems:
1.  Run 10g DB $OH/sysman/admin/emdrep/bin/RepManager
NOTE: Type RepManager by itself and you will get a list of options available for the tool

2.  After you delete the Repository, you will need to remove the configuration files.  To do this, run emca -x

3.  Finally, to created both the schema objects and configuration files run emca and answer the prompts

On Windows Systems:
NOTE: The RepManager script in 10.1.0.2.0 does not work correctly on Windows.  For this reason, you will have to manually drop the sysman schema and management objects.  The RepManager script should be fully functional in the 10.1.0.3.0 release.

1.  Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and mangement objects:

•    SHUTDOWN IMMEDIATE;

•    STARTUP RESTRICT;

•    EXEC sysman.emd_maintenance.remove_em_dbms_jobs;

•    EXEC sysman.setEMUserContext(”,5);

•    REVOKE dba FROM sysman;

•    DECLARE
•        CURSOR c1 IS
•          SELECT owner, synonym_name name
•          FROM   dba_synonyms
•          WHERE  table_owner = ‘SYSMAN’
•        ;
•      BEGIN
•        FOR r1 IN c1 LOOP
•            IF r1.owner = ‘PUBLIC’ THEN
•               EXECUTE IMMEDIATE ‘DROP PUBLIC SYNONYM ‘||r1.name;
•            ELSE
•               EXECUTE IMMEDIATE ‘DROP SYNONYM ‘||r1.owner||’.'||r1.name;
•            END IF;
•        END LOOP;
•      END;

•    DROP USER mgmt_view CASCADE;

•    DROP ROLE mgmt_user;

•    DROP USER sysman CASCADE;

•    ALTER SYSTEM DISABLE RESTRICTED SESSION;

2.  At a command Prompt, run emca -x sid to remove the existing configuration files and then recreate the schema and configuration files with just emca.  For example:
emca -x <SID>
emca

For additional information on emca commandline options, please see the Oracle Enterprise Manager 10g Advanced Configuration Guide.  The Guide is available from OTN.  http://download-west.oracle.com/docs/pdf/B12013_01.pdf

1.    Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and mangement objects:

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
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;
e. drop public synonym SETEMVIEWUSERCONTEXT;
(Note If any of the above statement failed and saying object doesn’t exist just skip that
statement)

B. Drop the DB Control configuration files.

Remove the following directories:
$rm -rf $ORACLE_HOME/<HOSTNAME_SID>
$rm -rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<HOSTNAME_SID>

On Windows systems just delete the folders above from the Explorer.

Remove the entries for the old dbconsole information from the $ORACLE_HOME/install/portlist.ini file

On Windows, use delsrv.exe (available for free download from Microsoft) or the ’sc’ command to remove the ORACLEDBCONSOLE<SID> service if it still remains.

1.    Remove the current Database Control configuration files and repository

1.1 set ORACLE_HOME and ORACLE_SID environment variable
1.2 <ORACLE_HOME>/bin/emca -x <SID>
1.3 <ORACLE_HOME>/sysman/admin/emdrep/bin/RepManager <hostname> <actual_listener_port> <sid> -action drop
1.4 Manually delete any <hostname>_<sid> directories in <ORACLE_HOME> and <ORACLE_HOME>/oc4j/j2ee
1.5 On Windows, use delsrv.exe (available for free download from Microsoft) or the ’sc’ command to remove the ORACLEDBCONSOLE<SID> service if it still remains.

2. Recreate the Database Control configuration files and repository

2.1 <ORACLE_HOME>/bin/emca


Sursa
2009-01-30 12:09:59



Comenteaza





Ultimele 25 posturi adăugate

05:39:29BALAURI/ DRAGONES* —» Andrei LANGA. Blogul personal
23:16:33Dark Red Wine Bread —» ajna-blogging-press
23:04:51Ce a promis directorul retelelor electrice Edinet pentru Zabriceni si Onesti —» Curaj.TV | Media alternativă
19:35:46Cercetare și tradiții —» Biblioteca de Arte 'Tudor Arghezi'
19:34:54©️ Aproape 💙 —» Licurici de suflet
18:53:04Mors de rachitele (merisoare) —» Bucataria Talinei - condimentat cu dragoste
17:35:33Despre încălzirea globală și alte pericole #palavre —» Curaj.TV | Media alternativă
17:04:19Vești bune pentru moldovenii din Italia: Din 10 ianuarie 2020 vor putea să convertească permisele de conducere —» Elena Robu
16:37:03MAEIE face precizări referitoare la autocarul cu cetățeni moldoveni reținuți în Olanda —» Elena Robu
13:59:15Teatrul Țăndărică din București vine la Chișinău! Hai cu noi la spectacolul „Motanul Încălțat”! —» Sunt MAMĂ!
11:58:45Toate Evele mele —» Frinturi din suflet de femeie
10:38:38Culioșelele —» apostu
09:17:23Autocar cu 65 de moldoveni, reținut în Olanda —» Elena Robu
08:49:31Da, Maia a pierdut încrederea SUA // Cum s-a „ridicat” Hogan în câteva zile —» un alt blog
07:47:34Viaţa bate filmul şi poliţia din Buzău —» Curaj.TV | Media alternativă
06:49:14Duminică nu mai votez Pro Iohannis —» un alt blog
05:52:03Teen Boy Comforter Set —» Andrei Fornea
04:07:34Room And Board Dining Table —» Andrei Fornea
03:33:47Din ciclul: români pe Badoo —» Viata pe Tinder – Viata amoroasa pe Tinder
23:21:02Why Canadians send me to the Russians?! —» Informaţii pentru studenţi !
21:10:16The 10 Health Benefits of Wine Will Inspire You to Pour a Hearty Glass Tonight —» ajna-blogging-press
20:15:05Горит ЧЕК, аварийный режим. Удаление сажевых фильтров DPF —» Сажевые фильтры (DPF/ FAP). Чип тюнинг. Теория, практика.
20:05:51Турбо-утюг BMW F30 335 ActiveHybrid3. Stage1- 418 HP. Project 500 HP —» Сажевые фильтры (DPF/ FAP). Чип тюнинг. Теория, практика.
19:46:51Les livres sont, comme les virus, des entités intermédiaires entre l’objet et l’être vivant. —» turn up the silence
19:11:28Правительство элитарного меньшинства не будет решать проблемы большинства —» Блог Михаила Полянского