General: Advanced

The Advanced tab enables you to configure advanced profile information for either a client or server computer.

Send operation Time Out

Use to specify the time, in seconds, for a database server to complete a send operation to clients to complete after connection establishment.

For environments in which clients shut own on occasion or abnormally, setting this parameter is recommended. If the database server is unable to complete a send operation in the time specified, then it logs an ORA-12535:TNS:operation timed out and ORA-12608: TNS: Send timeout occurred to the sqlnet.log file.

Without this parameter, the database server continues to send responses to clients that are unable to receive data due to a downed computer or a busy state.

You can also set this parameter on the clientside to specify the time, in seconds for a client to complete send operations to the database server after connection establishment. Without this parameter, the client may continue to send requests to a database server already saturated with requests.

Receive operation Time Out

Use to specify the time, in seconds, for a database server to wait for client data after connection establishment. A client must send some data within time interval.

For environments in which clients shut down on occasion or abnormally, setting this parameter is recommended. If a client does not send any data in time specified, then the database server logs an ORA-12535:TNS:operation timed out and ORA-12609: TNS: Receive timeout occurred to the sqlnet.log file.

Without this parameter, the database server continues to wait for data from clients that may be down or are experiencing difficulties. You can also use this setting on the clientside to specify the time, in seconds, for a client to wait for response data from the database server after connection establishment.

Without this parameter, the client may wait for a long period of time for a response from a database server saturated with requests.

Total Send Buffer Size

Specify the buffer space limit for send operations of sessions. This parameter is supported by the TCP/IP, TCP/IP with SSL, and SDP protocols.

Total Receive Buffer Size

Specify the buffer space limit for receive operations of sessions. This parameter is supported by the TCP/IP, TCP/IP with SSL, and SDP protocols.

TNS Time Out Value

Specify the time interval, in minutes, to send a probe to verify that client/server connections are active. Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit. This setting is intended for the database server, which typically handles multiple connections at any one time.

Limitations on using this terminated connection detection feature are:

• It is not allowed on bequeathed connections.

• Though very small, a probe packet generates additional traffic that may downgrade network performance.

• Depending on which operating system is in use, the server may need to perform additional processing to distinguish the connection probing event from other events that occur. This can also result in degraded network performance.

Note: This option can be used only on the server.

Client Registration ID

Enter a unique identifier for this client. This identifier is passed to the listener with any connection request.

The listener includes this identifier in its log file. The identifier can be any string up to 128 characters long.

Logon Authentication Protocol Version

Use to specify which authentication protocols are allowed by the client or database. If the client and database server do not have at least one matching version, then authentication fails with an error.

Supported values include:

• 10 for 10i authentication protocols

• 9 for 9i authentication protocols

• 8 for 8i authentication protocols

• Default for 10i , 9i , and 8i authentication protocols

Any value other than 10 could expose vulnerabilities that may have existed in previous version of the authentication protocols. For complete compatibility, set the list of allowable versions for logon to Default to include all versions of database in the system.

Turn off UNIX Signal Handling

Choose to configure the client to pass child process cleanup to the UNIX init process by disabling signal handlers.

Since the client application spawns a server process internally, the client application becomes responsible for cleaning up the child process when it completes. When the server process completes its connection responsibilities, it becomes a defunct process. Signal handlers are responsible for cleaning up these defunct processes.

Disable Out of Band Break

Choose to disable or enable out-of-band breaks.

If deselected, enables Oracle Net to send and receive "break" messages using urgent data provided by the underlying protocol.

If selected, disables the ability to send and receive "break" messages using urgent data provided by the underlying protocol. Once enabled, this feature applies to all protocols used by this client.

Related Topics

Configure Advanced Profile Information

Oracle Net Services Overview  

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

General: Logging

The Logging tab enables you to set logging parameters for this computer. If this computer is a client, then use the Client Information fields. If this computer is a server, then use the Server Information fields.

Log Directory

Enter the directory path to which log files will be written. The default is $ORACLE_HOME/network/log on UNIX and ORACLE_HOME \network\log on Windows platforms.

Log File

Enter the name of the log file on the client. The default name is sqlnet.log.

Related Topics

Configure Profile Logging and Tracing

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

General Parameters: Authentication

The Authentication tab enables you to configure security for a listener. This way, privileged operations, such as saving configuration changes or stopping the listener, issued from the Listener Control utility will require a password. The Oracle Net Manager enables you to set an encrypted password.

Do Not Require a Password for Listener Operations

Choose to disable authentication for administrator tasks.

Require a Password for Listener Operations

Choose to enable authentication for certain administrator tasks. You can then enter the required password. The default password is "oracle".

Note: Oracle Net allows configuration of one password for each listener.

Related Topics

Configure Password Authentication for the Listener

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

General Parameters: Logging & Tracing

The Logging & Tracing tab enables you to enable logging and tracing for the listener. The Oracle Net Manager enables you to specify the name and location to which listener log files are written.

Logging Disabled

Select to disable logging on the listener.

Logging Enabled

Select to enable logging on the listener. Once enabled, you can specify where log information will be written.

Log File

