Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

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

    • 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
    //doorbell.io feedback widged