My Oracle Support Banner

OID Database Tools (i.e, catalog, ldifwrite, bulkload, oidpasswd) Fail with: Unable to Connect to Database: Incorrect location for tnsnames.ora or Incorrect TNS Connect string or Invalid Password (Doc ID 882360.1)

Last updated on APRIL 03, 2023

Applies to:

Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Internet Directory Database (DB) tools, such as catalog, ldifwrite, bulkload, bulkdelete or oidpasswd, for example:

ldifwrite connect=<SERVICE_NAME> basedn="cn=users,dc=<COMPANY>,dc=com" ldiffile="<OUTPUT_PATH/FILENAME>"

Fails with:

OID 12c:
Unable to Connect to Database: Incorrect location for tnsnames.ora (derived from DOMAIN_HOME) or Incorrect TNS Connect string or Invalid Password

OID 11g:
Unable to Connect to Database: Incorrect location for tnsnames.ora (derived from ORACLE_INSTANCE) or Incorrect TNS Connect string or Invalid Password

Oidpasswd tool may fail as follows, for example:

$oidpasswd connect=<SERVICE_NAME> unlock_su_acct=true
OID DB user password:
ERROR * gsldpuUnlockSuAccount * ORA-12154:ORA-12154: TNS:could not resolve the connect identifier specified
encountered
Error in unlocking OID super user account.


Even after setting the environment variables correctly, including TNS_ADMIN, DB tools continue to fail.

Verified that sqlplus with the same OID DB user (ODS) username, password and servicename of OID works fine.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.