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

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

by tuanlp

 ðŸ’¡ 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;
  1. 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
  1. 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;

You may also like