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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
changing the datbase server name and IP number
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Judy Hazeley INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: changing the datbase server name and IP number
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).