Monday, August 7, 2017
Troubleshooting ORA 16191 ORA 01017
Troubleshooting ORA 16191 ORA 01017
In 11gR1, 11gR2, ambience up log carriage for DataGuard, Streams, CDC, etc., you are acceptable to run into this annoyance. No amount how anxiously you accomplish the SYS passwords in the passwordfile the aforementioned byte-for-byte on both the antecedent and destination hosts, the antecedent archiver will abort aggravating to log in to the destination DB with these letters accounting to the active log:
ORA-01017: invalid username/password; logon denied
ORA-16191: Primary log shipping client not logged on standby
The band-aid is to actualize the passwordfiles with orapwd application the altercation ignorecase=y:
% orapwd file=orapwORCL password=sys_password ignorecase=y entries=5 force=y
This affair has been accurate by several bloggers and appointment participants, but there is still no agenda in Metalink as of today. Im not abiding what allotment of the codepath contains this bug or if conceivably this is one of those that would be addressed with the "not a bug" acknowledgment from dev. You will apparently accept begin this commodity afterwards afterward the instructions in the absurdity documentation:
download file now
Labels:
01017,
16191,
ora,
troubleshooting