Stack Overflow
Stack Overflow

Questions tagged [odp.net-managed]

The Oracle Managed DataAccess Provider is the .Net Native version of ODP.Net. It doesn't need a prior Oracle Client installation or have any dependency on the OCI library. Applications that reference it may therefore be built 'AnyCPU'.

110 questions
33
votes
4 answers

Can the Oracle managed driver use async/await properly?

I was trying to make an Oracle query with the async/await .NET feature. The result set is pretty large and takes about 5-10 seconds to come back. The Window_Loaded is hanging the UI thread, essentially I wanted to use async/wait to do the query in…
user17753
  • 3,083
  • 9
  • 35
  • 73
19
votes
2 answers

ODP.net managed driver throws ORA-12570: Network Session: Unexpected packet read error

In one of our products we retrieve data from the Oracle database using stored procedures using the ODP.net managed driver. Every now and then (roughly every 1000 queries) we get the following exception: (ORA-12570: Network Session: Unexpected packet…
vc 74
  • 37,131
  • 7
  • 73
  • 89
18
votes
2 answers

ODP.Net Driver Throwing Exception on .NET Core 5.0

I am trying to port my database application from .NET Core 3.1 to .NET Core 5.0. When running the following code, public async Task> LoadDataFromSQL(string sql, U parameters, string connectionStringName) { …
Jason D
  • 1,863
  • 2
  • 16
  • 30
16
votes
9 answers

Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied

I have a challenging situation on one of our servers. I have an ASP.NET MVC 3 application that needs to connect to an Oracle 12c database. It does so using the following connection string: User ID=myuserid;Password=mypass;Data…
DerHaifisch
  • 394
  • 1
  • 5
  • 14
13
votes
4 answers

Oracle ODP.NET error

I have a VS 2012 Web Project Up. I have ODP.NET installed as we are an Oracle Workshop. I inherited a project that uses Oracle.ManagedAccess.Data and EF. Upon running the project in VS 2012, I get the following error: There is a duplicate…
dawriter
  • 425
  • 3
  • 8
  • 21
11
votes
5 answers

Oracle ManagedDataAccess - Connection Request Timed out - Pooling

I'm finally admitting defeat and asking for help. I've done everything I can think of to solve this problem, but it seems I'm incapable of doing it. I'm working with: VS2010 C# Oracle 12c ODP.Net Managed121012 I have inherited an app that uses both…
Ruth Amui
  • 143
  • 1
  • 2
  • 12
11
votes
6 answers

EF + ODP.NET + CLOB = Value Cannot be Null - Parameter name: byteArray?

Our project recently updated to the newer Oracle.ManagedDataAccess DLL's (v 4.121.2.0) and this error has been cropping up intermittently. We've fixed it a few times without really knowing what we did to fix it. I'm fairly certain it's caused by…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
9
votes
1 answer

ODP.NET Managed Driver Performance Counters missing in perfmon

How do I enable the performance counters for ODP.NET Managed Driver in perfom in order to be able to monitor them? Currently I am unable to see the category "Oracle Data Provider for .NET" in perfmon at all. I've tried to register the counters from…
metalheart
  • 3,740
  • 1
  • 23
  • 29
7
votes
5 answers

Set NLS_LANG for oracle managed data access

I have a winforms c# application using Oracle 12c through oracle.manageddataaccess (via NHibernate 4.0), The oracle database is on another machine on customer site we've had issues with character set conversion due to NLS_LANG differences between…
Alex McMahon
  • 268
  • 1
  • 4
  • 11
6
votes
1 answer

Error when using OracleConnection.Open() ORA-00303: Network Library: Name-Value syntax error ODP.NET managed dll

I am getting this error when i hit the source.Open(); line of code and I cannot figure out why. I was using the unmanaged dll and I am trying to upgrade to the version Oracle.ManagedDataAccess.dll 64-bit and my project is using .NET framework 4. The…
user2848442
  • 63
  • 1
  • 1
  • 3
6
votes
1 answer

Oracle.ManagedDataAccess Connection request timed out

I'm having trouble with threaded code which I'm using with the Oracle ManagedDataAccess.dll. To simulate the issue I have created a small test application that opens a connection, does a query and closes the connection. The thing that happens is…
Vincent
  • 61
  • 1
  • 1
  • 4
5
votes
1 answer

How to connect with ODP.NET Core to Oracle 9i database - Managed Driver

When i try to connect to Oracle 9i db, i get always ORA-1017 invalid username/password; logon denied. On Oracle 10g or higher all is well. ODP.NET Core: 2.18.3; ASP.NET Core: 2.1.403 ConnectionString: "Data…
gopek
  • 686
  • 7
  • 20
5
votes
2 answers

ODP.NET + Unexpected traffic on port 6200 (Oracle Notification Services)

We've got a client using our product, which includes a windows service built using .NET 4+, Entity Framework, and ODP.NET. For some reason in one particular installation, but not any other, the windows service appears to be generating traffic on…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
5
votes
2 answers

ODP.NET Managed ConnectionPool closes/opens every 3 minutes

We are using the latest Official ODP.NET Managed (Published: 2015-10-14 | Version: 12.1.2400) from Oracle to a Oracle 12 database (non RAC) configuration and we are unable to keep database connections alive for more than typically < 3 minutes. Our…
Jonny Bekkum
  • 93
  • 1
  • 6
5
votes
1 answer

How to use Dapper micro-ORM with Oracle to map NUMBER (OracleDecimal)

The ODP.NET provider raises an exception in IDataReader.GetValue()/GetValues() if the column type is NUMBER(x,y) such that it will overflow all .NET numeric types. So Dapper is unable to map such a column to a POCO property. I have an Oracle stored…
MC5
  • 293
  • 3
  • 11
1
2 3 4 5 6 7 8