I've got two 220.127.116.11 databases, a primary and a logical standby.
On the Logical Standby, the apply process is attempting the following command and experiencing an ORA-01017 invalid username/password login denied
GRANT SELECT ON OPS$EHJ6533.V_COUNTY TO OPS$TER6944
The V_COUNTY view contains a public database link in it. The public database link works just fine. I can log in as the owner of the view and select * from user_users@dblinkname
I'm wondering if the problem is that the public database link is a connected user link and somehow there is a mismatch in passwords for the process that actually runs the apply process???
I have verified that OPS$EHJ6533 and OPS$TER6944 have identical passwords on both the primary database and the LSB database so I know the error cannot be related to that.
Any ideas what could be causing the ORA-01017 errors during the apply process? It's causing the apply process to stop cold.
One other thing, I checked and the SYS password is identical on all databases, primary, LSB and the target database where the the database link points, the password for OPS$EHJ6533 is identical on primary, LSB and the database where the db link in the view points as is the password for OPS$TER6944.