Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

Change of IP address [and hostname]

Hi,

We use tnsnames. I understand that change in IP address and hostname requires changes in following :

1. In database server, listener.ora and tnsnames.ora
2. In clients, tnsnames.ora

Wll this change of IP/hostname have any impact on db links and snapshots ?
If we are using dblinks and snapshots, any additional changes required ?

Thanks,
grora
0
grora
Asked:
grora
1 Solution
 
seazodiacCommented:
No, it will not, as long as you change the client TNSNAMES.ORA file.
0
 
BobMcCommented:
You are correct - as long as you update the files you list, you shouldnt have any problems.
Your database links and snapshots will refer to a net service name in the server tnsnames.ora file (which you have already updated) so it should all be seamless.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now