1.从Oracle官方下载安装odp.net 11.1.0.7.20. http://www.oracle.com/technology/software/tech/windows/odpnet/index.html.
2.修改环境变量,将11g客户端的目录放在原来10g目录之后。
3.根据文档要求创建Schema,或者为现有的Schema赋予相应的权限文档在安装目录/product/11.1.0/client_1/ASP.NET/doc下ASPNET.pdf。这里我为asp.net Membership单独创建一个Schema,脚本如下:
CREATE USER ASPNETDB
IDENTIFIED BY 'aspnetdb'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for ASPNETDB
GRANT CONNECT TO ASPNETDB;
GRANT RESOURCE TO ASPNETDB;
GRANT DBA TO ASPNETDB;
ALTER USER ASPNETDB DEFAULT ROLE NONE;
-- 12 System Privileges for ASPNETDB
GRANT CREATE PUBLIC SYNONYM TO ASPNETDB;
GRANT CREATE ROLE TO ASPNETDB;
GRANT DROP PUBLIC SYNONYM TO ASPNETDB;
GRANT CREATE SYNONYM TO ASPNETDB;
GRANT CREATE PROCEDURE TO ASPNETDB;
GRANT CREATE VIEW TO ASPNETDB;
GRANT UNLIMITED TABLESPACE TO ASPNETDB;
GRANT CREATE SESSION TO ASPNETDB;
GRANT CREATE TABLE TO ASPNETDB;
GRANT CHANGE NOTIFICATION TO ASPNETDB;
GRANT CREATE JOB TO ASPNETDB;
GRANT CREATE SEQUENCE TO ASPNETDB;
-- 1 Tablespace Quota for ASPNETDB
ALTER USER ASPNETDB QUOTA UNLIMITED ON USERS;
4. 打开命令行,到odp.net 11安装目录下product/11.1.0/client_1/ASP.NET/SQL目录下。
5.以在第3步中创建的数据库用户连接到oracle,执行InstallAllOracleASPNETProviders.sql即可安装所有的asp.net Provider的数据库.卸载时执行UninstallAllOracleASPNETProviders.sql即可.
sqlplus aspnetdb/aspnetdb
sql>@InstallAllOracleASPNETProviders.sql
6.修改machine.config文件配置OracleMembershipProvider的默认连接串。打开C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/CONFIG/machine.config文件,搜索OraAspNetConString找到默认连接串,修改为
<add name="OraAspNetConString" connectionString="data source=//localhost/orcl;user id=aspnetdb;password=aspnetdb;" />即可。
注:data source=orcl的话将无法连接
至此可以用asp.net成员管理工具来配置你的网站了,当然也可以像使用AspNetSqlMembershipProvider一样,在web.config中为您的应用配置一个特定的Provider、连接串等等。