How To Use Different SQLNET.ORA Files With Multiple Web Applications Running Under IIS
(Doc ID 786908.1)
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version 220.127.116.11 and later
Oracle Provider for OLE DB - Version 18.104.22.168 and later
Oracle Data Provider for .NET - Version 22.214.171.124 and later
Microsoft Windows (32-bit)
***Checked for relevance on 07-Sep-2016***
When running more than one Oracle enabled web application from Microsoft's Internet Information Services (IIS), by default, each application uses the same copy of the SQLNET.ORA file that resides under your ORACLE_HOME\Network\Admin folder. Depending on the nature of each web application, the same set of parameters configured in a single SQLNET.ORA file may not provide the proper configuration for each application. For example, the SQLNET.ORA file can be used to configure the method in which you application connects to an Oracle database, enable/disable SQL*NET tracing parameters, set different authentication methods and apply different SQL*Net settings specific to your application and its behavior.
In order to use more than one version of a SQLNET.ORA file, you must configure your web applications and IIS to use the following:
- TNS_ADMIN Environment Variable
- Separate IIS Application Pools
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!