Changing IP-Address of Database Server
Dear All,
Following are the environment details:
Red Hat Enterprise Linux 5.5 (64-bit)
Oracle 11g Release 2 (64-bit)
Number of database of the host: 4
We have to change the IP-Address of the database server. Following are the actions I think I sould take:
1) Shutdown all databases
2) Stop Listener
3) change IP-Address
4) Start Listener (make sure new IP-Address is in effect)
5) Check tnsnames.ora for IP-Address/hostname and make necessary changes.
6) Start database
Please validate my steps and make necessary corrections if required.
Also, if I have to change the hostname of the database server, I think I still have to follow the above procedure.
Please share your exprerience/knowledge in this regard.
- P