We are creating Physical standby Dataguard and there is a big issue that the archive logs doesn't received from Primary server .
I tried many Oracle links that said that i have to create a password file on the Primary and copy it to Standby server then change the name to the new Standby server SID.. and change Remote Login Password file & set it's value to be exclusive on both servers. and i did that and still have issue.
My Primary DB : ORADB
My Standby DB: ORADBS2
Query below from Standby DB
select to_char(timestamp,'YYYY-MON-DD HH24:MI:SS')||' '||message from v$dataguard_status;
2016-DEC-27 15:55:40 ARC0: Archival started
2016-DEC-27 15:55:41 ARC1: Archival started
2016-DEC-27 15:55:41 ARC2: Archival started
2016-DEC-27 15:55:41 ARC3: Archival started
2016-DEC-27 15:55:41 ARC0: Becoming the 'no FAL' ARCH
2016-DEC-27 15:55:41 ARC1: Becoming the heartbeat ARCH
2016-DEC-27 15:55:41 ARC1: Becoming the active heartbeat ARCH
2016-DEC-27 15:55:46 Error 1017 received logging on to the standby
2016-DEC-27 15:55:46 FAL[client, ARC3]: Error 16191 connecting to ORADB for fetching gap sequence
Below query from Primary DB:
SQL> select message from v$dataguard_status;
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC3: Archival started
ARC1: Beginning to archive thread 1 sequence 244 (3391460-3393492)
ARC1: Completed archiving thread 1 sequence 244 (3391460-3393492)
Error 1033 received logging on to the standby
Error 1033 for archive log file 2 to 'ORADBS2'
Error 1033 received logging on to the standby PING[ARC2]: Heartbeat failed to connect to standby 'ORADBS2'. Error is 1033.
Error 1033 received logging on to the standby FAL[server, ARC0]:
Error 1033 creating remote archivelog file 'ORADBS2'
Appreciate your advise .
Also i can connect from Primary to standby and from standby to primary using sqlplus sys/sys@oradb as sysdba & sqlplus sys/sys@oradbs2 as sysdba also TNSPING works from both Primary and Standby On Primary and Standby Tnsping Oradb Tnsping oradbs2 Password file name on Primary is: orapworadb.ora Password file name on Primary is: orapwORADBS2.ora |