Description of Issue
|
Oracle APEX 5.1 new installation(Embedded plsql gateway configuration) completed successfully, However, Unable to open Oracle Apex Login Page / Oracle APEX Login Page Blank. Tried to access below URL still same issue http://<Machine-Name>:<port-number>/i/apex_version.txt |
Cause
|
Database parameters [shared_servers,DISPATCHERS] are not properly set which are required for XDB |
Solution
|
Verify Listener and below Database Parameters: $ lsnrctl status SQL> show parameter local listener SQL> show parameter dispatchers SQL> show parameters shared_servers
1) We should have shared_servers > 0, please set the following
alter system set shared_servers = 5;
2) You will also need to set dispatchers
Reference:
How to Setup XDB Protocol Server: FTP, HTTP, WebDAV ( Doc ID 362540.1 )
Specifically:
*************************************************************************
Set the DISPATCHERS parameter.
The DISPATCHERS system parameter is required for XDB protocol registration with the Listener. The DISPATCHERS parameter is set in the init.ora.
Run the following in SQLPlus to determine if the dispatchers parameter is already set:
show parameter dispatchers
If XDB dispatchers is not already set, add the following line to the init.ora:
Non-RAC:
dispatchers="(PROTOCOL=TCP)(SERVICE=<sid>XDB)"
Or from the SQL*Plus prompt:
SQL> alter system set dispatchers="(PROTOCOL=TCP)(SERVICE=XDB)" scope=both sid='<sid>';
RAC:
instanceid1.dispatchers="(PROTOCOL=TCP) (SERVICE=<instanceid1>XDB)"
instanceid2.dispatchers="(PROTOCOL=TCP) (SERVICE=<instanceid2>XDB)"
Or from the SQL*Plus prompt:
Execute this for each node:
alter system set dispatchers="(PROTOCOL=TCP)(SERVICE=XDB)" scope=both sid='<sid>';
NOTE: Replace <sid> ,<instanceid1>, etc. with the actual values.
For example:
dispatchers="(PROTOCOL=TCP) (SERVICE=OrclXDB)"
If the DISPATCHERS parameter is set then the default value for SHARED_SERVERS is 1. The value of SHARED_SERVERS parameter should always be >= 1 for this setup to work.
|
No comments:
Post a Comment