Oracle Database - How to reconfigure Enterprise Manager Database Control (with Emca)

> Database > Oracle Database

1 - About

You may have to reconfigure the Enterprise Manager database control when for instance, the Database Host Name or IP Address Change.

3 - Impact of the environment variable ORACLE_HOSTNAME

While installing Enterprise Manager or related components on Multi-homed (Multi-IP) machines, that is, a machine having multiple IP addresses, hostname will be derived from ORACLE_HOSTNAME environment variable if it is set; else the first name in the host file (/etc/hosts for Linux) will be considered for installation purposes.

4 - Automatic mode

When the database host name (including the domain name) or the IP address changes, deconfigure and then reconfigure the Database Console with the repository create command. Run the following command:

emca -deconfig dbcontrol db
emca -config dbcontrol db -repos recreate

or

emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
Advertising

5 - Manual reconfiguration

If you have some problem during the reconfiguration problem. Here are a manual fashion.

  emca -deconfig dbcontrol db -repos drop

And then as sys as sysdba :

DROP USER sysman cascade;
DROP PUBLIC SYNONYM SETEMVIEWUSERCONTEXT;
DROP role MGMT_USER;
DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
DROP USER MGMT_VIEW;

Restart the computer because/if the service is marked to delete.

And to finish :

  emca -config dbcontrol db -repos create

6 - The result

The result that you must obtain :

INFO: Starting Database Control (this may take a while) ...
13-jul-2009 14:20:28 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
13-jul-2009 14:20:28 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://gerardnico.com:1
158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 13-jul-2009 14:20:28
db/oracle/oracledb_emca_how_to_reconfigure.txt · Last modified: 2017/09/06 19:28 by gerardnico