Original problem back ... Frustrating.. Summary: Host:HOSTNAME Problem:Oracle SIDNAME Alert Log Msg=( ORA-20000: index "ARADMIN"."IT145" or par
Notes: Host:DHOSTNAME Problem:Oracle SIDNAME Alert Log Msg=( ORA-20000: index "ARADMIN"."IT145" or partition of such index is in unusable state ) - full details in work info On Mon, Apr 9, 2012 at 3:16 PM, patrick zandi <[email protected]> wrote: > I am getting a little frustrated.. > Following the Clob in a row doc to put in a row.. after I ran the job, I > get alerts in the oracle alert log about the > Index is corrupt, SO I figure .. fine I will dump all the indexes and I > cannot.. I get the > ORA-00054: resource busy and acquire with NOWAIT specified or timeout > expired, 552, BMC.CORE:BMC_BaseElement > So fine, BMC comes back with > > From the above error it looks like the table/view - > 'BMC.CORE:BMC_BaseElement ' is already locked by some query. Like you have > executed "select for update" and has yet not committed/rollback and again > fired select query. Kindly have your DBA to unlock the query or rollback > before executing your query. > > > They don't tell you how.. just that it needs to be done.. So we figure > out that it is locked and then unlocked at about a every 15 seconds, and > then not for 10 and then for 15 .. on and off.. constantly.. > > no ryme nor reason.. Fine.. so we shutdown the db.. and start it back up > again.. > > Everything seems fine.. dropped all indexes.. Yeah... !!! > > added 4 indexes.. Wham .. Puke puke puke puke.. > > Failure during SQL operation to the database : ORA-00054: resource busy > and acquire with NOWAIT specified or timeout expired (ARERR 552). > > Failure during SQL operation to the database : 400131300 (ARWARN 552). > > Failure during SQL operation to the database : 400079600 (ARWARN 552). > > Failure during SQL operation to the database : > 179,1,400079600,400127400,400129200 (ARWARN 552). > > Index length longer than 255 bytes -- > > may not work on all databases (ARWARN 8037). > > > This clob in a row, is turning into a FIASCO !!! BMC .. come on... my > "less than bronze" support is not working.. > > > > > > > -- > Patrick Zandi > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
