ADBS: DB Link From ATP-S To On-Premise Through CMAN Failed With ORA-12564: TNS:connection Refused
(Doc ID 2796412.1)
Last updated on AUGUST 16, 2021
Applies to:
Autonomous Database on Shared Infrastructure - Version N/A to N/AInformation in this document applies to any platform.
Symptoms
DB link from ATPS to RAC on TCPS through CMAN failed with ORA-12564. DB links from ADB with correct client wallet failed to establish when the backend DB uses TCPS local listener with remote listener pointing to CMAN. Same wallet can be used to connect sqlplus with backend DB however. Once a sqlplus session is established, the same db links from ADB can connect to the target DB through the same CMAN address.
Error
select instance_name from v$instance@dblink
*
ERROR at line 1:
ORA-12564: TNS:connection refused
*
ERROR at line 1:
ORA-12564: TNS:connection refused
CMAN Trace
2021-07-20 03:38:13.078 : ntzgpcd:found value in connect data for "MY_WALLET_DIRECTORY": "/u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet"
2021-07-20 03:38:13.078 : ntzgpcd:exit
2021-07-20 03:38:13.078 : ntzgwrl:value specified for wallet directory: "/u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet"
2021-07-20 03:38:13.078 : ntzAllocate:entry
2021-07-20 03:38:13.078 : ntzAllocate:allocating 67 bytes of memory.
2021-07-20 03:38:13.078 : ntzAllocate:exit
2021-07-20 03:38:13.078 : ntzgwrl:exit
2021-07-20 03:38:13.078 : ntzGetWRLFromDatabaseCallback:entry
2021-07-20 03:38:13.078 : ntzGetWRLFromDatabaseCallback:SERVICE_NAME available and WRL type is NZTTWRL_FILE, checking to see if per-PDB wallet for TLS is available.
...
2021-07-20 03:38:13.079 : snzdfo_open_file:Opening file /u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet/ewallet.p12 with READ ONLY permissions
2021-07-20 03:38:13.079 : snzdfo_open_file:File Open/Close error
2021-07-20 03:38:13.079 : nzdfo_open:File Open/Close error
2021-07-20 03:38:13.079 : nziropen:rio open failed with error 28759
2021-07-20 03:38:13.079 : nzirclose:entry
2021-07-20 03:38:13.079 : nziropen:entry
2021-07-20 03:38:13.079 : nzdfo_open:entry
2021-07-20 03:38:13.079 : snzdfo_open_file:entry
2021-07-20 03:38:13.079 : snzdfo_open_file:Opening file /u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet/cwallet.sso with READ ONLY permissions
2021-07-20 03:38:13.079 : snzdfo_open_file:File Open/Close error
2021-07-20 03:38:13.079 : nzdfo_open:File Open/Close error
2021-07-20 03:38:13.079 : nziropen:rio open failed with error 28759
2021-07-20 03:38:13.079 : nzirclose:entry
2021-07-20 03:38:13.079 : nzdtrsr_store_certreq:nziropen() returned error 28759
...
2021-07-20 03:38:13.080 : nserror:nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=540, nt[1]=0, nt[2]=0; ora[0]=28759, ora[1]=0, ora[2]=0
2021-07-20 03:38:13.080 : nsopen:unable to open transport
2021-07-20 03:38:13.078 : ntzgpcd:exit
2021-07-20 03:38:13.078 : ntzgwrl:value specified for wallet directory: "/u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet"
2021-07-20 03:38:13.078 : ntzAllocate:entry
2021-07-20 03:38:13.078 : ntzAllocate:allocating 67 bytes of memory.
2021-07-20 03:38:13.078 : ntzAllocate:exit
2021-07-20 03:38:13.078 : ntzgwrl:exit
2021-07-20 03:38:13.078 : ntzGetWRLFromDatabaseCallback:entry
2021-07-20 03:38:13.078 : ntzGetWRLFromDatabaseCallback:SERVICE_NAME available and WRL type is NZTTWRL_FILE, checking to see if per-PDB wallet for TLS is available.
...
2021-07-20 03:38:13.079 : snzdfo_open_file:Opening file /u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet/ewallet.p12 with READ ONLY permissions
2021-07-20 03:38:13.079 : snzdfo_open_file:File Open/Close error
2021-07-20 03:38:13.079 : nzdfo_open:File Open/Close error
2021-07-20 03:38:13.079 : nziropen:rio open failed with error 28759
2021-07-20 03:38:13.079 : nzirclose:entry
2021-07-20 03:38:13.079 : nziropen:entry
2021-07-20 03:38:13.079 : nzdfo_open:entry
2021-07-20 03:38:13.079 : snzdfo_open_file:entry
2021-07-20 03:38:13.079 : snzdfo_open_file:Opening file /u03/dbfs/xxxxxxxxxxxxxxxxxxxxxxx/data/client_wallet/cwallet.sso with READ ONLY permissions
2021-07-20 03:38:13.079 : snzdfo_open_file:File Open/Close error
2021-07-20 03:38:13.079 : nzdfo_open:File Open/Close error
2021-07-20 03:38:13.079 : nziropen:rio open failed with error 28759
2021-07-20 03:38:13.079 : nzirclose:entry
2021-07-20 03:38:13.079 : nzdtrsr_store_certreq:nziropen() returned error 28759
...
2021-07-20 03:38:13.080 : nserror:nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=540, nt[1]=0, nt[2]=0; ora[0]=28759, ora[1]=0, ora[2]=0
2021-07-20 03:38:13.080 : nsopen:unable to open transport
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 |