2 Replies Latest reply on Oct 23, 2013 10:15 AM by 86092875-e9a7-479e-8f1a-96bb20cda003

    Apex 4.2.3 - Completely blank login screen - ORA-22288: file or LOB operation FILEOPEN failed The system cannot find the path specified

    sbing52

      Environment:

      Apex 4.2.3

      Listener:  PL/SQL Gateway (EPG)

      Oracle Database 11.2.0.3

      Windows 7 64 bit

       

       

      Just finished upgrading from Apex 3.2 to 4.3.2 and I am getting a completely blank login screen.

       

      I executed the following process to load the images file:

       

      cd M:\apex_4.2.3\apex_4.2.3_en\apex

      > sqlplus /@orcl as sysdba 

      SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 11 13:56:14 2013

      Copyright (c) 1982, 2011, Oracle.  All rights reserved.

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL> show user

      USER is "SYS"

      SQL> @apxldimg.sql M:\apex_4.2.3\apex_4.2.3_en\apex    <<< this is my software download directory

      PL/SQL procedure successfully completed.

      PL/SQL procedure successfully completed.

      . Loading images directory: M:\apex_4.2.3\apex_4.2.3_en\apex/apex/images  << notice the slashes

      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.XMLTYPE", line 296

      ORA-06512: at line 15

      PL/SQL procedure successfully completed.

      PL/SQL procedure successfully completed.

      Commit complete.

      Directory dropped.

      timing for: Load Images

      Elapsed: 00:00:07.09

      SQL>

       

      I am still getting a completely blank login screen. I noticed that the path mixes forward slashes with back slashes.  I think that this is why I am getting the "The system cannot find the path specified."

       

      This is a valid direcotry where I downloaded the 4.2.3 software

      M:\apex_4.2.3\apex_4.2.3_en\apex>ls -l M:\apex_4.2.3\apex_4.2.3_en\apex

      total 1586

      -rw-rw-rw-   1 user     group         831 Apr  6  2013 apex_epg_config.sql

      -rw-rw-rw-   1 user     group        2130 Aug 31 00:38 apex_epg_config_con.sql

      -rw-rw-rw-   1 user     group       16742 Aug 26 07:52 apex_epg_config_core.sql

      -rw-rw-rw-   1 user     group        4424 Aug 31 00:38 apex_rest_config.sql

      -rw-rw-rw-   1 user     group        2653 Aug 31 00:38 apex_rest_config_con.sql

      -rw-rw-rw-   1 user     group        9626 Aug 31 00:38 apex_rest_config_core.sql

      -rw-rw-rw-   1 user     group          77 Oct 11 12:52 apexins.out

      .    .    .    .    .    .     .     . <more files>

       

      This is the sqlplus command that I am using:

      @apxldimg.sql M:\apex_4.2.3\apex_4.2.3_en\apex

       

      I also executed apex_epg_config and got the same error:

      SQL> @apex_epg_config M:\apex_4.2.3\apex_4.2.3_en

      PL/SQL procedure successfully completed.


      PL/SQL procedure successfully completed.

      . Loading images directory: M:\apex_4.2.3\apex_4.2.3_en/apex/images  <<< once again mixed slashes

      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.XMLTYPE", line 296
      ORA-06512: at line 16

       

      PL/SQL procedure successfully completed.


      PL/SQL procedure successfully completed.


      Commit complete.


      Directory dropped.

      timing for: Load Images
      Elapsed: 00:00:02.51

      PL/SQL procedure successfully completed.


      Commit complete.

      SQL> quit