oracle 监听加密 tcps,oracle - 为Oracle配置SSL连接 - SO中文参考 - www.soinside.com

我正在尝试通过ODBC为Oracle配置SSL加密的连接。我在Internet上进行搜索，发现此配置的步骤与此类似，并且在[[server端更改后，最新的配置文件如下：sqlnet.oraSQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS)

SSL_VERSION = 3.1

SQLNET.ENCRYPTION_SERVER = requested

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SSL_CLIENT_AUTHENTICATION = TRUE

SQLNET.CRYPTO_SEED = 'VALIDSEED111'

SQLNET.ENCRYPTION_TYPES_SERVER= (AES256, RC4_256, AES192, 3DES168,

AES128, RC4_128, 3DES112, RC4_56, DES, RC4_40, DES40)

WALLET_LOCATION = (SOURCE =

(METHOD = FILE)

(METHOD_DATA =

(DIRECTORY = /home/oracle/oracle/product/10.2.0/db_1/bin)

) )

SSL_CIPHER_SUITES= (SSL_RSA_WITH_RC4_128_MD5)listener.oraSID_LIST_LISTENER = (SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

) )

SSL_CLIENT_AUTHENTICATION = FALSE

WALLET_LOCATION = (SOURCE =

(METHOD = FILE)

(METHOD_DATA =

(DIRECTORY = /home/oracle/oracle/product/10.2.0/db_1/bin)

) )

LISTENER = (DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCPS)(HOST = localhost.localdomain)(PORT = 1531))

) )我通过执行以下命令在更新了listener.ora文件之后也重新启动了监听器：

lsnrctl stop

lsnrctl start更改

客户端端后的最新配置文件如下：sqlnet.oraSQLNET.AUTHENTICATION_SERVICES= (BEQ, TCPS, NTS)

SSL_VERSION = 3.1

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SSL_CLIENT_AUTHENTICATION = TRUE

SQLNET.ENCRYPTION_TYPES_CLIENT= (AES256, RC4_256, AES192, 3DES168,

AES128, RC4_128, 3DES112, RC4_56, DES, RC4_40, DES40)

WALLET_LOCATION = (SOURCE =

(METHOD = FILE)

(METHOD_DATA =

(DIRECTORY = C\app\oracle\product\11.2.0\client_1\BIN\owm\wallets)

) )

SSL_CIPHER_SUITES= (SSL_RSA_WITH_RC4_128_MD5)

ADR_BASE = C:\app\oracle\product\11.2.0\client_1\logtnsnames.oraORCL43 = (DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCPS)(HOST = XX.XX.XX.XX)(PORT = 1531))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

(SECURITY=

(SSL_SERVER_CERT_DN="cn=TGL,cn=OracleContext,c=IN,o=PQR")

) )listener.oraSSL_CLIENT_AUTHENTICATION = FALSE

LISTENER = (DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1521)) )

ADR_BASE_LISTENER = C:\app\oracle\product\11.2.0\client_1\log[当我尝试使用'ORCL43'通过SQL Plus连接Oracle数据库时，出现了<< [ORA-12560：TNS：协议适配器错误'。

请让我知道我在哪里做错了。请帮助我。