Primary Oracle Database is not able to ship log to Standby Database

ISSUE :
My Primary Database is not able to ship Archive Logs to Standby Database
On Primary Database i see this error :

ORA-16191: Primary log shipping client not logged on standby
2025-01-27T10:14:51.519672+03:00
PR00 (PID:4208): Error 1017 received logging on to the standby
PR00 (PID:4208): ————————————————————————-
PR00 (PID:4208): Check that the source and target databases are using a password file
PR00 (PID:4208): and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
PR00 (PID:4208): and that the SYS password is same in the password files,
PR00 (PID:4208): returning error ORA-16191
PR00 (PID:4208): ————————————————————————-
PR00 (PID:4208): FAL: Error 16191 connecting to EBSUAT for fetching gap sequence
2025-01-27T10:14:51.519672+03:00

Cause:
Password file is missing OR not synched between Primary and Standby with same sys password

SOLUTION:
First connect your Primary Database and change the sys password if you dont know existing password.

sqlplus / as sysdba
alter user sys identified by Oracle123123;

Linux/Unix:
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwdPROD password=YourSysPassword entries=5 force=y

MS Windows:
%ORACLE_HOME%\bin\orapwd file=%ORACLE_HOME%\database\pwdEBSUAT.ora password=Oracle123123$ entries=5 force=y

NOTE:
In Windows Platform Make sure the Password file has the .ora extension since i faced errors without extention.
After the password is generated , Transfer to Standby Database respectively and better rename password to Standby Unique Name too respectively.

This entry was posted in Uncategorised. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *