E-SQR: On Windows 2008 Pssqr Errors With SQR 5528, 4701 Or 1803 And ORA-01017

(Doc ID 1100832.1)

Last updated on APRIL 04, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.

Symptoms

Environment:
PT 8.49.x, Process Scheduler, Windows 2008, Oracle DB

Issue:
When attempting to run a SQR process from the Process Scheduler, the following error occurs and is reported in the SQR *.out file.
However, when the same Pssqr Command Line is run from a DOS window, the error does not occur and the SQR program runs successfully.

Error:
(SQR 5528) ORACLE OCISessionBegin(RDBMS) error 1017 in cursor 0:
ORA-01017: invalid username/password; logon denied
(SQR 4701) Cannot logon to the database.
SQR for PeopleSoft: Program Aborting.

Alternate error:
(SQR 1803) CONNECT failed. Perhaps username/password incorrect.
SQR for PeopleSoft: Program Aborting.

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