Saturday, June 27, 2020

SQLNET.ORA

SQLNET.ORA for 11g DB Server

SQLNET.AUTHENTICATION_SERVICES=(NTS)

# EZCONNECT is used by CRS
NAMES.DIRECTORY_PATH=(TNSNAMES,EZCONNECT)

DIAG_ADR_ENABLED=OFF
# ADR_BASE=C:\app\oracle

TCP.NODELAY=YES
DISABLE_OOB=ON
DEFAULT_SDU_SIZE=64240
USE_DEDICATED_SERVER=ON
SQLNET.EXPIRE_TIME=10

SQLNET.CRYPTO_CHECKSUM_SERVER=REJECTED 
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1)

SQLNET.ENCRYPTION_SERVER=REJECTED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES128)
SQLNET.CRYPTO_SEED='xxx'


LISTENER.ORA does not need the SDU size to be set.

SQLNET.ORA For 11g Client

SQLNET.AUTHENTICATION_SERVICES=(NONE)
NAMES.DIRECTORY_PATH=(TNSNAMES)

DIAG_ADR_ENABLED=OFF
# ADR_BASE=C:\app\oracle

TCP.NODELAY=YES
DISABLE_OOB=ON
DEFAULT_SDU_SIZE=64240
SQLNET.EXPIRE_TIME=10
SQLNET.OUTBOUND_CONNECT_TIMEOUT=2

No comments:

Post a Comment