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

Card Puncher Data Processing


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

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.

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


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

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 user MGMT_VIEW;

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

And to finish :

  emca -config dbcontrol db -repos create

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
158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at 13-jul-2009 14:20:28

Discover More
Card Puncher Data Processing
Oracle Database - Oracle Enterprise Manager Database Control (Database Control)

Oracle Enterprise Manager Database Control is one of the two way that Oracle Enterprise Manager can be installed. You can deploy Oracle Enterprise Manager: locally on the database system called database...

Share this page:
Follow us:
Task Runner