Oracle7 Server Distributed Systems Volume I: Distributed Data

Contents Index Home Previous Next

Testing your Configuration

After configuring the network using Network Manager and distributing the configuration files to the destination machines, each component can be started and tested.

The preferred sequence for testing the network is to:

In addition, if Oracle Names is running on your network, test Oracle Names. For further information on how to do so, see the Oracle Names Administrator's Guide.

Start the Listener

From each listener's node, use the Listener Control Utility, LSNRCTL, to start each listener. In command line mode, the command is:

LSNRCTL START listener_name 

LSNRCTL should display a status message indicating that it has started the listener process successfully. Check that all expected SIDs for that listener are listed in the services summary in the status message.

Test the Listener

To test the listener, initiate a connection from a client in the same community as the listener to any active database controlled by that listener.

The simplest test uses SQL*Plus as follows:

SQLPLUS user/password@service_name 

The service_name is found in the TNSNAMES.ORA file before each entry. For more information about testing from a client, see [*].

If there are no clients in the same community as the listener, you must start an Interchange before testing the listener.

Repeat these steps for each listener in the network.

Start the MultiProtocol Interchanges

Use the Interchange Control Utility, INTCTL, on the Interchange node to start an Interchange. For example, in command line mode the command is:

INTCTL START INTERCHANGE 

or

INTCTL START INT 

INTCTL should display a status message indicating that it has started the interchange successfully. For more information on the Interchange Control Utility, see the Oracle MultiProtocol Interchange Administrator's Guide.

Test the Interchanges

To test the Interchange, initiate a connection through the Interchange from a client in one community to a database in another. On the client machine type:

SQLPLUS user/password@service_name 

The service_name for the database in the other community is found in the TNSNAMES.ORA file. To ensure that the connection went through the Interchange, type:

INTCTL STATUS INTERCHANGE 

The Connection Manager should indicate that there is one active connection through the Interchange. The STATUS command can be run on the Interchange machine, or, if the Interchange is listed in the TNSNAMES.ORA file, from any other node.

Test Each Client Type to Make Sure you can Connect to Servers

Make sure that each client type is tested. It is not enough to test that the Interchange works. If there are several different client types in your network, initiate a connection to a server from each of them.

If a connection is unsuccessful, use logging and tracing, the diagnostic utilities, to find the cause of the problem. An error stack in the error log may point to the problem. If not, turn on tracing and repeat the operation. You can find information about error logging and tracing in the Oracle Network Products Troubleshooting Guide.

Common Errors During Testing

If you are unsuccessful in bringing up a listener or Interchange, or fail to make a connection to a database, one of the following common errors may be the cause.

Other common errors are listed in Understanding SQL*Net. All the error messages generated by SQL*Net, the MultiProtocol Interchange, Oracle Names, and Network Manager (and their underlying layers) can be found in the Oracle Network Products Troubleshooting Guide. This book also contains information about how to interpret log files and how to use the trace facility for trouble-shooting purposes.


Contents Index Home Previous Next