We are encountering a strange issue at work. For years we had a .NET Framework Windows service running with the Unmanaged Oracle Client (10.1.3001) with no problems at all. Recently, we decided to upgrade that service and decided to use the latest Oracle Managed DataAccess (21.10.0 - https://www.nuget.org/packages/Oracle.ManagedDataAccess/21.10.0#versions-body-tab) . We faced no problems with this migration so far, except from an issue with a procedure that uses a PARALLEL hint and accesses a remote table via a DB Link. This Oracle exception is thrown: ORA-12840: cannot access a remote table after parallel/insert direct load txn We have solved that problem by inserting some commit statements in the procedure, but we can't understand why the Driver change caused that behavior. Any ideas ?

Does Visual Studio 2017 Community (.NET Framework 4.6.2) support Oracle 8i? I am trying to connect with .NET Framework 4.6.2 to a production Oracle 8i database. I googled it, but I can not find anything which is related to this topic. I checked also this site but that is for Windows 2008 R2. I tried Oracle 19 and Oracle 18 and it works. But I can't find what the oldest version is that is still compatible with .NET Framework (like Oracle 8 or Oracle 9) . I tried to connect using ODP.NET Managed Driver but it was unsuccessful. I am an Oracle Developer and Web Developer for the organisation. I have been given the task to test it if it's possible to connect on our (TEST) database which is Oracle 8i (I believe). Our main database is Oracle 10, but this data is restricted and I cannot manipulate it. This part is for our DBA.

Good evening everybody, I am planing to dive into the oracle database world. Additionally, I want to develop some tools, which make my life easy by checking and modifying information in different tables. Since I would develop the tools in C#, I found the Oracle Data Provider for .NET Managed Driver, which seems to be really nice. Before using it, I have some questions: - Is it free to use? Regarding to the license (http://www.oracle.com/technetwork/licenses/distribution-license-152002.html) , I should be able to use the managed driver. Or do I interpret it in a wrong way? For me it is not clear, if I could also use my tools at customer side? Or could I give the tool to some customer to help him or does it lead to a license problem already? What about selling the tool? For me it is hard to interpret the answers from the license text. I hope you can help me. Best regards Seth

I installed oracle client 11.2.0 version in my machine and also installed Oracle data access providers for visual studio.I also installed Oracle Data Access 11.2.0.3.20. I am trying to connect to the database through the visual studio i am getting the below exception ORA -12504 : TNS: listner was not given the SERVICE_NAME in CONNECT_DATA** The tnsnames.ora file contains the folloing code creds= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = aaa.cedd.net)(PORT = 1521)) ) (CONNECT_DATA = (SID = creds) ) )

We have a .net application that suddenly started hanging. The log indicates the error is an unhandled user-defined exception and gives a line number. We can't find any error in the function, yet it hangs indefinitely. We have had to kill the process in the past but we don't think we killed this one. Trace log shows: errors in file /u01/app/oracle/diag/rdbms/ccccc/ccccc/trace/prdccccc_ora_22685.trc (incident=52744): ORA-00603: ORACLE server session terminated by fatal error ORA-24557: error 6510 encountered while handling error 28; exiting server process ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUNCTIONNAME", line 13 ORA-06512: at line 1 ORA-00028: your session has been killed Incident details in: /u01/app/oracle/diag/rdbms/ccccc/ccccc/incident/incdir_52744/prdccccc_ora_22685_i52744.trc Fri Oct 14 17:30:41 2016 Dumping diagnostic data in directory=[cdmp_20161014173041], requested by (instance=1, osid=22685), summary=[incident=52744]. Fri Oct 14 17:30:41 2016 opiodr aborting process unknown ospid (22685) as a result of ORA-603 Fri Oct 14 17:30:41 2016 Sweep [inc]: completed Sweep [inc2]: completed Fri Oct 14 17:43:05 2016 Memory Notification: Library Cache Object loaded into SGA Heap size 51200K exceeds notification threshold (51200K) Details in trace file /u01/app/oracle/diag/rdbms/ccccc/ccccc/trace/prdcrccf_ora_27648.trc Fri Oct 14 17:43:05 2016 KGL object name :2387355888921555146 DEFAULT This is the function containing the "error" CREATE OR REPLACE FUNCTION fnGetCarriersForGroup(pGroupID IN INTEGER DEFAULT NULL) RETURN IDsTable PIPELINED AS lRow IDs; CURSOR cCarriers IS SELECT * FROM vwCarrierGroups START WITH ID=NVL(pGroupID,0) CONNECT BY NOCYCLE PRIOR ID = ParentID; BEGIN lRow := IDs(NULL, NULL, NULL, NULL); FOR cRow IN cCarriers LOOP IF (cRow.EntityID IS NOT NULL) THEN lRow.ID := cRow.ID; lRow.GroupName := cRow.GroupName; lRow.EntityID := cRow.EntityID; lRow.ParentID := cRow.ParentID; PIPE ROW(lRow); END IF; END LOOP; RETURN; END;

The latest Oracle patch: http://www.oracle.com/technetwork/security-advisory/cpujul2017-3236622.html has been installed on the server running version 12.1.0.2.0. We have .Net applications running directly on the same machine which uses the Oracle.DataAccess.dll which was at version 2.121.2.0 but the patch seems to have upgraded this to version 2.121.2.0 RELEASE 4 like so: and now we get which appears to be a generic error: > Data provider internal error(-3000) [System.String] > OracleException (0x80004005): Data provider internal error(-3000) [System.String]] Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable) +1909 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) +53 Oracle.DataAccess.Client.OracleConnection.Open() +5393 NHibernate.Connection.DriverConnectionProvider.GetConnection() +134 NHibernate.Impl.SessionFactoryImpl.OpenConnection() +65 Any ideas where I can even start to look? I am suspecting version mismatch but I can't understand why that would happen.

I need to know which component is under each installation type! - Instant Client - Administrator - Runtime - Custom (No need as it shows all the components) ALSO? does it includes **ODP.NET**? is it the component > Oracle Data Provider for NET if not then I need to have to install (ODAC 112040 Xcopy) after!