C
Configuration Parameters

Purpose:  

Defines a protocol address. This parameter may be embedded under ADDRESS_LIST or DESCRIPTION. A DESCRIPTION is typically only used in a TNSNAMES.ORA or LISTENER.ORA file.

Additional Information: Each protocol has its own required parameters needed in the address, as explained on "Configuring Protocol Addresses".  

Example:  

(address=
 (protocol=tcp)
 (host=sales-pc)
 (port=1521)
)

Purpose:  

Defines lists of addresses that share a set of common characteristics.

This parameter may be embedded under DESCRIPTION or DESCRIPTION_LIST. A DESCRIPTION or DESCRIPTION_LIST is typically only used in a TNSNAMES.ORA or LISTENER.ORA file.

Note: If there is only one list in a TNSNAMES.ORA or a LISTENER.ORA file, ADDRESS_LIST is not necessary.  

Example:  

 (address_list=
  (address=
   (protocol=tcp)
   (host=sales-pc)
   (port=1521)
  )  
  (address=
   (protocol=tcp)
   (host=hr-pc)
   (port=1521)
  ) 
 ) 
 (address_list=
  (address=
   (protocol=tcp)
   (host=finance-pc)
   (port=1521)
  )  
  (address=
   (protocol=tcp)
   (host=sales-pc)
   (port=1521)
  ) 
 ) 

Purpose:  

Turn on/off signal handling in Net8 on UNIX systems.  

Default:  

NO which leaves signal handling on.  

Values:  

• YES - Turns off signal handling

• NO - Leaves signal handling on

Example:  

bequeath_detach=yes

Purpose:  

Turns tracing on/off to a certain specified level for the Oracle Enterprise Manager daemon.  

Default:  

OFF  

Values  

• OFF - No trace output

• USER - User trace information

• ADMIN - Administration trace information

• SUPPORT - WorldWide Customer Support trace information

Example:  

daemon.trace_level=user

Purpose:  

Specifies that only the Oracle Enterprise Manager daemon trace entries are logged into the trace file.  

Default:  

$ORACLE_HOME/network/trace on UNIX platforms and ORACLE_HOME/network/trace on Windows platforms  

Example:  

daemon.trace_mask=(106)

Purpose:  

Disables out of band breaks.  

Default:  

OFF  

Usage Notes:  

Disable out of band breaks if the underlying transport protocol does not support the feature.  

Example:  

disable_oob=off

Purpose:  

Controls the directory for where the log file is written.  

Default:  

Current directory where executable is started from.  

Example:  

log_directory_client=/oracle/network/log

Purpose:  

Controls the directory for where the log file is written.  

Default:  

Current directory where executable is started from.  

Example:  

log_directory_server=/oracle/network/log

Purpose:  

Controls the log output file name for an Oracle client.  

Default:  

SQLNET.LOG  

Example:  

log_file_client=client

Purpose:  

Controls the log output file name for an Oracle server.  

Default:  

SQLNET.LOG  

Example:  

log_file_server=svr.log

Purpose:  

Specifies the DCE cell name (prefix) to use for name lookup.  

Default:  

/.:/subsys/oracle/names

Example:  

names.dce.prefix=/.:/subsys/oracle/names

Purpose:  

Indicates the domain from which the client most often requests names. When this parameter is set, the default domain name will be automatically appended to any unqualified service name. Any name which contains an unescaped dot ('.') will not have the default domain appended. Simple names may be qualified with a trailing dot (for example, 'rootserver.').  

Default:  

NULL  

Example:  

names.default_domain=com

Purpose:  

Indicates the order of the naming methods, such as TNSNAMES or Oracle Names, that will be used for client name requests.  

Default:  

TNSNAMES, ONAMES, HOSTNAME  

Values:  

• TNSNAMES

• ONAMES

• HOSTNAME

• DCE

• NIS

• NOVELL

Example:  

names.directory_path=(tnsnames, onames)

Purpose:  

Determines how long a client will wait for a response from an Oracle Names server before reiterating the request to the next server in the preferred servers list.  

Default:  

15  

Minimum Value:  

1  

Maximum Value:  

600  

Example:  

names.initial_retry_timeout=20

Purpose:  

Determines how many connections an Oracle Names client may have open at one time.  

Default:  

10  

Minimum Value:  

3  

Maximum Value:  

64  

Example:  

names.max_open_connections=3

Purpose:  

Determines the initial number of messages allocated in the client's message pool which are used for forwarded message requests.  

Default:  

10  

Minimum Value:  

3  

Maximum Value:  

256  

Example:  

names.message_pool_start_size=10

Purpose:  

Specifies the file to be used to map NIS attributes to an NIS mapname.  

Default:  

SQLNET.MAPS  

Example:  

names.nis.meta_map=sqlnet.maps

Purpose:  

Indicates the name, addresses, and order of Oracle Names servers that will be used for a client's name requests.  

Default:  

None  

Example:  

names.preferred_servers= (address_list=
  (address=(protocol=ipc)(key=n23))
  (address=(protocol=tcp)(host-nineva)(key=1575))
  (address=(protocol=tcp)(host=cicada)(key=1575)))

Purpose:  

Specifies the number of times the client should try each server in the list of preferred servers before allowing the operation to fail.  

Default:  

1  

Minimum Value:  

1  

Maximum Value:  

5  

Example:  

names.request_retries=5

Purpose:  

If set to TRUE, NAMESCTL encrypts the password when it is sent to the Oracle Names server.

