Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: changing the datbase server name and IP number

Re: changing the datbase server name and IP number

From: Rodd Holman <>
Date: Fri, 23 Mar 2001 11:03:44 -0800
Message-ID: <>

As long as you are keeping the DB_NAME's the same you should be able to get by with changing the listener.ora and tnsnames.ora files. You will also need to change your global tnsnames or Onames server references to these db's.

On Friday 23 March 2001 11:30, you wrote:
> We are setting up a new database server. It's HP-UX 11.0. Oracle 7.3.4 (I
> know, we need to upgrade !) has already been installed and configured on
> it. Databases have been built and are in use for testing. In a couple of
> weeks, we'll be exporting the production database from our old server and
> importing it to the new machine. Sometime during this process, we'd like
> to rename the new machine to have the same name as our old production
> server. At the same time, the IP number will be changed. The goal is to
> make the new production machine have the same name and IP number as the old
> production machine. Since Oracle has already been installed on the new
> server, and it already has test databases on it, what will need to change
> Oracle-wise when the host machine name and IP number change ?
> Thanks for any information you can share!
> Judy Hazeley
> Millersville University
> Millersville, PA
> <>

Rodd Holman
Oracle DBA
(605) 988-1373
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation

Please see the official ORACLE-L FAQ:
Author: Rodd Holman

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: (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).
Received on Fri Mar 23 2001 - 13:03:44 CST

Original text of this message