Database Administration (MOSC)

MOSC Banner

Connection to database using TCPS on RAC

Hi

Oracle client and db 19c

I am trying to use TCPS instead of TCP. But I am having little difficulties.

Here is what I have done.

-- Configured TCPS:2484 from database server 1 and 2
$ srvctl modify listener -p TCP:1521/TCPS:2484

-- Added to listener.ora
-- vi /oracle/19c/grid/network/admin/listener.ora
SSL_CLIENT_AUTHENTICATION = FALSE
WALLET_LOCATION =
  (SOURCE =
	(METHOD = FILE)
	(METHOD_DATA =
	  (DIRECTORY = /oracle/wallet)
	)
  )

-- Restarted listener
lsnrctl stop
lsnrctl start

-- Added to DB_HOME sqlnet.ora file
WALLET_LOCATION =
   (SOURCE =
     (METHOD = FILE)
     (METHOD_DATA =
       (DIRECTORY = /oracle/wallet)
     )
   )
SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS,BEQ)
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA)

--
-- Client and server wallet
-- Client machine
$wallet_loc="c:\oracle\wallet"
orapki wallet create -wallet $wallet_loc -pwd Walletpass123 -auto_login_local
orapki wallet add -wallet $wallet_loc -pwd Walletpass123 -dn "CN=%computername%" -keysize 1024 -self_signed -validity 3650
orapki wallet export -wallet $wallet_loc -pwd Walletpass123 -dn "CN=%computername%" -cert

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center