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 9.2.0.1 and later
Oracle Provider for OLE DB - Version 9.2.0.1 and later
Oracle Data Provider for .NET - Version 9.2.0.1 and later
Microsoft Windows (32-bit)



***Checked for relevance on 07-Sep-2016***

Goal

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:

NOTE: The following example demonstrates how to configure two different ASP.NET applications using two different SQLNET.ORA files and requires that you are using IIS 6.0 or later which supports multiple Application Pools.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms