APEX

Hi all,

I am in need of some guidance as I do not have a DB Admin. I needed to setup a TEST envoirnment to test migration from Oracle Database 11g Standard Edition to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0. For this purpose I installed RHEL6 and then Oracle Database 11g Enterprise Edition, finally I recovered backup of my production server RMAN to this TEST server and upgraded to Enterprise Edition DB.

Our users access the DB on LIVE server through an ORACLE APEX 3.2 Application, the same was imported when I recovered the RMAN Backup on to the TEST server, after setting up LSNRCTL files the application was up and running and was working fine. The next task was to upgrade APEX 3.2 to APEX 4.2, I followed the installation steps provided in the documentation with the standard switches:

Full development environment. Run apexins.sql passing the following four arguments in the order shown:

@apexins SYSAUX SYSAUX TEMP /i/

I monitored the installation process onscreen as best as I could and the installation was fine, however I am unable to locate any logs. Moving on, I used the following to further test the installation:

You can verify the validity of an Oracle Application Express installation by running the following query:

SELECT STATUS FROM DBA_REGISTRY
WHERE COMP_ID = 'APEX';

SQL> SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

STATUS
-----------
VALID

Finally, I restarted the DB and LSNRCTL, everything works great from SQL prompt, the DB is working fine, TNSPING and TRCROUTE work fine. However, herein begins my problem as I am getting a blank page at:

http://127.0.0.1:8080/apex/
http://127.0.0.1:8080/apex_admin requests a username and password but failed to accept Admin u/s & pass with the following "A username and password are being requested by http://127.0.0.1:8080. The site says: "XDB""

My application ID is 110 so the page at:

http://127.0.0.1:8080/apex/f?p=110 gives me a login page but neither does it log me in nor does it interact as if broken somewhere. And the page is all out of proportion as well. I searched for 2 days for a solution and have played as much as I can with:

@apxldimg.sql /mypath & (have done it with success a few times but without resolution of the blank page and non working page)

I have gotten absolutely nowhere. But as http://127.0.0.1:8080/apex is leading me to a blank page at address http://127.0.0.1:8080/apex/f?p=4550:1:13790940594234 I am assuming that the application works fine but something is either wrong with the images or linkages somewhere.

Support would be highly appriciated.

Thanks & Regards.