Reg: ORA 28864 SSL connection closed gracefully.

chandra_1986

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.

chandra_1986

Any comments

User_B3VZO

Hello, I would like to ask how you solved the problem. My server version is 11.2.0.1 and I also encountered this problem.

User_KACDL

Coding also involves the creation of a database, data structure, and a code generator. It also requires a programmer to understand and use various programming tools https://mlsdev.com, including linkers, compilers, and debuggers. During the development process, you'll also need to write tests to ensure that your code is working correctly and delivering the desired outcome.

Kean Sargent

Even a single error or flaw that surfaced after the product was released could have disastrous results. Yes, businesses make significant investments in testing and quality assurance. But what more can you do to hasten the launching of your product and lessen security flaws? https://sloboda-studio.com/blog/software-code-audit Auditing software code is the solution.