Compatibility Error with Oracle 12c

Posts   
 
    
msantana
User
Posts: 14
Joined: 09-Jul-2013
# Posted on: 11-Dec-2013 14:46:01   

Team:

I'm currently attempting to upgrade an ASP.NET Web Forms application to Oracle 12c hosted on a Windows 2012 Server ( IIS8 ) just for the sake of lab testing and compatibility verification. When I make a complete First-Time Installation (which does not causes problems in Oracle 11gR2), the following error is displayed when I launch the application:

Server Error in '/ISOtrain' Application.
--------------------------------------------------------------------------------


ORA-03134: Connections to this server version are no longer supported.

  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

 Exception Details: System.Data.OracleClient.OracleException: ORA-03134: Connections to this server version are no longer supported.


Source Error: 


 An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 



[OracleException (0x80131938): ORA-03134: Connections to this server version are no longer supported.
]
   ISOtrainDAL.GenericDB.HelperClasses.LogItem.WriteLog(String strActivity, String strAction, String strMessage, String strSourcePage, LogType LogType) +1221
   ISOtrainDAL.GenericDB.EntityClasses.MyNewsEventEntity.GetNews() +1093

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +229
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +193
   System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +1293
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1986
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +28
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +313
   System.Web.UI.WebControls.ListView.PerformSelect() +124
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +146
   System.Web.UI.WebControls.ListView.CreateChildControls() +80
   System.Web.UI.Control.EnsureChildControls() +189
   System.Web.UI.Control.PreRenderRecursiveInternal() +60
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4297




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18056 

As you can see, the first methods called within the exception are a Helper Class and Entity Class method from LLBLGen and I'm afraid that the issue is with the OR Mapper. For this application, we use LLBLGen Pro version 2.6 and for the moment (since it is a validated application) we cannot upgrade to a further version. Is this LLBLGen version compatible with Oracle 12c?

Thanks for your help as always.

Marcos Santana

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 11-Dec-2013 21:37:23   

A basic question: can you connect too the Oracle Server using vanilla ADO.NET?

msantana
User
Posts: 14
Joined: 09-Jul-2013
# Posted on: 11-Dec-2013 22:56:02   

Hi, thanks for the response.

I am hosting the database and the application on the same Win2012 box. I can connect to it and manage it from a remote computer using Toad, SQL Developer or any other database management tool. I have not used Vanilla DAL before and I don't have access to the source code so that will prove to be a little bit difficult. Can you provide some light on your question or does my answer helps?

Thanks!

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 12-Dec-2013 06:55:08   

Also, AFAIK, connection to 12c is only supported on v4.1 LLBLGen drivers. See http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=22294

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39859
Joined: 17-Aug-2003
# Posted on: 12-Dec-2013 10:18:41   

Additionally, the error given is NOT from us, as it's an Oracle Error: ORA-03134: Connections to this server version are no longer supported.

namely ORA-03134. So either client related or db related, but not our code.

Frans Bouma | Lead developer LLBLGen Pro
msantana
User
Posts: 14
Joined: 09-Jul-2013
# Posted on: 12-Dec-2013 15:03:16   

Team:

Thanks for your help. The problems seems to be with IIS 8. I tried to connect to an Oracle 11g database and the same error was displayed. I used and IIS7.5 deployment and the application works as expected. Therefore, there are no compatibility issues so far with Oracle 12c using LLBLGen Pro 2.6.

I'm still trying to figure out what other settings need to be established on the IIS 8 (windows 2012) server so that this works. I installed the latest ODAC.NET installer and still does not work, but at least this proves that LLBLGen is not the problem.

Thank you guys so much!

Best Regards, Marcos Santana