I have written one make file to compile a proc code, it's giving the following error: "/18.104.22.168/bin/proc: error while loading shared libraries: libclntsh.so.9.0: cannot open shared object file: No such file or directory." I have checked the link and file exists in $ORACLE_HOME/lib. Could you please suggest something?
Since the file exists, I must assume that the permissions are not sufficient for the user to be able to read the file. On your database server, sign on as the user that owns the software (typically 'oracle' for Unix/Linux). Then do "cd $ORACLE_HOME/install". Next, execute the changePerm.sh shell script. This will update your file permissions.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading