DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, April 21, 2017

How To Diagnose And Debug A HTTP 503 Error In A Portal Environment (Doc ID 751101.1)

Error Received in browser:
"Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at my.host.com Port 7780"

Checked the log from $ORACLE_HOME/Apache/Apache/logs/error_log
[Thu Apr 20 19:14:17 2017] [error] [client xxx.xx.xxx.x] [ecid: 1492695857:xxx.xxx.x.xx:21647:0:1,0] mod_plsql: /pls/apex_forging/apex HTTP-503 ORA-28000

1. Verify the APEX_PUBLIC_USER (or HTMLDB_PUBLIC_USER) password. By default, it will be the same password defined for the APEX ADMIN user.
If you are unable to login as the APEX_PUBLIC_USER, modify the password as the SYS user using the following command:
alter user APEX_PUBLIC_USER  identified by <password>;

After changing APEX_PUBLIC_USER password received the below error in browser:
"Forbidden
You don't have permission to access /pls/apex on this server"

Checked the log from $ORACLE_HOME/Apache/Apache/logs/error_log
[Tue Sep 14 09:34:03 2004] [error] [client 111.111.111.10] [ecid: 1095168843:121.121.121.12:2764:0:431,0] mod_plsql: /pls/apex/apex HTTP-403 ORA-1017

2. Make a backup of the file containing the Database Access Descriptor (DAD) definitition for APEX- tyically marvel.conf or dads.conf.
3. Modify the value PlsqlDatabasePassword in to reflect the password identified in step 1. For this example, let's say the password is manager1:

PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword manager1

4. Restart the Oracle HTTP Server.
$ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=HTTP_Server
$ORACLE_HOME/opmn/bin/opmnctl startproc ias-component=HTTP_Server

5. Test to verify that you can login to APEX / HTML DB successfully.

No comments: