11i - Login 500 Internal Error because of the expired status of APPLSYSPUB database user

(Doc ID 1519694.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.0 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, IAS for Applications Technology, when attempting to access login page, the following error occurs:

500 internal error

OA_HTML/jsp/fnd/aoljtest.jsp, error message :

-----------------------
Checking GWYUID...
Trying to make a connection with APPLSYSPUB/PUB... java.sql.SQLException: Protocol violation
ERROR:Failed to make connection using the given gwyuid: APPLSYSPUB/PUB, please make sure GWYUID is set correctly.

Changes

 Changed 'PASSWORD' resource type of 'DEFAULT' profile in dba_profiles from unlimited to a limit value, then restore back to unlimited.

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