Step 1: Communication: Configuring tnsnames.ora and sqlnet.ora files - syncsort_capacity_management - 12 - 12.40

Within the “Types of Connection String” section, it states that the TNSNAMES.ORA file should contain the database alias information that is also used within the Wallet.

In addition, the local user requires read-only access to both the tnsnames.ora and the sqlnet.ora configuration files. By default, both of these files are located within the $ORACLE_HOME/network/admin directory.

If either global read access or group read access is not available on these configuration files in that location, then it is necessary to:

• Copy the existing tnsnames.ora and sqlnet.ora files from the $ORACLE_HOME/network/admin directory into your local home directory, i.e., (/home/acquire) then rename the files with a dot (.) to make them hidden.

  Example: .tnsnames.ora, .sqlnet.ora

When connecting to a database via the Wallet (listener) it will reference the .sqlnet.ora or .tnsnames.ora files located within the acquire home directory before then the default global location of $ORACLE_HOME/network/admin.

The SQLNET.ORA file also needs to be updated to include the secure Wallet location. The following lines should be appended to the file. The DIRECTORY path should also be changed to reflect the location of your Wallet.

WALLET_LOCATION = 
 (SOURCE =
   (METHOD = FILE)
    (METHOD_DATA =
       (DIRECTORY = /home/acquire/secure)
  )
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0

Only one password may be stored in the wallet per TNS alias.

We have created an alias called “PAOLO”:

         PAOLO =(
         DESCRIPTION =
         (ADDRESS=(PROTOCOL=TCP)(HOST='oraprod1')(PORT=1521))
         (CONNECT_DATA=(SID=PAOLO))
         )