APEX

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

403 Forbidden Error in Oracle APEX 20.1

Farshid GolziMar 11 2025 — edited Mar 11 2025

Hello everyone,

I have installed Oracle Database 21c (21.3.0.0.0) on my database server (192.168.0.112) and set up APEX 20.1 on my Pluggable Database (PDB) named EGSP.
Additionally, I installed Oracle Fusion Middleware 12c (12.1.3.0.0) and configured Oracle HTTP Server (OHS) on my web server (192.168.0.111) using:

C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin\config.cmd

However, when I try to access APEX using the following URL:

http://192.168.0.111/egs

I get this error:
403 Forbidden
You are not authorized to access the requested resource.

Configuration Details

dads.conf (Located at: C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\OHS\instances\ohs1\mod_plsql)

<Location /egs>
  Order deny,allow
  PlsqlDocumentPath docs
  AllowOverride None
  PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
  PlsqlDatabaseConnectString     192.168.0.112:1521:egs
  PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
  PlsqlAuthenticationMode        Basic
  SetHandler                     pls_handler
  PlsqlDocumentTablename         wwv_flow_file_objects$
  PlsqlDatabaseUsername          APEX_PUBLIC_USER
  PlsqlDefaultPage               apex
  PlsqlDatabasePassword          EGS
  PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
  PlsqlPathAlias                 r
  PlsqlPathAliasProcedure        wwv_flow.resolve_friendly_url
  Allow from all
</Location>

tnsnames.ora Configuration

EGSCDB =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.112)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = EGS)
   )
 )
 EGS =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.112)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = EGSP)
   )
 )

Additional Information

I can successfully connect to the EGSP database from the web server using SQL*Plus, which confirms that the database connection itself is working.

C:\Users\Administrator>C:\oracle\app\product\BIN\sqlplus.exe APEX_PUBLIC_USER/EGS@EGS

Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> show con_name;

CON_NAME
------------------------------
EGSP
SQL>

Issue

Even though I can connect to the database from the web server, APEX is still returning a 403 Forbidden error when I try to access it via the browser.

Has anyone encountered this issue before? Any suggestions on how to resolve it would be greatly appreciated.

Thanks in advance!

This post has been answered by jariola on Mar 12 2025

Jump to Answer

Processing