Thursday, May 7, 2009

Oracle Application Express Upgrade 3.1.1 to 3.1.2

APEX Upgrade 3.1.1 to 3.1.2 Steps

SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.1.00.09

1.Download from metalink p7313609_11106_GENERIC.zip
2.Unzip and extract p7313609_11106_GENERIC.zip
3.Stop Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
4.Login Oracle Database

sqlplus "/as sysdba"
5.Run apxpatch.sql

SQL>@patch\apxpatch.sql
6.Copy image folder.

cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache
7.Start Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server


SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.2.00.02

No comments: