Another surprise from Oracle - ORDS, SODA & JSON in the Database

For 6 months the APEX Listener page shows that Tomcat is the web server to go with Oracle APEX Listener, but as of today this is not anymore!
Is Tomcat Apache not an option to install the APEX listener? If so, why? (Is the $25,000 per CPU WebLogic affordable to any one!!!)
When we compared all the app servers the Tomcat was much much faster! Has this been taken into consideration or just as usual Oracle wants to keep everything proprietary?

Our technical deployment teams have just raised a similar question having downloaded the listener and reviewed the documentation. In the long term we are looking to reduce the Oracle licence overheads associated with our products, and using Tomcat with the APEX Listener would give take us a way down this road
Could one of the Oracle team comment on whether Tomcat support for the listener will be provided. Perhaps it's a documentation oversight?

I would like to second this request for clarification. We have been planning on the use of Tomcat with the Apex listener and if it is not supported, then it will delay several critical projects until an alternative is built and configured.
Is there anyone on the Oracle side that can comment on this?
Thanks in advance! 

Performance Test Outcome:
Oracle GlassFish 3.0:
20 seconds to load GlassFish homepage (index.jsf heavy content)
Tomcat Apache 6.0.24:
3 seconds to load Apache homepage (index.html low content)
Oracle Database SE1 11.2
Oracle APEX 4.0
Oracle Listener 1
JDK 6u20
Could please Oracle team confirm if our performance test has some accuracy. We need an answer from Oracle team on the Tomcat why has been removed and what benefits gained from GlassFish replacement.

We just finished testing applications on both Tomcat Apache 6.0.24 and Oracle GlassFish 3.0, the performance identical for applications.

I too am a bit miffed at the sudden exclusion of Tomcat from the list of supported application servers.
"Sun GlassFish Enterprise Server" is listed as one of the newly supported server. Does this support cover "GlassFish 3.0.1 Open Source Edition Web Profile"? I'm going to try to set that up now.
We don't want to license a server solely for running APEX. Surely it can run a free open source application servers... 

I've got APEX 4.0 up and running on "GlassFish 3.0.1 Open Source Edition Web Profile". Seems like a good app server. Nice administration page! 

John, What about performance?

For me, performance on glassfish are better then tomcat! 

Performance? Seems great. I never actually setup the APEX listener on Tomcat so I'm not comparing to that. I use Chrome to access my application and its all running smooth as you like. 

The APEX Listener is certified against Oracle WebLogic Server, Glassfish and OC4J only.
Using the APEX Listener with any of these Web Servers is "fully" supported which allows you to contact Oracle Support with any issues.
We did not certify other Web Servers (including Tomcat) as we would not be able to support issues that arise when it is specific to these external Web Servers.
The APEX Listener should run without issue on any J2EE Web Server, however, this is an unsupported configuration.
David Peake
Product Manager
Oracle Application Express 

This thread is a duplicate of this : Tomcat not supported by the Apex Listener?

Is GlassFish a free software?


No ORDS Support in Payara (Glassfish) ??

Greetings!After checking out a few REST and ORDS related sessions at Open World back in October, we decided here at our shop to try a move to toward restful API's aswe begin to re-engineer our Java EE apps that were built back in the early to mid 2000's.  We've got everything installed, we've got a game plan for a couple of our behemoth sized apps.But then in the ORDS 17.4.1 readme file we see the following: "Deprecation of Glassfish SupportWhile 17.4 continues to support Glassfish (4.1.2 and later), support for Glassfish will be removed in a future release. Use of Oracle WebLogic , ORDS Standalone Mode or Apache Tomcat is recommended instead."Does anyone know if this is still the plan by Oracle going forward?   Payara / formerly Glassfish is a primary platform for us.  Ugh.  I suppose we could put a Tomcat instance in the middle? Thanks,-Doug

ORDS upgrade from V2.0 to V18.2 without impacting JDK version on Weblogic server

Hi, We are currently using LINUX servers on which Oracle EBS Application is deployed. The current version of Java on server is JDK 1.6. But to upgrade our ORDS the version needed is JDK 8.We cannot upgrade JDK on server because of many constraints/dependencies it has. When we raised an Oracle SR, they suggested to use a stand alone version of ORDS. Please suggest a better approach to handle this situation. Is there any disadvantages of using standalone version. Just note we have integrated ORDS to APEX on weblogic sever. RegardsVivek
ORDS does not need WebLogic. But ORDS standalone will give you a Jetty web server, with not very much in terms of web server management features. You can do some things with configuring Jetty, but it's via XML flags in the ORDS config. MOST of our users end up with ORDS running with Tomcat - which is very lightweight and also free. 
Is it not possible to have both JDKs installed?  Let ORDS use the JDK 8 home and any of the other dependencies use the JDK 6 home.
Thank you for the response.  We are a bit concerned with using the stand alone ORDS and the limitations it might have. I believe you have rightly pointed some of them. Even using Tomcat I believe we still need to upgrade our JDK to 8 on the server which is of concern right now. Just to add we already have ORDS version 2 on weblogic which we are trying to upgrade.
Thank you for the suggestion. This is one of the options we are exploring. The moment we upgrade to JDK 8, it will be part of the default path and all application might try using the same. It is my understanding that I need to change JAVA home manually in each of the application. Since there are many applications running fine and pointed JDK 6, this is being considered as a risk right now. Can you please suggest an easy way of doing this. Like we install JDK 8 and ensure ORDS uses this JAVA home, but none of the other application should point to this. RegardsVivek
You can actually have multiple versions of Java on a linux machine. Your "softlinks" just need to point to the "most used one".  This is done by root at the command prompt. See:  Additionally, you'll need to modify the TomCat startup scripts to ensure JAVA_HOME is set to the Java 8 location. My $0.02 MK PS - to change your screen nickname:Video tutorial how to change nickname available

