1 Reply Latest reply: Jan 7, 2014 3:33 AM by Hemant K Chitale RSS

    standby instance  failiure ( using DGMGRL)

    955912

      Hi all ;

       

      PRIMARY ----> ORG

      STANDBY -----> DUMMY

       

      WHEN TRYING  SWITCHOVER USING DGMGRL , I AM GETTING ERROR.

       

      DGMGRL> switchover to

      dummy;

      Performing switchover NOW, please wait...

      Operation requires shutdown of instance "org" on database "org"

      Shutting down instance "org"...

      ORA-01109: database not open

       

      Database dismounted.

      ORACLE instance shut down.

      Operation requires shutdown of instance "dummy" on database "dummy"

      Shutting down instance "dummy"...

      ORA-01109: database not open

       

      Database dismounted.

      ORACLE instance shut down.

      Operation requires startup of instance "org" on database "org"

      Starting instance "org"...

      Unable to connect to database

      ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Failed.

      You are no longer connected to ORACLE

      Please connect again.

      Unable to start instance "org"

      You must start instance "org" manually

      Operation requires startup of instance "dummy" on database "dummy"

      You must start instance "dummy" manually

      Switchover succeeded, new primary is "dummy"

      DGMGRL> !

      Unrecognized command "!", try "help"

      DGMGRL> exit

       

      bash-3.2$ export ORACLE_SID=dummy

      bash-3.2$ sqlplus / as sysdba

       

      SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 7 14:39:38 2014

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      Connected to an idle instance.

       

      SQL> startup

      ORACLE instance started.

       

      Total System Global Area 1048576000 bytes

      Fixed Size                  1223344 bytes

      Variable Size             255853904 bytes

      Database Buffers          784334848 bytes

      Redo Buffers                7163904 bytes

      Database mounted.

      Database opened.

      SQL> select database_role from v$database;

       

      DATABASE_ROLE

      ----------------

      PRIMARY

       

      When trying to connect  standby database , i am getting error :

       

      bash-3.2$ export ORACLE_SID=org

      bash-3.2$ sqlplus / as sysdba

       

      SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 7 14:40:15 2014

       

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

       

      Connected to an idle instance.

       

      SQL> startup

      ORACLE instance started.

       

      Total System Global Area 1048576000 bytes

      Fixed Size                  1223344 bytes

      Variable Size             255853904 bytes

      Database Buffers          784334848 bytes

      Redo Buffers                7163904 bytes

      Database mounted.

      Database opened.

      SQL> select database_role from v$database;

      select database_role from v$database

      *

      ERROR at line 1:

      ORA-03135: connection lost contact

      SQL> select database_role from v$database;

      ERROR:

      ORA-03114: not connected to ORACLE

       

      ------------------------

       

      FYI : both  database ping well on same server.