English 中文(简体)
Oracle DB 供应商安装印本错误
原标题:Oracle DB Providers installation scripts errors

在安装Oracle XE DB和耗氧潜能吨之后。 NET, i试图包括文字,以建立表格。 NET提供商。 如果想像InstallOracle Membership.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

Then comes some warnings -> Warning: Function created with compilation errors. And the more 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

For this purpose i created user and added him privileges like create role, view, table according to this tutorial Oracle tutorial I am using ODAC 11.2 Release 4 (11.2.0.3.0) 32bit, Oracle 11g R2 XE DB, Win7 Professional 64bit and VS2010.

有一点失踪? 什么是错了? 得到帮助。

最佳回答

The manual says you need to run $ORACLE_HOMEASP.NETsqlInstallOracleASPNETCommon.sql install script before any other install scripts.

rel=“nofollow” http://docs.oracle.com/cd/E11882_01/appdev.112/e10767/installation.htm

问题回答

暂无回答




相关问题
Export tables from SQL Server to be imported to Oracle 10g

I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

How to make a one to one left outer join?

I was wondering, is there a way to make a kind of one to one left outer join: I need a join that matches say table A with table B, for each record on table A it must search for its pair on table B, ...

Insert if not exists Oracle

I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL ...

How can I store NULLs in NOT NULL field?

I just came across NULL values in NOT-NULL fields in our test database. How could they get there? I know that NOT-NULL constraints can be altered with NOVALIDATE clause, but that would change table s ...

Type reference scope

I m studying databases and am currently working on a object-relational DB project and I ve encountered a small problem with the number of possible constraints in an object table. I m using "Database ...

OracleParameter and DBNull.Value

we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...

热门标签