Need to change IP on Oracle 9i

[olemma]

Hi Oracle Gurus,
My net admin needs to change the IP address on our production Oracle 9i DB running on RedHat Enterprise Linux 2.1/Kernel 2.4.9-e.59 enterprise. What would be the appropiate steps to acomplish this?

 

[hoinz]

Hi,

I suppose your net admin knows how to change your server's IP, and I suppose your question is:
What additional steps have to be done at Oracle level?

(If however you do need help in changing your server's IP, I suggest you ask in a Linux forum; I don't know much about RedHat.)

Answer to the question above:
Probably nothing at all.
But to be sure, there are a few configuration files that usually contain host names. If they contain IPs instead, this will cause a problem.
These files are in a directory $ORACLE_HOME/network/admin, names are *.ora.
If there are IPs, replace them with the new one, or rather replace them with the host name.
Another problem may be at the clients that connect to your database. There also should be a directory ....\network\admin and a file tnsnames.ora that has to be checked.
And I suppose your net admin will make sure that name resolution will work.

good luck!

 

[olemma]

Thanks hoinz. Yes, that's what I meant by my question.