Change IP address of the Server

[Chandra]

Hi,
Can we change the IP address after you create the Database.

Thanks.

[Chris]

I think so, yes. I suppose it would have an impact on connectivity if you used ip addresses as opposed to host names in your tnanames.ora and listener.ora files, but apart from that I can't see a problem. Anyone else, please correct me if I'm wrong.

cheers

chris.

[rohitsn]

Hi,
Yes we can change the IP address of the machine after u create the database.But u have to make sure that ur tnsnames.ora file on the server and the clients are also updated with the new Ip address.Also u have to see that ur database links are working properly after the change.
In case of any doubts please be free to write to me at rohitsn@altavista.com

Regards,
Rohit Nirkhe,Oracle DBA.OCP 8i
rohitsn@altavista.com

[gpsingh]

tnsnames.ora,sqlnet.ora and listener.ora should never have an IP address.
They should have hostname.domain name and DNS or /etc/hosts should take care of the mapping.

[jmodic]

Originally posted by gpsingh
tnsnames.ora,sqlnet.ora and listener.ora should never have an IP address.

Never say never . As much as I agree with you, there allways are exceptions from the rule. For example, when setting up Oracle Fail Safe in NT cluster environment, Oracle insists in having virtual network addresse to be written as IP andresses and refuses to use aliases.