5 Replies Latest reply: Oct 11, 2013 4:49 AM by saurabh RSS

    change parameter instance_name after standby database has been activated

    vivalavida

      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