Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

3255488Feb 19 2017 — edited Feb 25 2017

Hi All,

Here are the configuration details :-

Primary DB Name - Standby ( One node Oracle Restart)

Standby DB name - 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,

Sandy                  

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 25 2017
Added on Feb 19 2017
23 comments
17,896 views