Oracle Network Products Troubleshooting Guide

Contents Index Home Previous Next

Providing Troubleshooting Information

Connection problems may be caused by a number of things. Perhaps a needed Oracle product is not installed. Perhaps the necessary configuration files are missing, or are not in the correct directories. Perhaps your environment variables are incorrectly set. You can choose to look at the following aspects of your environment:

Contacting Oracle Customer Support

The Client Status Monitor includes a form suitable for faxing to Oracle Customer Support. If you cannot resolve your problem yourself, the fax report form provides information generated by the Client Status Monitor in a convenient format to send to Oracle Customer Support. Sending the fax report form can speed the resolution of your problem by providing answers to many of the support analyst's questions before they are even asked.

Editing Individual SQLNET.ORA Files

The Client Status Monitor enables you to access the SQLNET.ORA Editor to change some of the optional parameters in the SQLNET.ORA file. You might want to do this to change the trace level or the name and location of the trace file, to change the TNSPING trace level, or to make other changes. The Client Status Monitor's SQLNET.ORA Editor is an efficient way to make changes that affect only the individual client in whose SQLNET.ORA file the changes are made.

Note: There may be more than one SQLNET.ORA file available, a system-level and a user-level file. If both are available, the values for the variables in the user-level file take priority over those in the system-level file.


Contents Index Home Previous Next