Skip to Main Content

APEX

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!

ORA-28860: Fatal SSL error

AquaNX4Feb 24 2018 — edited Feb 26 2018

Good Day Experts:

I have one hair left after trying to configure APEX and Oracle for HTTPS.  I am hoping someone can help me out or point me in the right direction.

Oracle 12c Enterprise

I used the wallet manager to create a wallet - imported trusted certificates (entire chain)

I get the following error on my browser when I try to access the site:

This site can’t provide a secure connection

xx.xx.xx uses an unsupported protocol.

ERR_SSL_VERSION_OR_CIPHER_MISMATCH

Unsupported protocol

The client and server don't support a common SSL protocol version or cipher suite.

Here are my relevant settings for the config files:

--sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

WALLET_LOCATION =

   (SOURCE =

     (METHOD = FILE)

     (METHOD_DATA =

       (DIRECTORY = /pwallet)

     )

   )

SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS,BEQ)

SSL_CLIENT_AUTHENTICATION = FALSE

SSL_CIPHER_SUITES = (SSL_RSA_WITH_3DES_EDE_CBC_SHA, SSL_RSA_WITH_AES_128_CBC_SHA, SSL_RSA_WITH_AES_256_CBC_SHA)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

--listener.ora

WALLET_LOCATION =

  (SOURCE =

    (METHOD = FILE)

    (METHOD_DATA =

      (DIRECTORY = /pwallet)

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = C:\oracle\product\12.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\product\12.2.0\dbhome_1\bin\oraclr12.dll")

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST =xxxxxxx)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCPS)(HOST = xxxxxxx)(PORT = 443))

    )

  )

SSL_CLIENT_AUTHENTICATION = FALSE

Thank you for any help you can provide.

Aqua

This post has been answered by jariola on Feb 24 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2018
Added on Feb 24 2018
15 comments
4,443 views