时间戳

首页 > 解决方案 > ubuntu中vscode中的oracle连接

c# - ubuntu中vscode中的oracle连接

问题描述

无法加载共享库“oci”或其依赖项之一

您好，我正在用 C#、Ubuntu 16.04 和 vscode 开发一个访问 ORACLE 数据库的程序。有问题的程序部分如下：

Console.WriteLine("*******************************************");
Console.WriteLine("*PopulaFuncionário");
OracleConnection ora = new OracleConnection(connStr);
ora.Open();
Console.WriteLine("*Conectou na versão:" + ora.ServerVersion );
Console.WriteLine("*******************************************");

上面的 Open 返回以下错误。

Unable to load shared library 'oci' or one of its dependencies.

我的计算机上安装了 ORACLE 客户端和 OCI 库，但我不知道如何引用它们。请，如果有人有解决方案...谢谢。

Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware[1]
      An unhandled exception has occurred while executing the request.
System.DllNotFoundException: Unable to load shared library 'oci' or one of its dependencies. In order to help diagnose loading problems, consider setting the LD_DEBUG environment variable: liboci: cannot open shared object file: No such file or directory
   at System.Data.OracleClient.Oci.OciCalls.OciNativeCalls.OCIEnvCreate(IntPtr& envhpp, OciEnvironmentMode mode, IntPtr ctxp, IntPtr malocfp, IntPtr ralocfp, IntPtr mfreep, Int32 xtramem_sz, IntPtr usrmempp)
   at System.Data.OracleClient.Oci.OciEnvironmentHandle..ctor(OciEnvironmentMode mode)
   at System.Data.OracleClient.Oci.OciGlue.CreateConnection(OracleConnectionInfo conInfo)
   at System.Data.OracleClient.OracleConnectionPoolManager.CreateConnection(OracleConnectionInfo info)
   at System.Data.OracleClient.OracleConnectionPool.GetConnection()
   at System.Data.OracleClient.OracleConnection.Open()
   at app1.Models.PopulaFuncionario..ctor() in /home/w0513263/Desenv/C#/app1/Models/PopulaFuncionario.cs:line 23
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCreateInstance(CreateInstanceCallSite createInstanceCallSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitTransient(TransientCallSite transientCallSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ActivatorUtilities.GetService(IServiceProvider sp, Type type, Type requiredBy, Boolean isDefaultParameterRequired)
   at lambda_method(Closure , IServiceProvider , Object[] )
   at Microsoft.AspNetCore.Mvc.Controllers.ControllerActivatorProvider.<>c__DisplayClass4_0.<CreateActivator>b__0(ControllerContext controllerContext)
   at Microsoft.AspNetCore.Mvc.Controllers.ControllerFactoryProvider.<>c__DisplayClass5_0.<CreateControllerFactory>g__CreateController|0(ControllerContext controllerContext)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

标签： c#linuxvisual-studio-code

解决方案

After much searching, I found the solution. Just add the packages:

  • Oracle.ManagedDataAccess

and everything worked perfectly ...

推荐阅读