TNS-03505: Failed to resolve name from 12c client to 19c DB [message #689116] |
Wed, 27 September 2023 05:42 |
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|