-
Hi,
Can we change the IP address after you create the Database.
Thanks.
-
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.
-
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
-
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.
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|