Changing the Domain of Oracle Database Server

I recently had the task of moving our Database server onto a new domain. The following steps outline what was involved in performing this task.

1. Change the Domain of the server

• Take the server of the current domain
• Reboot
• Change the domain to the new one
• Reboot

2. Update the Listener.ora and Tnsnames.ora

• Change to the new domain name

3. Make sure the the instance is running

• sqlplus / as sysdba

4. Drop the Enterprise Manager Console

• emca -deconfig dbcontrol db -repos drop
• Enter the SID name (ORA11gDB)
• Listener port number = 1521
• Password for SYS user
• Password for SYSMAN user
• Do you wish to continue = Y
• Depending on the size of the DB it can take some minutes to complete the (10 minutes)

5. Reinstall the Enterprise Manager Console

• emca -config dbcontrol db -repos create
• Enter the SID name (ORA11gDB)
• Listener port number = 1521
• Password for SYS
• Password for DBSNMP
• Password for SYSMAN
• Email address for notification
• Outgoing mail (SMTP)
• Do you wish to continue = Y
• Again this can take some minutes to complete (20 minutes

6. Restart the database

7. Test connections

8. All should be OK