HOME > > Embedded PL/SQL Gateway (EPG) Configuration

Embedded PL/SQL Gateway (EPG) Configuration

Anup - Tuesday, December 3, 2019

If you want to use the Embedded PL/SQL Gateway (EPG) to front APEX, you can follow the instructions here. 
SQL> CONN sys@pdb1 AS SYSDBASQL> @apex_epg_config.sql <passing in the base directory of the installation software as a parameter>
Check the port setting for XML DB Protocol Server.
SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
          0
1 row selected.

SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.
SQL> EXEC DBMS_XDB.sethttpport(8080);
PL/SQL procedure successfully completed.

SQL>
APEX should now be available from a URL like "http://machine:port/apex".

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me