Installing or Upgrading Oracle APEX
HTML DB did not impress me much (huh?) – but I have to say I am pretty impressed with Oracle Apex.
It is one of the quickest ways to make db-aware web solutions. That combined with the fact that is uses Oracle is just great.
Well, anyway – I was asked to upgrade the APEX to the latest version (4.02 while writing this).
Here is a quick guide:
1. Download apex installation package
2. Unzip it somewhere like c:\oraclexe\apex or /var/oraclexe/apex
3. Open shell or cmd and CD there, “sqlplus / as sysdba” from that directory
4. @apexins SYSAUX SYSAUX TEMP /i/
5. ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
5.1. ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password
If your images are not displayed correctly, you may need to run also:
@apxldimg c:\oraclexe\
In order to change the admin account password, run: @apxxepwd.sql
BR,
Pasi
Tags: Apex, Oracle, Oracle Apex