My Oracle Support Banner

How To Use Different SQLNET.ORA Files With Multiple Web Applications Running Under IIS (Doc ID 786908.1)

Last updated on AUGUST 02, 2023

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)

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:

  • TNS_ADMIN Environment Variable
  • Separate IIS Application Pools
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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.