Forum Stats

  • 3,874,563 Users
  • 2,266,761 Discussions
  • 7,911,898 Comments

Discussions

Reg: ORA 28864 SSL connection closed gracefully.

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.

Answers