SQL*Net Failure - Changing Hostname on Canandaiuga Machines
- Change the hostname of an Advant station running the Canandaugia release
If set_parms is used to change the hostname of an Advant station running the Canandaugia release, after the node is re-booted, the statup may report that SQL*Net failed. This is because the old hostname is embedded in 2 different Oracle files which are not modified by set_parms.
To fix this problem, the files /etc/tnsnames.ora and /etc/listener.ora need to be edited, changing all of the occurrences of the old hostname to the new hostname.
After editing these files, be sure to check the owners and permissions of the files.
- Trouble changing hostname