oracle11g配置网络加密传输 - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

240476947cecd4972b.png (91.69 KB, 下载次数: 554)

2025-12-21 18:41 上传

服务器端配置：[oracle@lncs admin]$ pwd
/oracle/app/product/11.2.0/db_1/network/admin
[oracle@lncs admin]$ cat sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /oracle/app
DIAG_ADR_ENABLED=OFF
DIAG_SIGHANDLER_ENABLED=FALSE
DIAG_DDE_ENABLED=FALSE
添加：

SQLNET.ENCRYPTION_SERVER = requested
SQLNET.ENCRYPTION_TYPES_SERVER= (RC4_256)
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = MD5

监听无需重启。

客户端配置：(无需配置)

LNDB58 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.205.58)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lndb)
)添加

(SECURITY =
   (ENCRYPTION_CLIENT=REQUIRED)
   (ENCRYPTION_TYPES_CLIENT=RC4_256)
   (CRYPTO_CHECKSUM_CLIENT=REQUESTED)
   (CRYPTO_CHECKSUM_TYPES_CLIENT=MD5))
)

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)