Could not connect as dbvrep to database ORA-PROD, error is ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin)

Question

I received the error: ERR-11: Could not connect as dbvrep to database ORA-PROD, error is ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin)  What causes that?

Answer

This could be one of several things:

• You do not have a TNSENTRY for  the source/target database in your local TNSNAMES.ora file.

• We have also seen this error when the parameter in the APPLY/MINE.ddc files are not pointing at the correct TNSNAMES.ora. This occurs if the source and target have different paths. Check the: memory\_set TNS\_ADMIN /u01/app/oracle/product/11.2.0/db\_1/network/admin parameter in the APPLY/MINE.ddc file.