5 Replies Latest reply on Jun 1, 2017 12:12 PM by 1302009

    DGM-17016: failed to retrieve status for database

    1302009

      Hello,

       

      Appreciate your support in this..Urgently Please help me to solve this issue as its a production issue!

      its Oracle Data guard 11g r2 windows environment ..

      it was working fine but after restarting i found this error the standby database oracle not available and the primary database redo transport error.

      Kindly find the screenshots below for more details..

      Note: the connection name lbsdb is what i used to connect at but after restarting is gives tns:listener does not currently know of service requested in connect descriptor when logging,

      So i created a new listener (Listener1) with the port 1522 and it used the connection name in tnsnames LBSDB_test just to login.

      And here is my TNS names:

       

      ORACLR_CONNECTION_DATA =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

          )

          (CONNECT_DATA =

            (SID = CLRExtProc)

            (PRESENTATION = RO)

          )

        )

       

       

      LBSDB_PR =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)

          )

        )

       

       

      LBSDB_SB =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)

          )

        )

       

       

      DGB_PR =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = LBSDB_PR_UN_DGMGRL.CORP.SA.ZAIN.COM)

          )

        )

       

       

      DGB_SB =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = LBSDB_SB_UN_DGMGRL.CORP.SA.ZAIN.COM)

          )

        )

       

       

      LBSDB_PR_AP =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1525))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = LBSDB_PR_UN.CORP.SA.ZAIN.COM)

          )

        )

       

       

      LBSDB_SB_AP =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1525))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = LBSDB_SB_UN.CORP.SA.ZAIN.COM)

          )

        )

       

       

      LBSDB =

      (DESCRIPTION =

          (LOAD_BALANCE = OFF)

          (FAILOVER = ON)

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1525))

            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1525))

      )

         (CONNECT_DATA =

         (SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)

         (SERVER = DEDICATED)

            (FAILOVER_MODE =

              (TYPE = select)

              (METHOD = BASIC)

              (RETRIES = 15)

              (DELAY = 10)))))

       

       

      LBSDB_QUERY =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (FAILOVER = ON)

            (LOAD_BALANCE = OFF)

            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1525))

            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1525))    )

          (CONNECT_DATA =

            (SERVICE_NAME = LBSDB_SB.CORP.SA.ZAIN.COM)

          )

        ) 

       

       

      GISSTAGING =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.123.105.179)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = GISSTAGING)

          )

        )

      LBSDB_test =

      (DESCRIPTION =

          (LOAD_BALANCE = OFF)

          (FAILOVER = ON)

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1522))

            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1522))

      )

         (CONNECT_DATA =

         (SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)

         (SERVER = DEDICATED)

            (FAILOVER_MODE =

              (TYPE = select)

              (METHOD = BASIC)

              (RETRIES = 15)

              (DELAY = 10)))))

       

      show conf_err.pngPRI_ERR.pngSB_ERR.png

        • 1. Re: DGM-17016: failed to retrieve status for database
          CKPT

          Is there any changes done prior to reboot?

          Can you check whether the standby is mounted and then we have to crosscheck why Broker is reporting "Oracle not available"' ? it looks me that trying to connect wrong port/host/service name?

          Can you please get output of below command from both primary and stnadby?

          DGMGRL> show database "db" statusreport;

           

          Primary-DGMGRL> show database "db" LogXptStatus

          • 2. Re: DGM-17016: failed to retrieve status for database
            1302009

            Thanks for responding, The system administrator did a windows patch update.

            i have checked the status of the database in standby its open and the oracle services and listener is running.

            Kindly find below the output of the db status..

            For the Primary Database:

            DGMGRL>  show database "LBSDB_PR_UN" statusreport;

            STATUS REPORT

                   INSTANCE_NAME   SEVERITY ERROR_TEXT

                           lbsdb      ERROR ORA-16737: the redo transport service for standby database "LBSDB_SB_UN" has an error

                               *    WARNING ORA-16829: fast-start failover configuration is lagging

             

            DGMGRL> show database "LBSDB_PR_UN" LogXptStatus;

            LOG TRANSPORT STATUS

            PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME               STATUS

                           lbsdb          LBSDB_SB_UN ORA-01034: ORACLE not available

            For the standby Database:

            DGMGRL>  show database "LBSDB_SB_UN" statusreport;

            Error: ORA-01034: ORACLE not available

            Error: ORA-16625: cannot reach database "LBSDB_SB_UN"

             

            DGMGRL> show database "LBSDB_SB_UN" LogXptStatus;

            Error: ORA-01034: ORACLE not available

            Error: ORA-16625: cannot reach database "LBSDB_SB_UN"

            • 3. Re: DGM-17016: failed to retrieve status for database
              1302009

              I Found the below errors in the logs..

               

              Tns main err code: 12564

              Adjusting the default value of parameter parallel_max_servers 

              Fast-Start Failover cannot proceed because: "standby has connectivity to the primary"

               

               

              Fatal NI connect error 12638, connecting to:

              (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

               

               

                VERSION INFORMATION:

                TNS for 64-bit Windows: Version 11.2.0.4.0 - Production

                Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production

                Time: 28-MAY-2017 04:21:31

                Tracing not turned on.

                Tns error struct:

                  ns main err code: 12638

                 

              TNS-12638: Credential retrieval failed

                  ns secondary err code: 0

                  nt main err code: 0

                  nt secondary err code: 0

                  nt OS err code: 0

              • 4. Re: DGM-17016: failed to retrieve status for database
                CKPT

                DGMGRL> show database "LBSDB_PR_UN" LogXptStatus;

                LOG TRANSPORT STATUS

                PRIMARY_INSTANCE_NAME STANDBY_DATABASE_NAME               STATUS

                               lbsdb          LBSDB_SB_UN ORA-01034: ORACLE not available

                 

                Can you try connecting from primary to standby and vice versa?

                Also check standby listener status and ensure the services are in Ready?

                • 5. Re: DGM-17016: failed to retrieve status for database
                  1302009

                  Pinging to each others is replying and the listeners is running.