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

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version 9.0.4 to 10.1.4.2 [Release 10g to 10gR2]
Information in this document applies to any platform.
Checked for relevance on 03-Apr-2014

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.

You can easily check if this is your situation 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://machine:port/pls/portal or http://machine:port/portal/page?_pageid=3&_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 148.87.19.50] [ecid: 1150348881:140.83.21.99:20125:0:46370,0] 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 similar to :

06/06/15 15:26:37 portal: id=1150349197:140.83.21.99:20125:0:46372,0 Invalid status code encountered : status=503 reason=Service Temporarily Unavailable name=content-fetcher22 label=pageMeta url=https://tools4.au.oracle.com:4447/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 tools4.au.oracle.com Port 7778</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 Errors in ORACLE_HOME/Apache/Apache/logs/error_log.XXXXXXXXXXX is:

no errors

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

06/06/15 13:39:40 portal: [module=PortalServlet, ecid=78439379017,1] ERROR: Repository Gateway error: Database Error: ORA=28000 ORA-28000: the account is locked
06/06/15 13:39:40 portal: [module=PortalServlet, ecid=78439379017,1] 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://machine:port/pls/portal or http://machine:7778/portal/page?_pageid=3&_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 148.87.19.50] [ecid: 1150349761:140.83.21.99:30837:0:20937,0] 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 140.83.21.99] [ecid: 112911661421,1] 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 similar to :

06/06/15 15:36:28 portal: id=1150349788:140.83.21.99:20123:0:44938,0 Invalid status code encountered : status=503 reason=Service Temporarily Unavailable name=content-fetcher17 label=pageMeta url=https://tools4.au.oracle.com:4447/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 tools4.au.oracle.com Port 7778</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 Errors in ORACLE_HOME/Apache/Apache/logs/error_log.XXXXXXXXXXX is:-

   none

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


06/09/21 12:36:52 portal: [module=PortalServlet, ecid=87105934233,1] 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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms