Hi
I am using Oracle.ManagedDataAccess.dll to connect with oracle database from Azure cloud to on premise oracle database. I have used ODP.NET_Managed_ODAC12cR4 64 bit dll downloaded from 64-bit Oracle Data Access Components (ODAC) for Windows. and getting following errors:
Error1: Connection request timed out (I am using one minute for timeout).
Error2: ORA-12570: Network Session: Unexpected packet read error. (No of occurrence of this error is very high)
ORA-12570: Network Session: Unexpected packet read error at Oracle.ManagedDataAccess.Client.OracleException.HandleError(OracleTraceLevel level, OracleTraceTag tag, Exception ex, OracleLogicalTransaction oracleLogicalTransaction)
at OracleInternal.TTC.TTCLob.ReceiveResponse(List`1 dataSegments)
at OracleInternal.TTC.TTCClob.CreateTemporaryLob(Boolean bCache, Boolean bNClob, Int32 duration)
at OracleInternal.ServiceObjects.OracleClobImpl.CreateTemporaryLob()
at OracleInternal.ServiceObjects.OracleParameterImpl.SetClobDataInBytes(OracleConnectionImpl connImpl, Boolean bIsNClob, Object paramValue, Int32 offset, Int32 maxSize, Int32[] maxArrayBindSize, Byte[]& clobByteArray, Object& saveValue)
at OracleInternal.ServiceObjects.OracleParameterImpl.SetClobDataInBytes(OracleConnectionImpl connImpl, Boolean bIsNClob, Object paramValue, Int32 offset, Int32 maxSize, Int32[] maxArrayBindSize)
at Oracle.ManagedDataAccess.Client.OracleParameter.PreBind_Clob(OracleConnectionImpl connImpl, Boolean isEFSelectStatement, SqlStatementType stmtType)
at Oracle.ManagedDataAccess.Client.OracleParameter.PreBind(OracleConnectionImpl connImpl, ColumnDescribeInfo cachedParamMetadata, Boolean& bMetadataModified, Int32 arrayBindCount, ColumnDescribeInfo& paramMetaData, Object& paramValue, Boolean isEFSelectStatement, SqlStatementType stmtType)
at OracleInternal.ServiceObjects.OracleCommandImpl.InitializeParamInfo(ICollection paramColl, OracleConnectionImpl connectionImpl, ColumnDescribeInfo[] cachedParamMetadata, Boolean& bMetadataModified, Boolean isEFSelectStatement, MarshalBindParameterValueHelper& marshalBindValuesHelper)
at OracleInternal.ServiceObjects.OracleCommandImpl.ProcessParameters(OracleParameterCollection paramColl, OracleConnectionImpl connectionImpl, ColumnDescribeInfo[] cachedParamMetadata, Boolean& bBindMetadataModified, Boolean isEFSelectStatement, MarshalBindParameterValueHelper& marshalBindValuesHelper)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
Also I tried to use Nuget package (Oracle.ManagedDataAccess.12.1.24160419) and got the following error:
ORA-12570: Network Session: Unexpected packet read error A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
I am simply calling store procedure which is storing data in three table in transaction fashion. Which version of dll i should use and what I am missing here. sometimes It allows insertion of data and most of the time we get the following errors.
any help on this much appreciated..