Tuesday, March 1, 2011

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

No comments:

Post a Comment

Post a Comment