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
0