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
groraAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
BobMcConnect With a Mentor Commented:
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
 
seazodiacCommented:
No, it will not, as long as you change the client TNSNAMES.ORA file.
0
All Courses

From novice to tech pro — start learning today.