ТЕМА:

Далее по тексту:

1521 – default non-ssl port number (Oracle DB server)
2484 - default ssl port number (Oracle DB server)

ORACLE-HOST1.COM – Oracle server (physical machine) host name

ORCL – Oracle DB Instance name
cn=ORCL - отличительное имя сервера БД (д.б. такое же точно как в wallet'e сервера БД

1.1. $ORACLE_HOME\network\admin\tnsnames.ora (сервер и клиент).
#
# для обычных пользователей
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-host1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ORCL)
)
)
# для особых случаев
ORCLSSL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = oracle-host1)(PORT = 2484))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
(SID = ORCL)
)
(SECURITY=
(AUTHENTICATION_SERVICE = TCPS)
(SSL_SERVER_CERT_DN="cn=ORCL")
)
)

2. $ORACLE_HOME\network\admin\listener.ora (сервер)
#
#
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\wallet) # здесь указать где реально есть wallet сервера БД
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-host1)(PORT = 1521)) # non SSL
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = oracle-host1)(PORT = 2484)) # SSL
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92) # здесь указать реальный oracle_home
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\ora92) # здесь указать реальный oracle_home
(SID_NAME = ORCL)
)
)
SSL_CLIENT_AUTHENTICATION = FALSE

3.1. $ORACLE_HOME\network\admin\sqlnet.ora (сервер).
#
#
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\wallet) # здесь указать где реально есть wallet сервера БД
)
)

#SSL_CIPHER_SUITES= (SSL_RSA_WITH_3DES_EDE_CBC_SHA)
SQLNET.AUTHENTICATION_SERVICES= (NTS,BEQ, TCPS)
#
SSL_CLIENT_AUTHENTICATION = TRUE
SSL_VERSION = 3.0
NAMES.DIRECTORY_PATH= (TNSNAMES)

3.2. $ORACLE_HOME\network\admin\sqlnet.ora (клиент).
#
#
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\wallet) # здесь указать где реально есть wallet клиента
)
)
#SSL_CIPHER_SUITES= (SSL_RSA_WITH_3DES_EDE_CBC_SHA)
SQLNET.AUTHENTICATION_SERVICES= (TCPS)
#
SSL_CLIENT_AUTHENTICATION = TRUE
SSL_VERSION = 3.0
NAMES.DIRECTORY_PATH= (TNSNAMES)