Hello,
I've used the following guide
https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-and-tls-for-database-connections#client-wallet-and-certif…
to configure a SSL connection between the database server and client.
I've configured it for Oracle 12g and client without any issues, but when I attempt to configure for Oracle 11.2.0.4 server & 11.2.0.4.0 client.
But when I attempt to connect via SQLPLUS, I'm redirected to the TCP port (1521) instead of the TCPS port (which I've configured to 1522).
The connection attempt is recorded in the listener log as follows:
Mon Dec 19 16:44:58 2016
19-DEC-2016 16:44:58 * 12560
TNS-12560: TNS:protocol adapter error
TNS-00540: SSL protocol adapter failure
64-bit Windows Error: 61: Unknown error
19-DEC-2016 16:44:58 * (CONNECT_DATA=(SERVICE_NAME=VDB)(CID=(PROGRAM=C:\oracle\ora112\client\bin\sqlplus.exe)(HOST=2012R2-SC-2)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.220.70)(PORT=50101)) * establish * NNVSDB * 0
The sqlnet.ora file:
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\wallet)
)
)
SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS)
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA)
The listener.ora file:
ADR_BASE_NNVSDB_LISTENER = C:\oracle
SSL_CLIENT_AUTHENTICATION = FALSE
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\wallet)
)
)
VDB_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = 192.168.220.71)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.71)(PORT = 1521))
)
)
SID_LIST_VDB_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = VDB)
(ORACLE_HOME = C:\oracle\ora112)
)
)
Please advise.
Message was edited by: DavidFaiz, added listener.ora & sqlnet.ora files.