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: "drop_user.sh: line 11: sqlplus: command not found"

    AIK step 5.5: "drop_user.sh: line 11: sqlplus: command not found"

    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: 20

    Problem Symptoms:
    At the end of AIK step 5.5:

    /exlibris/app/oracle/product/11r2/bin/sqlplus: Permission denied.
    INFO: Droping unused schemas
    INFO: Droping MAB useres from DB
    drop_user.sh: line 11: sqlplus: command not found
    Error: Failed during alephe relocation - drop user

    Cause:
    The UNIX user aleph does not have permission to execute the program sqlplus. This is due to the fact that the permissions on the file /exlibris/app/oracle/product/11r2/bin/sqlplus are too restrictive. The permissions are as follows (file mode 700):
    -rwx------ /exlibris/app/oracle/product/11r2/bin/sqlplus

    If this is a TWO_TASK installation, see KB 16384-56740 ("AIK step 5.5: " drop_user.sh: line 11: sqlplus: command not found" -- TWO_TASK")

    Resolution:
    Summary: Run AIK Step 3.1 again and ensure that it extracts the Oracle 11.2.0.3 software as $ORACLE_USER. Then run AIK Step 5.5.

    (0)
    Check file /exlibris/ftp_from_exlibris/AIK21/param_bash.ini and set the variable $ORACLE_USER to the correct value (as described in KB 16384-62706 ("AIK Step 2.5 overwrites variable $ORACLE_USER in file param_bash.ini"):

    ORACLE_USER=oracle

    (1)
    Shut down the ARC processes and the Aleph 20 processes.

    (2)
    Stop the Oracle 11.2.0.3 Listener (as $ORACLE_USER):

    $ lsnrctl stop
    (3)
    Shut down the Oracle database aleph21 (as $ORACLE_USER):

    $ sqlplus / as sysdba
    SQL> shutdown immediate

    (4)
    Move the directory /exlibris/app/oracle/product/11r2 aside by renaming it (as $ORACLE_USER):

    $ cd /exlibris/app/oracle/product
    $ mv 11r2 11r2.bad

    (5)
    Run AIK 3.1 to extract the Oracle 11.2.0.3 software (as UNIX user root).

    (6)
    Verify that the file /exlibris/app/oracle/product/11r2/bin/sqlplus has the correct permissions (-rwxr-xr-x).

    (7)
    Copy the following files from the previously installed Oracle 11.2.0.3 software directory (as $ORACLE_USER):

    11r2.bad/dbs/orapwaleph21 ---> 11r2/dbs/orapwaleph21
    11r2.bad/dbs/spfilealeph21.ora ---> 11r2/dbs/spfilealeph21.ora

    11r2.bad/network/admin/tnsnames.ora ---> 11r2/network/admin/tnsnames.ora
    11r2.bad/network/admin/listener.ora ---> 11r2/network/admin/listener.ora

    (8)
    Start the Oracle 11.2.0.3 Listener (as $ORACLE_USER):

    $ lsnrctl start

    (9)
    Start the Oracle database aleph21 (as $ORACLE_USER):

    $ sqlplus / as sysdba
    SQL> startup

    (10)
    Verify that AIK 3.4 can connect to the Oracle database aleph21 via the Listener (as UNIX user root).

    (11)
    Start the ARC processes and the Aleph 20 processes and verify that those applications are working properly.

    (12)
    Verify that UNIX user aleph has permission to execute the program /exlibris/app/oracle/product/11r2/bin/sqlplus:

    $ su -f aleph
    $ source /exlibris/aleph/a21_1/alephm/.cshrc
    $ sqlplus /nolog

    SQL*Plus: Release 11.2.0.3.0 [...]

    (13) If
    /exlibris/app/oracle/product/11r2/bin/sqlplus
    and
    /exlibris/app/oracle/product/11r2/

    have only permission rwx------
    change it to: rwxr-xr-x

    (14)
    Execute AIK Step 5.5 again and verify that it executes the function "Drop unused schemas" (as UNIX user root).

    (15)
    Delete the directory /exlibris/app/oracle/product/11r2.bad .

    Additional Information

    The permissions on the file /exlibris/app/oracle/product/11r2/bin/sqlplus are incorrect because AIK Step 3.1 extracted the Oracle 11.2.0.3 software as UNIX user aleph. It should have extracted the Oracle software as UNIX user oracle, though. See KB 16384-62706 ("AIK Step 2.5 overwrites variable $ORACLE_USER in file param_bash.ini").

    One site notes: "I tried at least 5 times but got stuck at the same AIK 5.5 step, the only way I could install AIK22 was to go back and check the $Oracle_user=oracle right after I run AIK step 2.5. then after this the installation runs without problems."

    Category: Installation & Upgrades (500)

    Subject: New Installation (500)


    • Article last edited: 11/16/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • AIK step 5.5: " drop_user.sh: line 11: sqlplus: command not found" -- Two_Task
      • AIK Step 5.5.: "Error: Failed during alephe relocation - drop user"; no listener
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Installation & Upgrades (500)
      4. New Installation (500)
      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