Moving to the ODP.NET forum to get a wider audience.
Is this issue resolved?
We are facing the same issue in our applications we just moved to 12c ODAC Release 3
Applications that were working fine with 11g ODAC are failing now with below exception.
"exception: ORA-02048: attempt to begin distributed transaction without logging on"
Which data provider are you using? If ODP.NET, is this with managed or unmanaged ODP.NET?
Not sure if this is the same issue but I can reliably produce an ORA-02048 with the current ODP.NET managed driver (22.214.171.124) and the simplest possible setup:
using( var ts = new TransactionScope() )
using( var conn = new OracleConnection() )
conn.ConnectionString = "Data Source=//host/svc;persist security info=true;user id=usr;password=pwd;enlist=true;";
conn.Open(); // ORA-02048 thrown here
When connecting to 10g (10.2.0.3.0) an exception is always thrown at the line above, however 11g (126.96.36.199.0) works just fine.
If I add "promotable transaction=local" then the connection works but since this completely disables distributed transactions it's only a partial workaround.
My team has been able to reproduce this problem with DB 10.2.0.3, but not with DB 10.2.0.5. If it's possible, I would recommend using 10.2.0.5 if you need an immediate solution.
This issue was resolved after upgrading to Oracle 11g R2. It is a known issue in Oracle 10g.
the same issue to me in Oracle 10.@10.2.4. is there another way to resolve this issue except update database ?