Odi's astoundingly incomplete notes
New entries | CodeRename an Oracle instance
Here is how to rename an Oracle instance.
Also change the instance name in
Also change the TNS name in network/admin/tnsnames.ora
If you also change the IP/hostname, don't forget to:
Also change the instance name in
/etc/oratab
!Also change the TNS name in network/admin/tnsnames.ora
If you also change the IP/hostname, don't forget to:
- deconfigure the dbconsole
- shutdown database and listener
- /etc/hosts: change IP/hostname there
- $ORACLE_HOME/network/admin/tnsnames.ora and listener.ora
- startup database and listener
- configure the dbconsole again
Add comment