After upgrading APEX to 4.1 the application 4950 is not working anymore

After installing an Oracle Database 11g XE Beta on a Ubuntu 11.04 x64 server the application web page was accessible as it should.
Then I upgraded the apex application to 4.1 following (hopefully) all upgrading steps, and the APEX 4.1 is working just fine; but the is giving me an Error ERR-1014 Application not found, application 4950 workspace=10 (and also is asking me to log in, but I have seen that if I am using a stupid page is asking me always for it).
Just as a note, after the upgrade I have dropped the old User APEX_040000 as mentioned in the installation guide. Most probably the application 4950 was installed only on the old user, not migrated to the new one.
Is it any way to put back this 4950 application on apex 4.1? I have another oracle 11g xe beta instance available, with the original apex version, but I don't know how to do the application migration from one apex version to 4.1.
Thank you 
application 4950 is part of 11.2 XE, not part of APEX 4.0, so you don't have it on any other database running APEX 4.0. (Well, unless someone used a hack to export this application from 11.2 XE and imported it there). If you install a standard APEX instead of the one that shipped with XE, you'll lose all XE-specific extensions. This has been the same with the management application provided with 10.2 XE - if you installed for instance APEX 4.0 as upgrade or fresh install on top of this release, you had "just" a standard APEX.
Of course you could ask why this application isn't migrated like user applications. As far as I know, no "system" application (area 4000+) is migrated. For the internal applications is obvious - they get updated and hence reinstalled. This XE management application is, as I said before, not part of APEX, so it is not maintained by the people who develop APEX. If they would just migrate it to a new APEX release, it's likely it would either not work or possibly mess up your system, as at least the APEX internal parts will probably have changed enough to make adjustments necessary. Of course you could claim you'd like the XE development team to support other APEX versions as well. But that's the point in XE: There is no support, no updates, whatsoever. The possibility to upgrade APEX at all is the big exception, but it somehow also proves the rule.
Thank you for your answer, I was afraid of that, I saw that when I have upgraded 10g XE to APEX 4. But I hoped that this time, on 11g XE, the things has been changed.
There is still a chance in the final version of 11g XE to have the latest APEX 4.1 included. Anyhow, this is not an issue as the APEX database application is not as useful as the administration web page of Oracle 11.2 database (full version), but it was nice to have it.

Oracle APEX Listener, Weblogic and IE 6

Hi All,
I am currently in the process of planning a move from Oracle HTTP Server 10g to Weblogic 11gR2 on a customer site where we are constrained by Internet Explorer 6 as the only available browser. I understand that we can deploy the Apex Listener to Weblogic but the documentation states that this only supports Internet Explorer 8. My question is has anyone tried using this with Internet Explorer 6. Even if it does work I guess it would be an unsupported option ? Are there any supported alternatives ? FYI we are using APEX 3.2 with no current scope to upgrade.
Thanks in advance !
You can use IE 6. APEX Listener does not support it officially, but you'll be able to use the configuration pages, though they won't look as intended as IE 6 doesn't support all CSS methods (and probably other stuff) used.
Concerning APEX itself, it makes no difference which web server you use - there are some limitations with IE 6, but these are the same for OHS and APEX Listener.

OBIEE-OC4J and Apex Listener

RDBMS: Oracle EE
We read that you can install Oracle Application Express Listener with Oracle Containers for J2EE (OC4J).
In our environment there is OBIEE with a version of OC4J (
We would like to understand if we could use the OC4J that comes from OBIEE in order to install Oracle Application Express Listener.
Hello A.C.,
it is possible to deploy APEX Listener onto OC4J. Though yours is quite outdated it should work, but might not be supported any longer. Are you sure you still have support for that scenario?
At least the default Java version for that environment will not meet the requirements (JDK 1.6 Update 20 or higher). I'm not sure all components on your OBIEE will work with a recent JDK properly, nor that it is certified for that JDK. If you don't want to put risks and/or efforts on your OBIEE environment, I'd recommend to setup a JEE container outside of your "embedded" OC4J.