Note: When running 11g your image path might be set to "images" instead of "i". Below is sample script for installing apex321 from c:\apex321\apex

1. CREATE SMALLFILE TABLESPACE "APEX" DATAFILE ‘C:\ORACLE11G\ORADATA\LOCALDB\apex01.dbf’ SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

2. CREATE SMALLFILE TABLESPACE "APEX_FILES" DATAFILE ‘C:\ORACLE11G\ORADATA\LOCALDB\apex_files01.dbf’ SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

3. @apexins APEX APEX_FILES TEMP /images/ — will take some time

4. @apxchpwd — to change admin password

5. @apex_epg_config c:\apex321 — will take some time

6. ALTER USER ANONYMOUS ACCOUNT UNLOCK;

7. @apxldimg.sql c:\apex321 — to update new images into database, will take some time

8. SELECT DBMS_XDB.GETHTTPPORT FROM DUAL; — to know the port

9. EXEC DBMS_XDB.SETHTTPPORT(8080); — below commit is required

10. commit;

Below describes theme installation for an APEX environment with an embedded PL/SQL Gateway. This is the usual set up when running APEX on either an Oracle 11g or Oracle XE database.

  1. Unzip the downloaded ZIP file(s) to any directory. This will create an SQL file and a style directory containing images and CSS files.
  2. In Internet Explorer select FileOpen. Enter the location of your images directory, e.g. http://127.0.0.1:8080/images/ — check Open as Web Folder and click Open.
  3. When prompted enter the username and password of the system user.
  4. Copy the style directory previously unzipped into your themes directory in Internet Explorer.
  5. To verify that you have successfully completed the above steps go to the following URL:
    http://<database_ip>:<port>/i/themes/<theme name>/master.css
    e.g. http://127.0.0.1:8080/i/themes/alpha_001/maser.css
  6. Now log into Oracle APEX.
  7. Navigate to the Shared Components of your application.
  8. Select Themes and then Import Theme from the task list.
  9. Locate the SQL file previously unzipped and click Next, Next and Install Theme.
  10. To activate your new theme click Switch Theme. Select your theme from the dropdown selection, if not already selected, and click Next, Next and Switch Theme.
  11. Two substitution strings are used by all of our themes. In Shared Components select Definition then Substitutions. Create the following substitution strings:

Name

Value

THEME_PATH

Required – This should be set to the path of the style directory for your theme.
For example: /i/themes/alpha_001/
Please note: The value must start and end with /

COPYRIGHT_MSG

Optional – This can be set to the copyright message that will display on all pages in your application, usually in the footer.
For example: Copyright © Your Company Name

Thanks to www.apex-themes.com for the guidance and support on apex