| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Change Server Name on NT Box (how to)
I would recommend DNS for if you replace the machine and use a different IP
address then you again have to change everything. DNS should be stable.
At 07:25 AM 11/8/00 -0800, Michael Ray wrote:
>Gary,
>If you use local naming, you will need to change the tnsnames.ora file on
>all the clients. If you use Oracle Names, then you simply change it on the
>names server(s). These 2 options tell the client where it finds the
>listener to make the connection. Since the listener machines names will be
>different, they will not be able to find it anymore. The listener then
>decides where the instance is, which you've already noticed from the
>listener.ora file.
>
>One other thing you may wish to consider if your environment will allow it
>is to use the IP address rather than machine name. Then you wouldn't have
>had this problem. It is also slightly more efficient since it removes the
>DNS server from the equation. We normally use DHCP here but use static IPs
>on the servers.
>
>Michael Ray
>Oracle DBA
>TRW, Marshall, IL
>217-826-3011 x2438
>
> >>> gnorwell_at_hybridturkeys.com 11/08/00 08:50AM >>>
>I recently installed an Oracle 8i database on an NT box previously
>used for another application. No problems, other than our network
>admin now wants me to change the name of the NT box.
>
>I did a quick check and noted that the current name of the NT
>machine is part of the listener control file. From an Oracle
>perspective, it appears that I have to modify the listener parameters
>to reflect the new machine name, but what other considerations (if
>any) are there to consider before implementing this change?
>
>-------------------------------------------
>Gary Norwell, Database Developer
>Hybrid Turkeys a Division of Nutreco Canada
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Michael Ray
> INET: Michael.Ray_at_trw.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).
Bill Wagman
Univ. of California at Davis
Information Resources
wjwagman_at_ucdavis.edu
(530) 754-6208
 |
 |