Sunday, 14 January 2018

Oracle APEX 5.1.4 and ORDS 17.4 upgrade

Oracle APEX 5.1.4 and ORDS 17.4 upgrade

 

Weblogic 10.3.6 and ORDS 17.4


Webserver and ORDS JAVA compatibility issue


This popped out during our ORACLE APEX 5.1.4 upgrade

We were running WebLogic 10.3.6 and Oracle APEX 5.1.2 doing upgrade to latest version of ORDS and APEX (ORDS 17.4 and APEX 5.1.4)

APEX upgrade as such was smooth but on ORDS restart we got an error:



Problem was in JAVA version that was running on our WebLogic Server -> JAVA version 7(
jdk1.7.0_25) was not supported by ORDS.


More info here

Solutions available:
- Downgrade to use ORDS 17.3
- Upgrade your WebLogic with JDK 1.8
- Upgrade your WebLogic to 12c

We decided (for now) to go with ORDS 17.3 and APEX was up and running again.



Happy APEXing,
Lino

5 comments:

  1. Hi!
    Would You share a reasons from Your viewpoint (if any) to migrate from ORDS 3.0.12/Tomcat 9/Java 8 to ORDS 17.3/Tomcat 9/Java 8

    Thank You.

    ReplyDelete
  2. Hi Sasha, :)

    thanks for your comment.

    if you need a reason why to upgrade your ORDS have a look at http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/ords-relnotes-173-3873542.html

    My two favorites improvements are:
    - REST enabled SQL and Maximum Open Cursors Exceeded when using Application Express 4.2

    But these are definitely not something you have to do at your end.

    Aim of my post is to warn people doing the upgrades who are running WebLogic 10.3.6 that will hit that Java incompatibility issue with ORDS 17.4 upgrade hence we opted for 17.3 version.

    We could have also opted to stay with ORDS 3.0.10 that we were on before the upgrade.

    Also notice that you mentioned 10.0.12 that seems to be the same as 17.3 (new Oracle naming change Year.Quarter.PointVersion) so you would go from 10.0.12 to latest 17.4/Tomcat 9/Java 8 if you wanted.

    Hope this helps


    ReplyDelete
  3. Perfect answer. I do appreciate You.

    ReplyDelete
  4. Hi,

    Is there any document for upgrade from Apex 4.2 to 5.1 on Weblogic.

    Regards,
    Rama

    ReplyDelete
  5. i have a oracle ebs 12.2.9 using weblogic 10.3.6 and need ords 17.3 to run apex. where can i find this download. Tried all day and cant find the zip file. its like its been wiped clean. I am using oracle vm instance for a sandbox environment to learn ebs and apex development. Maybe you can share the zip file or any help would be great.
    thanks

    ReplyDelete