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

    ILLSV / Oracle user and tables are missing

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    In Aleph 18 we are in the progress to migrate to "Integrated ILL". We would like to communicate via ISO-ILL and therefore need the ILLSV-library. We see that on our Aleph 18 site the ILLSV-user does not exist in Oracle:

    >>s+ illsv

    SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 20 08:55:50 2011

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    ERROR:
    ORA-01017: invalid username/password; logon denied

    How can we create Oracle user and tables for ILLSV?

    Resolution:
    Please use the script $aleph_proc/clear_ora_user:

    >>csh -f $aleph_proc/clear_ora_user ILLSV
    Load: /exlibris/aleph/u18_1/alephe/tab/tab100
    Load: /exlibris/aleph/a18_1/illsv/tab/tab100

    ALEPH/SUN_OS_2, Copyright Ex Libris.
    version 18 revision 01 copy 1, 15-Oct-2006
    enter yes to create oracle user ILLSV yes
    default password is ILLSV
    if user ILLSV exists all data will be erased!!!
    enter no to reconfirm no

    • Article last edited: 10/8/2013