CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Net Services
Version 11.1
General

Windows Note:
to find used ports on a Windows server:

c:\> netstat -a

to find the executable using that port:

c:\> netstat -b

to find the port by protocol:

c:\> netstat -p TCP (or other protocol name)

for help with additional options:

c:\> netstat -h
 
SQLNET.ORA Parameters: Node Checking
Note: Protocol specific parameters are not dynamic. They are read only at startup.

In 8i in protocol.ora
In 9i and above in sqlnet.ora
Node checking
Required for Excluded and Inivted nodes
TCP.VALIDNODE_CHECKING=<yes/no>
tcp.validnode_checking=yes
Excluding nodes

Use this parameter to specify which clients are denied access to the database
TCP.EXCLUDED_NODES=
(hostname | ip_address, hostname | ip_address,...)
TCP.EXCLUDED_NODES=(finance.us.acme.com,
mktg.us.acme.com, 144.25.5.25)
Invited nodes

Use this parameter to check for invited and excluded nodes. This list takes   precedence over the TCP.EXCLUDED_NODES
parameter if both lists are present
TCP.INVITED_NODES=(hostname | ip_address, hostname | ip_address, ...)
TCP.INVITED_NODES=(sales.us.acme.com,
hr.us.acme.com, 144.185.5.73)
TCP delay

Use this parameter to preempt delays in buffer flushing within the TCP/IP protocol stack
TCP.NODELAY=<yes/no>
TCP.NODELAY=yes
 
Additional SQLNET.ORA Parameters

Authentication Services
sqlnet.authentication_services (<value>)
Value Description
NONE Disables logging on without password
NTS NT operating system authentication
ALL All authentication methods
 
For Advanced Security Only
dcegssapi DCE GSSAPI authentication
kerberos5 Kerberos authentication
radius RADIUS authentication
sqlnet.authentication_services = (NONE)
Bequeath Detach Turns signal handling on or off for UNIX systems

Options <yes | no>
Default: no
BEQUEATH_DETACH=yes
Client Identifier Sets a unique identifier for a client computer. The identifier is passed to the listener with any connection request and is included in the Audit Trail. The identifier can be any alphanumeric string up to 128 characters long.
sqlnet.client_registration=42
Connection Routing names.directory_path=(<values>)
names.directory_path=(LDAP, TNSNAMES, ONAMES, HOSTNAME)
Inactive Session Expiration Time Kill inactive SQLNET sessions. If set to a non-zero value enables DCD (Dead Connection Detection)

sqlnet.expire_time = <integer_minutes>
sqlnet.expire_time=10
Minimum Client Version sqlnet.allowed_logon_version= <version_number>
sqlnet.allowed_logon_version=10

Names Directory Path
names.directory_path=
(order_of_naming_methods_for_client_name_resolution)

  Naming Method Values
directory naming A naming method that resolves a database service, net service name, or net service alias to a connect descriptor stored in a central directory server
external naming A naming method that uses a third-party naming service, such as NIS or CDS
host naming Name resolution in a TCP/IP environment to resolve names through the existing name resolution service.
local naming A naming method that locates network addresses by using information configured and stored on each individual client's tnsnames.ora file. Local naming is most appropriate for simple distributed networks with a small number of services that change infrequently.
Network Information Service (NIS) Sun Microsystems' Yellow Pages (yp) client/server protocol
NAMES.DIRECTORY_PATH=(tnsnames, onames, hostname)
Names Server Default Domain names.default_domain=<domain_name>
NAMES.DEFAULT_DOMAIN=psoug.org
RECV_BUF_SIZE Specifies the buffer space limit for receive operations of sessions. This parameter is supported by the TCP/IP, TCP/IP with SSL, and SDP protocols.

Default is operating system specific (32K for Solaris 2.6)
RECV_BUF_SIZE=9375000
SEND_BUF_SIZE Specifies the buffer space limit for send operations of sessions. This parameter is supported by the TCP/IP, TCP/IP with SSL, and SDP protocols.

Default is operating system specific (8K for Solaris 2.6)
SEND_BUF_SIZE=9375000
DEFAULT_SDU_SIZE Oracle Corporation recommends setting this parameter in both the client-side and server-side sqlnet.ora file to ensure the same SDU size is used throughout a connection. When the configured values of client and database server do not match for a session, the lower of the two values is used.

Default 2048  (2K) / Range 512 to 32768 (32K)
DEFAULT_SDU_SIZE=32768
Security Parameters
Cryptography Seed Value This optional parameter is required for when encryption or checksumming are turned on. Encryption is turned on if the SQLNET.ENCRYPTION_CLIENT parameter is specified for the client and the SQLNET.ENCRYPTION_SERVER parameter is specified for the database server

sqlnet.crypto_seed = <10_to_70_random_characters>

Default: qwertyuiopasdfghjkl;zxcvbnm,.s1
sqlnet.crypto_seed=pqowieuryt;laksjdhfgmznxbcv,.s1
Checksum Client Behavior sqlnet.checksum_client = <accepted | rejected | requested | required>
sqlnet.checksum_client=required

Default: accepted
Checksum Server Behavior sqlnet.checksum_server = <accepted | rejected | requested | required>
sqlnet.checksum_server=required

Default: accepted
Checksum Type Client Behavior sqlnet.crypto_checksum_types_client = <md5 | sha1>
sqlnet.crypto_checksum_types_client=md5

Default: accepted
Checksum Type Server Behavior sqlnet.crypto_checksum_types_server = <md5 | sha1>
sqlnet.crypto_checksum_types_server=md5

Default: 
Encryption Client sqlnet.encryption_client = <accepted | rejected | requested | required>
sqlnet.encryption_client=required

Default: accepted
Encryption Server sqlnet.encryption_server = <accepted | rejected | requested | required>
sqlnet.encryption_server=required

Default: 

Encryption Type: Client
sqlnet.encryption_types_client = <value>

value choices:
3des112 for triple DES with a two-key (112 bit) option
3des168 for triple DES with a three-key (168 bit) option
des for standard 56 bit key size
des40 for 40 bit key size
rc4_40 for 40 bit key size
rc4_56 for 56 bit key size
rc4_128 for 128 bit key size
rc4_256 for 256 bit key size
sqlnet.encryption_types_client=(rc4_256)

Default: all avialable algorithms 

Encryption Type: Server
sqlnet.encryption_types_server = <value>

value choices:
3des112 for triple DES with a two-key (112 bit) option
3des168 for triple DES with a three-key (168 bit) option
des for standard 56 bit key size
des40 for 40 bit key size
rc4_40 for 40 bit key size
rc4_56 for 56 bit key size
rc4_128 for 128 bit key size
rc4_256 for 256 bit key size
sqlnet.encryption_types_server=(rc4_256)

Default: all available algorithms 
TNSPING Parameters
Trace Directory tnsping.trace_directory=<Null, logfile_location>
tnsping.trace_directory=$ORACLE_HOME/network/log
Trace Level tnsping.trace_level=<off, admin, support, user>
tnsping.trace_level=admin
Connection Tracing Parameters
LOG_DIRECTORY_CLIENT log_directory_client = <operating system path>
log_directory_client=/oracle/network/log
LOG_DIRECTORY_SERVER log_directory_server = <server directory path>
log_directory_server=/oracle/network/log
LOG_FILE_CLIENT log_file_client = <file_name>
log_file_client=sqlnet.log
LOG_FILE_SERVER log_file_server = <file_name>
log_file_server=sqlnet.log
TRACE_LEVEL_CLIENT trace_level_client = <trace_level>
trace_level_client=16
TRACE_LEVEL_SERVER trace_level_sever = <trace_level>
trace_level_server=16
TRACE_LEVEL_UNIQUE Avoid multiple sessions in a single trace file

trace_level_unique = <TRUE | FALSE>
trace_level_unique=TRUE
TRACE_DIRECTORY_CLIENT The directory into which the trace file is written
trace_directory_client=c:\oracle\product\ora10 etwork race
TRACE_DIRECTORY_SERVER The directory into which the trace file is written
trace_directory_server=c:\oracle\product\ora10 etwork race
 
Connection Manager Parameters
Control Utility CMCTL
Administer administer
CMCTL> administer
Current instance CMAN_perrito is not yet started
Connections refer to (ADDRESS=(PROTOCOL=TCP)(HOST=perrito)
(PORT=1521).
The command completed successfully.
CMCTL:CMAN_perrito
Close close connections
CMCTL> 
Exit exit
CMCTL> exit
Help help
CMCTL> 
Quit  
CMCTL> 
Reload  
CMCTL> 
Resume  
CMCTL> 
Save Password save_passwd
CMCTL> 
Set  
CMCTL> 
Show  
CMCTL> 
Shutdown  
CMCTL> 
Sleep  
CMCTL> 
Startup startup
CMCTL> startup
Suspend  
CMCTL> 
 
Listener Parameters
Control Utility LSNRCTL
Change Password change_password
LSNRCTL> change_password
Exit exit
LSNRCTL> exit
Quit quit
LSNRCTL> quit
Reload reload
LSNRCTL> reload
Save Configuration save_config
LSNRCTL> save_config
Services services
LSNRCTL> services
Set set <current_listener | displaymode | 
     inbound_connect_timeout | log_directory | log_file |
     log_status | password | rawmode | save_config_on_stop |
     startup_waittime | trc_directory | trc_file | trc_level>
LSNRCTL> set

or ... in SQLNET.ORA

#Timeout Parameters
SQLNET.INBOUND_CONNECT_TIMEOUT = 300
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300
Show show <current_listener | displaymode |
      inbound_connect_timeout | log_directory | log_file |
      log_status | rawmode | rules | save_config_on_stop |
      snmp_visible | startup_waittime | trc_directory |
      trc_file | trc_level>
LSNRCTL> show
Start start
LSNRCTL> start
Status status
LSNRCTL> status
Stop stop
LSNRCTL> stop
Trace trace <1 | 2>
LSNRCTL> trace 1
Version version
LSNRCTL> version
 
Directory Usage (LDAP) Parameters
   
 
 
Tracing Parameters
   
 
 
Other Related Topics
Profile
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [59 users online]    © 2010 psoug.org