After download patch, I patch on my apex.
- Check version an disable Oracle XML DB HTTP Server
SQL> select version from dba_registry where comp_id='APEX';- Install patch
VERSION
------------------------------
4.0.1.00.03
SQL> EXEC DBMS_XDB.SETHTTPPORT(0);
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
GETHTTPPORT
-----------
0
$ ls p10173973_112020_Generic.zip- Updating the Images Directory
p10173973_112020_Generic.zip
$ unzip p10173973_112020_Generic.zip
$ cd patch
SQL> connect / as sysdba
SQL> @apxpatch.sql
SQL> @apxldimg.sql /tmp/patch- Enable Oracle XML DB HTTP Server
SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);- Check version
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> select version from dba_registry where comp_id='APEX';
VERSION
------------------------------
4.0.2.00.06
2 comments:
Hi Surachart, I followed you procedure in the APEX patch but in the Oracle patch distribution file it does not exist the file called apxpatch.sql. Where do you get that file?
download Patch: 10173973 from support.oracle.com
you will see this file in patch
Post a Comment