[Spacewalk-list] Daily Oracle errors

[Jan Pazdziora]

On Tue, Mar 29, 2011 at 02:34:13PM +0000, BUPE(Peter Burgstaller) wrote:
> Dear all,
> 
> I have spacewalk 1.3 running on a Oracle 11R2 and receive a daily error from my DBMS:
> 
> ORA-7445[kokscfac()+232][SIGSEGV][ADDR:0x10][PC:0x1110922][Address not mapped to object]
> 
> SELECT /* DS_SVC */ /*+ cursor_sharing_exact dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") */ 1 AS C1 FROM (SELECT SYS_OP_NOEXPAND("NP_PE"."EVR") "ITEM_1","NP_PE"."SYS_NC00006$" "ITEM_2","NP_PE"."SYS_NC00007$" "ITEM_3","NP_PE"."SYS_NC00008$" "ITEM_4","NP_NP"."NAME_ID" "ITEM_5","NP_NP"."PACKAGE_ARCH_ID" "ITEM_6","NP_NP"."CHANNEL_ID" "ITEM_7",MAX("NP_PE"."EVR") "ITEM_8" FROM "RHNPACKAGEEVR" "NP_PE","RHNCHANNELNEWESTPACKAGE" "NP_NP" WHERE "NP_PE"."ID"="NP_NP"."EVR_ID" GROUP BY SYS_OP_NOEXPAND("NP_PE"."EVR"),"NP_PE"."SYS_NC00006$","NP_PE"."SYS_NC00007$","NP_PE"."SYS_NC00008$","NP_NP"."NAME_ID","NP_NP"."PACKAGE_ARCH_ID","NP_NP"."CHANNEL_ID") "VW_GBC_13#3", (SELECT "SP_SP"."SERVER_ID" "SERVER_ID","SP_SP"."NAME_ID" "NAME_ID","SP_SP"."PACKAGE_ARCH_ID" "PACKAGE_ARCH_ID",MAX("SP_PE"."EVR") "MAX_EVR" FROM "RHNSERVERPACKAGE" "SP_SP","RHNPACKAGEEVR" "SP_PE" WHERE "SP_PE"."ID"="SP_SP"."EVR_ID" GROUP BY "S!
> P_SP"."SERVER_ID","SP_SP"."NAME_ID","SP_SP"."PACKAGE_ARCH_ID") "SP#2" WHERE ("SP#2"."NAME_ID"="VW_GBC_13#3"."ITEM_5") AND ("SPACEWALK"."EVR_T"."COMPARE"("SP#2"."MAX_EVR","VW_GBC_13#3"."ITEM_1")<0)) innerQuery
> 
> Has anybody already encountered this issue and if so, what is the cause of it?
> Is there a fix for this?

The description for the ORA-7445 bug is

07445, 00000, "exception encountered: core dump [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause: An OS exception occurred which should result in the creation of a
//         core file.  This is an internal error.
// *Action: Contact your customer support representative.

So I suggest you escalate the issue with your Oracle support.

Yours,

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat