Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. AIK Step 5.5.: "Error: Failed during alephe relocation - drop user"; no listener

    AIK Step 5.5.: "Error: Failed during alephe relocation - drop user"; no listener

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    The AIK Step 5.5 (Relocate alephe directory) fails with the following messages:

    Relocating alephe directory:
    INFO: Removing unused language files
    INFO: Removing unused uni Directories...
    INFO: Removing unused mab Directories...
    INFO: Cleaning some irrelevant files before
    INFO: Droping unused schemas
    INFO: Droping MAB users from DB
    Error: Failed during alephe relocation - drop user
    Press any key to continue

    The Menu-Point remains open (not OK).

    The u-tree has not been built.

    Cause:
    The script drop_user.sh which is called during Step 5.5 connects to the Oracle database via the Oracle Listener. However, the Listener is currently not running on this server:

    $ pgrep -l -f tnslsnr | wc
    0 0 0

    The log file of the Installation Kit (/exlibris/ftp_from_exlibris/aik/log/aleph_installation_kit.log) clearly points to this fact:

    [...]
    INFO: Droping MAB useres from DB

    ERROR:
    ORA-12541: TNS:no listener

    SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
    Failed to generate list of users to drop
    Error: Failed during alephe relocation - drop user
    [...]

    Resolution:
    (1)
    Start the Oracle Listener by executing Step 3.4 "Startup Oracle listener".

    (2)
    Watch the log file of the Listener:

    $ tail -f /exlibris/app/oracle/diag/tnslsnr/alephneub/listener/trace/listener.log

    When you see the message

    [...] * service_register * aleph20 * 0

    the database aleph20 is registered with the Listener.

    (3)
    Now test the connection to the database via the Listener by executing Step 3.5 "Check connection to the database via listener".

    (4)
    Execute Step 5.5 again.

    In case of error messages on the screen have a look at the log file aleph_installation_kit.log.

    Additional Information

    If the complete message is "drop_user.sh: line 11: sqlplus: command not found", see KB 16384-56740 ("drop_user.sh: line 11: sqlplus: command not found")

    Category: Installation

    Subject: New Installation


    • Article last edited: 12/11/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • AIK step 5.5: "drop_user.sh: line 11: sqlplus: command not found"
      • v23 AIK step 6.2: "compile_ora compilation is not successful"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. contype:kba
      3. Installation
      4. New Installation
      5. Prod:Aleph
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved