"Servlet Error: Unable to Access Portal Page" after Locking or Changing Portal Schema Password. (Doc ID 392408.1)

Last updated on OCTOBER 10, 2023

Applies to:

Portal - Version 9.0.4 to 10.1.4.2 [Release 10g to 10gR2]
Information in this document applies to any platform.

Symptoms

1. Portal account is locked.

If you have the Database password features enabled, the Database Server will lock the schema after a certain number of failed attempts to login to database schema. When this occurs, you will not be able to login to Portal.

This can be checked by running the following query as system schema:

SQL> select username, account_status from dba_users where username='PORTAL';
( or use select username, account_status from dba_users where account_status ='LOCKED';)

USERNAME            ACCOUNT_STATUS
---------------            --------------------------
PORTAL                   LOCKED

1.1. When trying to access Portal from Browser

http://<HOSTNAME>:<PORT>/pls/portal or http://<HOSTNAME>:<PORT>/portal/page?_pageid=<PAGE_ID>&_dad=portal&_schema=PORTAL

PRE 10.1.2.0.2 :

The Error in Browser:

Service Temporarily Unavailable or
Error: The listener returned the following Message: 503 Service Temporarily Unavailable

The Errors in ORACLE_HOME/Apache/Apache/logs/error_log.XXXXXXXXXXX is:

[Thu Jun 15 15:21:21 2006] [error] [client <IP_ADDRESS>] [ecid: <ECID>] mod_plsql: /pls/portal/portal.home HTTP-503 ORA-28000 Proxy log On failed. Please verify that you have specified correct connectivity information i.e. username, password & connect-string in the DAD

The error in ORACLE_HOME/j2ee/OC4J_Portal/application-deployments/portal/OC4J_Portal_default_island_1/application.log is:

06/06/15 15:26:37 portal: id=<ECID> Invalid status code encountered : status=503 reason=Service Temporarily Unavailable name=content-fetcher22 label=pageMeta url=https://<HOSTNAME>:<PORT>/pls/portal/!PORTAL.wwpob_page.show?_pageid=6 time=83ms content=<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE>503 Service Temporarily Unavailable</TITLE>
</HEAD><BODY>
<H1>Service Temporarily Unavailable</H1>
The server is temporarily unable to service your
request due to maintenance downtime or capacity
problems. Please try again later.
<HR>
<ADDRESS>Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at <HOSTNAME> Port <PORT></ADDRESS>
</BODY></HTML>

10.1.2.0.2 and later:

The Error in Browser:

Servlet Error
An unexpected servlet error was encountered.
Please check the log file for more details.

The error in ORACLE_HOME/j2ee/OC4J_Portal/application-deployments/portal/OC4J_Portal_default_island_1/application.log is:

06/06/15 13:39:40 portal: [module=PortalServlet, ecid=<ECID>] ERROR: Repository Gateway error: Database Error: ORA=28000 ORA-28000: the account is locked
06/06/15 13:39:40 portal: [module=PortalServlet, ecid=<ECID>] ERROR: oracle.webdb.repository.service.RepositoryServiceException: Unable to obtain Portal Repository version.

1.2. When trying to login to Portal via SQL*PLUS (using any password valid or invalid):

ERROR: ORA-28000: the account is locked

2. Portal Password changed from Database directly.

2.1. When trying to access Portal from Browser

       http://<HOSTNAME>:<PORT>/pls/portal or http://<HOSTNAME>:<PORT>/portal/page?_pageid=<PAGE_ID>&_dad=portal&_schema=PORTAL:

PRE 10.1.2.0.2 :

The Error in Browser :

       Forbidden
       You don't have permission to access /pls/portal/portal.home on this server

       Service Temporarily Unavailable
       Error: The listener returned the following Message: 503 Service Temporarily Unavailable

The Errors in ORACLE_HOME/Apache/Apache/logs/error_log.XXXXXXXXXXX is:

[Thu Jun 15 15:36:01 2006] [error] [client <IP_ADDRESS>] [ecid: <ECID>] mod_plsql: /pls/portal/portal.home HTTP-503 ORA-28000 Proxy log On failed.Please verify that you have specified correct connectivity information i.e. username, password & connect-string in the DAD

[Fri Jun 16 20:11:26 2006] [error] [client <IP_ADDRESS>] [ecid: <ECID>] mod_plsql: /pls/portal/htp.p HTTP-403 ORA-1017 Proxy log On failed.Please verify that you have specified correct connectivity information i.e. username, password & connect-string in the DAD

The error in ORACLE_HOME/j2ee/OC4J_Portal/application-deployments/portal/OC4J_Portal_default_island_1/application.log is:

06/06/15 15:36:28 portal: id=<ECID> Invalid status code encountered : status=503 reason=Service Temporarily Unavailable name=content-fetcher17 label=pageMeta url=https://<HOSTNAME>:<PORT>/pls/portal/!PORTAL.wwpob_page.show?_pageid=6 time=73ms content=<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE>503 Service Temporarily Unavailable</TITLE>
</HEAD><BODY>
<H1>Service Temporarily Unavailable</H1>
The server is temporarily unable to service your
request due to maintenance downtime or capacity
problems. Please try again later.
<HR>
<ADDRESS>Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at <HOSTNAME> Port <PORT></ADDRESS>
</BODY></HTML>

<FONT CLASS=PortletText1>Error: The servlet produced the following error stack. java.lang.Exception: Unable to determine Portal version using the portal_version_information call.
at oracle.webdb.page.PageBuilder.getPortalInformation(Unknown Source)
at oracle.webdb.page.PageBuilder.process(Unknown Source)
at oracle.webdb.page.Main.doRequest(Unknown Source)

10.1.2.0.2 and later:

The Error in Browser:

Servlet Error
An unexpected servlet error was encountered.
Please check the log file for more details.

The error in ORACLE_HOME/j2ee/OC4J_Portal/application-deployments/portal/OC4J_Portal_default_island_1/application.log is:

06/09/21 12:36:52 portal: [module=PortalServlet, ecid=<ECID>] ERROR: oracle.webdb.repository.service.RepositoryServiceException: Unable to obtain Portal Repository version.

2.2 Trying to change the Portal password from EM console > Infrastructure Tab, the error displayed is :

Failed to change the password. Examine the error log for possible reasons for the failure. Cannot connect to this database. Base Exception : java.sql.SQLException: ORA-01017: invalid username/password; logon denied