Step 2: deleting OCR repository
successfully deleted local CSS setup
L:/oracle/product/10.2.0/db10g/BIN>localconfig add
Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user '********', privgrp ''..
Operation successful.
Step 2: creating new CSS service
successfully created local CSS service
successfully added CSS to home
EM
If theHostnameis changed, then theEM Dbcontrol repositoryhas to berecreated. For this follow the below Note
https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=278100.1&blackframe=1How To Drop, Create And Recreate DB Control In A10gDatabase
References
[url=https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=278100.1&blackframe=1]https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=278100.1&blackframe=1[/url]- How To Drop, Create And Recreate DB Control In A10gDatabases
Subject:
How To Drop, Create And Recreate DB Control In A10gDatabase
[url=https://metalink2.oracle.com/help/usaeng/Search/search.html#file:278100.1]https://metalink2.oracle.com/help/usaeng/Search/search.html#file:278100.1[/url]
Type:BULLETIN Modified Date : 08-SEP-2008 Status: PUBLISHED
Applies to:
Enterprise Manager Grid Control - Version:10.1.0.2 to 11.1.0.0
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 single10gDatabase.
Scope and Application
The steps in 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:
https://metalink2.oracle.com/metalink/plsql/showdoc db=NOT&id=395162.1&blackframe=1How to manage DB Control 10.2 for RAC Database with emca
How To Drop, Create And Recreate DB Control In A10gDatabase
DB Control options:
A. Delete DB Control Objects:
Option 1. Delete DB Control Configuration Files using EMCA scripts
Option 2. Delete DB Control Configuration Files Manually:
Option 3. Delete DB Control Repository Objects using RepManager
Option 4. Delete DB Control Repository Objects Manually
Option 5. Delete DB Control 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:
For DB Control 10.2.x, run the command:
Important Note: the option -deconfig removes the EM jobs from Scheduling before the DB Control is deconfigured. Otherwise the repository, 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:
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
Alternatively on Window