Configuring Oracle APEX
In Oracle Database 11gR2, Oracle Application Express 3.2.1 is installed by default. APEX files are located at the $ORACLE_HOME/apex directory, where $ORACLE_HOME refers to the Oracle database home directory. The following steps will guide you in setting up APEX. You need to log in as SYS user (as SYSDBA) to run the setup.
Step 1: Check APEX Installation in Oracle Database 11g
To check the APEX installation, run the following command (check_apex_registry.sql):
column comp_name format a30
column status format a10
column version format a15
SELECT comp_name,status,version
FROM DBA_REGISTRY
WHERE comp_name in (‘Oracle Application Express’);
An example output is
COMP_NAME STATUS VERSION
------------------------------------ ...
Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
