|
|
|
Oracle SQL*Net is used for client access to the database server. Although Oracle provides two utilities (SQL*Net Configuration tool and Network Manager tool) for defining your network, clients, and server, you need a network administrator to perform this task. The server system administrator is usually the best candidate.
Note: For more information about these utilities, see the Oracle SQL*Net Administrator’s Guide.
SQL*Net requires certain files on both the server and client. These files can be generated by the Oracle networking tools, but can also be created using a text editor. Because Oracle does not support those sites that generate these files manually, it is better to use the appropriate Oracle utilities. The following lists the files required by SQL*Net:
|
File Name |
Required On |
File Contents |
|---|---|---|
|
TNSNAMES.ORA |
Client and Server |
A list of service names and connect descriptors for network destinations (tells the client where it can make connections) |
|
SQLNET.ORA |
Client and Server |
A list of optional diagnostic parameters |
|
LISTENER.ORA |
Server only |
A list of names and addresses of all listeners on a computer and the Oracle SIDs for the databases known on that computer |
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |