Configuring and enabling SSL connection
I'm trying to configure an SSL connection (DB version 11.2.0.1.0).Both client and server are on the same maschine.
My listener.ora, sqlnet.ora, tnsnames.ora files are:
---listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = ...\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:...\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
SSL_CLIENT_AUTHENTICATION = TRUE
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = localhost)(PORT = 2484))
)
)
ADR_BASE_LISTENER = ...\app\pachowicz
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = ...\product\11.2.0\dbhome_1\BIN\owm\wallets\pachowicz)
My listener.ora, sqlnet.ora, tnsnames.ora files are:
---listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = ...\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:...\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
SSL_CLIENT_AUTHENTICATION = TRUE
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = localhost)(PORT = 2484))
)
)
ADR_BASE_LISTENER = ...\app\pachowicz
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = ...\product\11.2.0\dbhome_1\BIN\owm\wallets\pachowicz)
1