Home » Infrastructure » Unix » renaming server
renaming server [message #97025] Wed, 24 October 2001 11:14 Go to next message
Ambrose Oberdorf
Messages: 3
Registered: October 2001
Junior Member
I found no documentation on the impact of renaming a server (HPUX 11.0 32 bit) that is running a 8.1.6 database. Unable to actually rename a server as a test. So to test, I ftped the files that made up the database (all dbf files + control files + init.ora) to a new box. It started OK, anyone have additional history/information on this subject.

----------------------------------------------------------------------
Re: renaming server [message #97047 is a reply to message #97025] Wed, 31 October 2001 15:25 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
there are several things to distinguish between first.
- SID
- DB name
- Global name

Changing the global name is easy and is mainly used to verify db_link names when global_names=true (generally required for replication).

See this link on changing the SID.

http://asktom.oracle.com/pls/ask/f?p=4950:8:229346::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:318216852435,%7Brename%7D%20and%20%7Bsid%7D

----------------------------------------------------------------------
Re: renaming server [message #97049 is a reply to message #97025] Thu, 01 November 2001 03:03 Go to previous message
aoberdorf
Messages: 2
Registered: November 2001
Junior Member
I don't wish to change the db_name, global_name, or sid. I know how to do that. The unix administrator wants to change the name of the unix server upon which the Oracle instance and database reside. My question is whether such a change will affect the existing database, I believe it will not but cannot test this easily.

----------------------------------------------------------------------
Previous Topic: Re: Connect to a new Oracle errors
Next Topic: Re: renaming server
Goto Forum:
  


Current Time: Thu Oct 01 01:41:34 CDT 2020