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 .