Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Control Utilities

1 Listener Control Utility

• Listener Control Utility Overview
• SET and SHOW Commands of the Listener Control Utility
• Distributed Operations
• Oracle Net Listener Security
• Listener Control Utility Commands
  • CHANGE_PASSWORD
  • EXIT
  • HELP
  • QUIT
  • RELOAD
  • SAVE_CONFIG
  • SERVICES
  • SET
  • SET CURRENT_LISTENER
  • SET DISPLAYMODE
  • SET INBOUND_CONNECT_TIMEOUT
  • SET LOG_DIRECTORY
  • SET LOG_FILE
  • SET LOG_STATUS
  • SET PASSWORD
  • SET SAVE_CONFIG_ON_STOP
  • SET STARTUP_WAITTIME
  • SET TRC_DIRECTORY
  • SET TRC_FILE
  • SET TRC_LEVEL
  • SHOW
  • SPAWN
  • START
  • STATUS
  • STOP
  • TRACE
  • VERSION

2 Oracle Connection Manager Control Utility

• Oracle Connection Manager Control Utility Overview
• Command Modes and Syntax
• Distributed Operations
• Oracle Connection Manager Control Utility Commands
  • ADMINISTER
  • CLOSE CONNECTIONS
  • EXIT
  • HELP
  • QUIT
  • RELOAD
  • RESUME GATEWAYS
  • SAVE_PASSWORD
  • SET
  • SET ASO_AUTHENTICATION_FILTER
  • SET CONNECTION_STATISTICS
  • SET EVENT
  • SET IDLE_TIMEOUT
  • SET INBOUND_CONNECT_TIMEOUT
  • SET LOG_DIRECTORY
  • SET LOG_LEVEL
  • SET OUTBOUND_CONNECT_TIMEOUT
  • SET PASSWORD
  • SET SESSION_TIMEOUT
  • SET TRACE_DIRECTORY
  • SET TRACE_LEVEL
  • SHOW
  • SHOW ALL
  • SHOW CONNECTIONS
  • SHOW DEFAULTS
  • SHOW EVENTS
  • SHOW GATEWAYS
  • SHOW PARAMETERS
  • SHOW RULES
  • SHOW SERVICES
  • SHOW STATUS
  • SHOW VERSION
  • SHUTDOWN
  • STARTUP
  • SUSPEND GATEWAY

Part II Configuration Parameters

3 Syntax Rules for Configuration Files

• Configuration File Syntax Overview
• Further Syntax Rules for Configuration Files
• Network Character Set
• Character Set

4 Protocol Address Configuration

• ADDRESSes and ADDRESS_LISTs
  • ADDRESS
  • ADDRESS_LIST
• Protocol Parameters
• Recommended Port Numbers
• Port Number Limitations

5 Profile Parameters (sqlnet.ora)

• Overview of Profile Configuration File
• sqlnet.ora Profile Parameters
  • 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
• Diagnostic Parameters in sqlnet.ora
  • ADR Diagnostic Parameters in sqlnet.ora
    • ADR_BASE
    • DIAG_ADR_ENABLED
    • TRACE_LEVEL_CLIENT
    • TRACE_LEVEL_SERVER
    • TRACE_TIMESTAMP_CLIENT
    • TRACE_TIMESTAMP_SERVER
  • Non-ADR Diagnostic Parameters in sqlnet.ora
    • LOG_DIRECTORY_CLIENT
    • LOG_DIRECTORY_SERVER
    • LOG_FILE_CLIENT
    • LOG_FILE_SERVER
    • TRACE_DIRECTORY_CLIENT
    • TRACE_DIRECTORY_SERVER
    • TRACE_FILE_CLIENT
    • TRACE_FILE_SERVER
    • TRACE_FILELEN_CLIENT
    • TRACE_FILELEN_SERVER
    • TRACE_FILENO_CLIENT
    • TRACE_FILENO_SERVER
    • TRACE_UNIQUE_CLIENT

6 Local Naming Parameters (tnsnames.ora)

• Overview of Local Naming Parameters
• General Syntax of tnsnames.ora
• Multiple Descriptions in tnsnames.ora
• Multiple Address Lists in tnsnames.ora
• Connect-Time Failover and Client Load Balancing with Oracle Connection Managers
• Local Naming Parameters
  • Connect Descriptor Descriptions
    • DESCRIPTION
    • DESCRIPTION_LIST
  • Protocol Address Section
    • ADDRESS
    • ADDRESS_LIST
  • Optional Parameters for Lists
    • ENABLE
    • FAILOVER
    • LOAD_BALANCE
    • RECV_BUF_SIZE
    • SDU
    • SEND_BUF_SIZE
    • SOURCE_ROUTE
    • TYPE_OF_SERVICE
  • Connect Data Section
    • CONNECT_DATA
    • FAILOVER_MODE
    • GLOBAL_NAME
    • HS
    • INSTANCE_NAME
    • RDB_DATABASE
    • SERVER
    • SERVICE_NAME
    • SID
  • Security Section
    • SECURITY
    • SSL_SERVER_CERT_DN

