Re: opatch error. Help please!

On Fri, 04 Jul 2003 20:37:48 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>All files in $ORACLE_HOME and all oracle data directories
>also make sure the Oracle executable and the tnslsnr executable have
>the setuid bit set.

They are.
>However from your description it looks like their might be a dangling
>.lck file. Each instance has a lock file, and those are located in
>$ORACLE_HOME/dbs
>dbstart will complain when starting a database and the lock file
>hasn't been removed by the last shutdown

It isn't the database per se I am having issues with, it is the opatch utility. I managed to install 4 patches OK the other night. Today I can't get any more patches to go do to a mysterius lock file.

There is no lock file here...
  sapbde:orabde 40> pwd
  /oracle/oraInventory/locks
  sapbde:orabde 41> ll
  total 0

Or here:

 sapbde:orabde 69> pwd
 /oracle/BDE/920_64/.patch_storage
 sapbde:orabde 70> ll
 total 11

 drwxr-xr-x   3 orabde     dba           1024 Jul  3 14:39 2856982
 drwxr-xr-x   3 orabde     dba           1024 Jul  3 14:42 2892876
 drwxr-xr-x   3 orabde     dba           1024 Jul  3 14:44 2961787
 drwxr-xr-x   3 orabde     dba           1024 Jul  4 14:45 2965263
 drwxr-xr-x   2 orabde     dba           1024 Jul  4 14:45 3023825

But when I run
/usr/bin/perl /oracle/BDE/920_64/OPatch/opatch.pl apply /oracle/stage/patches/3023825

I get a patch_locked file but it contains:

Locked for patch :  3023825
Locked by class  :  Apply
Locked by process:  17199
Locked at time   :  Fri Jul  4 14:45:04 2003
EUID             :  530
RUID             :  530
Host details     :  sapbde
RAC node details :  Not Applicable 

It is not the patch it is complaining about:

 Problems with the lock file
 Lock file exists, details are:
  Interim Patch 2965263 is holding the lock,   probably due to previous unsuccessful operation

Does that help clear things up?
Thanks!
Vince Received on Fri Jul 04 2003 - 14:48:04 CDT