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
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:
CREATE CONTROLFILE REUSE DATABASE "DEV1" NORESETLOGS ARCHIVELOG
-. Change it to :
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.
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.
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