This discussion is archived
5 Replies Latest reply: Oct 11, 2013 2:49 AM by saurabh RSS

change parameter instance_name after standby database has been activated

vivalavida Journeyer
Currently Being Moderated

Hello ,

 

our primary database is configured as follows:

SQL> show parameter db_name;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      prod01


SQL> show parameter instance_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      prod01

 

the corresponding standby database is configured as:

SQL> show parameter db_name;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      prod01


SQL> show parameter instance_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      stbyprod01

 

Now the standby database shall be activated. Afterwards I want to change the parameter INSTANCE_NAME from stbyprod01 to prod01.

 

The question now is: what needs to be done to change the parameter INSTANCE_NAME? As a matter of fact the standby database will

already be activated and be treated and handled as a standalone database. The former primary database will  not be used anymore.

I would proceed as follows:

 

SQL> create pfile='initprod01.ora' from spfile;

SQL> shutdown immediate;

oracle #> edit the pfile and change the parameter INSTANCE_NAME from stbyprod01 to prod01

SQL> startup;

SQL> create spfile='spfileprod01.ora' from pfile;

SQL> shutdown immediate;

SQL> startup;

That should be all - from my point of view (I know that LISTENER.ORA and TNSNAMES.ORA should be modified, too).

If anybody has already experiences with changing the INSTANCE_NAME parameter but sees some further configurations: please just let me know!

 

Rgds

Jan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points