 |
|
Change Oracle IP and Domain DNS Tips
Oracle Tips by Burleson Consulting |
Question: I want
to change the domain name for my Oracle server. What are some tips to
avoid the "ORA-01034: ORACLE not available" error?
Answer: So long as
you have the DNS host name in your tnsnames.ora file, changing the IP address
from the DNS file (i.e. /etc/hosts) should not have any changes at the database
level.
Question: What if
I'm changing a Windows workgroup with Oracle to move the Windows server to a new
site with new IP and DNS settings?
Answer:
I don't do Windows, but I would change any DNS entry in the tnsnames.ora
file and listener.ora file in the $ORACLE_HOME/$ORACLE_SID/network/admin
directory to reference the real IP address and bypass any DNS entries. Here are
my notes on
tnsnames.ora configuration.
Reader Feedback: My Listener.ora or tnsnames.ora files used DNS
hostnames instead of an IP address. So when I changed the IP, Subnet, Def
Gateway, DNS and WINS of the Windows 2003 server Oracle started up with no
problems.
