Hi Team,
I am facing issues for log shipping from primary to standby, archive log is not shipping from primary to standby automatically, also I too observed following error in standby alert log.
FAL[client, USER]: Error 16191 connecting to HPSBAQ2P for fetching gap sequence
Sat Jun 17 18:19:23 2017
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
Note: I shipped/copied password file from primaryserver@$ORACLE_HOME/dbs/ to standby $ORACLE_HOME/dbs location , with as per standby db name convention.
Also following error for the query.
select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------- --------- --------- -------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 ERROR OPTIONAL ORA-12514: TNS:listener does not currently know of
service requested in connect descriptor
Please suggest me what could be the issue for archive log shipping is not happening automatically.
Siva..