About
You may have to reconfigure the Enterprise Manager database control when for instance, the Database Host Name or IP Address Change.
Articles Related
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
or
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 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
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