Oracle “relink all”

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.

Advertisements

One Response to Oracle “relink all”

  1. Venkat says:

    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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: