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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
