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)

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

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