Log Shipping Issue in my dataguard environment- ORA16737 : the redo transport service has error
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-lReceived on Sun Feb 19 2017 - 18:57:00 CET