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.
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 firstname.lastname@example.org
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.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?