Im writing ASP.NET Core application and trying to Oracle DB, getting the following error.
Im using .NET core 3.0 Framework and Oracle.Managed.DataAccess.Core for Oracle connection.
Thanks, Prashanth
Error:
Oracle.ManagedDataAccess.Client.OracleException
HResult=0x80004005
Message=ORA-03135: Connection lost contact
Source=Oracle Data Provider for .NET, Managed Driver
StackTrace: at OracleInternal.ConnectionPool.PoolManager 3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OracleConnectionDispenser 3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria) at Oracle.ManagedDataAccess.Client.OracleConnection.Open() at Dapper.SqlMapper.d__140'1.MoveNext() in C:\projects\dapper\Dapper\SqlMapper.cs:line 1079 at System.Collections.Generic.List'1..ctor(IEnumerable'1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable'1 source) at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable'1 commandTimeout, Nullable'1 commandType) in
.... .... ....
at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
This exception was originally thrown at this call stack: OracleInternal.Network.ReaderStream.Read(OracleInternal.Network.OraBuf)
Inner Exception 1: NetworkException: ORA-03135: Connection lost contact
Inner Exception 2: SocketException: An established connection was aborted by the software in your host machine.`
User contributions licensed under CC BY-SA 3.0