Thanks for the question, Deyaa.
Asked: March 04, 2021 - 6:38 am UTC
Last updated: March 05, 2021 - 4:54 am UTC
Version: oracle 11g
Viewed 1000+ times
You Asked
We have an oracle database and the hostname in listener and tnsname files is 10.5.6.212
and there are some upgrades from the infrastructure team and they will change vlan for server and will be 10.8.6.212 so what should I do to prevent any impact on my oracle database
* Note: the OS is windows server.
and Connor said...
Well, that doesn't sound like the hostname, it sounds like the IP address.
Ideally, all references on your database server should always reference the host name not the IP address. In that instance, then we you change the network details at the OS level, the database will unaware and will run just fine.
In your case, it would be worth doing that now, so there are no references to "10.5.6.212" in any Oracle configuration file.
If the host *name* is changing, then you'd need to change occurrences of that throughout your config. Typical places will be:
- your init.ora files and possibly the spfile
- tnsnames.ora / sqlnet.ora / listener.ora
- any *client* versions of those files
Depending on what other software you are running, other files may be impacted as well.
You would make these changes with the database *down*
Is this answer out of date? If it is, please let us know via a Comment