Thread: upgrade problem to APEX 3


Permlink Replies: 13 - Pages: 1 - Last Post: Feb 5, 2010 11:14 PM Last Post By: user457403
adam_

Posts: 188
Registered: 06/29/07
upgrade problem to APEX 3
Posted: Jul 18, 2007 3:35 PM
Click to report abuse...   Click to reply to this thread Reply
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_ in response to: adam_
Click to report abuse...   Click to reply to this thread 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 in response to: TomF
Click to report abuse...   Click to reply to this thread 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_ in response to: adam_
Click to report abuse...   Click to reply to this thread 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_ in response to: adam_
Click to report abuse...   Click to reply to this thread 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 in response to: user535976
Click to report abuse...   Click to reply to this thread 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_ in response to: adam_
Click to report abuse...   Click to reply to this thread 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 in response to: Suri
Click to report abuse...   Click to reply to this thread 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 in response to: user565660
Click to report abuse...   Click to reply to this thread 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 in response to: anakin_s
Click to report abuse...   Click to reply to this thread Reply
Thank you! This one finally solved mine :D
user4468516

Posts: 1
Registered: 04/29/09
Re: upgrade problem to APEX 3
Posted: Apr 29, 2009 7:47 AM   in response to: TomF in response to: TomF
Click to report abuse...   Click to reply to this thread 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 in response to: anakin_s
Click to report abuse...   Click to reply to this thread 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.

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 in response to: ahmad8
Click to report abuse...   Click to reply to this thread 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 in response to: user10282895
Click to report abuse...   Click to reply to this thread 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
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums