Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Reg: ORA 28864 SSL connection closed gracefully.

chandra_1986
Member Posts: 298 Blue Ribbon
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/[email protected]
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.
Tagged:
Answers
-
Any comments