O'Reilly logo

Oracle Database 11g: Building Oracle XML DB Applications by Jinyu Wang

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

------------------------------------ ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required