Configuring the Oracle embedded gateway
The goal of this section is to show you how to configure Oracle Database for the embedded PL/SQL gateway. For Oracle XE, the embedded gateway comes configured for Apex by default.
All configuration is done via SQL*Plus. SQL*Plus represents the lowest common interface available across all Oracle versions. The command-line interface when used with a text editor enables quick and easy modification of most Oracle features.
Tools like Oracle SQL Developer and Enterprise Manager can also be used, but it is best to have a good understanding of the core capabilities before using GUI development tools:
Use SQL*Plus to connect to the database as SYS:
sqlplus / as sysdba
Check to make sure the database parameter dispatchers are correctly configured to allow the database to talk to the listener:
SQL> show parameter dispatchers
The output should look like the following:
NAME TYPE VALUE ------------------------------------ ----------- ----------...