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/ Oracle-HTTP-Server Server at Port 7780"

Checked the log from $ORACLE_HOME/Apache/Apache/logs/error_log
[Thu Apr 20 19:14:17 2017] [error] [client] [ecid:,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:
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] [ecid: 1095168843:,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: