oracle jdbc thin client login hangs no error

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = mydbservername)(PORT = 1521)) Now edit listener.ora in the server to add the secure endpoint (PROTOCOL = TCPS): LISTENER = SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA) SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS,BEQ) Now indicate in SQLNET.ORA the location of the wallet (in TNS_ADMIN folder, in both client and server). Orapki wallet add -wallet 'wallet' -pwd XXXXXXXX -trusted_cert -cert %REMOTECOMPUTER%.crt Then, create self-signed certificates (or signed by a trusted CA) orapki wallet add -wallet 'wallet' -pwd XXXXXXXX -dn 'CN=%COMPUTERNAME%' -keysize 1024 -self_signed -sign_alg sha256 -validity 3650Įxchange via SFTP/SCP and import each other certificate in the wallet orapki wallet export -wallet 'wallet' -pwd XXXXXXXX -dn 'CN=%COMPUTERNAME%' -cert. To setup TCPS with JDBC, we have a few tasks.įirst, create the wallet in both client and server: orapki wallet create -wallet 'wallet' -pwd XXXXXXXX -auto_login

Oracle jdbc thin client login hangs no error