OTN Discussion Forums : upgrade problem to APEX 3 ...

adam_

Posts: 188
Registered: 06/29/07

upgrade problem to APEX 3
Posted: Jul 18, 2007 3:35 PM

Hi

I have upgrade oracle 10g XE to APEX 3.

The only problem I am getting is that some images arent displaying in APEX.

An example would be when I look at "Shared Components" then page is missing all the images. If I try and one of the images in a new browser window I get an error like this:

The requested URL /i/menu/blank_app_64.gif was not found on this server.

Also this image isnt found http://localhost:8080/i/htmldb/builder/schema_compare_ctrl.gif
But this one is: http://localhost:8080/i/htmldb/builder/dw_exp_imp_ctrl.gif

It looks like it hasnt copied the new images over or hasnt update the links properly.

I used this to install

@apexins password SYSAUX SYSAUX TEMP /i/
@apxldimg.sql APEX_HOME
@apxxepwd.sql password

Dont know if this has any relevance but I couldnt use:

@APEX_HOME/apex/apxldimg.sql APEX_HOME
@APEX_HOME/apex/apxxepwd.sql password

Seams it doesnt know what APEX_HOME is.

This is also making the applications look strange as images are missing.

Anyone have an idea of what I've done wrong?

Regards
Adam

TomF

Posts: 451
Registered: 04/05/06

Re: upgrade problem to APEX 3
Posted: Jul 18, 2007 3:53 PM

in response to: adam_

Reply

Rerun the command:

@APEX_HOME/apex/apxldimg.sql APEX_HOME

substituting APEX_HOME for wherever you extracted the Apex 3.0.1 zip file. If you extracted it to c:\apextmp or /apextmp in Unix then run

@C:\apextmp\apex\apxldimg.sql c:\apextmp

or

@/apextmp/apex/apxldimg.sql /apextmp

adam_

Posts: 188
Registered: 06/29/07

Re: upgrade problem to APEX 3
Posted: Jul 18, 2007 4:16 PM

in response to: TomF

Reply

Rerun the command:

@APEX_HOME/apex/apxldimg.sql APEX_HOME

substituting APEX_HOME for wherever you extracted the
Apex 3.0.1 zip file. If you extracted it to
c:\apextmp or /apextmp in Unix then run

@C:\apextmp\apex\apxldimg.sql c:\apextmp

or

@/apextmp/apex/apxldimg.sql /apextmp

Hi

Thank you that fixed it.

Simple now that I think of it; my own fault for testing oracle upgrades late at night.

Going to do this upgrade tomorrow on our live system, now I've upgrade successfully

Regards
Adam

ahmad8

Posts: 21
Registered: 12/14/99

Re: upgrade problem to APEX 3
Posted: Oct 10, 2007 9:33 PM

in response to: adam_

Reply

Hello,

I had the same issue and the solution provided have fixed it

Thank you Adam and Tom

user535976

Posts: 1
Registered: 10/11/06

Re: upgrade problem to APEX 3
Posted: Nov 18, 2007 10:30 PM

in response to: adam_

Reply

Hi,

I have upgrade oracle 10g XE to APEX 3.

I used this to install:

@apexins password SYSAUX SYSAUX TEMP /i/
@apxldimg.sql APEX_HOME
@apxxepwd.sql password

Everything finished successful, but http://localhost:8080/apex/apex_admin dosn't works

Message was edited by:
user535976

anakin_s

Posts: 91
Registered: 07/09/99

Re: upgrade problem to APEX 3
Posted: Feb 23, 2008 6:49 AM

in response to: user535976

Reply

NOTE: I had to put the directory directly above my apex unzip for this to work or else it would fail.
Example: unzipped Apex 3 to /home/oracle/stage/apex

Ran:
SQL> @apxldimg.sql /home/oracle/stage/apex

PL/SQL procedure successfully completed.

old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/home/oracle/stage/apex/apex/images'

Directory created.

declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 287
ORA-06512: at line 15

Solution was to put that APEX_HOME up one dir:

SQL> @apxldimg.sql /home/oracle/stage

PL/SQL procedure successfully completed.

old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/home/oracle/stage/apex/images'

Directory created.

PL/SQL procedure successfully completed.

Commit complete.

timing for: Load Images
Elapsed: 00:01:21.88

Directory dropped.

Suri

Posts: 17
Registered: 02/13/08

Re: upgrade problem to APEX 3
Posted: Feb 24, 2008 9:13 AM

in response to: adam_

Reply

Hi! I also have upgrade Apex to 3.0.1 and I used this
(with my APEX_HOME):

@APEX_HOME/apex/apxldimg.sql APEX_HOME
@APEX_HOME/apex/apxxepwd.sql password

but some images still aren`t dysplaying?!
What should I do to correct this&

user565660

Posts: 4
Registered: 03/22/07

Re: upgrade problem to APEX 3
Posted: Feb 24, 2008 3:18 PM

in response to: Suri

Reply

Hi,

Have a look at the following document that demonstrates an upgrade:
Apex 3.0 Upgrade

Suri

Posts: 17
Registered: 02/13/08

Re: upgrade problem to APEX 3
Posted: Feb 25, 2008 9:46 AM

in response to: user565660

Reply

Thank you for your response, but scripts returned errors, so I solve my problem copying images from APEX_HOME to http://127.0.0.1:8080/i/

user3511889

Posts: 1
Registered: 04/02/09

Re: upgrade problem to APEX 3
Posted: Apr 2, 2009 8:35 AM

in response to: anakin_s

Reply

Thank you! This one finally solved mine

user4468516

Posts: 1
Registered: 04/29/09

Re: upgrade problem to APEX 3
Posted: Apr 29, 2009 7:47 AM

in response to: TomF

Reply

I have also problems upgrading to APEX 3.2. I tried apxconf and apexins.sql but my Application Express still remains at version 3.0.
When I try to run apxldimg.sql it messes up the Application Express the fonts on the login screen are huge and I can't log in any more. I wish there was a easier way to upgrade, or did Oracle make it so very cryptict to annoy people. What a shame and I even have a degree in Computer Systems...

armeck

Posts: 46
Registered: 09/26/06

Re: upgrade problem to APEX 3
Posted: May 29, 2009 10:20 AM

in response to: anakin_s

Reply

I am encountering this problem and have done the steps here to make sure the path is correct. I still have no success. Is there something to these errors that I am receiving?

PL/SQL procedure successfully completed.

old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/home/armeck/apex/images'

Directory created.

declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
Permission denied
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 287
ORA-06512: at line 15

PL/SQL procedure successfully completed.

Commit complete.

timing for: Load Images
Elapsed: 00:00:00.29

Directory dropped.

user10282895

Posts: 1
Registered: 01/20/10

Re: upgrade problem to APEX 3
Posted: Jan 20, 2010 8:06 AM

in response to: ahmad8

Reply

I had the same problems as well & this worked like a charm. Thanks!!

user457403

Posts: 4
Registered: 10/15/05

Re: upgrade problem to APEX 3
Posted: Feb 5, 2010 11:14 PM

in response to: user10282895

Reply

What's wrong with this one? Followed all the comments and ideas on the web. It seems it is the path and the use of "/" as against "\"

See error below:
SQL> @apxldimg.sql c:\apex321\apex

PL/SQL procedure successfully completed.

old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as 'c:\apex321\apex/apex/images'

Directory created.

declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
The system cannot find the path specified.
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 287
ORA-06512: at line 15