Log Shipping Issue in my dataguard environment- ORA16737 : the redo transport service has error

From: Sandip Mukhopadhyay <sandip.mukhopadhyay24_at_gmail.com>
Date: Sun, 19 Feb 2017 23:27:00 +0530
Message-ID: <CAO6SxR_=4XGwq1jtgO1WvBdQ4QxceyHUr8N9fmDGHZXjFu6DNQ_at_mail.gmail.com>



Hi All,

Here are the configuration details :-

Primary DB Name - Standby ( One node Oracle Restart)

Standby DB nae - rac, two nodes RAC namely rac1,rac2

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. Connected.
DGMGRL> show configuration;

Configuration - haconfig

  Protection Mode: MaxPerformance
  Databases:
    standby - Primary database
      Error: ORA-16778: redo transport error for one or more databases

    rac - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR tnsnames.ora :-

rac =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = racattack-cluster-scan)(PORT = 1521))

    )
(CONNECT_DATA =

      (SERVICE_NAME = rac)
    )
  )

rac2 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racattack2-vip)(PORT = 1521))
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
      (instance_name = rac2)

    )
  )

rac1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racattack1-vip)(PORT = 1521))
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
      (instance_name = rac1)

    )
  )

standby =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.78.58)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = standby)
    )
  )

Listener.ora in Standby :-

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.78.58)(PORT = 1521))     )
  )
SID_LIST_LISTENER=
   (SID_LIST=

        (SID_DESC=
          (GLOBAL_DBNAME=standby_DGMGRL)
          (SID_NAME=standby)
          (ORACLE_HOME=/u01/app/oracle/product/11.3.0/dbhome_1)
        )
      )

ADR_BASE_LISTENER = /u01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON Listener.ora in RAC nodes(rac1,rac2)

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3 = ON ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = rac1_DGMGRL)
      (ORACLE_HOME = /u01/app/11.2.0/grid)
      (SID_NAME = rac)

    )
  )

LISTENER =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
  )

ADR_BASE_LISTENER = /u01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON LISTENER_SCAN3 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN3))
  )

LISTENER_SCAN2 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2))
  )

ADR_BASE_LISTENER_SCAN3 = /u01/app/oracle

LISTENER_SCAN1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  )

ADR_BASE_LISTENER_SCAN2 = /u01/app/oracle

ADR_BASE_LISTENER_SCAN1 = /u01/app/oracle

I am getting error for logshipping to standby as ORA16737 : the redo transport service has error

Can anyone help ?

Best Regards,
Sandip

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 19 2017 - 18:57:00 CET

Original text of this message