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:
Oracle Internet Directory - Version 11.1.1.9.0 and laterOracle Net Services - Version 11.2.0.4 and later
Information in this document applies to any platform.
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
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 |