Home » RDBMS Server » Server Administration » INSTANCE_NAME change
INSTANCE_NAME change [message #209599] Fri, 15 December 2006 14:54 Go to next message
Messages: 97
Registered: June 2005
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.

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
Messages: 24963
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.
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

also go through below link

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

Current Time: Tue Oct 25 05:33:12 CDT 2016

Total time taken to generate the page: 0.08884 seconds