Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Reg: ORA 28864 SSL connection closed gracefully.

chandra_1986May 19 2022

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.

Comments
Post Details
Added on May 19 2022
4 comments
1,526 views