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：協定擴充卡錯誤'。

請讓我知道我在哪裡做錯了。請幫助我。