Session altered.
...changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
3. 配置嵌入式PL/SQL网关。
SQL> @apex_epg_config /u01/apex
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Directory created.
declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.XMLTYPE", line 296
ORA-06512: at line 18
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:00:03.68
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.
错误原因是目录不对。解决办法：
改 /tmp 为你解压apex后所在的目录，例如我的是：/u01/apex，那么/tmp为/u01
文档做了注释，但地方不对，在@apxldimg.sql是有如下说明：
引用
Tip:
The above examples assume that you unzipped Oracle Application Express in a directory called TEMP on Windows and tmp on UNIX or Linux.
纠正后如下：
SQL> @apex_epg_config /u01
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Directory created.
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:01:45.40
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.