We're here to help!

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)

Follow

Read our docs This article explains how to resolve issue when dbvrep is trying to connect to the database.


Problem Details

Problem Statement

Issues connecting to the database as dbvrep user.

Applicable Error Code

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)

Affected Versions

All replicate versions

Affected Platforms

Platform independent

 
Description
Received error when trying to connect to database as dbvrep user. This can happen during startup of the MINE/APPLY process.
 
Solution

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.

Chris Lawless June 11, 2015 11:26

Have more questions? Submit a request

Comments