My Oracle Support Banner

OUD12c: The "tnsping" command Fails with Error: "TNS-03505: Failed to resolve name" (Doc ID 2798652.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle Unified Directory - Version 12.2.1.3 and later
Information in this document applies to any platform.

Symptoms

Scenario 1:

As per the OUD Install guide , In OUD 12c TNS aliases can be used when EUS is configured.
EUS is enabled in OUD while creating the instance.
Using the below dsconfig command it's confirmed that  "eus-alias-resolution" is enabled.

dsconfig -h <host> -p <admin port> -D "<DS admin>" --bindPasswordFile pwd.txt -X list-workflow-elements

value for the aliasedObjectName is updated correctly in OUD for the database entry.
However tnsping fails with the below errors.

tnsping <dbname>

TNS Ping Utility for 32-bit Windows: Version 19.0.0.0.0 - Production on 03-AUG-2021 13:02:38
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
C:\APPS\oracle\product\11.2.0\tnsadmin\sqlnet.ora
TNS-03505: Failed to resolve name

access log has the below errors.

[03/Aug/2021:13:02:40 -0500] CONNECT conn=14997 from=<DB IP>:<port> to=<OUD IP>:<LDAP PORT> protocol=LDAP
[03/Aug/2021:13:02:40 -0500] BIND REQ conn=14997 op=0 msgID=1 type=SIMPLE dn="" version=3
[03/Aug/2021:13:02:40 -0500] BIND RES conn=14997 op=0 msgID=1 result=0 authDN="" etime=1
[03/Aug/2021:13:02:40 -0500] SEARCH REQ conn=14997 op=1 msgID=2 base="cn=<dbname>,cn=OracleContext,<base DN>" scope=base filter="(objectclass=*)" attrs="objectclass,orclNetDescString,orclNetDescName,orclVersion"
[03/Aug/2021:13:02:40 -0500] SEARCH RES conn=14997 op=1 msgID=2 result=80 message="An unexpected error was encountered while processing a search in one of the Directory Server backends: NullPointerException()" nentries=0 etime=2
[03/Aug/2021:13:02:40 -0500] UNBIND REQ conn=14997 op=2 msgID=3
[03/Aug/2021:13:02:40 -0500] DISCONNECT conn=14997 reason="Client Disconnect"

 Scenario 2:

The same configuration works in another environment.

But in this new server, tnsping for a DB service name in a newly added context suffix dn fails with TNS-03505: Failed to resolve name

The access log shows no errors but no/0 entries are returned from the tnsping related search:

[2023-02-22T21:00:49.919+00:00] [<oud instance>] [TRACE] [OUD-24641549] [PROTOCOL] [host: <hostname>] [nwaddr: <IP>] [tid: <tid>] [userId: userid] [ecid: <ecid>] [category: RES] [conn: 115] [op: 0] [msgID: 1] [result: 0] [authDN: ] [etime: 0] BIND
[2023-02-22T21:00:49.938+00:00] [<oud instance>] [TRACE] [OUD-24641551] [PROTOCOL] [host: <hostname>] [nwaddr: <IP>] [tid: <tid>] [userId: userid] [ecid: <ecid>] [category: REQ] [conn: 115] [op: 1] [msgID: 2] [base: cn=<db_name>,cn=OracleContext,<new suffix dn>] [scope: base] [filter: (objectclass=*)] [attrs: objectclass,orclNetDescString,orclNetDescName,orclVersion] SEARCH
[2023-02-22T21:00:49.938+00:00] [<oud instance>] [TRACE] [OUD-24641552] [PROTOCOL] [host: <hostname>] [nwaddr: <IP>] [tid: <tid>] [userId: userid] [ecid: <ecid>] [category: RES] [conn: 115] [op: 1] [msgID: 2] [result: 0] [nentries: 0] [etime: 1] SEARCH
[2023-02-22T21:00:49.957+00:00] [<oud instance>] [TRACE] [OUD-24641550] [PROTOCOL] [host: <hostname>] [nwaddr: <IP>] [tid: <tid>] [userId: userid] [ecid: <ecid>] [category: REQ] [conn: 115] [op: 2] [msgID: 3] UNBIND

 

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
Cause
Solution


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