使oracle支持dbo,Oracle.ManagedDataAccess.EntityFramework – ORA-01918:用户’dbo’不存在

我正在尝试使用Oracle.ManagedDataAccess 6.121.1.0提供程序实现代码第一次迁移,但是根本没有成功。

当我收到ORA代码时,我假设连接已成功打开。但是迁移是失败的,因为可能,提供程序表现为sql Server,而不是Oracle。我认为这是托盘使用“dbo”作为默认模式。

这是我的web.config设置:

type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection,EntityFramework,Version=6.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089"

requirePermission="false" />

type="OracleInternal.Common.ODPMSectionHandler,Oracle.ManagedDataAccess,Version=4.121.1.0,PublicKeyToken=89b483f429c47342" />

type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices,Oracle.ManagedDataAccess.EntityFramework,Version=6.121.1.0,PublicKeyToken=89b483f429c47342" />

invariant="Oracle.ManagedDataAccess.Client"

description="Oracle Data Provider for .NET,Managed Driver"

type="Oracle.ManagedDataAccess.Client.OracleClientFactory,PublicKeyToken=89b483f429c47342" />

providerName="Oracle.ManagedDataAccess.Client"

connectionString="Data Source=OracleServer:1521/BRSYSDS;User ID=USER;Password=PASSWORD;" />

这里Stacktrace:

[OracleException (0x77e): ORA-01918: user ‘dbo’ does not exist]

OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl,Int32& cursorId,Boolean bThrowArrayBindRelatedErrors,OracleException& exceptionForArrayBindDML,Boolean& hasMoreRowsInDB,Boolean bFirstIterationDone) +652

OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl,Boolean bFirstIterationDone) +39

OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText,OracleParameterCollection paramColl,CommandType commandType,OracleConnectionImpl connectionImpl,Int32 longFetchSize,Int64 clientInitialLOBFS,OracleDependencyImpl orclDependencyImpl,Int64[]& scnFromExecution,OracleParameterCollection& bindByPositionParamColl,Boolean& bBindParamPresent,Boolean isFromEF) +7480

Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() +678

System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__0(DbCommand t,DbCommandInterceptionContext1 c) +10

System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch(TTarget target,Func3 operation,TInterceptionContext interceptionContext,Action3 executing,Action3 executed) +72

System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command,DbCommandInterceptionContext interceptionContext) +357

System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() +104

System.Data.Entity.Migrations.DbMigrator.Executesql(DbTransaction transaction,MigrationStatement migrationStatement,DbInterceptionContext interceptionContext) +152

System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable1 migrationStatements,DbTransaction transaction,DbInterceptionContext interceptionContext) +82

System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable1 migrationStatements,DbConnection connection) +626

System.Data.Entity.Migrations.<>c__DisplayClass30.b__2e() +19

System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute(Action operation) +9

System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable1 migrationStatements,DbTransaction existingTransaction) +194

System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable1 migrationStatements) +7

System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId,XDocument targetModel,IEnumerable1 operations,IEnumerable1 systemOperations,Boolean downgrading,Boolean auto) +825

System.Data.Entity.Migrations.DbMigrator.AutoMigrate(String migrationId,VersionedModel sourceModel,VersionedModel targetModel,Boolean downgrading) +564

System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable1 pendingMigrations,String targetMigrationId,String lastMigrationId) +404

System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration) +447

System.Data.Entity.Migrations.<>c__DisplayClassc.b__b() +13

System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) +422

System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration) +78

System.Data.Entity.Internal.DatabaseCreator.CreateDatabase(InternalContext internalContext,Func3 createMigrator,ObjectContext objectContext) +89

System.Data.Entity.Internal.InternalContext.CreateDatabase(ObjectContext objectContext,DatabaseExistenceState existenceState) +116

System.Data.Entity.Database.Create(DatabaseExistenceState existenceState) +218

System.Data.Entity.DropCreateDatabaseAlways1.InitializeDatabase(TContext context) +137

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值