Home » RDBMS Server » Networking and Gateways » TNS-03505: Failed to resolve name from 12c client to 19c DB (oracle 19c Windows 2019)
TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689116] Wed, 27 September 2023 05:42 Go to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi All,

I am not able to connect from 12c client to 19c db in windows platform.

but able to do tnsping within the server.

Client Setutp:

Quote:

ABC19C =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.0.0)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = ABC19c)
   )
 )
Lstener Status:

C:\Users\****>lsnrctl status listener1

LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 27-SEP-2023 16:01:54

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=*******)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER1
Version                   TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date                27-SEP-2023 15:51:25
Uptime                    0 days 0 hr. 10 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\Oracle19c\db_home\network\admin\listener.ora
Listener Log File         D:\Oracle19c\app\diag\tnslsnr\*******\listener1\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=*******)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=*******)(PORT=5500))(Security=(my_wallet_directory=D:\ORACLE19C\APP\admin\*****\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "*****" has 1 instance(s).
  Instance "****", status READY, has 1 handler(s) for this service...
Service "*****" has 1 instance(s).
  Instance "*****", status READY, has 1 handler(s) for this service...
The command completed successfully
Error while doing TNSPING:

*********>tnsping dpm19c

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 27-SEP-2
023 16:08:55

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
E:\Oracle_Primary\product\12.1.0\dbhome_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name
What could went wrong. kindly suggest.
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689118 is a reply to message #689116] Wed, 27 September 2023 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

TNS-03505: Failed to resolve name
 *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
          an Oracle Names server, or a native naming service.
 *Action: Verify that you entered the service name correctly.  You may need
          to ensure that the name was entered correctly into the network
          configuration.
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689119 is a reply to message #689118] Wed, 27 September 2023 06:12 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Michel,

Yes,I have entered the correct details in the tnsname.ora file, as mentioned above.

But still couldn't be.

Note: Able to do tnsping locally within the server.

Regards
M.krish
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689120 is a reply to message #689119] Wed, 27 September 2023 07:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The problem is NOT on the server it is on the CLIENT.

You showed ABC19C in client tnsnames.ora file and used "tnsping dpm19c" which is obviously not the same thing.

Check
TNSADMIN variable
%TNSADMIN%\sqlnet.ora
%TNSADMIN%\tnsnmanes.ora
E:\Oracle_Primary\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
E:\Oracle_Primary\product\12.1.0\dbhome_1\network\admin\tnsnmanes.ora

Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689122 is a reply to message #689120] Wed, 27 September 2023 09:16 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Michel,

The actual ALIAS Name is DPM19c only, in order to keep secrete of our firm's DB name, i had just showed any random name like ABC19c.

All the entries mentioned are correct only.

We four of us are trying to reach that DB in our individual machine.


Note: We are able to connect to the 12c version DB but not to the 19c version DB.

Below are the configurations of our desktop machine.

TNS_NAME:
E:\Oracle_Primary\product\12.1.0\dbhome_1\NETWORK\ADMIN

SQLNET

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES=(NONE)
TNSNAME.ORA

DPM19C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.41.42)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DPM19c)
    )
  )

Thanks and regards
M.Krish
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689124 is a reply to message #689122] Wed, 27 September 2023 10:36 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Do you have a domain set in your client's sqlnet.ora file?
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689134 is a reply to message #689124] Thu, 28 September 2023 01:22 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi John,

All above details given is of CLIENT only.

No domain has set.

Regards
M.krish
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689161 is a reply to message #689134] Fri, 29 September 2023 01:24 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi,

Got success with just mentioning ip address instead of alias name.

tnsping 10.80.41.42
C:\Users\******>tnsping 10.80.41.42

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 29-SEP-2
023 11:32:59

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
E:\Oracle_Primary\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=10.80.41.42)(PORT=1521)))
OK (20 msec)
But, what happening here.

What configuration to be changed.

please guide me.

Regards
M.krish
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689162 is a reply to message #689161] Fri, 29 September 2023 01:29 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
If you do not show the contents of E:\Oracle_Primary\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora and E:\Oracle_Primary\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnanames.ora it is difficult to assist.
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689164 is a reply to message #689162] Fri, 29 September 2023 03:57 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi John,

All i have given already in the first phase only.

Here we go:

ABC19C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.41.42)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ABC19c)
    )
  )
SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)
Regards
M.krish
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689165 is a reply to message #689164] Fri, 29 September 2023 04:01 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
I have no idea what syntax errors you may (or may not) have in your SQL*Net files that prevent clients from finding the entry that you claim to have in there. Unless you provide the files, un-redacted, there is no hope.
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689166 is a reply to message #689165] Fri, 29 September 2023 04:59 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Jhon,

Its very sad, that eventhough I have given all the details, not getting solution.
Its ok.

Regards
M.krish
Re: TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689167 is a reply to message #689166] Fri, 29 September 2023 06:09 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, you didn't provide all the details, you provided only the details YOU think are relevant.
If you really want a solution you have to provide what John asked and asked again.

Previous Topic: SQLNET.NO_NTLM=FALSE in the SQLNET.ORA file
Goto Forum:
  


Current Time: Sat Apr 27 01:30:05 CDT 2024