If set to FALSE, NAMESCTL does not encrypt the password when it is sent to the Oracle Names server. This enables unencrypted passwords to be set in the NAMES.ORA file with the NAMES.PASSWORD parameter.  

Default:  

FALSE  

Values:  

TRUE | FALSE  

Example:  

namesctl.internal_encrypt_password=true

Purpose  

If set to TRUE, NAMESCTL enables a set of internal undocumented commands. All internal commands are preceded by an underscore in order to distinguish them as internal.  

Purpose:  

If set to TRUE, NAMESCTL suppresses any error messages when unable to connect to a default Oracle Names server.  

Default:  

FALSE  

Values  

TRUE | FALSE  

Example:  

namesctl.no_initial_server=true

Purpose:  

Indicates whether sensitive commands (STOP, RELOAD, RESTART) should be prompted with a confirmation when running the NAMESCTL utility.  

Default:  

OFF  

Values  

ON | OFF  

Example:  

namesctl.noconfirm=on

Purpose:  

Indicates the value that matches the configured password set in the NAMES.ORA file with the NAMES.PASSWORD parameter. This eliminates the need to enter the password with the SET PASSWORD command each time you use the NAMESCTL utility to perform secure options, such as STOP, RESTART and RELOAD.  

Example:  

namesctl.server_password=secret

Purpose:  

Indicates the level at which the NAMESCTL program should be traced.  

Default:  

OFF  

Values:  

OFF, USER, ADMIN, SUPPORT  

Example:  

namesctl.trace_level=admin

Purpose:  

Indicates the file in which the NAMESCTL trace output is placed.  

Default:  

NAMESCTL_PID.TRC  

Example:  

namesctl.trace_file=nmsctl

Purpose:  

Indicates the directory where trace output from the NAMESCTL utility is placed.  

Default:  

$ORACLE_HOME/network/trace on UNIX and ORACLE_HOME/network/trace on Windows NT  

Example:  

namesctl.trace_directory=/oracle/trace

Purpose:  

Indicates whether a process identifier is appended to the name of each trace file generated, so that several can co-exist.  

Default:  

ON  

Values:  

ON | OFF  

Example:  

namesctl.trace_unique=on

Purpose:  

Enter the location of wallets. Wallets are certificates, keys and trustpoints processed by SSL.  

Default:  

None  

Example:  

oss.source.my_wallet=  
   (source=
      (method=file)
      (method_data=  
        (directory=/home/smalladi/oss)))

Purpose:  

Defines the method for retrieving encrypted private keys.  

Default:  

None  

Example:  

oss.source.location= 
(source= 
 (method=oracle) 
 (method_data=
    (sqlnet_address=oss)))

Purpose:  

Enables one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either NONE or to one of the authentication methods.  

Default:  

None  

Values:  

NONE - the database will use the user name and password to log in

ALL - Enables all authentication methods to be used.

BEQ - always used in conjunction with one or more of the following items:

NDS - use NetWare Directory Services (NDS)

NTS - use Windows NT Native

KERBEROS5 - use Kerberos

SECURID - use SecurID

CYBERSAFE - use Cybersafe

IDENTIX - use Identix

DCEGSSAPI - use DCE GSSAPI

RADIUS - use RADIUS  

Example:  

sqlnet.authentication_services =(beq, kerberos5, cybersafe)

Purpose:  

Defines the name of the service used to obtain a Kerberos service ticket  

Default:  

None  

Example:  

sqlnet.authentication_kerberos5_service= oracle

Purpose:  

Defines the CyberSAFE service principal  

Purpose:  

Sets a unique identifier for this client machine. This identifier will be passed to the listener with any connection request and will be included in the Audit Trail. The identifier can be any alphanumeric string up to 128 characters long.  

Default:  

None  

Example:  

sqlnet.client_registration 1432

Purpose:  

Specifies the desired checksum behavior when this client is connecting to a server  

Default:  

ACCEPTED  

Values:  

• ACCEPTED

• REJECTED

• REQUESTED

• REQUIRED

Example:  

sqlnet.crypto_checksum_client=accepted

Purpose:  

Specifies the desired checksum behavior when a client is connecting to this server  

Default:  

ACCEPTED  

Values:  

• ACCEPTED

• REJECTED

• REQUESTED

• REQUIRED

Example:  

sqlnet.crypto_checksum_server=accepted

Purpose:  

Specifies a list of crypto-checksum algorithms this client is allowed to use  

Default:  

MD5  

Values:  

MD5 - RSA Data Security's MD5 algorithm  

Example:  

sqlnet.crypto_checksum_types_client=(md5)

Purpose:  

Specifies a list of crypto-checksum algorithms this server is allowed to use  

Default:  

MD5  

Values:  

MD5 - RSA Data Security's MD5 algorithm  

Example:  

sqlnet.crypto_checksum_types_server=(md5)

Purpose:  

Specifies the characters used when generating cryptographic keys. The more random the characters are, the stronger the keys are. This is required whenever encryption or checksumming is turned on. The string should be 10-70 random characters.  

Default:  

qwertyuiopasdfghjkl;zxcvbnm,.s1  

Example:  

sqlnet.crypto_seed="qwertyuiopasdfghjkl;zxcvbnm,.s1"

Purpose:  

Specifies the desired behavior when this client is connecting to a server  

Default:  

ACCEPTED  

Values:  

• ACCEPTED

• REJECTED

• REQUESTED

• REQUIRED

Example:  

