|Oracle Providers for ASP.NET Developer's Guide
11g Release 1 (18.104.22.168.20)
|PDF · Mobi · ePub|
Oracle Providers for ASP.NET can be installed through XCopy or Oracle Universal Installer.
Administrators use XCopy to deploy Oracle Providers for ASP.NET to a large number of computers for production deployments. It has a small footprint and fine grain control during installation and setup.
Oracle Universal Installer
Developers or users use Oracle Universal Installer for automatic installation. It includes documentation and code samples that are not part of the XCopy.
Note:This section describes installation using the Oracle Universal Installer. For the XCopy installation instructions and configuration, refer to the README file that is part of that installation.
When Oracle Providers for ASP.NET are installed, Oracle Universal Installer automatically registers
Oracle.Web.dll with the Global Assembly Cache (GAC).
The Oracle Providers for ASP.NET installation creates entries in the
machine.config file of the computer on which it is installed. These entries provide basic configuration information for the Oracle Membership, Profile, Role, Site Map, Web Parts Personalization, and Web Event Providers. The
machine.config includes a blank connection string for
OraAspConString, which a developer can configure to connect to an Oracle database with the Oracle Providers for ASP.NET schema.
See Also:"ASP.NET Client Setup" for more details
Additionally, Oracle Providers for ASP.NET Dynamic Help is registered with Visual Studio, providing context-sensitive online help that is seamlessly integrated with the Visual Studio Dynamic Help. With Dynamic Help, the user can access Oracle Providers for ASP.NET documentation within Visual Studio by placing the cursor on an Oracle Providers for ASP.NET keyword and pressing the F1 function key.
Once you have installed Oracle Providers for ASP.NET, two additional setup tasks are required, as follows:
See Also:Oracle Database Installation Guide for Windows for installation instructions
To set up the Oracle database, database administrators must grant the following database privileges to the Oracle Providers for ASP.NET schema. These privileges grant the schema privileges to create the tables, views, stored procedures, and other database objects the Oracle Providers for ASP.NET require. These scripts must be run against the database from which the ASP.NET providers will retrieve their stored state information. These SQL scripts can be run using SQL*Plus or within Oracle Developer Tools for Visual Studio. How to configure the providers is described in the following sections:
Oracle Providers for ASP.NET requires the following privileges:
Create public synonym
Drop public synonym
Grant access to and allocate space in an Oracle tablespace
Errors that occur during the setup script execution may indicate that the user needs to be granted the above privileges. If this is the case, the database administrator must grant these privileges. The Oracle Session State Provider for ASP.NET requires the
CREATE JOB privilege when Oracle Database 10g or later is the database.
To configure all providers in the database at once, run
InstallAllOracleASPNETProviders.sql. This script is found in the
To install Oracle Session State Provider with an Oracle Database 9i Release 2, developers must modify the
InstallAllOracleASPNETProviders.sql script to call the appropriate install script for the provider as listed in Table 1-2. This script calls the configuration script for each provider one by one.
Applications may not require all Oracle Providers for ASP.NET. Providers can be set up individually. Except for the Oracle Session State Provider and Oracle Cache Dependency Provider, the following install script must be executed before any other install scripts. Then, for each Oracle Provider for ASP.NET, a SQL script specific for that provider must be executed (in any order).
These install scripts are found in the
|Provider||Required Installation Script|
Oracle Membership Provider
Oracle Personalization Provider
Oracle Profile Provider
Oracle Role Provider
Oracle Session State Provider
For Oracle Database 10g Release 1 and later
For Oracle Database 9i Release 2
There are correspondingly named uninstall scripts for these install scripts.
Note: This provider only requires the execution of the appropriate provider-specific
Oracle Site Map Provider
Oracle Web Events Provider
Oracle Cache Dependency Provider
No script execution needed
InstallOracleASPNETCommon.sql runs and calls the individual installation scripts, the installation scripts, in turn, execute corresponding
.plb scripts, which create the stored procedures and functions. The installation
.sql scripts must execute where the .
plb file can be accessed.
Each provider also provides corresponding uninstall scripts to remove database objects that were created from the install scripts. These scripts are prefixed with the word
Installation configures the
machine.config file to enable Oracle Providers for ASP.NET systemwide. Users can use the
\OraProvCfg utility to configure the provider-specific entry in the
machine.config file as follows:
To display the
OraProvCfg utility help:
To add Oracle Providers for ASP.NET-specific entries to the
OraProvCfg /action:config /product:aspnet /component:all /frameworkversion:v2.0.50727 /providerpath:c:\Oracle\odp.net\bin\2.x\Oracle.Web.dll
Where Framework version and Provider path (especially) may need to change accordingly.
To remove the Oracle Providers for ASP.NET-specific entries from the
OraProvCfg /action:unconfig /product:aspnet /component:all /frameworkversion:v2.0.50727
Where Framework version may need to change accordingly.
After installation, developers must provide the connection information to the database schema that stores and retrieves the ASP.NET state information. This step requires developers to supply the
Source, and other connection string information if necessary. In the
machine.config file, developers can provide an entry similar to the example below.
<connectionStrings> <add name="OraAspNetConString" connectionString="User Id=aspnet;Password=aspnet;Data Source=oracle; " /> </connectionStrings>
Optionally, developers can customize the properties of each ASP.NET provider from within the
<system.web> section of the
While Oracle Universal Installer automatically configures the
machine.config, developers can apply more fine grained application-level control over the Oracle Providers for ASP.NET by using the
web.config file. This file overrides entries from the
machine.config file, but only for the specific web application it is a part of. Developers can set up their
web.config file with the same XML syntax as the