regaring instance

I want to change my instance name
there is a parameter in init.ora instance_name
I have change but there is no effect of that change
while fetching the instance name from the query it is giving me the provios one
even I shutdown database soo many times but there is no
effect on it
pls. help me to find out the correct way
Thanks in advance

to change instance name

1. shutdown your database
2. export ORACLE_SID=new_instance_name
3. start your database
4. check v$instance it should now indicates a new instance name

Thanks for reply

But will you plz. tell me how do I export Oracle_SID

thanks in Advance

err it's just I wrote, in command line export ORACLE_SID... are u in NT?

I am guessing that you are attempting to rename your instance.
If this is true, you have to recreate your controlfile. Here are the steps to do that;

-. from server manager execute the following command :
alter database backup controlfile to trace;
-. go to your user dump destination
-. search through the list of recent file (date time stamp)
-. there should be a file there that has information about your database
-. make a copy of that file
-. if your database was called "DEV" and you wish to call it "TEST" you would
see the following:
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DEV1" NORESETLOGS ARCHIVELOG
-. Change it to :
STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE TEST NORESETLOGS ARCHIVELOG
-. shutdown the instance
-. Make changes to your oratab, listener, tnsnames files
-. set your oracle sid to test (export ORACLE_SID=TEST (on unix 0 or
SET ORACLE_SID=TEST (on microsoft virus))
-. start server manager and run the script.
-. When your database comes up, your instance will now be called TEST.

Hope it helps

gram2000 that is to change database name not instance name, you can change your instance name just by changing oracle_sid and bounce the database

I think, in some other thread also 'changing the instance name' was discussed. About the INSTANCE_NAME parameter, it is a new parameter added in oracle 8i. It is not to change the instance name. It is for the automatic registration of the instance with the default listener.

Thanks to all of you

but still I am in problem as you said that
set Oracle_SId =(new instance name)
I have given this command on command prompt
but it has no use the instance name is still same it is not taking what I have specified as well as about instance parameter that is availiable in 8.1.6 or 8.1.7
So what I do now?
Pls. help me

could you please tell us about you operating system wheather it is windows unix linux solaris ?

have you shutdown the database before change ORACLE_SID...?!?!

The database in on NT
and I have shutdown the database before changing the instance name but it is taking the same name

if it´s NT you have to use oradim to change instance name

dear shailendra,
pl follow following steps to change instance name:-
eg- suppose u want to change from orcl to ora
- pl go to command prompt
-type 'oradim -delete -sid orcl
-type 'set Oracle_SID=ora
-type 'oradim -new -sid ora -intpwd oracle -startmode auto -pfile pathOfInit.ora

there after u come out of cmd prompt
go to setting>control panel>services and see that the service oracleoracleora has started.
if u have put instance name in init.ora file then change there also and bounce the database. u will have to keep the database shut for the above procedure.
regards
satish

Thanks to all of you

Satish I have tried what you have told
The instance name is changed but when I run the svrmgrl utiliy to open the database
it is giving error TNS Protocol Adapter Error
can you pls. tell me how to solve this problem
Thanks

My knowlegdeable friends ,


i have a similar problem like shailender

i have tried shutting down the database and then from the command prompt i SET ORACLE_SID = TEST...
I DON'T SEE THE EFFECT ..
this does not even bring the change in the registry .
also pls can you tell me if i make the change manually in the registry the oracle_sid value then will it work

thank you
regards

Two things here.
>On NT when you are setting oracle_sid, don't give any spaces before and after '=' sign e.g oracle_sid=orcl is correct, not oracle_sid = orcl.
>when you are invoking svrmgr and you get that error, check whether NT service for that sid is started or not.