Oracle DB Providers安装脚本错误

Question

在安装Oracle和ODP.NET之后，我尝试运行包含的脚本来为.NET提供程序建立表。例如，当我尝试运行InstallOracleMembership.sql时，操作失败并出现以下错误：

IF ( ora_aspnet_TableExists('ORA_ASPNET_MEMBERSHIP') = 0)   THEN
      *
ERROR at line 2:
ORA-06550: line 2, column 11:
PLS-00201: identifier 'ORA_ASPNET_TABLEEXISTS' must be declared
ORA-06550: line 2, column 6:
PL/SQL: Statement ignored

然后出现一些警告：-> Warning: Function created with compilation errors。错误越多：

GRANT SELECT ON ora_vw_aspnet_Applications TO ora_aspnet_Mem_ReportAccess
            *
ERROR at line 1:
ORA-00942: table or view does not exist

                .
                .
                .
GRANT ora_aspnet_Mem_BasicAccess TO ora_aspnet_Mem_FullAccess
                                *
ERROR at line 1:
ORA-01917: user or role 'ORA_ASPNET_MEM_FULLACCESS' does not exist

为此，我创建了用户，并根据本教程为他添加了create role、view、table等权限。我使用的是ODAC11.2 Release 4 (11.2.0.3.0) 32位、Oracle11g R2 XE DB、Win7 Professional 64位和VS2010。

我是不是漏掉了什么？我做错了什么？谢谢你的帮助。

Answer 1

该手册说，您需要先运行$ORACLE_HOME\ASP.NET\sql\InstallOracleASPNETCommon.sql安装脚本，然后再运行任何其他安装脚本。

http://docs.oracle.com/cd/E11882_01/appdev.112/e10767/installation.htm