sqlnet.encryption_client=accepted

Purpose:  

Specifies the desired behavior when a client is connecting to this server  

Default:  

ACCEPTED  

Values:  

• ACCEPTED

• REJECTED

• REQUESTED

• REQUIRED

Example:  

sqlnet.encryption_server=accepted

Purpose:  

Specifies a list of encryption algorithms this client is allowed to use  

Default:  

All algorithms are used if none are specified.  

Values:  

One or more of the following:

RC4_40 - RSA RC4 (40 bit key size) Domestic & International

RC4_56 - RSA RC4 (56 bit key size) Domestic only

RC4_128 - RSA RC4 (128 bit key size) Domestic only

DES - Standard DES (56 bit key size) Domestic only

DES40 - (40 bit key size) Domestic & International  

Example:  

sqlnet.encryption_types_client=(rc4_40)

Purpose:  

Specifies a list of encryption algorithms this server is allowed to use when acting as a server  

Default:  

All algorithms are used if none are specified.  

Values:  

RC4_40 - RSA RC4 (40 bit key size) Domestic & International

RC4_56 - RSA RC4 (56 bit key size) Domestic only

RC4_128 - RSA RC4 (128 bit key size) Domestic only

DES - Standard DES (56 bit key size) Domestic only

DES40 - (40 bit key size) Domestic & International  

Example:  

sqlnet.encryption_types_server=(rc4_40, des, ...)

Purpose:  

Determines time interval to send a probe to verify the session is alive  

Default:  

None  

Minimum Value:  

0 minutes  

Recommended Value:  

10 minutes  

Example:  

sqlnet.expire_time=10

Purpose:  

Specifies the service name or alias for the authentication fingerprint database  

Default:  

None  

Example:  

sqlnet.identix_fingerprint_database=fingrdb

Purpose:  

Specifies the well known user name for the fingerprint database  

Default:  

None  

Example:  

sqlnet.identix_fingerprint_database_user=manager

Purpose:  

Specifies the well known password for the fingerprint database  

Default:  

None  

Example:  

sqlnet.identix_fingerprint_database_password=password

Purpose:  

Specifies the method name for the fingerprint database. The method name must be ORACLE  

Default:  

None  

Example:  

sqlnet.identix_fingerprint_method=oracle

Purpose:  

Specifies the complete path name to the Kerberos credentials cache file.  

Default:  

/usr/tmp/krbcache on UNIX and c:\tmp\krbcache on Windows platforms  

Example:  

sqlnet.kerberos5_cc_name= /usr/tmp/krbcache

Purpose:  

Specifies how many seconds can pass before a Kerberos credential is considered out of date.  

Default:  

300  

Example:  

sqlnet.kerberos5_clockskew=1200

Purpose:  

Specifies the complete path name to the Kerberos configuration file, which contains the realm for the default KDC and maps realms to KDC hosts.  

Default:  

/krb5/krb.conf on UNIX and c:\krb5\krb.conf on Windows platforms  

Example:  

sqlnet.kerberos5_conf=/krb5/krb.conf

Purpose:  

Specifies the complete path name to the Kerberos principal/secret key mapping file, which is used to extract keys and decrypt incoming authentication information.  

Default:  

/etc/v5srvtab on UNIX and c:\krb5\v5srvtab on Windows platforms  

Example:  

sqlnet.kerberos5_keytab=/etc/v5srvtab

Purpose:  

Specifies the complete pathname to the Kerberos realm translation file, which provides a mapping from a host name or domain name to a realm.  

Default:  

/krb5/krb.realms on UNIX and c:\krb5\krb.realms on Windows platforms  

Example:  

sqlnet.kerberos5_realms= /krb5/krb.realms

Purpose:  

Specifies an alternate RADIUS server used in case the primary server is unavailable. The value can be either the IP address or host name of the server.  

Default:  

None  

Example:  

sqlnet.radius_alternate=radius2

Purpose:  

Listening port of the alternate RADIUS server.  

Default:  

1645  

Example:  

sqlnet.radius_alternate_port= 1667

Purpose:  

Times to resend  

Default:  

3  

Example:  

sqlnet.radius_alternate_retries=4

Purpose:  

Time to wait for response.  

Default:  

5 seconds  

Example:  

sqlnet.radius_authenetication_timeout= 10

Purpose:  

Specifies the location of the primary RADIUS server, either by its host name or IP address.  

Default:  

local host  

Example:  

sqlnet.radius_authenetication= officeacct

Purpose:  

Specifies the class containing the user interface used to interact with the user.  

Default:  

DefaultRadiusInterface  

Example:  

sqlnet.radius_authenetication_interface= 

Purpose:  

Listening port of the primary RADIUS server.  

Default:  

1645  

Example:  

sqlnet.radius_authenetication_port= 1667

Purpose:  

Times to resend.  

Default:  

3  

Example:  

sqlnet.radius_authenetication_retries=4

Purpose:  

Time to wait for response.  

Default:  

5 seconds  

Example:  

sqlnet.radius_authenetication_timeout= 10

Purpose:  

Turns challenge response ON or OFF.  

Default:  

OFF  

Values:  

ON | OFF  

Example:  

sqlnet.radius_challenge_response=ON

Purpose:  

Specifies the full path to the file containing the RADIUS shared secret.  

Default:  

$ORACLE_HOME/network/security/radius.key on UNIX and ORACLE_HOME/network/security/radius.key on Windows NT  

Example:  

sqlnet.radius_secret= oracle/bin/admin/radiuskey

