Skip to Main Content
  • Questions
  • Hostname for oracle database will change

Breadcrumb

Question and Answer

Connor McDonald

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 100+ 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 we 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*

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database