Enterprise Manager DB Control/DB Console (OEM) is not working after Changing Hostname or IP Address

ERROR

Enterprise Manager DB Control/DB Console (OEM) is not working after Changing Hostname or IP Address

 

SOLUTION

Step 1. Set $ORACLE_HOSTNAME to the old hostname

  
export ORACLE_HOSTNAME=old_name

Step 2.Β De-configure the old DB Console by running the following command:

  
$ORACLE_HOME/bin/emca -deconfig dbcontrol db

Step 3.Β $ORACLE_HOSTNAME to the new hostname:

export ORACLE_HOSTNAME=new_name

Step 4.Β Configure the new DB Console

$ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSerror

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

Leave a Reply