An excerpt from the book Create Rapid Web Applications Using Oracle Application Express - Second Edition
Oracle Database 11 g Express Edition (Oracle XE), which 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 on 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.
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.
Also see
