5. Sqlnet
The "sqlnet.ora" file contains client side network configuration parameters located at "$ORACLE_HOME/network/admin" or "$ORACLE_HOME/net80/admin" directory on the client.
This file will also be present on the server if client style connections are used on the server itself.
Here is an example of an "sqlnet.ora" file.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH set to specify the order of the naming methods used for client name resolution lookups
Tnsnames Set to resolve a net service name through the tnsnames.ora file on the clientLdap Set to resolve a database service name, net service name, or net service alias through a directory server.ezconnect or hostname Select to enable clients to use a TCP/IP connect identifier, consisting of a host name and optional port and service namecds Set to resolve an Oracle database name in a Distributed Computing Environment (DCE) environment.Nis Set to resolve an Oracle database name in a Distributed Computing Environment (DCE) environment.
If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.
NONE for no authentication methods. A valid username and password can be used to access the database.
ALL for all authentication methods
NTS for Windows NT native authentication
6. Control file
Control file is a small binary file that records the physical structure of the database. The control file also includes:
