DNS Server change effect on oracle connections

5 pts.
Tags:
DHCP
DNS
Oracle performance
Hello, There is going to be a change in DNS server at our site. Also, there is going to be migration from Static to DHCP IP, but it has been assured to us that IP address will not change. All our databases are accessed via DNS alias entries in TNSNAMES.ora. Will a change in DNS server affect the current connections to database? Please comment. Thanks, Garima

Answer Wiki

Thanks. We'll let you know when a new response is added.

Don’t put your server on DHCP, I mean keep it with the same static IP when Oracle was installed (if you change Server’s IP, manually or dynamically, oracle will have to be reinstalled). Rest all machines except the servers can be put on DHCP.

***
A change in IP does not require a new installation of the Oracle database software. I have moved servers to new subnets within a DNS domain numerous times. If your tnsnames entry identifies the database using Hostname with a fully qualified domain, then no changes will be required. If your tnsnames.ora entry uses the IP addresses to identify the host, then any change in IP will need to be reflected in the tnsnames.ora entry. For a database server, a static IP address should be required, but as long as the hostname is fully qualified and both the nslookup and reverse lookup work properly and point to the same host, you should be able to communicate.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following