Understanding SQL*Net
Modifying Client Parameters
Client configuration parameters are contained in the SQLNET.ORA file. Generally, you generate SQLNET.ORA files for clients with similar navigation needs (called client profiles or client types) using Oracle Network Manager. The SQLNET.ORA file determines the following client characteristics:
- preferred choices of name respolution services
- preferred Names Servers (if Oracle Names is used on the network)
- preferred Oracle MultiProtocol Interchanges (if used on the network)
- non-default tracing and logging characteristics
- preferred security services (if Secure Network Services is used on the network)
- characteristics of connection requests (whether to use a dedicated server, out-of-band breaks, IPC addresses)
- client registration information for statistical reporting
The SQLNET.ORA file created by Network Manager generally is used by a number of clients. If you want to change any of these parameters for a whole group of clients, you may use Network Manager to change the network definition and create new SQLNET.ORA files to be distributed as needed.
Alternatively, if you want to change parameters for individual clients, you may use the SQLNET.ORA Editor. This utility is part of the Client Status Monitor. It enables you to open the SQLNET.ORA file on an individual client and change its parameters either through a graphical user interface or through the command line.
If you are using Oracle Names version 2.0 and the Dynamic Discovery Option, you do not necessarily need to use Network Manager. If you do not use it, a SQLNET.ORA file is not created. If you find you want to provide some non-default parameters for the client, you can create an empty SQLNET.ORA using any text editor, such as vi, and then add the parameters you need using the SQLNET.ORA Editor. Using this method to create the file makes it less likely that typographical or formatting mistakes will cause errors.