RE: changing the datbase server name and IP number

You may also need to indclude sqlnet.ora as well.

-----Original Message-----
Sent: Friday, March 23, 2001 06:41
To: Multiple recipients of list ORACLE-L

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
> judy.hazeley_at_millersville.edu <mailto:judy.hazeley_at_millersville.edu>

--
Rodd Holman
Oracle DBA
(605) 988-1373
rodney.holman_at_lodgenet.com
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: http://www.orafaq.com
--
Author: Rodd Holman
  INET: rodney.holman_at_lodgenet.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

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).