Table of Contents
- Title and Copyright Information
- Preface
-
1
Listener Control Utility
- 1.1 Listener Control Utility Overview
- 1.2 SET and SHOW Listener Control Utility Commands
- 1.3 Understanding Distributed Operations
- 1.4 Understanding Oracle Net Listener Security
-
1.5
Listener Control Utility Commands
- 1.5.1 EXIT
- 1.5.2 HELP
- 1.5.3 QUIT
- 1.5.4 RELOAD
- 1.5.5 SAVE_CONFIG
- 1.5.6 SERVICES
- 1.5.7 SET
- 1.5.8 SET CURRENT_LISTENER
- 1.5.9 SET DISPLAYMODE
- 1.5.10 SET INBOUND_CONNECT_TIMEOUT
- 1.5.11 SET LOG_DIRECTORY
- 1.5.12 SET LOG_FILE
- 1.5.13 SET LOG_STATUS
- 1.5.14 SET SAVE_CONFIG_ON_STOP
- 1.5.15 SET TRC_DIRECTORY
- 1.5.16 SET TRC_FILE
- 1.5.17 SET TRC_LEVEL
- 1.5.18 SHOW
- 1.5.19 SHOW STATS
- 1.5.20 SPAWN
- 1.5.21 START
- 1.5.22 STATUS
- 1.5.23 STOP
- 1.5.24 TRACE
- 1.5.25 VERSION
-
2
Oracle Connection Manager Control Utility
- 2.1 Connection Manager Control Utility Command Modes and Syntax
- 2.2 Oracle Connection Manager Control Utility Overview
-
2.3
Oracle Connection Manager Control Utility Commands
- 2.3.1 ADMINISTER
- 2.3.2 CLOSE CONNECTIONS
- 2.3.3 CLOSE NON_ADMIN_ENDPOINTS
- 2.3.4 EXIT
- 2.3.5 HELP
- 2.3.6 QUIT
- 2.3.7 RELOAD
- 2.3.8 RESUME GATEWAYS
- 2.3.9 SET
- 2.3.10 SET ASO_AUTHENTICATION_FILTER
- 2.3.11 SET CONNECTION_STATISTICS
- 2.3.12 SET EVENT
- 2.3.13 SET IDLE_TIMEOUT
- 2.3.14 SET INBOUND_CONNECT_TIMEOUT
- 2.3.15 SET LOG_DIRECTORY
- 2.3.16 SET LOG_LEVEL
- 2.3.17 SET OUTBOUND_CONNECT_TIMEOUT
- 2.3.18 SET SESSION_TIMEOUT
- 2.3.19 SET TRACE_DIRECTORY
- 2.3.20 SET TRACE_LEVEL
- 2.3.21 SHOW
- 2.3.22 SHOW ALL
- 2.3.23 SHOW CONNECTIONS
- 2.3.24 SHOW DEFAULTS
- 2.3.25 SHOW EVENTS
- 2.3.26 SHOW GATEWAYS
- 2.3.27 SHOW PARAMETERS
- 2.3.28 SHOW RULES
- 2.3.29 SHOW SERVICES
- 2.3.30 SHOW STATS
- 2.3.31 SHOW STATUS
- 2.3.32 SHOW VERSION
- 2.3.33 SHUTDOWN
- 2.3.34 STARTUP
- 2.3.35 SUSPEND GATEWAY
- 3 Syntax Rules for Configuration Files
- 4 Protocol Address Configuration
-
5
Parameters for sqlnet.ora Files
- 5.1 Overview of Profile Configuration Files
-
5.2
Profile Parameters in sqlnet.ora Files
- 5.2.1 ACCEPT_MD5_CERTS
- 5.2.2 ACCEPT_SHA1_CERTS
- 5.2.3 ALLOWED_WEAK_CERT_ALGORITHMS
- 5.2.4 AZURE_DB_APP_ID_URI
- 5.2.5 BEQUEATH_DETACH
- 5.2.6 CLIENT_CERTIFICATE
- 5.2.7 CLIENT_ID
- 5.2.8 EXADIRECT_FLOW_CONTROL
- 5.2.9 EXADIRECT_RECVPOLL
- 5.2.10 DEFAULT_SDU_SIZE
- 5.2.11 DISABLE_INTERRUPT
- 5.2.12 DISABLE_OOB
- 5.2.13 DISABLE_OOB_AUTO
- 5.2.14 IPC.KEYPATH
- 5.2.15 KERBEROS5_PRINCIPAL
- 5.2.16 NAMES.DEFAULT_DOMAIN
- 5.2.17 NAMES.DIRECTORY_PATH
- 5.2.18 NAMES.LDAP_AUTHENTICATE_BIND
- 5.2.19 NAMES.LDAP_AUTHENTICATE_BIND_METHOD
- 5.2.20 NAMES.LDAP_CONN_TIMEOUT
- 5.2.21 NAMES.LDAP_PERSISTENT_SESSION
- 5.2.22 NAMES.NIS.META_MAP
- 5.2.23 OCI_COMPARTMENT
- 5.2.24 OCI_CONFIG_FILE
- 5.2.25 OCI_DATABASE
- 5.2.26 OCI_IAM_URL
- 5.2.27 OCI_PROFILE
- 5.2.28 OCI_TENANCY
- 5.2.29 PASSWORD_AUTH
- 5.2.30 RECV_BUF_SIZE
- 5.2.31 REDIRECT_URI
- 5.2.32 SDP.PF_INET_SDP
- 5.2.33 SEC_USER_AUDIT_ACTION_BANNER
- 5.2.34 SEC_USER_UNAUTHORIZED_ACCESS_BANNER
- 5.2.35 SEND_BUF_SIZE
- 5.2.36 SQLNET.ALLOW_WEAK_CRYPTO
- 5.2.37 SQLNET.ALLOW_WEAK_CRYPTO_CLIENTS
- 5.2.38 SQLNET.ALLOWED_LOGON_VERSION_CLIENT
- 5.2.39 SQLNET.ALLOWED_LOGON_VERSION_SERVER
- 5.2.40 SQLNET.AUTHENTICATION_SERVICES
- 5.2.41 SQLNET.BREAK_RESET_TIMEOUT
- 5.2.42 SQLNET.CLIENT_REGISTRATION
- 5.2.43 SQLNET.CLOUD_USER
- 5.2.44 SQLNET.COMPRESSION
- 5.2.45 SQLNET.COMPRESSION_ACCELERATION
- 5.2.46 SQLNET.COMPRESSION_LEVELS
- 5.2.47 SQLNET.COMPRESSION_THRESHOLD
- 5.2.48 SQLNET.CRYPTO_CHECKSUM_CLIENT
- 5.2.49 SQLNET.CRYPTO_CHECKSUM_SERVER
- 5.2.50 SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT
- 5.2.51 SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER
- 5.2.52 SQLNET.DBFW_PUBLIC_KEY
- 5.2.53 SQLNET.DOWN_HOSTS_TIMEOUT
- 5.2.54 SQLNET.ENCRYPTION_CLIENT
- 5.2.55 SQLNET.ENCRYPTION_SERVER
- 5.2.56 SQLNET.ENCRYPTION_TYPES_CLIENT
- 5.2.57 SQLNET.ENCRYPTION_TYPES_SERVER
- 5.2.58 SQLNET.EXPIRE_TIME
- 5.2.59 SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS
- 5.2.60 SQLNET.INBOUND_CONNECT_TIMEOUT
- 5.2.61 SQLNET.FALLBACK_AUTHENTICATION
- 5.2.62 SQLNET.KERBEROS5_CC_NAME
- 5.2.63 SQLNET.KERBEROS5_CLOCKSKEW
- 5.2.64 SQLNET.KERBEROS5_CONF
- 5.2.65 SQLNET.KERBEROS5_CONF_LOCATION
- 5.2.66 SQLNET.KERBEROS5_KEYTAB
- 5.2.67 SQLNET.KERBEROS5_REALMS
- 5.2.68 SQLNET.KERBEROS5_REPLAY_CACHE
- 5.2.69 SQLNET.OUTBOUND_CONNECT_TIMEOUT
- 5.2.70 SQLNET.RADIUS_ALLOW_WEAK_CLIENTS
- 5.2.71 SQLNET.RADIUS_ALLOW_WEAK_PROTOCOL
- 5.2.72 SQLNET.RADIUS_ALTERNATE
- 5.2.73 SQLNET.RADIUS_ALTERNATE_PORT
- 5.2.74 SQLNET.RADIUS_ALTERNATE_RETRIES
- 5.2.75 SQLNET.RADIUS_ALTERNATE_TIMEOUT
- 5.2.76 SQLNET.RADIUS_ALTERNATE_TLS_HOST
- 5.2.77 SQLNET.RADIUS_ALTERNATE_TLS_PORT
- 5.2.78 SQLNET.RADIUS_AUTHENTICATION
- 5.2.79 SQLNET.RADIUS_AUTHENTICATION_INTERFACE
- 5.2.80 SQLNET.RADIUS_AUTHENTICATION_PORT
- 5.2.81 SQLNET.RADIUS_AUTHENTICATION_RETRIES
- 5.2.82 SQLNET.RADIUS_AUTHENTICATION_TIMEOUT
- 5.2.83 SQLNET.RADIUS_AUTHENTICATION_TLS_HOST
- 5.2.84 SQLNET.RADIUS_AUTHENTICATION_TLS_PORT
- 5.2.85 SQLNET.RADIUS_CHALLENGE_KEYWORD
- 5.2.86 SQLNET.RADIUS_CHALLENGE_RESPONSE
- 5.2.87 SQLNET.RADIUS_CLASSPATH
- 5.2.88 SQLNET.RADIUS_SECRET
- 5.2.89 SQLNET.RADIUS_SEND_ACCOUNTING
- 5.2.90 SQLNET.RADIUS_TRANSPORT_PROTOCOL
- 5.2.91 SQLNET.RECV_TIMEOUT
- 5.2.92 SQLNET.SEND_TIMEOUT
- 5.2.93 SQLNET.URI
- 5.2.94 SQLNET.USE_HTTPS_PROXY
- 5.2.95 SQLNET.WALLET_OVERRIDE
- 5.2.96 SSL_ALLOW_WEAK_DN_MATCH
- 5.2.97 SSL_CERTIFICATE_ALIAS
- 5.2.98 SSL_CERTIFICATE_THUMBPRINT
- 5.2.99 SSL_CERT_REVOCATION
- 5.2.100 SSL_CRL_FILE
- 5.2.101 SSL_CRL_PATH
- 5.2.102 SSL_CIPHER_SUITES
- 5.2.103 SSL_CLIENT_AUTHENTICATION
- 5.2.104 SSL_DISABLE_WEAK_EC_CURVES
- 5.2.105 SSL_ENABLE_WEAK_CIPHERS
- 5.2.106 SSL_EXTENDED_KEY_USAGE
- 5.2.107 SSL_SERVER_DN_MATCH
- 5.2.108 SSL_VERSION
- 5.2.109 TCP.ALLOWED_PROXIES
- 5.2.110 TCP.CONNECT_TIMEOUT
- 5.2.111 TCP.EXCLUDED_NODES
- 5.2.112 TCP.INVITED_NODES
- 5.2.113 TCP.NODELAY
- 5.2.114 TCP.QUEUESIZE
- 5.2.115 TCP.VALIDNODE_CHECKING
- 5.2.116 TENANT_ID
- 5.2.117 TNSPING.TRACE_DIRECTORY
- 5.2.118 TNSPING.TRACE_LEVEL
- 5.2.119 TOKEN_AUTH
- 5.2.120 TOKEN_LOCATION
- 5.2.121 USE_CMAN
- 5.2.122 USE_DEDICATED_SERVER
- 5.2.123 USE_SNI
- 5.2.124 WALLET_LOCATION
- 5.3 ADR Diagnostic Parameters in sqlnet.ora
-
5.4
Non-ADR Diagnostic Parameters in sqlnet.ora Files
- 5.4.1 LOG_DIRECTORY_CLIENT
- 5.4.2 LOG_DIRECTORY_SERVER
- 5.4.3 LOG_FILE_CLIENT
- 5.4.4 LOG_FILE_SERVER
- 5.4.5 TRACE_DIRECTORY_CLIENT
- 5.4.6 TRACE_DIRECTORY_SERVER
- 5.4.7 TRACE_FILE_CLIENT
- 5.4.8 TRACE_FILE_SERVER
- 5.4.9 TRACE_FILEAGE_CLIENT
- 5.4.10 TRACE_FILEAGE_SERVER
- 5.4.11 TRACE_FILELEN_CLIENT
- 5.4.12 TRACE_FILELEN_SERVER
- 5.4.13 TRACE_FILENO_CLIENT
- 5.4.14 TRACE_FILENO_SERVER
- 5.4.15 TRACE_UNIQUE_CLIENT
-
6
Local Naming Parameters in the tnsnames.ora File
- 6.1 Overview of Local Naming Parameters
- 6.2 General Syntax of tnsnames.ora
- 6.3 Using Multiple Descriptions in tnsnames.ora Files
- 6.4 Multiple Address Lists in tnsnames.ora Files
- 6.5 Connect-Time Failover and Client Load Balancing with Oracle Connection Managers
- 6.6 Connect Descriptor Descriptions
- 6.7 Protocol Addresses
- 6.8 Optional Parameters for Description
-
6.9
Connection Data Section
- 6.9.1 CONNECT_DATA
- 6.9.2 COLOCATION_TAG
- 6.9.3 CONNECTION_ID_PREFIX
- 6.9.4 FAILOVER_MODE
- 6.9.5 GLOBAL_NAME
- 6.9.6 HS
- 6.9.7 INSTANCE_NAME
- 6.9.8 POOL_BOUNDARY
- 6.9.9 POOL_CONNECTION_CLASS
- 6.9.10 POOL_NAME
- 6.9.11 POOL_PURITY
- 6.9.12 RDB_DATABASE
- 6.9.13 SHARDING_KEY
- 6.9.14 SHARDING_KEY_ID
- 6.9.15 SUPER_SHARDING_KEY
- 6.9.16 SERVER
- 6.9.17 SERVICE_NAME
- 6.9.18 TUNNEL_SERVICE_NAME
-
6.10
Security Section
- 6.10.1 AUTHENTICATION_SERVICE
- 6.10.2 AZURE_DB_APP_ID_URI
- 6.10.3 CLIENT_CERTIFICATE
- 6.10.4 CLIENT_ID
- 6.10.5 IGNORE_ANO_ENCRYPTION_FOR_TCPS
- 6.10.6 KERBEROS5_CC_NAME
- 6.10.7 KERBEROS5_PRINCIPAL
- 6.10.8 OCI_COMPARTMENT
- 6.10.9 OCI_CONFIG_FILE
- 6.10.10 OCI_DATABASE
- 6.10.11 OCI_IAM_URL
- 6.10.12 OCI_PROFILE
- 6.10.13 OCI_TENANCY
- 6.10.14 PASSWORD_AUTH
- 6.10.15 REDIRECT_URI
- 6.10.16 SECURITY
- 6.10.17 SSL_CERTIFICATE_ALIAS
- 6.10.18 SSL_CERTIFICATE_THUMBPRINT
- 6.10.19 SSL_CLIENT_AUTHENTICATION
- 6.10.20 SSL_DISABLE_WEAK_EC_CURVES
- 6.10.21 SSL_SERVER_CERT_DN
- 6.10.22 SSL_SERVER_DN_MATCH
- 6.10.23 SSL_VERSION
- 6.10.24 TENANT_ID
- 6.10.25 TOKEN_AUTH
- 6.10.26 TOKEN_LOCATION
- 6.10.27 WALLET_LOCATION
- 6.11 Timeout Parameters
- 6.12 Compression Parameters
- 7 Centralized Configuration Provider Naming Parameters
-
8
Oracle Net Listener Parameters in the listener.ora File
- 8.1 Overview of Oracle Net Listener Configuration File
- 8.2 Protocol Address Parameters
- 8.3 Connection Rate Limiter Parameters
-
8.4
Control Parameters
- 8.4.1 ADMIN_RESTRICTIONS_listener_name
- 8.4.2 ALLOW_MULTIPLE_REDIRECTS_listener_name
- 8.4.3 CRS_NOTIFICATION_listener_name
- 8.4.4 DEDICATED_THROUGH_BROKER_LISTENER
- 8.4.5 DEFAULT_SERVICE_listener_name
- 8.4.6 ENABLE_EXADIRECT_listener_name
- 8.4.7 INBOUND_CONNECT_TIMEOUT_listener_name
- 8.4.8 LOCAL_REGISTRATION_ADDRESS_listener_name
- 8.4.9 MAX_ALL_CONNECTIONS_listener_name
- 8.4.10 MAX_REG_CONNECTIONS_listener_name
- 8.4.11 REGISTRATION_EXCLUDED_NODES_listener_name
- 8.4.12 REGISTRATION_INVITED_NODES_listener_name
- 8.4.13 REMOTE_REGISTRATION_ADDRESS_listener_name
- 8.4.14 SAVE_CONFIG_ON_STOP_listener_name
- 8.4.15 SERVICE_RATE_listener_name
- 8.4.16 SSL_CIPHER_SUITES
- 8.4.17 SSL_CLIENT_AUTHENTICATION
- 8.4.18 SSL_DISABLE_WEAK_EC_CURVES
- 8.4.19 SSL_VERSION
- 8.4.20 SUBSCRIBE_FOR_NODE_DOWN_EVENT_listener_name
- 8.4.21 USE_SID_AS_SERVICE_listener_name
- 8.4.22 USE_SNI_listener_name
- 8.4.23 VALID_NODE_CHECKING_REGISTRATION_listener_name
- 8.4.24 WALLET_LOCATION
- 8.5 ADR Diagnostic Parameters for Oracle Net Listener
- 8.6 Non-ADR Diagnostic Parameters for Oracle Net Listener
- 8.7 Class of Secure Transports Parameters
-
9
Oracle Connection Manager Parameters
- 9.1 Overview of Oracle Connection Manager Configuration File
-
9.2
Oracle Connection Manager Parameters
- 9.2.1 ADDRESS
- 9.2.2 ADMIN_GROUP
- 9.2.3 ASO_AUTHENTICATION_FILTER
- 9.2.4 BANDWIDTH
- 9.2.5 CLIENT_DN_RULE_MATCH
- 9.2.6 COMPRESSION
- 9.2.7 COMPRESSION_LEVELS
- 9.2.8 COMPRESSION_THRESHOLD
- 9.2.9 CONNECTION_STATISTICS
- 9.2.10 DN_LIST
- 9.2.11 ENABLE_IP_FORWARDING
- 9.2.12 EVENT_GROUP
- 9.2.13 EXPIRE_TIME
- 9.2.14 GROUP
- 9.2.15 IDLE_TIMEOUT
- 9.2.16 INBOUND_CONNECT_TIMEOUT
- 9.2.17 IP_RATE_COUNT
- 9.2.18 IP_RATE_INTERVAL
- 9.2.19 IP_RATE_BLOCK
- 9.2.20 LOG_FILE_NUM
- 9.2.21 LOG_FILE_SIZE
- 9.2.22 LOG_SUPPRESS_NODES
- 9.2.23 MAX_ALL_CONNECTIONS
- 9.2.24 MAX_CMCTL_SESSIONS
- 9.2.25 MAX_BANDWIDTH_GROUP
- 9.2.26 MAX_CONNECTIONS
- 9.2.27 MAX_GATEWAY_PROCESSES
- 9.2.28 MAX_REG_CONNECTIONS
- 9.2.29 MIN_GATEWAY_PROCESSES
- 9.2.30 NEXT_HOP
- 9.2.31 OUTBOUND_CONNECT_TIMEOUT
- 9.2.32 REGISTRATION_EXCLUDED_NODES
- 9.2.33 REGISTRATION_INVITED_NODES
- 9.2.34 REST_ADDRESS
- 9.2.35 RULE
- 9.2.36 SDU
- 9.2.37 SERVICE_RATE
- 9.2.38 SESSION_TIMEOUT
- 9.2.39 SSL_CIPHER_SUITES
- 9.2.40 SSL_CLIENT_AUTHENTICATION
- 9.2.41 SSL_VERSION
- 9.2.42 TRACE_FILE
- 9.2.43 USE_SERVICE_AS_TNSNAMES_ALIAS
- 9.2.44 USE_SID_AS_SERVICE
- 9.2.45 USE_SNI
- 9.2.46 VALID_NODE_CHECKING_REGISTRATION
- 9.2.47 WALLET_LOCATION
- 9.3 Oracle Connection Manager in Traffic Director Mode Parameters
- 9.4 ADR Diagnostic Parameters for Oracle Connection Manager
- 9.5 Non-ADR Diagnostic Parameters for Oracle Connection Manager
- 9.6 Oracle Connection Manager Tunneling Parameters
- 10 Directory Usage Parameters in the ldap.ora File
- 11 LDAP Parameters in the Connect Identifier
- A Upgrade Considerations for Oracle Net Services
- B LDAP Schema for Oracle Net Services
- C Configuring OpenLDAP Server to Use Oracle Net Naming Directory