Oracle/Admin

ORACLE NETWORK ; sqlnet.ora (링크)

에몽이ㅋ 2012. 4. 4. 10:52
sqlnet.ora 파일에 대한 설명 링크
http://docs.oracle.com/cd/B28359_01/network.111/b28317/sqlnet.htm



sqlnet.ora : Profile Configuration File로 아래와같은 기능을 사용할 수 있습니다.
Specify the client domain to append to unqualified names
  • Prioritize naming methods

  • Enable logging and tracing features

  • Route connections through specific processes

  • Configure parameters for external naming

  • Configure Oracle Advanced Security

  • Use protocol-specific parameters to restrict access to the database



  • 또한 sqlnet.ora안에는 아래와 같은 parameter들을 사용할 수 있습니다.

  • BEQUEATH_DETACH

  • DEFAULT_SDU_SIZE

  • DISABLE_OOB

  • NAMES.DCE.PREFIX

  • NAMES.DEFAULT_DOMAIN

  • NAMES.DIRECTORY_PATH

  • NAMES.LDAP_AUTHENTICATE_BIND

  • NAMES.LDAP_PERSISTENT_SESSION

  • NAMES.NIS.META_MAP

  • RECV_BUF_SIZE

  • SDP.PF_INET_SDP

  • SEC_USER_AUDIT_ACTION_BANNER

  • SEC_USER_UNAUTHORIZED_ACCESS_BANNER

  • SEND_BUF_SIZE

  • SQLNET.ALLOWED_LOGON_VERSION

  • SQLNET.AUTHENTICATION_KERBEROS5_SERVICE

  • SQLNET.AUTHENTICATION_SERVICES

  • SQLNET.CLIENT_REGISTRATION

  • SQLNET.CRYPTO_CHECKSUM_CLIENT

  • SQLNET.CRYPTO_CHECKSUM_SERVER

  • SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT

  • SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER

  • SQLNET.CRYPTO_SEED

  • SQLNET.ENCRYPTION_CLIENT

  • SQLNET.ENCRYPTION_SERVER

  • SQLNET.ENCRYPTION_TYPES_CLIENT

  • SQLNET.ENCRYPTION_TYPES_SERVER

  • SQLNET.EXPIRE_TIME

  • SQLNET.INBOUND_CONNECT_TIMEOUT

  • SQLNET.KERBEROS5_CC_NAME

  • SQLNET.KERBEROS5_CLOCKSKEW

  • SQLNET.KERBEROS5_CONF

  • SQLNET.KERBEROS5_KEYTAB

  • SQLNET.KERBEROS5_REALMS

  • SQLNET.OUTBOUND_CONNECT_TIMEOUT

  • SQLNET.RADIUS_ALTERNATE

  • SQLNET.RADIUS_ALTERNATE_PORT

  • SQLNET.RADIUS_ALTERNATE_RETRIES

  • SQLNET.RADIUS_AUTHENTICATION

  • SQLNET.RADIUS_AUTHENTICATION_INTERFACE

  • SQLNET.RADIUS_AUTHENTICATION_PORT

  • SQLNET.RADIUS_AUTHENTICATION_RETRIES

  • SQLNET.RADIUS_AUTHENTICATION_TIMEOUT

  • SQLNET.RADIUS_CHALLENGE_RESPONSE

  • SQLNET.RADIUS_SECRET

  • SQLNET.RADIUS_SEND_ACCOUNTING

  • SQLNET.RECV_TIMEOUT

  • SQLNET.SEND_TIMEOUT

  • SSL_CERT_REVOCATION

  • SSL_CERT_FILE

  • SSL_CERT_PATH

  • SSL_CIPHER_SUITES

  • SSL_CLIENT_AUTHENTICATION

  • SSL_SERVER_DN_MATCH

  • SSL_VERSION

  • TCP.CONNECT_TIMEOUT

  • TCP.EXCLUDED_NODES

  • TCP.INVITED_NODES

  • TCP.VALIDNODE_CHECKING

  • TCP.NODELAY

  • TNSPING.TRACE_DIRECTORY

  • TNSPING.TRACE_LEVEL

  • USE_CMAN

  • USE_DEDICATED_SERVER

  • WALLET_LOCATION

  • WALLET_OVERRIDE