Saturday, November 20, 2010

Patch Oracle Application Express Release 4.0.2

Oracle Application Express Release 4.0.2 was released on November 19, 2010. We can check Patch Set Notes and download APEX 4.0.2. Or download patch number 10173973 from metalink
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';

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
- Install patch
$ ls p10173973_112020_Generic.zip
p10173973_112020_Generic.zip

$ unzip p10173973_112020_Generic.zip

$ cd patch

SQL> connect / as sysdba

SQL> @apxpatch.sql
- Updating the Images Directory
SQL> @apxldimg.sql /tmp/patch
- Enable Oracle XML DB HTTP Server
SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.
- Check version
SQL> select version from dba_registry where comp_id='APEX';

VERSION
------------------------------
4.0.2.00.06

2 comments:

Anonymous said...

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?

Surachart Opun said...

download Patch: 10173973 from support.oracle.com

you will see this file in patch