Saturday, June 12, 2010

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. I'm 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:

1 comments:

sap implementation guide said...

I like your post because you explain everything in very well defined way but this time I am bit disappointed as I am unable to understand the given topic. The logic behind troubleshooting is not clear. It will be better if you can provide example for the same.