Changing the host name

[nirasha]

Hello there,

I need help to know whether changing of the OS hostname of a server (and IP address). Besides having to change my tnsnames and listener files is there something else I need to look for?

Thanks,
Nirasha

[tamilselvan]

You only need to change TNSNAMES.ORA and LISTENER.ORA file unless you SQLNET.ORA or ONAMES.ORA.