Purpose:  

Turns accounting ON and OFF. If enabled, packets will be sent to the active RADIUS server at listening port plus one. The default port is 1646.  

Default:  

OFF  

Values:  

ON | OFF  

Example:  

sqlnet.radius_send_accounting=ON

Purpose:  

Controls whether or not a client--in addition to the server--is authenticated using SSL.  

Default:  

TRUE  

Values:  

TRUE | FALSE  

Example:  

ssl_cipher_suite=(ssl_dh_dss_with_des_cdc_sha)

Purpose:  

Controls the destination directory of the trace file.  

Default:  

$ORACLE_HOME/network/trace  

Example:  

tnsping.trace_directory=/oracle/traces

Purpose:  

Turns tracing on/off to a certain specified level.  

Default:  

OFF  

Values  

• OFF - No trace output

• USER - User-induced error conditions trace information

• ADMIN - Administration trace information

• SUPPORT - WorldWide Customer Support trace information

Example:  

tnsping.trace_level=admin

Purpose:  

Controls the destination directory of the trace file.  

Default:  

$ORACLE_HOME/network/trace  

Example:  

trace_directory_client=/oracle/traces

Purpose:  

Controls the destination directory of the trace file.  

Default:  

$ORACLE_HOME/network/trace  

Example:  

trace_directory_server=/oracle/traces

Purpose:  

Controls the name of the client trace file.  

Default:  

SQLNET.TRC  

Example:  

trace_file_client=clientsqlnet.trc

Purpose:  

Controls the name of the server trace file.  

Default:  

SVR_PID.TRC  

Example:  

trace_file_server=svrsqlnet.trc

Purpose:  

Turns tracing on/off to a certain specified level.  

Default:  

OFF  

Values  

• OFF - No trace output

• USER - User trace information

• ADMIN - Administration trace information

• SUPPORT - WorldWide Customer Support trace information

Example:  

trace_level_client=user

Purpose:  

Turns tracing on/off to a certain specified level.  

Default:  

OFF  

Values  

• OFF - No trace output

• USER - User trace information

• ADMIN - Administration trace information

• SUPPORT - WorldWide Customer Support trace information

Example:  

trace_level_server=admin

Purpose:  

Used to make each client trace file have a unique name to prevent each trace file from being overwritten with the next occurrence of the client. The PID is attached to the end of the file name.

Determines whether or not a unique trace file is created for each client. The same trace file name is used for every client. If the value is OFF, when a new trace file is created for a client, it overwrites the existing file. If the value is set to ON, a thread identifier is appended to the name of each trace file generated so that several can coexist.

This parameter creates unique trace files named SQLNETTHREAD_ID.TRC.  

Default:  

ON  

Example:  

trace_unique_client=on

Purpose:  

When set to TRUE, forces all sessions to go through Oracle Connection Manager to get to the server. If no Oracle Connection Manager addresses are available, connections are routed through any available listener address.

Note: If you are using Oracle Connection Manager with Oracle Names, this option must be set on clients and Oracle Names servers.  

Default:  

FALSE  

Values:  

TRUE | FALSE  

Example:  

use_cman=true

Purpose:  

Forces the listener to spawn a dedicated server process for sessions from this client.  

Default:  

OFF  

Values:  

• ON - spawn dedicated server processes

• OFF - hand off to existing server processes

Example:  

use_dedicated_server=on

Purpose:  

Defines a list of connect descriptors for a particular net service name.  

Example:  

net_service_name= 
(description_list=
 (description=
  (address=...)
  (connect_data=(service_name=sales.com))
 (description=
  (address=...)
  (connect_data=(service_name=sales2.com))
)

Purpose:  

Defines a listener protocol address. This parameter may be embedded under a ADDRESS_LIST or DESCRIPTION.

Additional Information: See "Configuring Protocol Addresses" for descriptions of the correct parameters to use for each protocol.  

Example:  

net_service_name=
(description= 
  (address =...)
  (address =...)
  )
  (connect_data=(service_name=sales.com))

Purpose:  

Defines a list of addresses. If there is only list, ADDRESS_LIST is not necessary. This parameter may be embedded under a DESCRIPTION or DESCRIPTION_LIST.  

Example:  

net_service_name=
(description= 
 (address_list=
  (address =...)
  (address =...)
  )
 )
 (address_list= 
  (load_balance=off)
  (address =...)
  (address =...)
  )
 )
 (connect_data=(service_name=sales.com))

Purpose:  

When set to ON, instructs Net8 at connect time to fail over to a 
different listener if the first listener fails. It determines how 
many addresses are tried. When set to OFF, instructs Net8 to 
try one address.

This parameter must be embedded under a DESCRIPTION_LIST, DESCRIPTION or ADDRESS_LIST.

Note: This feature will not work if the LISTENER.ORA is configured with static service configuration parameters. See "SID_LIST_listener_name Static Service Section" for further information about these parameters. Static configuration is required for Oracle8i release 8.0 or Oracle7 databases and Oracle Enterprise Manager.  

Default:  

ON for DESCRIPTION_LISTs, DESCRIPTIONs, and ADDRESS_LISTs.  

Values:  

ON | OFF | YES | NO | TRUE | FALSE  

Example:  

net_service_name=
 (description= 
  (failover=on)
  (address =...)
  (address =...)
  )
  (connect_data=(service_name=sales.com))
    
 )
        

Purpose:  

