Hi experts,
SSL db while connecting giving an error : ORA 28864 SSL connection closed gracefully.
Listener.ora
# listener.ora Network Configuration File: D:\Oracle\Ora11\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SSL_CLIENT_AUTHENTICATION=FALSE
#SECURE_CONTROL_LISTENER = TCPS
#SECURE_REGISTER_LISTENER = TCPS
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=D:\Oracle\Ora11\product\11.2.0\dbhome_1\BIN\wallet)))
U4N =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SR-111-DB.SCT.VN)(PORT = 3001))
(ADDRESS = (PROTOCOL = TCPS)(HOST = SR-111-DB.SCT.VN)(PORT = 2484))
)
)
SID_LIST_U4N =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = U4N)
(ORACLE_HOME = D:\Oracle\Ora11\product\11.2.0\dbhome_1)
(SID_NAME = U4N)
)
)
ADR_BASE_U4N = D:\Oracle\Ora11\product\11.2.0\dbhome_1\log
sqlnet.ora:
# 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=(TCPS,NTS,NONE)
NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)
SSL_CLIENT_AUTHENTICATION=FALSE
SSL_VERSION = 0
WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=D:\Oracle\Ora11\product\11.2.0\dbhome_1\BIN\wallet)))
SSL_CIPHER_SUITES=(SSL_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_3DES_EDE_CBC_SHA)
SQLNET.AUTHENTICATION_SERVICES=(TCPS,NTS,NONE)
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
#sqlnet.fallback_authentication = TRUE
#SSL_CLIENT_AUTHENTICATION=FALSE
ADR_BASE_N4U = D:\Oracle\Ora11\product\11.2.0\dbhome_1\log
#NAMES.DEFAULT_DOMAIN = VN
tnsnames.ora
# tnsnames.ora Network Configuration File: D:\Oracle\Ora11\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
CUSU.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SVR-1132-DB)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CUSU)
)
)
EBSUAT.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SVR-1135-EBS)(PORT = 3002))
)
(CONNECT_DATA =
(SID = EBSU)
)
)
N4DEV.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = svr-1117-db)(PORT = 3002))
)
(CONNECT_DATA =
(SERVICE_NAME = N4D)
(INSTANCE_NAME = N4D)
)
)
N4PROD.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 192.168.202.30)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = 192.168.202.30)(Port = 1522))
)
(CONNECT_DATA =
(SID = N4P)
)
)
N4BU.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = svr-1117-db)(PORT = 3003))
)
(CONNECT_DATA =
(SERVICE_NAME = n4bu)
)
)
EBS26UAT.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ws-1054)(PORT = 3002))
)
(CONNECT_DATA =
(SID = EBSU)
)
)
U4NAT.SPCT.VN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SR-111-DB.SCT.VN)(PORT = 3001))
)
(CONNECT_DATA =
(SERVICE_NAME = U4N)
(INSTANCE_NAME = U4N)
)
)
U4NAT.SPCTSSL.VN=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=SR-111-DB.SCT.VN)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=U4N)(INSTANCE_NAME=U4N)))
when doing sqlplus u4_owner/u4_onwer@U4NAT.SPCTSSL.VN
Error below :-
Error:
ORA-28864 : SSL connection closed gracefully.
please suggest, how to fix this issue, as listener status showing up and 2484 port is listening from db listener status, tnsping giving an error tns-protocol adaptor error TNS-12560 Tns protocol adaptor error.