Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-01017: invalid username/password; logon denied

     

    • 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
    • Was this article helpful?