Enter the directory path name and the file name to which log information from the listener will be written. Note that the file name extension for this file is always .log. The default name is listener.log.The default directory is $ORACLE_HOME/network/log on UNIX and ORACLE_HOME \network\log on Windows platforms.

Tracing Disabled

Select to disable tracing on the listener.

Tracing Enabled

Select to enable tracing on the listener. Once enabled, you can specify the level of tracing desired and where trace information will be written by changing the default trace file.

Tracing Level

From the list, select the level of tracing:

Off--Tracing is not enabled. OFF is the default setting.

User--Tracing is set to a level appropriate for users. Traces to identify user-induced error conditions.

Administrator--Tracing is set to a level appropriate to database administrators. Traces to identify installation-specific problems.

Support--Tracing is set to a level appropriate for customer support.

Trace files can get very large. Oracle Corporation recommends that you keep tracing off when not troubleshooting network problems.

Trace File

Enter the directory path name and file name to which trace information from the listener will be written. Note that the file name extension for this file is always .trc. The default name is listener.trc. The default directory is $ORACLE_HOME/network/trace on UNIX and ORACLE_HOME \network\trace on Windows platforms.

Related Topics

Configure Listener Logging and Tracing

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Heterogeneous Services

An integrated component that provides the generic technology for accessing non-Oracle systems from the Oracle database server. Heterogeneous Services enables you to:

• Use Oracle SQL to transparently access data stored in non-Oracle systems as if the data resides within an Oracle server.

• Use Oracle procedure calls to transparently access non-Oracle systems, services, or application programming interfaces (APIs), from your Oracle distributed environment.

To initiate a connection to the non-Oracle system, the Oracle8i database starts an agent process through the listener on the gateway. In order for the Oracle8i database to connect to the agent, the server must be configured with a net service name to access the agent and the listener must be configured with service information about the agent.

Related Topics

Configure a Connect Descriptor for Heterogeneous Services

Configure Heterogeneous Services for the Listener

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

General: Tracing

The Tracing tab enables you to set tracing parameters for this computer. If this computer is a client, then use the Client Information fields. If this computer is a server, then use the Server Information fields.

Client tracing keeps track of the operations the client performs. Server tracing keeps track of the operations the server performs during a network connection.

Trace Level

From the list, select the level of tracing:

OFF--Tracing is not enabled. off is the default setting.

USER--Tracing is set to a level appropriate for users. Traces to identify user-induced error conditions.

ADMIN--Tracing is set to a level appropriate to database administrators. Traces to identify installation-specific problems.

SUPPORT--Tracing is set to a level appropriate for customer support.

Trace files can get very large. Oracle Corporation recommends that you keep tracing off when not troubleshooting network problems.

Trace Directory

Enter the directory to which trace files will be written. While client and server trace files carry information about either the client or the server, both will be written on the local computer. The default is in $ORACLE_ HOME/network/trace on UNIX and ORACLE_HOME\network\trace on Windows platforms.

Trace File

Enter the trace file name. The default file name is sqlnet.trc for the client and svr_pid..trc for the server.

Unique Trace File Name

Choose to create unique names for each trace file. A process identifier is appended to the name of each trace file, so that several trace files can coexist. Clear this option if you do not want unique trace files created and you want all trace information stored in the same trace file.

Related Topics

Configure Profile Logging and Tracing

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

IP address

Used to identify a node on a network. Each computer on the network is assigned a unique IP address, which is made up of the network ID and a unique host ID. This address is typically represented in dotted-decimal notation, with the decimal value of each octet separated by a period, for example, 144.45.9.22.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Listener Control utility

A utility included with Oracle Net Services to control various listener functions, such as starting, stopping, and getting the status of the listener. The Listener Control utility is executed in the following manner:

lsnrctl command [listener_name]

[listener_name] the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if the default listener name, LISTENER, is being used.

For more information, see Chapter 1, Listener Control Utility, in the Oracle10i Net Services Reference Guide.

Related Topics

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Lightweight Directory Access Protocol (LDAP)

A protocol for accessing on-line directory services. LDAP is an Internet standard for storage and directory access. LDAP is based on the X.500 information standard.

Related Topics

Oracle Net Services Overview 

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

KERBEROS(v5)

The KERBEROS(V5) authentication method requires you to set the following parameters:

Element	Description
Service	Enter the name of the authentication service: KERBEROS.
Credential Cache File	The complete path to the Kerberos credential cache file: default is operating system dependent.
Configuration File	The complete path to the Kerberos configuration file. This file contains the realm for the default key distribution center (KDC) and maps hosts to KDC hosts: the default is operating system dependent.
Realm Translation File	The complete path to the Kerberos realm translation file. This file maps a host name, or a domain name, to a realm: default is operating system dependent.
Key Table	The complete path to the Kerberos principal/secret key mapping file. This path is used by the Oracle server to extract its key and decrypt the incoming authentication information from the client. The default is operating system dependent.
Clock Skew	The number of seconds after which the Kerberos credential is considered out of date. Default = 300 seconds

Related Topics

Oracle Advanced Security: Other Params

Oracle Net Services Overview

Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.