ORA-16191: Primary log shipping client not logged on standby

 💡 While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view.

SQL> select DEST_ID, STATUS, DESTINATION, ERROR from V$ARCHIVE_DEST where dest_id='2';

DEST_ID STATUS
———- —————————
DESTINATION
——————————————-
ERROR
—————————————————————–
2 ERROR
<standby DB>
ORA-16191: Primary log shipping client not logged on standby

And when checked in the alert logfile, we see the below error too,

.. Detailed OCI error val is 1017 and errmsg is ‘ORA-01017: invalid username/password; logon denied

1. Stop media recovery at standby side

sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2. Tạo lại mật khẩu trên primary and standby với password giống nhau

cd $ORACLE_HOME/dbs
orapwd file=orapw$ORACLE_SID password=Vss1234$ entries=10 force=y

3. Bật lại recovery

sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

4 Nếu tạo theo cách trên không được thì tốt nhất lên tạo mật khẩu ở primary sau đó cop sang standby

cd $ORACLE_HOME/dbs
orapwd file=PWDorcl.ora password=Vss1234$
scp /u01/app/oracle/product/12.2.0.1/db_1/dbs/orapworcl oracle@192.168.7.220:/u01/app/oracle/product/12.1.0.2/db_1/dbs/orapworcl

Xong thì làm tiếp bước 3 và chạy thêm câu

sql> alter system switch logfile;