When set to ON, instructs Net8 to progress through the list of listener addresses in a random sequence, balancing the load on the various listeners. When set to OFF, instructs Net8 to try the addresses sequentially until one succeeds.

This parameter must be embedded under a DESCRIPTION_LIST, DESCRIPTION or ADDRESS_LIST.  

Default:  

ON for DESCRIPTION_LISTs  

Values:  

ON | OFF | YES | NO | TRUE | FALSE  

Example:  

net_service_name=
 (description= 
  (load_balance=on)
  (address =...)
  (address =...)
  )
  (connect_data=(service_name=sales.com)) 

Purpose:  

When set to ON or YES, instructs Net8 use each address in order until the destination reached. This parameter is required when reaching the destination requires more than one address stop.

This parameter is required for Oracle Connection Manager. For Oracle Connection Manager, an initial connection from the client to the Oracle Connection Manager is required, and a second connection from the Oracle Connection Manager to the listener is required.

This parameter must be embedded under a DESCRIPTION_LIST, DESCRIPTION or ADDRESS_LIST.  

Default:  

OFF  

Values:  

YES, NO, ON, OFF  

Example:  

net_service_name=
 (description =
  (source_route=yes)
  (address=...)
  (address=...)
  )
  (connect_data=(sid=sales))

Purpose:  

Specifies the type of service to use for an Oracle RDB database. It is used by Rdb interface tools. This feature should only be used if the application supports both an Oracle Rdb and Oracle database, and you want the application to randomly choose (load balance). This parameter must be embedded under a DESCRIPTION.  

Example:  

net_service_name=
 (description_list=
  (description=
    (address=...)
    )
    (connect_data= 
     (service_name=generic)
     (rbd_database=[.mf]mf_personal.rdb)
     (global_name=alpha5))
    (type_of_service=rdb_database))
 (description=
   (address=...)
    (connect_data= 
     (service_name=sales))
    (type_of_service=oracle8_database)))

Purpose:  

Defines the database to which to connect. This parameter must be embedded under a DESCRIPTION.  

Example:  

net_service_name=
 (description= 
  (address =...)
  (address =...)
  )
  (connect_data=(service_name=sales.com))

Purpose:  

Defines a listener protocol address, as well as the presentation and session communication layers to use.

Prior to this release, Net8 only supported connections that used the Two-Task Common (TTC) presentation layer and Transparent Network Substrate (TNS) Network session (NS) layer to establish client connections.

In order for clients to connect to the Java option in the database, the presentation layer and session layer support have been expanded. For those clients wishing to connect to the Java option, the General Inter-Orb Protocol (GIOP) presentation layer is used with no session layer.

This parameter may be embedded under a DESCRIPTION_LIST.

It is not necessary to use DESCRIPTIONs if all the protocol addresses specified use TTC and NS.

Additional Information: See "Configuring Java Option Connections" for configuration information.  

Example:  

listener_name =
  (description_list =
    (description =
      (address=
        (protocol=ipc)
        (key=extproc0))
    )
    (description =
      (protocol_stack =
        (presentation=giop)
        (session=raw))
      (address=
        (protocol=tcp)
        (host=sales-pc)
        (port=2481))
  )

Purpose:  

Defines a list of listener protocol address and protocol stack descriptions.  

Example:  

listener_name =
  (description_list =
    (description =
      (address=
        (protocol=ipc)
        (key=extproc0))
    )
    (description =
      (protocol_stack =
        (presentation=giop)
        (session=raw))
      (address=
        (protocol=tcp)
        (host=sales-pc)
        (port=2481))
  )

Purpose:  

Defines a listener protocol address. This parameter may be embedded under a ADDRESS_LIST or DESCRIPTION.

Additional Information: See "Configuring Protocol Addresses" for descriptions of the correct parameters to use for each protocol.  

Example:  

listener_name =
      (address=
        (protocol=ipc)
        (key=extproc0))
      (address=
        (protocol=tcp)
        (host=sales-pc)
        (port=2481))

Purpose:  

Defines lists of listener protocol addresses. Because there will only be one list of addresses, it is not necessary to use this parameter. By default operation, the Net8 Assistant and Net8 Configuration Assistant create an ADDRESS_LIST each time an address is specified, even though there is only one list. This parameter may be embedded under a DESCRIPTION or DESCRIPTION_LIST.  

Example:  

listener_name =
  (description_list =
    (description =
      (address_list =
         (address=
           (protocol=ipc)
           (key=extproc0))
      )
    )
    (description =
      (protocol_stack =
        (presentation=giop)
        (session=raw)
      )
      (address_list =
         (address=
           (protocol=tcp)
           (host=sales-pc)
           (port=2481))
      )
    )
    (description =
      (address_list =
         (address=
           (protocol=tcp)
           (host=sales-pc)
           (port=1521))
      )
    )
  )

Purpose:  

Prior to this release, Net8 only supported connections that used the Two-Task Common (TTC) presentation layer and Network Session (NS) layer to establish client connections.

For those clients wishing to connect to the Java option, the General Inter-Orb Protocol (GIOP) presentation layer is used with no session layer.

This parameter must be embedded under a DESCRIPTION.

It is not necessary to use PROTOCOL_STACK if the protocol address(es) specified use TTC and NS.

Additional Information: See "Configuring Java Option Connections" for further configuration information.  

Example:  

listener_name =
  (description_list =
    (description =
      (address=
        (protocol=ipc)
        (key=extproc0))
    )
    (description =
      (protocol_stack =
        (presentation=giop)
        (session=raw))
      (address=
        (protocol=tcp)
        (host=sales-pc)
        (port=2481))
  )

Purpose:  

Identifies the session layer.  

Default:  

NS  

Values:  

NS | RAW

IIOP clients require no session layer (RAW).

Typical Net8 clients use a session layer of Transparent Network Substrate (TNS) Network Session (NS).  

Example:  

listener_name =
  (description_list =
    (description =
      (address=
        (protocol=ipc)
        (key=extproc0))
    )
    (description =
      (protocol_stack =
        (presentation=giop)
        (session=raw))
      (address=
        (protocol=tcp)
        (host=sales-pc)
        (port=2481))
  )

Purpose:  

The global database name is the name and domain name of the database, as given in SERVICE_NAMES parameter in the database initialization parameter file (INITSID.ORA). If you want to refer to the database by its global database name on the network, then you must specify that global database name to the listener. This parameter must be embedded under SID_DESC and should match the value of the SERVICE_NAMES parameter.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=orcl)
    (oracle_home=/usr/oracle)
   )
  )

Purpose:  

Identifies the Oracle home location of the database that you are specifying. This parameter must be embedded under SID_DESC.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
     (sid_name=extproc)
     (oracle_home=/usr/oracle)
     (program=extproc)
   )
  )

