Oracle Network Products Troubleshooting Guide

Client Status Monitor in Command Line Mode

To enter the Client Status Monitor in command line mode, enter CSM. The prompt changes to Status Monitor> to show that the Client Status Monitor has started.

Note: Command line mode is not appropriate to use on machines running MS Windows. Use the graphical interface for Windows, described earlier.

Overview

To get an overview of the commands available, at the status monitor prompt enter HELP:

status monitor> help

The following display appears:

SHOW ALL                   SHOW NAME_RESOLUTION_SERVICES  SHOW GENERAL
SHOW INSTALLED_PRODUCTS    SHOW NETWORK_PROTOCOL_ADAPTERS SHOW CSI_INFORMATION
SHOW SYSTEM_SQLNET_OPTIONS SHOW SECURE_NETWORK_SERVICES   SHOW FILE_PATHS
SHOW USER_SQLNET_OPTIONS   SHOW UNIXENV                   SHOW MAN_PAGE
 
SET USE_DEDICATED_SERVER   SET TRACE_DIRECTORY_CLIENT     SET DISABLE_OOB
SET TRACE_FILE_CLIENT      SET SQLNET.CLIENT_REGISTRATION SET AUTOMATIC_IPC
SET TNSPING.TRACE_LEVEL    SET TNSPING.TRACE_DIRECTORY    SET TRACE_LEVEL_CLIENT
 
SET CSI_ID                 SET CSI_PHONE                  SET CSI_FAX
SET CSI_FROM               SET CSI_SUBJECT                SET CSI_COMMENT
 
RESOLVE_SERVICE_NAME       ATTEMPT_CONNECT                PRINT_REPORT
HELP                       QUIT

These commands enable you to show or set the same information as you can using the graphical version of the tool.

Note: Within the Client Status Monitor, case is not significant. For example, you can enter either HELP or help.

For example, if you want to display the general information for your client, enter the following:

Status Monitor> SHOW GENERAL

A display like the following appears on your screen:

       *** General ***
 
TNS for Unix: Version 2.1.6.1.0 Production
system config file =>  
user config file   =>  
log file           => /home/jshaw/sqlnet.log 
client trace file  => 
registration       => 
client tracelevel  => OFF

To set parameters, enter the value you wish to set following the command name.

For example, to set the name of the contact for Oracle Customer Support to be JShaw, enter the following:

Status Monitor> SET CSI_CONTACT JSHAW

If you want to edit the SQLNET.ORA file to turn tracing ON, enter the following:

Status Monitor> SET TRACE_LEVEL_CLIENT ADMIN

Using Client Status Monitor for Individual Commands

From the command line, you can open the Client Status Monitor and issue a command on the same line. For example, you can open the Client Status Monitor and ask for a display of general information about the client by entering the following command at the operating system prompt:

> CSM SHOW GENERAL

After the Client Status Monitor has carried out the command, the operating system prompt returns.

Display the Client Environment

To display information about your environment, you can use the following commands:

Status Monitor> SHOW INSTALLED_PRODUCTS

The Client Status Monitor displays a list of all the Oracle products on this machine.

Status Monitor> SHOW FILE_PATHS

The Client Status Monitor displays the paths of the SQL*Net configuration files on the client machine.

Status Monitor> SHOW UNIXENV

The Client Status Monitor displays the environment variables for your operating system.

Status Monitor> SHOW NAME_RESOLUTION_SERVICES

The Client Status Monitor displays the name resolution services available to the client, and shows the order in which they are used.

Status Monitor> SHOW NETWORK_PROTOCOL_ADAPTERS

The Client Status Monitor displays the protocol adapters installed on the client.

Status Monitor> SHOW SECURE_NETWORK_SERVICES

The Client Status Monitor displays the security services available to the client. These services include encryption, checksumming, and authentication.

Status Monitor> SHOW ALL

The Client Status Monitor displays all the the information available through the individual commands listed in this section.

Contact Oracle Customer Support

The Client Status Monitor can print a fax sheet containing information for you to provide to Oracle Customer Support. Most of the information on the fax page is similar to the result of the SHOW ALL command. However, you must provide identifying information for Oracle Customer Support. To do this in character mode, enter the following commands:

Status Monitor> SET CSI_ID customer_ID

Status Monitor> SET CSI_PHONE phone_number_of_local_contact

Status Monitor> SET CSI_FAX fax_number_of_local_contact

Status Monitor> SET CSI_CONTACT name_of_local_contact

After providing the identifying information, print the fax page by entering the following command:

Status Monitor> PRINT_FAXPAGE

Edit SQLNET.ORA

In command line mode you can change some parameters in the user level SQLNET.ORA file. The commands to use and the values available to use with them follow:

Status Monitor> SET USE_DEDICATED_SERVER ON|OFF

Use this command to make a connection to a dedicated server rather than to use a multi-threaded server.

Status Monitor> SET DISABLE_OOB ON|OFF

Use this command to disable (or enable) out-of-band breaks. The default is for out-of-band breaks to be enabled.

Status Monitor> SET TRACE_LEVEL_CLIENT OFF|USER|ADMIN

Unless you are troubleshooting a particular problem, the trace level should be OFF. Other choices are USER, for a moderately detailed trace report, and ADMIN, for more extensive trace information.

Note: After troubleshooting your connection problem, turn trace level back to OFF. Leaving the trace facility set to USER or ADMIN can impact performance.

Status Monitor> SET TRACE_FILE_CLIENT file_name

You can change the name for the trace file with this command. In most operating systems, the trace file name is automatically appended with the suffix .TRC. You do not need to enter that suffix in the field.

Status Monitor> SET TRACE_DIRECTORY_CLIENT directory_path

You can change the directory to which the client trace file is written with this command. Be sure that you have write permission to the directory you select.

Status Monitor> SET TNSPING.TRACE_LEVEL OFF|USER|ADMIN

Unless you are troubleshooting a particular problem, the trace level should be OFF. Other choices are USER, for a moderately detailed trace report, and ADMIN, for more extensive trace information.

Note: After troubleshooting your connection problem, turn trace level back to OFF. Leaving the trace facility set to USER or ADMIN can impact performance.

Status Monitor> SET TNSPING.TRACE_DIRECTORY directory_path

You can change the directory to which the TNSPING trace file is written with this command. Be sure that you have write permission to the directory you select.

Status Monitor> SET AUTOMATIC_IPC ON|OFF

Use this command to change whether or not the client should use an IPC connection before trying other protocols. The default is for IPC to be set to ON

Status Monitor> SET SQLNET.CLIENT_REGISTRATION unique_identifier

This command 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.

Resolve Service Name

You can find out the address to which a service name is resolved by entering the following command:

Status Monitor> RESOLVE_SERVICE_NAME service_name

The Client Status Monitor displays the address.

The Client Status Monitor will also attempt a connection using the TNSPING utility if you enter the following command:

Status Monitor> ATTEMPT_CONNECT service_name

The TNSPING utility will return a message stating whether the connection attempt was successful, and how long it took.