Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: IP change and TNS Names, etc.
John,
Yes, you can use hostnames in your tnsnames.ora file instead of IP addresses. We are doing so with Oracle 7.3.4 on Sun Solaris 2.6.
As long as your DNS is resolving the host names to the IP addresses correctly, you should have no problem.
Cherie Machler
Gelco Information Network
"John Grover" <grover_at_raptor.lmc.cc.mi.us> on 02/22/2001 07:25:47 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Cherie Machler/GELCO)
Hello Gurus:
We are in the process of changing over our IP addressing scheme to a private network behind a firewall. This meant that all out servers are going to get new IP addresses. I know that our TNSNames file has IP addresses in it that will have to be changed. What other places will I have to look to make sure everything still works when we switch? Is it possible (advisable) to replace the IP address with a DNS hostname?
We are running Oracle 7.3.4 on HP/UX and OAS 4.x on a Sun Enterprise 450
Thanks
JG
John Grover * Systems and Database Administrator L A K E M I C H I G A N C O L L E G Egrover_at_lmc.cc.mi.us * V (616)927-8133 * F (616)927-6589
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Grover INET: grover_at_raptor.lmc.cc.mi.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Feb 22 2001 - 10:11:18 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Cherie_Machler_at_gelco.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).