Wednesday, July 4th, 2007...11:26 pm
For some reason in the latest 10g oracle download for linux they fubared the perms for the $ORACLE_HOME directory, not allowing non-oracle users to run any oracle client tools like sqlplus. Causing awesome errors like:
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Also this completely broke oci8 for PHP, or any other thing that would use oracle libs on the same server that doesn’t run as root or oracle.
to fix this, and notice the upper case X that’s important.
as the oracle user run:
chmod -R a+rX $ORACLE_HOME
I want 3 hours of my life back Oracle!