[Spacewalk-list] Oracle bites again (ORA-02291)

[Mario Mikocevic]

On 08/06/2012 11:18:55 AM, Jan Pazdziora wrote:
> On Mon, Aug 06, 2012 at 10:44:32AM +0200, Mario Mikocevic wrote:
> > On 08/06/2012 09:28:14 AM, Jan Pazdziora wrote:
> > > 
> > > What did Oracle support tell you when you reported this issue to them?
> > > Is it a bug and as such, when will it be fixed or what's the
> > > workaround? Or is it considered an expected behaviour?
> > 
> > When my DB Admin coleague contacted Oracle about it, he got confirmation
> > that it is a bug in Oracle but with no immediate resolution fix.
> 
> Thank you for the confirmation.
> 
> > Over the weekend we kinda fixed it,
> > oracle optimization bug is basically in skipping presetting and/or initializing
> > 'vital' DB areas so we just browsed through DB structure.
> > Granted, this works only for situations when DB is already set.
> > 
> > So, my spacewalk production is back online.
> > 
> > For installations you can use https://www.redhat.com/archives/spacewalk-list/2011-May/msg00023.html fix !
> 
> To make it work, do you always have to do the three selects, or would
> one select be enough to setup those DB areas?

All three required.

> My fear as expressed in
> 
> 	https://www.redhat.com/archives/spacewalk-list/2011-May/msg00024.html
> 
> is that fixing it for one lookup value might still cause it to fail
> for a different one.

Yes, your fears are correct because I just recently hit the same bug after
more than a full year of flawless production. (Hence this)

> Also, after the database restart, do you need to do that select again
> or is it already set alright?

DB restart ? Huh?! That I am not allowed to do ever !
Remember, DB is on another server and in my case it's quite heavy production
use not just for spacewalk.

But no, after spacewalk setup I didn't need to do that select again.



-- 
T-Com
Odjel za upravljanje mrežom i uslužnim platformama /
/ Network and Service Platform Operations Department.
Radna jedinica za servisne mreže - T5.1.7
Mario Mikočević
Draškovićeva 26, Zagreb, 10000
+385  1 4913 835
+385 98  470 801 (GSM)
mario dot mikocevic at t-com dot hr
http://www.t-com.hr