Oracle10g下安装配置asp.net OracleMembershipProvider

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、连接串等等。