LDAP : tnsping = TNS-03505: Failed to resolve name using LDAP - sqlplus connection error ORA-12154: TNS:could not resolve the connect identifier specified - connect to DB via LDAP/OID (Doc ID 2301489.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

sqlplus system@ORCL :
===============

SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 21 13:11:14 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

tnsping ORCL :
=========

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 21-AUG-2017 12:46:57
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
/dbprog/oracle/product/12.2.0.1.1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name

Successful ldapsearch done on LDAP server :
=============================

ldapsearch -h <OS-host-name> -p 389 -D "cn=<USERNAME> -w XXXXXX -b "cn=<USERNAME>,cn=OracleContext,dc=<domain_name>,dc=no" -s base "objectclass=*"
cn=<USERNAME>,cn=OracleContext,dc=statoil,dc=no
objectclass=top
objectclass=orclNetService
cn=<USERNAME>
orclnetdescstring=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=db hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))
orclnetdescname=000:cn=<USERNAME>

Changes

New LDAP entry or modification in the LDAP Server OR OID Parameters

Cause

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