• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Description:
In running any batch jobs (such as p_manage_01) which update Oracle tables, we get this error:
ORA-01017: invalid username/password; logon denied 

And we see the same in util o/13/1:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0306: Invalid option.
...
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Note: "s+" *does* work OK.
Why did this happen?

Resolution:
This problem occurred because the setenv in /exlibris/aleph/a16_1/alephm/.cshrc had been changed. Even if the Oracle login/password is changed, this setenv *must* remain as:
setenv ALEPH_ADMIN ALEPH_ADMIN
Note: "ls " and "ls *cshrc*" will not show this file. To see this file you need to do: 
> ls .cshrc 
or
> view .cshrc 

Additional Information
If the ALEPH_ADMIN line is OK and you still see this problem, see KB's192-4615. and 16384-47857.
Note: It may be that the job runs OK despite these errors.

• Article last edited: 12-Mar-2016