Thursday, 12 September 2013

How to upgrade Oracle Application Express (APEX) to a new release

An excerpt from the book Create Rapid Web Applications Using Oracle Application Express - Second Edition
 
Oracle Database 11 g Express Edition (Oracle XE), that you just installed, includes Oracle Application Express release 4.0. In order to take advantage of the latest features you need to upgrade APEX to the most recent release. The following set of steps guide you how to do that:

1. Download the latest version of Application Express from the Oracle Technology Network.

2. Unzip the downloaded zip file (apex_4.2.2_en.zip) and save its content under c:\apex. Make sure that all the files and folders go into c:\apex and not into c:\apex\apex.

3. Open a command prompt and type cd c:\apex and hit the Enter key. At C:\apex>  type: sqlplus /nolog and hit the Enter key. At SQL> type: CONNECT SYS as SYSDBA and hit Enter. For Password, type manager and hit Enter. You’ll be connected to your database. The following screen-shot illustrates this step.



4. At the SQL> prompt type: @apexins SYSAUX SYSAUX TEMP /i/ to install the latest Application Express version. The upgrade process may take approximately 30 minutes and will end-up with the message: Disconnected from Oracle Database 11g.

5. Log back into SQL*Plus (as above) and load images: SQL>@apxldimg.sql C:\  hit Enter.

6. Upgrade Application Express admin password:  SQL>@apxchpwd hit Enter. Type password for Application Express ADMIN account. I entered and used Manager_2013 in later sections of this book.

No comments:

Post a Comment