IP address change. [message #56372] |
Tue, 25 March 2003 11:26 |
satish kumar
Messages: 10 Registered: March 2002
|
Junior Member |
|
|
Well,
What precautions should one take before the IP change!!!...
Can some one elaborate the steps... like shutdown oracle , services etc ...
Im afraid that after IP change the ora-12205 etc might occur.
rgds
Satish
|
|
|
Re: IP address change. [message #56376 is a reply to message #56372] |
Tue, 25 March 2003 15:39 |
Anand
Messages: 161 Registered: August 1999
|
Senior Member |
|
|
As far as Oracle is concerned, there's nothing big to be changed. If you have DNS enabled, you don't have to worry much, because even though the IP address is changed, you would still be referring to the existing DNS entry ( eg. oracle.com (or) microsoft.com )
Incase you use the raw IP address everywhere, then you have to be careful in changing wherever you have used it viz. listener.ora, tnsnames.ora. You may have to instruct all the users to modify their local tnsnames.ora file for the new IP address.
This is what I could think of !
|
|
|
Re: IP address change. [message #56378 is a reply to message #56372] |
Tue, 25 March 2003 17:43 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Nothing to worry about it. If you change the tnsnames.ora and listener.ora on the server and tnanames.ora on the clients - then Oracle will pick up the new values.
If you have UNIX machine, you can always check for any Sendmail configurations which might break:
$ find / -exec grep "oldhostname" {} ; -print
If you find some, check the file and edit it.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|