[يسار]The Database Console of 10G is one of the enhancements of the Oracle Database

10G with regard to administration, monitoring and tuning of database(s). Sometimes
a DBA wants to reconfigure, create or recreate the Database Control Repository.
When should one reconfigure the repository ?
1. When the databaseserver hostname either its’ s IP-adres(ses) changes.
2. In – rare - case when the ORACLE_SID changes
3. In case when the services_name of a database as registered by PMON in the
local listener changes
When should one create or recreate the repository ?
1. When it hasn’ t been created yet during database creation
2. When one would like to start from scratch with a clean repository (rare)
.

tomorrow we will talk about:
How I reconfigure the repository
How I Create the Repository
How I recreate the repository
أتمني أن يكون الموضوع مفيد وشامل[/يسار]

This topic is divided into three sections.

A.Delete DB Control Objects
B.Create DB Control Objects
C.Recreate/ReConfig DB Control

A.Delete DB Control Objects:

There are various ways to delete DB Control Objects.
1).Delete DB Control Configuration Files using EMCA scripts
2).Delete DB Control Configuration Files Manually:
3).Delete DB Control Repository Objects using RepManager
4).Delete DB Control Repository Objects Manually
5).Delete DB Control Configuration Files and Repository Objects using EMCA


1).Delete DB Control Configuration Files using EMCA scripts
In 10.1g run, $emca -x sid
In 10.2g run, $emca -deconfig dbcontrol db Then enter sid as prompt and then y.


2).Delete DB Control Configuration Files Manually:

Remove the following directories from your filesystem:
$ORACLE_HOME/hostname_sid
$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_sid
On Windows you also need to delete the DB Console service:
- run regedit
- navigate to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services
- locate the OracleDBConsolesid entry and delete it
On, Windows XP and Windows Server 2003 you can run the following from the command line:
’sc delete service_name’
- where service_name is the DB Control service name (typically: OracleDBConsolesid)


3).Delete DB Control Repository using RepManager:

Invoke following command, RepManager hostname listener_port sid -action drop
But don’t delete by RepManager. It puts the database in quiescence mode.


4).Delete DB Control Repository Objects Manually

If you fail after invoking command
emca -config dbcontrol db -repos create see alert log file for more details. Also refer to another log file if it shows. Directly go to step 3)
However I see many errors like,
CONFIG: ORA-00955: name is already used by an existing object
CONFIG: ORA-01921: role name ‘MGMT_USER’ conflicts with another user or role name
and many severals errors.
Execute the following commands in SQL*plus and then execute emca command. I wish no more error will come. After several experiment I get this.
drop user sysman cascade;
drop public synonym SETEMVIEWUSERCONTEXT;
drop role MGMT_USER;
drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop user MGMT_VIEW;
And then,
$ emca -deconfig dbcontrol db
$ emca -config dbcontrol db -repos create

B)Using RepManager:
If I drop the Repository using RepManager like following error will not come while creating repository.
$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager -action drop
This will not remove the configuration files, but only the repository related objects from the database.
But you need to remember when RepManager is ran the database will be put in Quiescing mode.


5).Delete DB Control Configuration Files and Repository Objects using EMCA

For 10.1,
>emca -x sid
>RepManager hostname listener_port sid -action drop
For 10.2,
>emca -deconfig dbcontrol db -repos drop

B.Create DB Control Objects

1)Create only DB Control configuration files:

on 10.1g ,>emca -r
On 10.2g, >emca -config dbcontrol db

2)Create both the DB Control Repository Objects and Configuration Files:

On 10.1g, >emca
On 10.2g, >emca -config dbcontrol db -repos create

C.Recreate/ReConfig DB Control:

1)Recreate only DB Control configuration files:
$ emca -config dbcontrol db

2)Recreate both the DB Control Repository Objects and Configuration Files:

$ emca -config dbcontrol db -repos recreate

أـمني أن تكون المعلومات مفيدة

جزاك الله خيرا وبارك الله فيك