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