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. $ORACLE_HOME/bin/sqlplus: fatal:
Permission denied

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


One Response to Oracle “relink all”

  1. Venkat says:

    Hi Mike,

    Thanks Mike . After upgrade from to The same error was observed in the database and after relink all. It didnt appear :)


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: