the following error occurs when running ora_cleansp:
./ora_cleansp <username>/<password>
ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory
/bin/ksh[57]: 9943 Killed
Can be a library linking issue.
The following steps are can be taken to rule out issues that can also cause the error. The issues are self explanatory:
1. You are able to connect to SQL*Plus via client, and the environment variables ORACLE_HOME and ORACLE_SID are set appropriately.
2. The permissions on sqlplus executables are fine, that is, execute permissions exists for others.
3. You may run genclntsh to correct any shared library issues but to no avail. The script genclntsh is used to create a single shared client library.
4. Normally the Oracle libraries are relinked automatically during Oracle upgrade or Oracle patch upgrade but it may be required in case of OS patch upgrade, any issues during with libraries during Oracle upgrade, etc. The command "relink all" is run to relink the libraries but it fails with the following errors:
[us-rwc-ods2/export/home/oracle/product/10.2.0.3/bin] ./relink all
./relink: /usr/bin/make: not found
./relink: /usr/bin/make: not found
.
.
/usr/bin/find: cannot read dir
/home/oracle/product/10.2.0.3/jdk/jre/lib/applet/: Permission denied
./relink: /usr/bin/make: not found
./relink: /usr/bin/make: not found
5. Finally relink is run on a component by component basis and subsequently ora_cleansp runs fine. Here is the syntax for relink:
cd $ORACLE_HOME/bin relink
usage: relink >parameter<
accepted values for parameter: all, oracle, network, client, client_sharedlib,
interMedia, precomp, utilities, oemagent
