Oracle Connection lost contact with .NET core 3.0

-1

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.`

oracle
asp.net-core
asp.net-core-3.0
asked on Stack Overflow Feb 17, 2020 by Prashanth

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0