3 Replies Latest reply: Mar 21, 2013 1:09 PM by mseberg RSS

    dgbroker issue

    HarryRonis
      standby db /primary db in sync .....

      managed recovery working but

      broker

      show configuration
      Connected.
      DGMGRL> show configuration

      Configuration - GenesisDR

      Protection Mode: MaxAvailability
      Databases:
      orcl - Primary database
      Warning: ORA-16629: database reports a different protection level from the protection mode

      stdby - Physical standby database
      Error: ORA-16664: unable to receive the result from a database

      Fast-Start Failover: DISABLED

      Configuration Status:
      ERROR

      DGMGRL>

      unsure what could be the issue!
        • 1. Re: dgbroker issue
          mseberg
          Hello;


          Have you checked this note :

          ORA-16629 database reports a different protection level from the protection mode [ID 1319903.1]

          Otherwise run this on both Primary and Standby and post results

          SELECT PROTECTION_MODE, PROTECTION_LEVEL FROM V$DATABASE;

          Example of fix

          DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; ( mode may vary )

          Good TS note

          http://oracledbabhuvan.blogspot.com/2012/03/ora-16737-redo-transport-service-for.html


          Best Regards

          mseberg
          • 2. Re: dgbroker issue
            HarryRonis
            mseberg wrote:
            Hello;


            Have you checked this note :

            ORA-16629 database reports a different protection level from the protection mode [ID 1319903.1]

            Otherwise run this on both Primary and Standby and post results

            SELECT PROTECTION_MODE, PROTECTION_LEVEL FROM V$DATABASE;

            Example of fix

            DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; ( mode may vary )

            Good TS note

            http://oracledbabhuvan.blogspot.com/2012/03/ora-16737-redo-transport-service-for.html


            Best Regards

            mseberg
            agreed ... mismatch stdby showed max performance for mode so did this to fix:

            [oracle/stdby@new-host-2 diag]$dgm^C
            [oracle/stdby@new-host-2 diag]$dgmgrl
            DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

            Copyright (c) 2000, 2009, Oracle. All rights reserved.

            Welcome to DGMGRL, type "help" for information.
            DGMGRL> connect sys/Qaz123@stdby
            Connected.
            DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
            Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
            Error: ORA-16625: cannot reach database "orcl"

            Failed.
            DGMGRL>

            listener config:


            [oracle/stdby@new-host-2 diag]$lsnrctl status

            LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 21-MAR-2013 13:19:21

            Copyright (c) 1991, 2011, Oracle. All rights reserved.

            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
            Start Date 21-MAR-2013 00:12:30
            Uptime 0 days 13 hr. 6 min. 50 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /orainstall/app/grid/product/11.2.0.3/ASM/network/admin/listener.ora
            Listener Log File /orainstall/app/grid/diag/tnslsnr/new-host-2/listener/alert/log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=new-host-2)(PORT=1521)))
            Services Summary...
            Service "+ASM" has 1 instance(s).
            Instance "+ASM", status READY, has 1 handler(s) for this service...
            Service "orcl_dgmgrl" has 1 instance(s).
            Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
            Service "stdby" has 2 instance(s).
            Instance "stdby", status UNKNOWN, has 1 handler(s) for this service...
            Instance "stdby", status READY, has 1 handler(s) for this service...
            Service "stdby_DGB" has 1 instance(s).
            Instance "stdby", status READY, has 1 handler(s) for this service...
            Service "stdby_dgmgrl" has 1 instance(s).
            Instance "stdby", status UNKNOWN, has 1 handler(s) for this service...
            Service "tgt1" has 1 instance(s).
            Instance "tgt1", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully
            [oracle/stdby@new-host-2 diag]$^Clp
            [oracle/stdby@new-host-2 diag]$dgmgrl
            DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

            Copyright (c) 2000, 2009, Oracle. All rights reserved.

            Welcome to DGMGRL, type "help" for information.
            DGMGRL> DGMGRL> [oracle/stdby@new-host-2 diag]$
            [oracle/stdby@new-host-2 diag]$tnsping orcl

            TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 21-MAR-2013 13:21:18

            Copyright (c) 1997, 2011, Oracle. All rights reserved.

            Used parameter files:


            Used TNSNAMES adapter to resolve the alias
            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = new-host-2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
            OK (10 msec)
            [oracle/stdby@new-host-2 diag]$tnsping stdby
            • 3. Re: dgbroker issue
              mseberg
              Hello again;

              Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

              The _DGMGRL looks OK, but generally won't handle a service with an issue.

              Compared to Mine
              Service "STANDBY.myhost.com" has 2 instance(s).
                Instance "STANDBY", status UNKNOWN, has 1 handler(s) for this service...
                Instance "STANDBY", status READY, has 1 handler(s) for this service...
              Service "STANDBY_DGMGRL.myhost.com" has 1 instance(s).
                Instance "STANDBY", status UNKNOWN, has 1 handler(s) for this service...
              Yours is missing READY

              Not a big fan of tnsping, it has limits.

              Would use SYS and sqlplus to test connect both ways.

              Best Regards

              mseberg

              Edited by: mseberg on Mar 21, 2013 1:08 PM