Benefits Administration Error: ORA-01005: Null Password Given; Logon Denied (Doc ID 1338504.1)

Last updated on AUGUST 24, 2016

Applies to:

PeopleSoft Enterprise HRMS Benefits Administration - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When running Benefits Administration, the following error occurs:

Error
----------------
Will use connect ID to retrieve OPR PSWD
Connect ID password required.

Application Program Failed
Action Type : SQL CONNEC
In Pgm Section : SQLRT:GG100 SQL-CONNECT
With Return Code: 01005
Error Message : ORA-01005: null password given; logon denied


Another scenario is when the error only occurs for a specific userid.

Error
----------------
Will use connect ID to retrieve OPR PSWD
Connect ID password required.

Application Program Failed
Action Type : SQL CONNECT

In Pgm Section : SQLRT: GG100-SQL-CONNECT

Error Message : Invalid process instance 000REVALUE

CONNECT ERROR. CHECK USER ID AND PASSWORD.

 

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