Back in July when I applied CPUJul2006, it failed to set the correct file permissions on some of the Oracle executables (e.g. imp/exp, sqlplus). This is Oracle9i running on Solaris 9 64-bit. Developers were getting the error below when invoking SQL*Plus.
ld.so.1: $ORACLE_HOME/bin/sqlplus: fatal:
$ORACLE_HOME/lib/libclntsh.so.9.0:
Permission denied
Killed
Their Unix account does not belong to the Unix dba group, which explains why I don’t see the problem when I login to my Unix account which is a member of the dba group.
I fixed the original occurrence by executing “relink all”. After applying the 9.2.0.8 patch about a month ago, the same error appeared this morning when one of the developers went to invoke SQL*Plus. Again, the problem was fixed with “relink all”.
Searching Metalink to see if this is a known issue. At the moment, I’m left wondering how many more times I will need to “relink all” after applying future CPUs.
Note: 9.2.0.8 is the terminal release for Oracle9i, so no worries about applying a future upgrade patch.
Sunday, June 10, 2007 at 15:16 pm |
Hi Mike,
Thanks Mike . After upgrade from 9.2.0.6 to 9.2.0.8. The same error was observed in the database and after relink all. It didnt appear :)
Regards,
Venkat