Oracle Database Discussions

Hello,

I'm running RHEL5 (linux) on an x86 Intel platform with Oracle 10gR2 (10.2.04), and don't seem to be able to give other users on this box the ability to run some of the Oracle client tools such as SQL*Plus, and sqlldr (for starters).

Most of the directories are created by oracle with 700 permissions (rwx------).
Even after opening all directories from /u01 up to the $OH/bin directory, the sqlplus still fails with the following error:

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

I really don't like opening up all the directories as 755 (rwxr-xr-x), and I certainly don't feel it is right to change permissions on various individual files and library files.

Does anyone know what the right solution to this problem would be?

Thanks.