RE: oem job fails..<solved>

From: <Sunil_Nookala_at_Dell.com>
Date: Tue, 02 Oct 2001 11:53:34 -0700
Message-ID: <F001.0039F4B4.20011002113525@fatcity.com>

I found out the session which kept the table locked. killed it, jobs run fine now.
thanks for help.

Sunil Nookala
-----Original Message-----
Sent: Tuesday, October 02, 2001 12:37 PM To: Multiple recipients of list ORACLE-L

that's not an oem problem per se... but is related to the fact that you are trying to update a row or table that is already in use

review the updates and order of updates you are making. Is anything else running at that time?

• Sunil_Nookala_at_Dell.com wrote:
  > Hi Guys,
  > While running a job(with lot of updates)in oem i get this error:
  >
  > ORA-00054: resource busy and acquire with NOWAIT specified.
  >
  > data base is 8.1.7 on NT.
  > please help me how to fix it.
  >
  > Sunil Nookala
  > Dell Corp.
  > Austin, TX
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author:
  > INET: Sunil_Nookala_at_Dell.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  

  ---

Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Sunil_Nookala_at_Dell.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 02 2001 - 13:53:34 CDT