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

    p_file_20: "can't get host by address or by nameLoad ..."

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

    Description:
    1.) When I run the patron load job (p_file_20) in PWD50, I get the message
    Oracle error: update_cursor z305
    ORA-00942: table or view does not exist
    This leads me to believe the job should run in the ADM library (XXX50) and not the usr_library..

    2.) But when I run the patron load job in XXX50, I get the following errors:.
    can't get host by address or by nameLoad: /aleph_tmp/utf_files/exlibris/aleph/u16_1/pwd50/tab/tab_bor_id.eng.
    can't get host by address or by nameLoad: /exlibris/aleph/u16_1/xxx50/tab/tab_bor_address.
    can't get host by address or by nameLoad: /exlibris/aleph/u16_1/pwd50/tab/tab_filing.
    can't get host by address or by nameEntity: line 1: error: Specification mandate value for attribute er <?xml version = "1.0" encoding = "UTF-8"?><update_suf_from_loc er *

    Resolution:
    1.) The p_file_20 does need to run in the ADM library (XXX50), not in the usr_library (PWD50)..
    2.) The "can't get host by address or by name" message is occurring because of these lines in the $alephe_tab/tab_suf_lib:.
    XXX01 XXX01 lib5.nd.edu:6991.
    XXX50 XXX50 lib5.nd.edu:6991.
    Please remove these. If your "shared user file" were on another server, they could be necessary; but since it's on the same, they are not. (It seems it's trying to connect to this "remote host" and failing.)

    • Article last edited: 10/8/2013