For Ignite to connect to Oracle instances by name (tnsnames or LDAP), the following Oracle Network configuration (.ora) files are required (see file descriptions below):

    tnsnames.ora - required for tnsname resolution
    ldap.ora - required for LDAP name resolution
    sqlnet.ora - required if default domains are used
   
NOTE: Oracle Names (onames) are not supported by Ignite.

The files must be created in or copied to the following location:

    <ignite_install_directory>/iwc/tomcat/ignite_config/oracle_config

If the Ignite server is running on a UNIX/LINUX machine, symbolic links can be used in place of the actual files.
   
The files may be added and modified while the Ignite server is running. The new properties will be used on any subsequent connection attempts.

Property names in sqlnet.ora and ldap.ora must be either upper case or lower case. Mixed case property names are not supported.

Ignite supports changing the location of these files to a directory external to the Ignite install. To prescribe an alternative directory:

1. Edit <ignite_install_directory>/iwc/tomcat/ignite_config/idc/system.properties
    
2. Set the property com.confio.ignite.oracleConfigurationDirectory to the patch of the desired file directory (directories in the path must be delimited by a forward slash).  For example:

com.confio.ignite.oracleConfigurationDirectory=c:/mytnsnamesdir

Notes:

• If the property does not exist in system.properties, you will need to add it. 
• This directory must exist and be accessible by the Ignite server process.
• The Ignite server must be restarted for this change to be recognized. 

sqlnet.ora
Only two properties from this file are used by Ignite. This file is not required unless a default domain is used for name resolution.

NAMES.DIRECTORY_PATH
Used to determine if name resolution should first be attempted using LDAP or TNSNAMES. The default is TNSNAMES. If the primary name resolution is LDAP, it is recommeneded that the sqlnet.ora file is added to the directory and this property set to (LDAP).

NAMES.DEFAULT_DOMAIN
If this property is set, all unqualified tnsnames will be suffixed with this domain.


tnsnames.ora
This file is used to resolve a name as a tnsname alias. Included files (ifile property) are not supported. If the NAMES.DEFAULT_DOMAIN property is specified in the sqlnet.ora file, all names will be suffixed with this value before the name is resolved.


ldap.ora
This file is used to determine the LDAP server(s) and default admin context
that are to be used to resolve names through a directory service (e.g., OID).

At a minimum, the DIRECTORY_SERVERS property must be defined in this file.

The absence of this file will prevent Ignite from resolving LDAP names.