Sitemap

Amicuk Programming Answers

APEX Listener with APEX 3.0 on 11gR2

2015-10-11   Views:4

Advertisement

Yes, I am crazy. We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set u

Yes, I am crazy.
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
Interested in pointers!
Rob

The replay answer
Advertisement
Hi Rob,
Yes, I am crazy.Why would that be? ;)
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.APEX 3.0 is supprted by EPG. See the [url http://docs.oracle.com/cd/B32472_01/doc/install.300/b32468/post_inst.htm#CHDBEJDA]APEX 3.0 Installation Guide for details.
APEX Listener is capable of hosting APEX 3.0 as well, though APEX 3.0 wasn't supported anymore when APEX Listener was initially released. The current APEX release at that time was 4.0, so this would be the first version to be known as really stable, whereas you won't get any support for older releases anymore. From personal experience I know that there are now issues with APEX 3.1 and APEX Listener, so it'll probably also work with 3.0.
Concerning your database release, the minimum for APEX Listener is 10.2.0.3, so you're definetly safe on that part, though I'd recommend to upgrade as regular support for 10.2 databases ended.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.This indicates that your APEX would actually be a 3.1 and you should update you images directory.
The APEX listener appears to be more than just a Java PL/SQL gateway.It is, but this has nothing to do with your 3.1 JS files, if this is why you stated this.
Is there a minimum version of APEX the APEX Listener supports?As mentioned above, 4.0 would be a safe approach, but 3.1 will definetly work, 3.0 probably will as well. I'd recommend you find out which APEX version is actually installed on your database before you consider any upgrade operations. Run the following query as privileged user:
SELECT comp_name, version, status
  FROM dba_registry
WHERE comp_id = 'APEX';-Udo

Go to See the other 3 answers

APEX Listener with APEX 3.0 on 11gR2

Category:DefaultRelease time:2015-10-11Views:130

Yes, I am crazy. We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set u[More]

How to access Apex environments that exist in multiple SID's on same Server

Category:DefaultRelease time:2015-10-11Views:130

HI, I've got a Linux Server which has 3 11gr2 Development instances (SID's), in each instance I'd like to setup Apex environment (I know Apex comes with the 11gr2 DB). How can I access a specific Apex environment (on one of the SID's) when all the da[More]

Report using LOV's

Category:DefaultRelease time:2015-10-11Views:130

Hi all again, I am building a report and need to have the LOV display not the value in the table. I am useing Apex 4.1 on 11Gr2 with the build in html server. I have a table I am reporting on the has several fields that are values in several LOV tabl[More]

Need help to show a thumbnail image column in report

Category:DefaultRelease time:2015-10-11Views:130

Hi, Gurus: I need to display a column of thumbnail images in a classical report. I follow the thread https://kr.forums.oracle.com/forums/thread.jspa?threadID=2201667 I am using APEX 4.1, Oracle 11gR2 Here is my table: CREATE TABLE "SORS"."S[More]

Hot
I am getting ready to blow away my iBook and do a fresh install of OS X. I use my iBook in a variety of different areas and have it setup on several WEP and WPA protected networks. Basically, I'd like to be able to backup my wireless configurations a [More]
Hello, We recently upgraded from ims5.2 to JES 2005Q4. With have patch -23 installed for UWC and patch -53 installed for the messaging server. Everything is going pretty well except we are having a problem with the mail filters in UWC. It seems that [More]
Dear Experts, I  have done the invoice in SRM and invoice created in ECC and the same invoice number has been updated in SRM with status 'posted in the backend'. for thi invoice, i have completed the payment. I would like to know whehter these status [More]
When you double-click the shortcut icon on the computer i tunes download it for 1 second and does not do anything after that. I've tried to open i tunes, the system administrator, but not any result. What can I do?gaah. i think you and your brother h [More]
My Safari has refused to open for quite sometime, but I've just now got around to fixing it. (I guess I'm getting used to Firefox.) Everytime I attempt to open it, the icon bounces on the dock and then says: "The application Safari quit unexpectedly. [More]
Hello all. Happy holidays. I have a bit of a problem that has been nagging me for a few days now. I just completed a twenty five minute I-Movie for my wife, and would like to surprise her with a DVD for Christmas. However, I cannot for the life of me [More]
I'm able to call a javascript using the below: img src="#IMAGE_PREFIX#add2.gif" border="0" alt="Icon 4" onClick="javascript:add_connect1('||CPORT.ID||')" But Now, I'd like to accomplish (2) New things: 1. instead of [More]
Hi there, I've had a major issue with my 160gb ipod classic from day 1. I've got a 140g music library on my PC and I've not been able to sync it to the ipod because of freezing and resetting problems.. until today. When I first tried to sync my whole [More]
I would like to know what other's system performance scores are (control panel/system/performance) on their W530s...specifically configured with : Intel Core i7-3720QM processor (6M Cache)   NVDIA Quadro K1000M Graphics with 2GB DDR Memory   8 GB DDR [More]
Hi Experts, I have created a quantity contract in VA41 and with that reference I am creating now a sales order. But while saving I am getting error "The Customer Requires Complete Delivery: Item XXXX has not been confirmedu201D Message number: V1293. [More]