==================================================
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
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
SQL SERVER 安装ORACLE provider for OLE DB 的连接服务驱动 (195个子文件)
BASIC_README 586B
configure.bat 25KB
uninstall.bat 19KB
unconfigure.bat 12KB
install.bat 11KB
genreg.bat 2KB
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 133.24MB
orannzsbb11.dll 1.49MB
oraocci11.dll 1.26MB
oraocci11.dll 1.26MB
oraocci11.dll 1.1MB
Oracle.DataAccess.dll 1.05MB
Oracle.DataAccess.dll 1.04MB
oci.dll 667KB
OraOLEDB11.dll 666KB
ociw32.dll 471KB
OraOps11w.dll 399KB
OraOps11w.dll 399KB
orasql11.dll 350KB
oramts11.dll 226KB
OraOLEDBrst11.dll 175KB
OraOledbIC11.dll 152KB
OraOLEDBgmr11.dll 140KB
ocijdbc11.dll 135KB
Oracle.Web.dll 104KB
Oracle.Web.dll 97KB
oramtsus.dll 64KB
omtsrecomsgus.dll 50KB
OraOLEDButl11.dll 19KB
OraOLEDBpus11.dll 15KB
oramts.dll 12KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
OraOLEDBrfc11.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.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.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
OraOLEDB11ptb.dll 10KB
OraOLEDB11i.dll 10KB
OraOLEDB11e.dll 10KB
OraOLEDBrmc11.dll 10KB
OraOLEDB11us.dll 10KB
OraOLEDB11f.dll 10KB
OraOLEDB11d.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
omtsrecoevnte.dll 10KB
omtsrecoevnti.dll 10KB
omtsrecoevntd.dll 10KB
omtsrecoevntus.dll 10KB
omtsrecoevntf.dll 10KB
omtsrecoevntptb.dll 10KB
omtsrecoevntja.dll 10KB
OraOLEDB11ja.dll 10KB
OraOLEDB11ko.dll 10KB
OraOLEDB11zhs.dll 10KB
OraOLEDB11zht.dll 10KB
omtsrecoevntko.dll 9KB
Oracle.Web.resources.dll 9KB
Oracle.Web.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
omtsrecoevntzht.dll 9KB
omtsrecoevntzhs.dll 9KB
Oracle.Web.resources.dll 9KB
Oracle.Web.resources.dll 9KB
Policy.2.111.Oracle.Web.dll 3KB
Policy.2.112.Oracle.Web.dll 3KB
Policy.4.112.Oracle.Web.dll 3KB
Policy.4.112.Oracle.DataAccess.dll 3KB
共 195 条
- 1
- 2
rikeli
- 粉丝: 2
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- NetOps-py通过sftp替换网络设备启动文件
- STM32单片机FPGA毕设电路原理论文报告任务驱动教学法在单片机课程教学中的应用
- STM32单片机FPGA毕设电路原理论文报告任务驱动法在单片机教学中的应用
- STM32单片机FPGA毕设电路原理论文报告人造金刚石压机智能化压力测控系统设计
- 以某列为依据匹配多项(Excel版)
- STM32单片机FPGA毕设电路原理论文报告人体短臂离心机实验台的显示控制系统
- STM32单片机FPGA毕设电路原理论文报告人工气候室监控系统的环境控制器研究
- STM32单片机FPGA毕设电路原理论文报告染整自动线张力控制系统的设计
- 数据挖掘与机器学习-实验
- 基于Linux系统Nginx的动态网站的LNMP环境源码包
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
前往页