Creating the sqlnet.ora file

The sqlnet.ora file manages Oracle network operations. You can create a new sqlnet.ora file, or FTP the file from your Oracle server.

1. Log in as oracle.
2. Change the directory to Oracle 12.1.0.2 client (32-bit):

   $ cd /opt/oracle/product/12.1.0-client32/network/admin

3. Create the sqlnet.ora file, which manages Oracle network operations. You must create an sqlnet.ora file for both Oracle server and Oracle client installations. Follow these steps:
   1. Copy the sqlnet.ora file that was created earlier during the configuration of oracle server net client, from /opt/oracle/product/12.1.0/network/admin directory.

      $ cp /opt/oracle/product/12.1.0/network/admin/sqlnet.ora .

   2. Add the following lines to this file:

      NAMES.DIRECTORY_PATH=(TNSNAMES)    
      NAMES.DEFAULT_DOMAIN=WORLD
      SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8            
      SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

      For example:

      # sqlnet.ora network configuration file in 
      # /opt/oracle/product/12.1.0/network/admin
      NAMES.DIRECTORY_PATH=(TNSNAMES)
      NAMES.DEFAULT_DOMAIN=WORLD
      SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8            
      SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

      Note: If you do not use WORLD as the DEFAULT_DOMAIN value, make sure that you enter the same value for DEFAULT_DOMAIN in both sqlnet.ora and tnsnames.ora.
   3. Write and quit the sqlnet.ora file.
   4. Restart the listener process by using the following commands:

       
      lsnrctl stop
      
      lsnrctl start

      Look for a successful completion message.