Purpose:  

Identifies the service's executable program name. For example, extproc.exe.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
     (sid_name=extproc)
     (oracle_home=oracle)
     (program=extproc)
   )
  )

Purpose:  

Identifies the SID of the database. Its value is operating system specific. This parameter must be embedded under SID_DESC.

This parameter should match the value of the INSTANCE_NAME parameter in the INITSID.ORA file.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=orcl)
    (oracle_home=/usr/oracle)
   )
  )

Purpose:  

Identifies a list of SID descriptions.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=...)
   (sid_desc=...)
  ) 

Purpose:  

Defines a SID. This parameter may be embedded under SID_LIST.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=...)
   (sid_desc=...)
  ) 

Purpose:  

Specifies the maximum number of prespawned dedicated server processes the listener will create. This number must be at least as many as the sum of the pool size for each protocol. Set this value to a large number so that prespawned dedicated server processes are always available for new connections.This parameter must be embedded under SID_LIST.

Prespawned dedicated servers cannot be configured on Windows NT.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=sid)
    (oracle_home=/usr/oracle)
    (prespawn_max=99))
  )

Purpose:  

Specifies a list of prespawnd dedicated server process descriptions. This parameter must be embedded under SID_DESC.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=sid)
    (oracle_home=/usr/oracle)
    (prespawn_max=99) 
    (prespawn_list= 
      (prespawn_desc= 
        (protocol=tcp)
        (pool_size=10)
        (timeout=2))
        (prespawn_desc=...)))
   ))

Purpose:  

Defines the protocol on which the listener creates prespawned dedicated server processes, as well as characteristics of the prespawned dedicated server. Each protocol must have its own PRESPAWN_DESC description. This parameter must be embedded under PRESPAWN_LIST.

Additional Information: See "Configuring Prestarted or Prespawned Dedicated Servers" for descriptions of PROTOCOL, POOL_SIZE, and TIMEOUT.  

Example:  

sid_list_listener_name=
  (sid_list= 
   (sid_desc=
    (global_dbname=oracle.com)
    (sid_name=sid)
    (oracle_home=/usr/oracle)
    (prespawn_max=99) 
    (prespawn_list= 
      (prespawn_desc= 
        (protocol=tcp)
        (pool_size=10)
        (timeout=2))
        (prespawn_desc=...)))
   ))

Purpose:  

Determines the amount of time the listener will wait for a valid connection request after a connection has been started.  

Default:  

10 seconds  

Example:  

connect_timeout_listener=12

Purpose:  

Sets a non-encrypted password for authentication to the Listener Control Utility (LSNRCTL). Allows one or more passwords. If this optional parameter specifies one or more passwords, then the use of one of these passwords is required to perform DBA tasks against the network listener using the LSNRCTL.  

Default:  

oracle  

Example:  

passwords_listener=(oracle8)

Purpose:  

Sets the number of seconds that the network listener sleeps before responding to the first listener control status command.  

Default:  

0 seconds  

Example:  

startup_waittime_listener=5

Purpose:  

Sets the name of the trace file for the listener.  

Default:  

LISTENER.TRC  

Example:  

trace_file_listener=list.trc

Purpose:  

Instructs the listener to find and register database information with an Oracle Names Server.

When a client requests a connection to a server, the Oracle Names server retrieves the necessary information, such as the service name and SID, from the listener.  

Default:  

OFF  

Values:  

ON | OFF  

Example:  

use_plug_and_play=on

Purpose:  

Describes the address on which the Oracle Names server listens. Any valid ADDRESS or ADDRESS_LIST is allowed.

Additional Information: See:

• "ADDRESSes and ADDRESS_LISTs" for description of address syntax

• "Configuring Protocol Addresses" for descriptions of the correct parameters to use for each protocol

Default:  