7 Oracle Net Listener Parameters (listener.ora)

• Overview of Oracle Net Listener Configuration File
• Oracle Net Listener Parameters
  • Protocol Address Section
    • ADDRESS
    • DESCRIPTION
    • IP
    • QUEUESIZE
    • RECV_BUF_SIZE
    • SEND_BUF_SIZE
  • Static Service Registration (SID_LIST) Section
    • ENVS
    • GLOBAL_DBNAME
    • ORACLE_HOME
    • PROGRAM
    • SID_DESC
    • SID_LIST
    • SID_NAME
    • SDU
  • Connection Rate Limiter
    • CONNECTION_RATE_listener name
    • RATE_LIMIT
  • Control Parameters
    • ADMIN_RESTRICTIONS_listener_name
    • CRS_NOTIFICATION_listener_name
    • DEFAULT_SERVICE_listener_name
    • INBOUND_CONNECT_TIMEOUT_listener_name
    • PASSWORDS_listener_name
    • SAVE_CONFIG_ON_STOP_listener_name
    • SSL_CLIENT_AUTHENTICATION
    • STARTUP_WAIT_TIME_listener_name
    • SUBSCRIBE_NODE_DOWN_EVENT_listener_name
    • WALLET_LOCATION
  • Diagnostic Parameters for Oracle Net Listener
    • ADR Diagnostic Parameters in listener.ora
    • Non-ADR Diagnostic Parameters in listener.ora
• Class of Secure Transports (COST) Parameters
  • SECURE_CONTROL_listener_name
  • SECURE_REGISTER_listener_name
  • SECURE_PROTOCOL_listener_name
  • DYNAMIC_REGISTRATION_listener_name
  • Using COST Parameters in Combination

8 Oracle Connection Manager Parameters (cman.ora)

• Overview of Oracle Connection Manager Configuration File
• Oracle Connection Manager Parameters
  • ADDRESS
  • ASO_AUTHENTICATION_FILTER
  • CONNECTION_STATISTICS
  • EVENT_GROUP
  • IDLE_TIMEOUT
  • INBOUND_CONNECT_TIMEOUT
  • MAX_CMCTL_SESSIONS
  • MAX_CONNECTIONS
  • MAX_GATEWAY_PROCESSES
  • MIN_GATEWAY_PROCESSES
  • OUTBOUND_CONNECT_TIMEOUT
  • PASSWORD_instance_name
  • REMOTE_ADMIN
  • RULE
  • SESSION_TIMEOUT
• Diagnostic Parameters for Oracle Connection Manager
  • ADR Diagnostic Parameters in cman.ora
    • ADR_BASE
    • DIAG_ADR_ENABLED
    • LOG_LEVEL
    • TRACE_LEVEL
    • TRACE_TIMESTAMP
  • Non-ADR Diagnostic Parameters in cman.ora
    • LOG_DIRECTORY
    • TRACE_DIRECTORY
    • TRACE_FILELEN
    • TRACE_FILENO

9 Directory Usage Parameters (ldap.ora)

• Overview of Directory Server Usage File
• Directory Usage Parameters
  • DIRECTORY_SERVERS
  • DIRECTORY_SERVER_TYPE
  • DEFAULT_ADMIN_CONTEXT

Part III Appendixes

A Features Not Supported in this Release

• Overview of Unsupported Features
• Unsupported Parameters
• Unsupported Control Utility Commands

B Upgrade Considerations for Oracle Net Services

• Overview of Unsupported Oracle Net Services Features
• Unsupported Parameters and Control Utility Commands
• Client and Database Coexistence Issues
  • Oracle9i Database Connections
  • Oracle8i or Oracle7 Database Connections
  • Oracle Names
• Using the Oracle Net Manager to Handle Compatibility Issues
• Upgrading to Oracle Net Services
  • Step 1: Verify Service Name and Instance Name
  • Step 2: Perform Software Upgrade on the Database Server
  • Step 3: Perform Software Upgrade on the Client
  • Step 4: Perform Functional Upgrade
    • tnsnames.ora
    • listener.ora

C LDAP Schema for Oracle Net Services

• Structural Object Classes
  • orclDBServer
  • orclNetService
  • orclNetServiceAlias
  • orclNetDescription
  • orclNetDescriptionList
  • orclNetAddress
  • orclNetAddressList
  • orclNetDescriptionAux1
  • orclNetAddressAux1
• Attributes

Glossary

Index