Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

is demo9.2 can hava multi-environment like dv920,py920,pd920 ?

2900133Jan 18 2018 — edited Feb 24 2018

ATT

Comments

417657
Update ODP.NET to 9.2.0.4
422058
Thanks- our DBA reinstalled the Oracle .NET Provider and the issue is now resolved. (Lesson: don't let a developer like me install anything Oracle-related on your servers)...
133763
We are experiencing odp.net 3000 errors:

DB:9.2.0.4.0
odp.net: 9.2.0.4.01 w/3095277 patch installed
client: 9.2.0.1 9ir2 patch set 9.2.0.4.0


Receiving 'Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)' on Middle-tier connections started at 10:30am this morning occurring continuously

Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery,
Boolean fillRequest, CommandBehavior behavior)
at
Oracle.DataAccess.Client.OracleCommand.System.Data.IDbCommand.ExecuteReader()
System.InvalidOperationException: Transaction could not be started. --->
Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleTransaction..ctor(OracleConnection
connection, IsolationLevel isolationLevel, Int32 txnHndAllocated)
at Oracle.DataAccess.Client.OracleConnection.BeginTransaction()
at
Oracle.DataAccess.Client.OracleConnection.System.Data.IDbConnection.BeginTransac
tion()


Oracle.DataAccess.Client.OracleException Data provider internal error(-3001)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery,
Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)


Oracle.DataAccess.Client.OracleException Data provider internal error(-3000)
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
src, String procedure)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()


Any suggestions?

thanks
K.P.Singh

kpsingh@ohiosavings.com
320111
Use the \Microsoft.NET\Framework\v1.1.4322\System.Data.OracleClient.dll from Microsoft instead. This error will never go away and crashes our intranet server daily.
133763
I saw your response about the 3000 errors.
Can you expand little bit more on that?

thanks

kpsingh@ohiosavings.com

216-588-3144

Greatly appreciate your response
320111
Install a basic Oracle client (ODP not required) 8i or above and then use code from the following documentation:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclient.asp
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 24 2018
Added on Jan 18 2018
1 comment
212 views