E-SQR: On Windows 2008 Pssqr Errors With SQR 5528, 4701 Or 1803 And ORA-01017 (Doc ID 1100832.1)

Last updated on OCTOBER 13, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.