Skip Headers
Oracle® Database Net Services Reference Guide
10
g
Releas e 1 (10.1)
Part Number B10776-01
Home
Book List
Index
Master Index
Feedback
Next
View PDF
Contents
Title and Copyright Information
Se nd Us Your Comments
Preface
Audience
Organization
Related Documentation
Conventions
Documentation Accessibility
Part I Contro l Utilities
1
Listener Control Utility
Listener Control Utility Overview
SET and SHOW Commands of the Listener Control Utility
Distrib uted Operations
Listener Security
Listener Co ntrol 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 SAV E_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 CONNE CTION_STATISTICS
SET EVENT
SET IDLE_TIMEOUT
SET INBOUND_CONNECT_TIMEOUT
SET LOG_DIRECTORY
< /dd>
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
S HOW 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 Configura tion Files
Network Character Set
Character Se t
4
Proto col 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
Profile Parameters
BEQUEATH_DETACH
DEFAULT_SDU_SIZE
DISABLE_OOB
LOG_DIRECTORY_CLIENT
LOG_DIRECTORY_SERVER
LOG_FILE_CLIENT
LOG_FILE_SERVER
NAMES.DCE.PREFIX
NAMES.D EFAULT_DOMAIN
NAMES.DIRECTORY_PATH
NAMES.NIS. META_MAP
RECV_BUF_SIZE
SEND_BUF_SIZE
SQLNET_ALLOWED_LOGON_VERSIONS
SQLNET.AUTHENTICATION_K ERBEROS5_SERVICE
SQLNET.AUTHENTICATION_GSSAPI_SERVICE
SQLNET.AUTHENTICATION_SERVICES
SQLNET.CLIENT_REGISTRATION
SQLNET.CRYPTO_CHECKSUM_CLIENT
SQLNET.CRYPTO_CHECKSUM_SERVER
SQLNET.CRYPTO_CHECKSUM_TYPE_CLIENT
SQLNET.CRYPTO_CHE CKSUM_TYPE_SERVER
SQLNET.CRYPTO_SEED
SQLNET.E NCRYPTION_CLIENT
SQLNET.ENCRYPTION_SERVER
SQL NET.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.RADIUS_ALTERNATE
< a href="sqlnet.htm#sthref504">SQLNET.RADIUS_ALTERNATE_PORT
SQLNET.RADIUS_ALTERNATE_RETRIE S
SQLNET.RADIUS_AUTHENTICATION
SQLNET.RADIUS_ AUTHENTICATION_INTERFACE
SQLNET.RADIUS_AUTHENTICATION_PORT
SQLNET.RADIUS_AUTHENTICATION_RETRIES
SQLNET.RADIUS_AUTHENTICATION_TIMEOUT a>
SQLNET.RADIUS_CHALLENGE_RESPONSE
SQLNET.RADIUS _SECRET
SQLNET.RADIUS_SEND_ACCOUNTING
SQLNET. RECV_TIMEOUT
SQLNET.SEND_TIMEOUT
SSL_CERT_REV OCATION
SSL_CERT_FILE
SSL_CERT_PATH
SSL_CIPHER_SUITES
SSL_CLIENT_AUTHENTICATION
< dd>
SSL_SERVER_DN_MATCH
SSL_VERSION
TCP.EXCLUDED_NODES
TCP.INVITED_NODES
TCP.VALIDNODE_CHECKING
TCP.NODELAY
TNSPING.TRACE_DIRECTORY
TNSPING.TRACE_LEVEL
TRACE_DIRECTORY_CLIENT
TRACE_DIRECTORY_SERVER
TRACE_FILE_CLIENT
TRACE_FILE_SERVER
TRACE_ FILELEN_CLIENT
TRACE_FILELEN_SERVER
TRACE_FIL ENO_CLIENT
TRACE_FILENO_SERVER
TRACE_LEVEL_CL IENT
TRACE_LEVEL_SERVER
TRACE_TIMESTAMP_CLIEN T
TRACE_TIMESTAMP_SERVER
TRACE_UNIQUE_CLIENT< /a>
USE_CMAN
USE_DEDICATED_SERVER
WALLET_LOCATION
6
Local Naming Parameters (tnsnames.ora)
Overview of Local Naming Parameters
General Syntax of tnsnames.ora
Multiple Descriptions in tnsnames.ora
Multiple Addre ss Lists in tnsnames.ora
Connect-Time Failover and Client Load Balancing with Oracle Co nnection Managers
Local Naming Parameters
Connect Descriptor Descriptions
DESCRIPTION
DESCRIPTION_LIST
Protocol Address Section
ADDRESS
ADDRESS_LIST
Optional Parameters for Lists
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
dd>
INSTANCE_NAME
RDB_DATABASE
SERVER
SERVICE_NAME
SID
Security Section
SECURITY
SSL_SERVER_CERT_DN
7
Listener Parameters (listener.ora)
a>
Overview of Listener Configuration File
Listener Parameters
Protocol Address Section
DESCRIPTION
ADDRESS
QUEUESIZE
RECV_BUF_SIZE
SEND_BUF_SI ZE
Static Service Registration (SID_LIST) Section
SID_LIST
SID_DESC
ENVS
GLOBAL_DBNAME
ORACLE_HOME
< /dd>
PROGRAM
SID_NAME
SDU
Control Parameters
ADMIN_RESTRICTIONS_
listener_name
INBOUND_CONNECT_TIMEOUT_< em>listener_name
LOG_DIRECTORY_
listener_name
LOG_FILE_
listener_name
LOGGING_
listener_name
PASSWORDS_
listener_name
SAVE_CONFIG_ON _STOP_
listener_name
SSL_CLIENT_AUTHENTICATION
STARTUP_WAIT_TIME_
listener_name
TRACE_DIRECTORY_
listener_nam e
TRACE_FILE_
listener_name
TRACE_FILELEN_
listener_name
TRACE_FILENO_
listener_name
< a href="listener.htm#sthref869">TRACE_LEVEL_
listener_name
TRACE_TIMESTAMP_
listener_name
WALLET_LOCATION
8
Oracle Connection Manager Parameters (cman.ora )
Overview of Oracle Connection Manager Configuration File
Oracle Connection Manager Parameters
Listening Endpoint
dd>
ADDRESS
Rule List
RULE
Parameter List
PARAMETER_LIST
ASO_AUTHENTICATION_FILTER
CONNECTION_STATISTICS
EVENT_GROUP
IDLE_TIMEOUT
INBOUND_CONNECT_TIMEOUT
LOG_DIRECTOR Y
LOG_LEVEL
MAX_CMCTL_SESSIONS
MAX_CONNECTIONS
MAX_GATEWAY_PROCESSES
MIN_GATEWAY_PROCESSES
OUTBOUND_CONNECT_TIMEOUT
PASSWORD_instance_name
REMOTE_ADMIN
SE SSION_TIMEOUT
TRACE_DIRECTORY
TRACE_FILELEN
dd>
TRACE_FILENO
TRACE_LEVEL
TRACE_TIMESTAMP
9
Directory Usage Parameters (ldap.ora)
Overvi ew of Directory Server Usage File
Directory Usage Parameters
DIRECTORY_SERVERS
DIRECTORY_SERVER_TYPE
DEFAULT_ADMIN_CONTEXT
Part III Appendixes
A
Commands and Parameters Not Supported in This Release
Ove rview of Unsupported Features
Unsupported Parameters
Unsupported Control Utility Commands
B
Upgrade Considerations for Oracle Net Services
Overview of Unsupported Oracle Net Services Features
Unsupported Paramet ers and Control Utility Commands
Client and Database Coexistence Issues
Oracle9i Database Connections
Oracle8 or Oracle7 Database Connections
Oracle Names
Using the Oracle Net Manager to Handle Compatibility Issues
Upgrading to Oracle Net Ser vices
Step 1: Verify Service Name and Instance Name
Step 2: Perform Software Upgrade on the Database Server
Step 3: Perfo rm Software Upgrade on the Client
Step 4: Perform Functional Upgrade
tnsnames.ora
listener.ora
C
LDAP Schema for Orac le Net Services
Structural Object Classes
orclDBServer
orclNetService
orclNetServiceAlias
orclNetDescription
orclNetDescriptionList
orclNetAddress
orc lNetAddressList
orclNetDescriptionAux1
orcl NetAddressAux1
Attributes
Glossary
In dex