names.addresses= 
  (address=(protocol=tcp)(host=oranamesrvr0)(port=1575)

Purpose:  

Describes the data source for an administrative region. If set, this parameter defines a database as a repository for information. If this parameter is not set, replication of data between Oracle Names server caches.  

Default:  

NULL  

Example:  

names.admin_region=
   (region=(name=local_region)
   (type=rosdb)
   (userid=names)
   (password=names)
   (description=
     (address=(protocol=tcp)
     (host=nineva)(port=1575)
     )
   )
   (connect_data=
        (service_name=em)
        )
    )
   (version=34619392)
   (refresh=14400)
   (retry=600)
   (expire=259200)

Purpose:  

Determines whether system queries require authoritative answers.  

Default:  

FALSE  

Example:  

names.authority_required=true

Purpose:  

Limits the amounts of time the Oracle Names server will wait for the connection from a client to complete.  

Default:  

3 seconds  

Minimum Value:  

1 second  

Maximum Value:  

600 seconds  

Example:  

names.connect_timeout=8

Purpose:  

Specifies the amount of time in seconds the Oracle Names server caches other region's database server addresses which have been obtained through NAMES.DOMAIN.HINTS. At the end of this interval, the Oracle Names server issues a query to the other region database servers to refresh the address.  

Default:  

600 seconds  

Acceptable Values:  

60-1209600 seconds  

Example:  

names.auto_refresh_expire=1200000

Purpose:  

Specifies the interval in seconds that the Oracle Names server will retry when the auto refresh query fails.  

Default:  

180  

Minimum Value:  

60  

Maximum Value  

3600  

Example:  

names.auto_refresh_retry=180

Purpose:  

Specifies the name and path of the file to which the Oracle Names server writes its checkpoint file.  

Default:  

$ORACLE_HOME/network/names/ckpcch.ora on UNIX and ORACLE_HOME\network\names\ckpcch.ora on Windows NT.  

Example:  

names.cache_checkpoint_
file=c:\oracle\network\names\cacheck.ora

Purpose:  

Indicates the interval at which a Oracle Names server writes a checkpoint of its stored data to the checkpoint file. Each Oracle Names server can periodically write its cached data to a file to protect against startup failures.  

Default:  

0 (disabled)  

Minimum Value:  

10  

Maximum Value:  

259200 (3 days)  

Example:  

names.cache_checkpoint_interval=24

Purpose:  

Specifies the name and path of the file used to checkpoint Oracle Names server configuration settings.  

Default:  

$ORACLE_HOME/network/names/ckcfg.ora on UNIX and ORACLE_HOME\network\names\ckcfg.ora on Windows NT.  

Example:  

names.config_checkpoint_
file=c:\oracle\network\names\configck.ora

Purpose:  

Address list of other Oracle Names servers which are used to forward queries.  

Example:  

names.default_forwarders= (forwarder_list=
  (forwarder=(name=rootserv1.com)(address=(protocol=tcp)
      (port=4200)(host=roothost))))

Purpose:  

When TRUE the Oracle Names server forwards queries only to those Oracle Names servers listed as default forwarders.  

Default:  

FALSE  

Usage Notes:  

If set to FALSE, Oracle Names servers listed as default forwarders will be called before Oracle Names servers found in the cache.  

Purpose:  

Lists the names, addresses and domains of all servers in one or more foreign regions. Enables the Oracle Names server to know about other regions' servers. This includes at least the root region for all servers who are not in the root region. Other regions may be provided as optimization requires.  

Example:  

names.domain_hints=
 (hint_desc=(hint_list=
   (hint=(name=rootserv1.com)
     (address=(protocol=tcp)(host=nineva)(port=4200)
     )
   )
 )

Purpose:  

List of domains in the server's local region, as well as the default time to live (TTL) for data in those domains.  

Example:  

names.domains=
 (domain_list=
    (domain=(name=)(min_ttl=86400))
    (domain=(name=com)(min_ttl=8640))
  )

Purpose:  

The Oracle Names server forwards operations to foreign regions if set to ON.  

Default  

ON  

Values:  

ON | OFF  

Example:  

names.forwarding_available=off

Purpose:  

If set to TRUE, then this Oracle Names servers forwards queries.  

Default:  

TRUE  

Values:  

TRUE | FALSE  

Example:  

names.forwarding_desired=true

Purpose:  

Specifies whether or not to attempt to keep the TNS connection to the region database open between operations. If set to FALSE, the connection will be closed after each load, reload or reload-check.  

Default:  

TRUE  

Values:  

TRUE | FALSE  

Example:  

names.keep_db_open=FALSE

Purpose:  

Indicates the name of the directory where the log file for Oracle Names server operational events are written.  

Default:  

$ORACLE_HOME/network/log on UNIX and ORACLE_HOME\network\log on Windows NT.  

Example:  

names.log_directory=c:\oracle\network\names

Purpose:  

Indicates the name of the output file to which Oracle Names server operational events are written. The file name extension is always .LOG. Do not enter an extension for this parameter.  

Default:  

NAMES  

Example:  

names.log_file=onames

Purpose:  

Specifies the number of seconds between full statistical dumps in the log file.  

Default:  

0 (0=OFF)  

Minimum Value:  

10 (least possible ON value)  

Maximum Value:  

none  

Example:  

names.log_stats_interval=12

Purpose:  

If set to TRUE, then the log file name will be unique and not overwrite existing log files.  

Default:  

FALSE  

Values:  

TRUE | FALSE  

Example:  

names.log_unique=true

Purpose:  

Specifies the number of connections that the Oracle Names server can have open at any given time. The value is generated as the value 10 or the sum of one connection for listening, five for clients, plus one for each foreign domain defined in the local administrative region, whichever is greater.

The calculated value is acceptable for most installations.  

Default:  

Calculated based on entered data.  

Minimum Value:  

2  

Maximum Value:  

64  

Example:  

names.max_open_connections=52

Purpose:  

Specifies the maximum number of times the server attempts to forward an operation.  

Default:  

2  

Minimum Value:  

1  

Maximum Value:  

15  

Example:  

names.max_reforwards=2

Purpose:  

Determines the initial number of messages allocated in the server's message pool which are used for incoming or outgoing forwarded messages.  

Default:  

10  

Minimum Value:  

3  

Maximum Value:  

256  

Example:  

names.message_pool_start_size=10

Purpose:  

If set to TRUE, the server refuses any operations which modify the data in its region.  

Default:  

FALSE  

Values:  

TRUE | FALSE  

Example:  

names.no_modify_requests=true

Purpose:  

If set to TRUE, the server does not look for a region database.  

Default:  

FALSE  

Example:  

names.no_region_database=true

Purpose:  

Sets the password for an Oracle Names server, so that certain sensitive operations, such as STOP, RESTART and RELOAD operations in NAMESCTL are secure.

If this parameter is set with the Net8 Assistant, the password is encrypted. A clear-text password may be made manually. If the password is clear-text, ensure the NAMESCTL.INTERNAL_ENCRYPT_PASSWORD parameter is set in the SQLNET.ORA file is set to FALSE.  

Default:  

None  

Example:  

names.password=625926683431aa55

Purpose:  

Specifies the name and path of the file used to checkpoint region data (for example, domain addresses, database addresses of Oracle Names servers in the local region)  

Default:  

$ORACLE_HOME/network/names/ckpreg.ora on UNIX and ORACLE_HOME\network\names\ckpreg.ora on Windows NT.  

Example:  

names.region_checkpoint_
file=c:\oracle\network\names\regionck.ora

Purpose:  

Specifies the number of seconds during which the statistics collected by the Oracle Names servers should accumulate. At the frequency specified, they are reset to zero. The default value of 0 means never reset statistics.  

Default:  

0 (never reset)  

Minimum Value:  

10  

Maximum Value:  

none  

Example:  

names.reset_stats_interval=15

Purpose:  

If set to TRUE, the server will save its runtime configuration settings back into NAMES.ORA. Any parameters which were modified through NAMESCTL SET operations will replace prior NAMES.ORA settings.  

Default:  

FALSE  

Example:  

names.save_config_on_stop=FALSE

Purpose:  

Each Oracle Names server is uniquely identified by a name. All configuration references to a particular Oracle Names server use this name.  

Default:  

ONAMES_onames_server  

Example:  

names.server_name=namesrv1.us.oracle.com

Purpose:  

Indicates the name of the directory to which trace files from a Oracle Names server trace session are written.  

Default:  

$ORACLE_HOME/network/trace on UNIX and ORACLE_HOME/network/trace on Windows NT.  

Example:  

names.trace_directory=/oracle/network/admin/trace

Purpose:  

Indicates the name of the output file from a Oracle Names server trace session. The file name extension is always .TRC.  

Default:  

NAMES  

Example:  

names.trace_file=onames

Purpose:  

Enables internal mechanism to control tracing by function name.  

Default:  

FALSE  

Example:  

names.trace_func=false

Purpose:  

Indicates the level at which the Oracle Names server is to be traced.  

Default:  

OFF  

Values  

• OFF - No trace output

• USER - User trace information

• ADMIN - Administration trace information

• SUPPORT - WorldWide Customer Support trace information

Example:  

names.trace_level=admin

Purpose:  

Indicates whether each trace file has a unique name, allowing multiple trace files to coexist. If the value is set to ON, a process identifier is appended to the name of each trace file generated.  

Default:  

ON  

Values  

ON | OFF  

Example:  

names.trace_unique=on

Purpose:  

Specifies listening addresses for Oracle Connection Manager gateway process, CMGW.  

Default:  

cman=(address=(protocol=tcp)(host=local_host)(port=1630))

Syntax:  

cman=
  [(address_list= ]
    (address= ...)
   [(address= ...))] 

Purpose:  

Sets parameters related to the running of Oracle Connection Manager.  

Default:  

• ANSWER_TIMEOUT=0

• AUTHENTICATION_LEVEL=0

• LOG_LEVEL=0

• MAX_FREELIST_BUFFERS=2048

• MAXIMUM_CONNECT_DATA=1024

• MAXIMUM_RELAYS=128

• RELAY_STATISTICS=NO

• SHOW_TNS_INFO=NO

• TRACE_DIRECTORY=$ORACLE_HOME/network/trace on UNIX and ORACLE_HOME\network\trace on Windows NT

• TRACING=NO

• USE_ASYNC_CALL=YES

Values:  

• ANSWER_TIMEOUT=[0 to n]

• AUTHENTICATION_LEVEL=[0, 1]

• LOG_LEVEL=[0-4]

• MAXIMUM_CONNECT_DATA=[257-4096]

• MAX_FREELIST_BUFFERS=[0-10240]

• MAXIMUM_RELAYS=[0-2048]

• RELAY_STATISTICS=[YES,NO]

• SHOW_TNS_INFO=[YES, NO]

• TRACE_DIRECTORY=pathname

• TRACING=[YES, NO]

• USE_ASYNC_CALL=[YES, NO]

Example:  

cman_profile =
   (parameter_list= 
      (maximum_relays=512)
      (log_level=1)
      (tracing=yes)
      (relay_statistics=yes)
      (show_tns_info=yes) 
      (use_async_call=yes)             
      (authentication_level=0)
   )