Oracle Network Products Troubleshooting Guide

Contents Index Home Previous Next

Format for Log Parameters

When you use Oracle Network Manager to create or edit the log parameters, you do not need to be concerned about syntax. Use Oracle Network Manager to create or edit the log parameters for all components except the server. See Chapter 5 in Oracle Network Manager Administrator's Guide

Note: There is usually a single SQLNET.ORA file for all the clients and servers on a node. That file would contain log parameters for both clients and servers. Generally all clients on a node will have similar logging requirements, as will all servers.

Editing Log Parameters

Use the following format information when you edit log parameters for the server in the SQLNET.ORA file. Use Network Manager or the SQLNET.ORA Editor to change log parameters for other components.

Log parameters are entered in the appropriate component configuration files in the form:

log_parameter_component = value 

The component is one of listener name, client, server, Connection Manager, Navigator, or Names Server.

Note: All log parameters except those for the listener are entered with their component's generic name (for example, navigator). Listener log parameters are entered with the name of the specific listener (for example, LISTENER2). However, the server is the only component for which you should configure log parameters manually. All other components are configured using Oracle Network Manager.

Summary of Available Log Parameters

Parameters are available to control the log filename and location for the client, the server, the listener, and the Names Server. The Connection Manager and the Navigator have these parameters, and in addition both have a parameter that controls whether logging is done.

Logging for the MultiProtocol Interchange

You can turn on logging for both the Connection Manager and the Navigator through a single entry in the Interchange property sheet in Oracle Network Manager. The Navigator has a parameter to control logging of optional information for process and audit control. The Connection Manager has a parameter to control the frequency of logging its statistics. Logging for the pumps is included in the log files for the Connection Manager.

Log Filenames

Log files produced by different components have unique names. The default filenames are:

SQLNET.LOG Contains client and/or server information
LISTENER.LOG Contains listener information
INTCHG.LOG Contains Connection Manager and pump information
NAVGATR.LOG Contains Navigator information
NAMES.LOG Contains Names Server information
You can control the name of the log file. For each component, any valid string can be used to create a log filename. The parameters are of the form:

LOG_FILE_component = string 

For example:

LOG_FILE_LISTENER = TEST 

This parameter would send listener log output to a file called TEST.LOG on the server machine. On most operating systems, the .log suffix is automatically appended to the log filename. Therefore, do not include a suffix in the log filename string.

Some platforms have restrictions on the properties of a filename. See your Oracle operating system-specific manuals for platform-specific restrictions.

Log File Directories

You can control the destination location of the log file for each component. The parameters are of the form:

LOG_DIRECTORY_component = valid directory

Examples are specific to different operating systems. An example on UNIX might be:

LOG_DIRECTORY_LISTENER = /tmp/log 

Some platforms have restrictions on the properties of a directory. See your Oracle operating system-specific manuals for platform-specific restrictions.

Logging for Interchange Components

You can set parameters that determine whether or not log files are produced by the Interchange components, the Connection Manager and pumps, and the Navigator. The Navigator has a parameter to control the amount of information collected into a log file. The Connection Manager has a parameter that controls the frequency of logging. These optional parameters are part of the INTCHG.ORA file.

Turning Logging On

By default, the Interchange components do not produce log files. If you want log files to be created, use the Logging page of the Interchange property sheet in Oracle Network Manager.

A single option, Level, determines whether logging is activated for the Connection Manager and the Navigator. The choices and their consequences are as follows:

OFF No logging for either the Connection Manager or the Navigator. This is the default.
ON Logging is on for the Connection Manager (and pumps), but not the Navigator.
ERRORS Logging is on for the Connection Manager (and pumps), and all errors of navigation are logged for the Navigator.
ALL Logging is on for the Connection Manager (and pumps), and all navigation requests are logged for the Navigator.

Setting Logging Intervals for the Connection Manager

The parameter LOG_INTERVAL_CMANAGER indicates the length of the interval between logs of statistics by the Connection Manager, if logging is turned on for that component. Set this parameter using the Logging page of the Interchange property sheet in Oracle Network Manager.

Logging for Pumps

There are no separate log files generated for pumps. All pump log properties are determined by the corresponding Connection Manager parameters.

Note: See the Oracle Network Manager Administrator's Guide for how to set logging parameters for all the network objects.


Contents Index Home Previous Next