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:
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 188.8.131.52 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: 184.108.40.206 is the terminal release for Oracle9i, so no worries about applying a future upgrade patch.