AIK step 5.5: "drop_user.sh: line 11: sqlplus: command not found"
- Article Type: General
- Product: Aleph
- Product Version: 20
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
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):
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")
Summary: Run AIK Step 3.1 again and ensure that it extracts the Oracle 188.8.131.52 software as $ORACLE_USER. Then run AIK Step 5.5.
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"):
Shut down the ARC processes and the Aleph 20 processes.
Stop the Oracle 184.108.40.206 Listener (as $ORACLE_USER):
$ lsnrctl stop
Shut down the Oracle database aleph21 (as $ORACLE_USER):
$ sqlplus / as sysdba
SQL> shutdown immediate
Move the directory /exlibris/app/oracle/product/11r2 aside by renaming it (as $ORACLE_USER):
$ cd /exlibris/app/oracle/product
$ mv 11r2 11r2.bad
Run AIK 3.1 to extract the Oracle 220.127.116.11 software (as UNIX user root).
Verify that the file /exlibris/app/oracle/product/11r2/bin/sqlplus has the correct permissions (-rwxr-xr-x).
Copy the following files from the previously installed Oracle 18.104.22.168 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
Start the Oracle 22.214.171.124 Listener (as $ORACLE_USER):
$ lsnrctl start
Start the Oracle database aleph21 (as $ORACLE_USER):
$ sqlplus / as sysdba
Verify that AIK 3.4 can connect to the Oracle database aleph21 via the Listener (as UNIX user root).
Start the ARC processes and the Aleph 20 processes and verify that those applications are working properly.
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 126.96.36.199.0 [...]
have only permission rwx------
change it to: rwxr-xr-x
Execute AIK Step 5.5 again and verify that it executes the function "Drop unused schemas" (as UNIX user root).
Delete the directory /exlibris/app/oracle/product/11r2.bad .
The permissions on the file /exlibris/app/oracle/product/11r2/bin/sqlplus are incorrect because AIK Step 3.1 extracted the Oracle 188.8.131.52 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