Home » RDBMS Server » Server Administration » INSTANCE_NAME change
INSTANCE_NAME change [message #209599] Fri, 15 December 2006 14:54 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All,

We have a database running under solaris.What is the best way to change the instance_name and confirm it. My plan is to change the instance_name parameter in the init.ora file and restart the database. Is there any problem with it. However I like to know if any one has temporarily changed the instance_name.

I believe if everything goes well then ps -ef|grep -i smon would show me the new instance_name. You may ask, why not I go ahead and give a shot. Because my dear, it is prod database and I cant play with it as I wish.

Thanks.
Re: INSTANCE_NAME change [message #209600 is a reply to message #209599] Fri, 15 December 2006 15:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It appears you are unwilling or incapable of using Google.
Below is 1 of the 1st hits returned.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:318216852435
Re: INSTANCE_NAME change [message #209621 is a reply to message #209599] Fri, 15 December 2006 23:09 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
also go through below link
http://www.oracle-base.com/articles/9i/DBNEWID.php


hope this helps
Taj
Previous Topic: changing the size of log_buffer
Next Topic: Full DB Export from 8i and Import into 10g
Goto Forum:
  


Current Time: Fri Sep 20 05:43:47 CDT 2024