Recrear em oracle

Página 1 de 3

">

How To Drop, Create And Recreate DB Control In A 10g Database [ID 278100.1] Modified 06-SEP-2010 Type BULLETIN Status PUBLISHED

In this Document Purpose Scope and Application How To Drop, Create And Recreate DB Control In A 10g Database DB Control options: A. Delete DB Control Objects: B. Create DB Control Objects C. Recreate/ReConfig DB Control References

Appliesto:
Enterprise Manager Grid Control - Version: 10.1.0.2 to 11.1.0.0 - Release: 10.1 to Information in this document applies to any platform. DBConsole

Purpose
This article provides detailed instructions on how to 1) create, 2) drop and 3)recreate the repository and configuration files for the DB Control application used to manage a single 10g Database.

Scope and Application
The stepsin this article are written for a DBA or System Administrator who needs to create, drop or reconfigure the DB Control Application. The format of the document will include steps for both 10.1 and 10.2 EMCA because the commands changed between the two releases. For detailed instructions on DB Control 10.2 for RAC, please consult also: Note 395162.1 How to manage DB Control 10.2 for RAC Databasewith emca

How To Drop, Create And Recreate DB Control In A 10g Database
DB Control options:

A. Delete DB Control Objects:
Option 1. Option 2. Option 3. Option 4. Option 5. Delete DB Control Configuration Files using EMCA scripts Delete DB Control Configuration Files Manually: Delete DB Control Repository Objects using RepManager Delete DB Control Repository Objects Manually Delete DBControl Configuration Files and Repository Objects using EMCA

Option 1. Delete DB Control Configuration Files using EMCA scripts:
For DB Control 10.1.x, run the command: /bin/emca -x For DB Control 10.2.x, run the command: bin/emca -deconfig dbcontrol db

Important Note: the option -deconfig removes the EM jobs from Scheduling before the DB Control is deconfigured. Otherwise therepository, which is not dropped, could be corrupted or inconsistent if EM jobs were scheduled as the time the DB Control is dropped. It could also cause some errors during the DB Control deletion.

Option 2. Delete DB Control Configuration Files Manually: Remove the following directories from your filesystem: / /oc4j/j2ee/OC4J_DBConsole__ If the dbcontrol is upgraded from lower version, forexample, from 10.2.0.3 to 10.2.0.4, then the following directory also needs to be removed from the file system. /.upgrade /oc4j/j2ee/OC4J_DBConsole__.upgrade

NOTE: On Windows you also need to delete the DB Console service: - run regedit - navigate to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services - locate the OracleDBConsole entry and delete it Alternatively on Windows XP and Windows Server2003 you can run the following from the command line: 'sc delete ' - where is the DB Control service name (typically: OracleDBConsole) OR use the command, 'nmesrvops delete ' - where is the DB Control service name (typically: OracleDBConsole)

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLET... 02/11/2010

Página 2 de 3

Also available from Microsoft isthe delsrv.exe command. (Free download from Microsoft)

Option 3. Delete DB Control Repository using RepManager: This option is not as complete as the other options. You may find that dropping the repository using the commandline options is a better solution. Also note, RepManager is not used to create a DB Control Repository.
In both 10g R1 and R2 run: /sysman/admin/emdrep/bin/RepManager-action drop

Warning: this command puts the database in Quiesce Mode. Please consult the Note 375946.1 Running EMCA Results in Database quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation

Option 4. Delete DB Control Repository Objects Manually
Step 1: Drop AQ related objects in the SYSMAN schema Logon SQLPLUS as user SYS SQL> exec...