109 questions
2
votes
0
answers
150
views
Visual Studio 2019 "Add Connection" window crashes when trying to add Oracle Database Connection into Server Explorer > Data Connections
I am trying to add Oracle database into Visual Studio 2019 Professional > Server Explorer.
I am able to get to the Add Connection Window after choosing Oracle Database ODP.NET, Managed Driver, ...
- 51
0
votes
0
answers
212
views
Why calling the Oracle from ODP.Net decrease the throughput of my asp.net webapi core by 1525%?
I am doing some research in order to increase the performance of my asp.net webapi core (5.0) when working with an oracle (12g) database.
I have made two endpoints for tests purpose in this API :
Raw ...
- 573
0
votes
0
answers
334
views
Transaction error when connecting to Oracle 19c with Oracle.ManagedDataAccess
When connecting to some databases, I get the following error message when opening a connection.
The caller is a TransactionScope.
From the app:
MTSRMManager.CCPEnlistDistributedTxnToSysTxn(...
- 540
0
votes
0
answers
257
views
Where does ODP.net (managed) create the windows event log message?
Oracle Docs Claim that ODP.net creates a windows event log containing the location of the trace.
ODP.NET will create an entry in the Windows event log where the trace was created anytime it creates a ...
- 4,500
0
votes
1
answer
507
views
Inserting in Oracle DB from vb.net application retuning value
I'm continue to learn using Oracle... and it's not so easy...
I want make a insert with parameter and return a value
Public Function InsertMapping(GeneralDatas As List(Of String)) As Decimal
Dim ...
0
votes
1
answer
945
views
Oracle Managed Data Access Seems to Ignore Port When Using Alias
I am getting the following error
ExceptionMessage: "ORA-12541: TNS: No listener"
ExceptionType: "Oracle.ManagedDataAccess.Client.OracleException"
InnerException: {Message: "An ...
- 1
1
vote
0
answers
722
views
Oracle.ManagedDataAccess.Client cannot connect using Windows authentication
We are unable to connect to Oracle 19c using Oracle.ManagedDataAccess.Client and windows authentication. Regular .NET 4.0 apps are able to connect but .NET Core apps are not able to connect (both are ...
- 121
1
vote
1
answer
1k
views
"ODP.NET, Managed Driver" is failing with System.Data.Common.DbProviderFactories.GetFactory. But "raw" works
Gaaaa. Oracle and DotNet Framework code.
I am trying to factory-create a "ODP.NET, Managed Driver"
I am getting
Unable to find the requested .Net Framework Data Provider. It may not be ...
- 28.2k
0
votes
0
answers
386
views
Is it possible to cast Oracle User Defined Types (UDT) as byte[]/blob in ODP.NET?
Our .NET application uses ODP.NET with SDO_GEOMETRY which is a UDT for spatial functionality.
Currently only the Oracle Unmanaged Driver supports UDT for use in ODP.NET.
Although it looks like UDT ...
- 2,507
0
votes
0
answers
284
views
OracleDataReader not being iterated despite having rows
I'm using Oracle.ManagedDataAccess 19.6.0 to get some data from Oracle 11g 11.2.0.3.0
This code was working fine until yesterday. 223 rows are getting returned by Oracle. But the while (...
- 4,260
1
vote
0
answers
2k
views
Oracle.ManagedDataAccess.Client.OracleException: ORA-01017: invalid username/password; logon denied
I'm experiencing an issue by using ODP.NET version 19.3 (latest Oracle Managed DataAccess available) to connect to Oracle 11g using a Secure External Password Store (SEPS), where the Oracle login ...
- 2,957
4
votes
0
answers
2k
views
ASP.NET won't connect to Oracle via SSL, console app will. What's different?
I am trying to connect to a client's Oracle database over SSL using the managed ODP.NET provider. The client has provided a self-signed certificate which I have imported on the server. To test the ...
- 741
3
votes
1
answer
3k
views
Scaffolding an Oracle database with EF Core failing with logon denied error
I am trying to scaffold some classes from an Oracle database for use with a .NET Core Web API. I have installed the following nuget packages:
Oracle.EntityFrameworkCore - v2.18.0-beta3
Oracle....
- 1,941
1
vote
1
answer
418
views
ora-01017 with ODP.net and NTS as sysdba
I'm having trouble connecting to my oracle databases with NTS and ODP as sysdba (the goal is to use a lot of maintenance scripts without any passwords in it). I did some research without success, so ...
5
votes
1
answer
2k
views
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
...
- 696
0
votes
1
answer
495
views
Issue with executing stored procedure with an OUT refcursor when using ODP.Net managed with Enterprise library
I am trying to execute multiple (3) stored procedures one by one using managed ODP.Net with Enterprise Library. Each stored procedure returns an OUT cursor, each of which has been named "cur_out". ...
- 11
4
votes
2
answers
5k
views
ODP.NET Managed Trace File
I'm having an issue attempting to generate a trace file for an application.
Attempting to troubleshoot an Oracle problem, but the trace file isn't being written. This is my app.config which gets ...
- 7,545
5
votes
4
answers
19k
views
Connection to Oracle using Oracle.ManagedDataAccess exception
I'm using the Oracle.ManagedDataAccess Nuget Package Version 12.2.1100 in my C# (>.NET 4.0) project. Everything works ok in my localhost but on the dev server I'm hit with this exception:
Exception ...
- 531
1
vote
2
answers
432
views
Reduce PARSE_CALLS using Oracle ODP.NET (or reuse cursors)
When I run Queries from ODP.NET I see in V$SQL that for every call it performs a PARSE_CALL.
See:
select
s.FETCHES,s.PARSE_CALLS,s.sql_Text,s.sql_id
from v$sql s where
sql_Text = 'select 1 ...
- 5,441
6
votes
2
answers
4k
views
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 ...
- 5,791
1
vote
0
answers
512
views
ODP.NET not picking up on .net alias
I'm working on a new mvc web app and I'm trying to configure a connection to an oracle database. I've installed Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework packages. I've ...
- 823
2
votes
0
answers
435
views
Oracle stored procedure fails when called from ODP.NET
I've got a fairly large and complex Oracle stored procedure (~2200 lines) which I'm able to call successfully from SQL Developer, and executes in 2-3 seconds, using the following:
var o_my_data ...
- 14.4k
0
votes
1
answer
2k
views
Oracle Stored procedure return cursor slow to C#, fast on TOAD
We are using asp.net mvc as web application and oracle 12C as database, 'Oracle.DataAccess.Client'(12.1.0, 64 bit version) for connecting to Oracle Database, and our asp.net MVC application runs on 64 ...
- 147
4
votes
3
answers
922
views
Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors
Our application uses managed ODP.NET code to call a variety of Oracle Procedures.
For one of our clients, who is using public database links, and referencing the linked tables within the procedure,...
- 5,791
0
votes
1
answer
1k
views
How to add configuration options to ODP.Net Managed Driver in Powershell
Using Oracle Managed Data Provider ODP.NET from Powershell works great. However, how to add application specific configuration settings is not quite clear.
How can this be done?
- 458