==================================================
ORACLE PROVIDERS FOR ASP.NET 11.2.0.2.0 Production
==================================================
Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved.
This document provides information that supplements the Oracle Providers
for ASP.NET Production documentation.
===============
IMPORTANT NOTES
===============
Oracle providers for ASP.NET support .NET Framework 2.0 and higher.
============================
INSTALLATION AND SETUP NOTES
============================
1. Product Dependencies
Oracle Providers for ASP.NET requires Oracle Client 11.2.0.2.0 or Oracle
Instant Client 11.2.0.2.0. When installing a new Oracle Providers for ASP.NET
11.2.0.2.0 instance, Oracle Universal Installer (OUI) will automatically
install Oracle Instant Client 11.2.0.2.0.
2. Policy DLLs
Note that the installation of this product places policy DLLS into the GAC so
that existing applications can start using newly installed version of this
product immediately after installation. However, if this is not desired, be
sure to remove the policy DLLs from the GAC.
3. Oracle Providers for ASP.NET 11.2.0.2.0 - Database Set Up
Before using Oracle Providers for ASP.NET 11.2.0.2.0, execute the database
SQL scripts that were part of the installation. Note that Oracle Providers for
ASP.NET ships with InstallAllOracleASPNETProviders.sql which will create all
the database objects for all the providers. If you already have an older version
of Oracle Providers for ASP.NET installed, the execution of
InstallAllOracleASPNETProviders.sql will update the stored procedures and column
definitions, but tables will not be dropped nor re-created.
==================================
TIPS, LIMITATIONS AND KNOWN ISSUES
==================================
1. If the HKEY_LOCAL_MACHINE\Software\Oracle\NLS_LANG registry entry is
set to "NA", ORA-12705 errors will be encountered when using Oracle
Providers for ASP.NET. To eliminate this problem, remove the
HKEY_LOCAL_MACHINE\Software\Oracle\NLS_LANG registry entry.
================================
AUTOMATIC MACHINE.CONFIG CHANGES
================================
After the installation of Oracle Providers for ASP.NET,
%windir%\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
file will be updated to make the system aware of the ASP.NET providers
that were installed. In addition, a connection string alias of
"OraAspNetConString" is added, which is referenced by each of the Oracle
Providers for ASP.NET. Below are typical entries that will be made in the
machine.config after the install.
(NOTE: You do not need to make these entries in the machine.config.
This is for your information only.)
(NOTE: "..." are place holders for existing entries in the machine.config.)
<configuration>
...
<connectionStrings>
...
<add name="OraAspNetConString" providerName="Oracle.DataAccess.Client" connectionString=" " />
</connectionStrings>
...
<system.web>
...
<membership>
<providers>
<add name="OracleMembershipProvider" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
...
</providers>
</membership>
...
</system.web>
...
</configuration>
The above example shows just an entry for the Oracle Membership Provider.
There will be similar entries for other providers.
=====================
QUICK SETUP REFERENCE
=====================
Below are the quick setup steps for Oracle Providers for ASP.NET.
The steps below assumes that Oracle 11g 11.2.0.2.0 Production
was installed under a valid Oracle Home which will be referred to as
%ORACLE_HOME% henceforth in this readme.txt.
1. SQL*Net Setup
a) EZCONNECT
Either EZCONNECT or TNSNAMES can be used to connect to Oracle for
executing the Oracle Providers for ASP.NET setup scripts as well as for
the providers to connect to Oracle. To connect to the database using
either approach, %ORACLE_HOME%\Network\Admin\sqlnet.ora file must be
created to contain:
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
To be able to connect using OS Authentication, the following line is
also needed to be included in sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
To use EZCONNECT, the data source must be specified in the following
format (and no other configuration file is needed):
[//]host[:port][/service_name][/server][/instance_name]
b) TNSNAMES
To use TNSNAMES, a tnsnames.ora file must be also created in or
copied to the %ORACLE_HOME%\Network\Admin directory.
The %ORACLE_HOME%\Network\Admin\tnsnames.ora file can be created, for
example, to contain the following:
oracle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my-pc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
The protocol, host, port, and service name in the tnsnames.ora should be
modified appropriately. If TNSNAMES is to be used, the TNSNAMES alias
is specified as the "data source", which in the example above is "oracle".
2. Executing the SQL Scripts
As noted during the install, the setup SQL scripts must be executed before
using any of the Oracle Providers for ASP.NET. For details, please see
Chapter 1 of the Oracle Providers for ASP.NET Developer's Guide.
If you don't have SQL*Plus to execute SQL scripts, you may install and use
Oracle Developer Tools (ODT) for Visual Studio 2005 or 2008 to execute those
scripts. Below are the steps:
a) Start up Visual Studio 2005 or 2008 IDE. Under Tools menu, select Run
SQL*Plus Script.
b) In the 'Run SQL*Plus Script' dialog box, click New Connection button.
c) In the Connection Properties dialog box, select "Oracle Database
Server (Oracle ODP.NET)" for Data Source and "Oracle Data Provider
for .NET" for Data Provider. Select a TNS alias
from Data Source Name drop-down list. If no entry is available, see
SQL*Net setup above. Enter a username and password, or select Use
Windows integrated authentication. Click Test Connection button to
test the connection. If it's successful, click the OK button to
continue.
NOTE: The scripts will create tables, stored procedures, views, and
roles. They will be owned by the database user that executed the
scripts. If the ASP.NET applications connect to the database as a
different database user than the database user that executed the
scripts, the database user (who owns the database objects that were
created for ASP.NET providers) will need to grant roles to other
database users, if they require access. For further details, please
read Chapter 1 of the Oracle Providers for ASP.NET user's Guide for
details.
d) Back in the 'Run SQL*Plus Script' dialog box, browse and select the
SQL scripts to run. Typically, the location of the scripts is
%ORACLE_HOME%\ASP.NET\SQL.
e) The InstallOracleASPNETCommon.sql script must be executed first
before executing any scripts for other Oracle Providers for ASP.NET.
Ho
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
odp.net 11g 32位版 (208个子文件)
BASIC_README 586B
configure.bat 27KB
uninstall.bat 20KB
unconfigure.bat 14KB
install.bat 12KB
genreg.bat 3KB
Policy.2.102.Oracle.DataAccess.config 399B
Policy.2.111.Oracle.DataAccess.config 399B
Policy.4.112.Oracle.DataAccess.config 393B
Policy.2.112.Oracle.DataAccess.config 393B
Policy.2.111.Oracle.Web.config 392B
Policy.2.112.Oracle.Web.config 386B
Policy.4.112.Oracle.Web.config 386B
oraociei11.dll 123.59MB
orannzsbb11.dll 1.2MB
Oracle.DataAccess.dll 1.05MB
Oracle.DataAccess.dll 1.05MB
oci.dll 992KB
oip11.dll 848KB
oraocci11.dll 708KB
oraocci11.dll 708KB
orasql11.dll 608KB
oraocci11.dll 539KB
OraOLEDB11.dll 512KB
OraOps11w.dll 344KB
OraOps11w.dll 344KB
ociw32.dll 340KB
oraclm32.dll 236KB
oramts11.dll 192KB
OraOledbIC11.dll 168KB
OraOLEDBrst11.dll 148KB
OraOLEDBgmr11.dll 136KB
Oracle.Web.dll 108KB
ocijdbc11.dll 100KB
Oracle.Web.dll 97KB
oramtsus.dll 80KB
OO4OAddin.dll 72KB
OO4Ocodewiz.dll 68KB
omtsrecomsgus.dll 49KB
OraOO4Oic11.dll 48KB
oraansi11.dll 24KB
OraOLEDButl11.dll 17KB
OraOLEDBpus11.dll 15KB
Oracle.DataAccess.resources.dll 13KB
Oracle.Web.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.Web.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
oramts.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
OraOLEDBrfc11.dll 10KB
Oracle.DataAccess.resources.dll 10KB
Oracle.DataAccess.resources.dll 10KB
Oracle.DataAccess.resources.dll 10KB
Oracle.Web.resources.dll 10KB
OraOLEDB11e.dll 10KB
OraOLEDBrmc11.dll 10KB
OraOLEDB11f.dll 10KB
OraOLEDB11d.dll 10KB
OraOLEDB11ptb.dll 10KB
OraOLEDB11i.dll 10KB
OraOLEDB11us.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.DataAccess.resources.dll 10KB
OraOLEDB11ja.dll 9KB
omtsrecoevntptb.dll 9KB
omtsrecoevntf.dll 9KB
OraOLEDB11zht.dll 9KB
omtsrecoevnti.dll 9KB
omtsrecoevntd.dll 9KB
OraOLEDB11ko.dll 9KB
omtsrecoevnte.dll 9KB
OraOLEDB11zhs.dll 9KB
omtsrecoevntus.dll 9KB
omtsrecoevntja.dll 9KB
omtsrecoevntko.dll 9KB
共 208 条
- 1
- 2
- 3
zinc88
- 粉丝: 6
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
前往页