ora-7445 [evaopn3] running Peoplesoft Business Intelligence Queries (Doc ID 864442.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7
This problem can occur on any platform.
This problem has been seen by customers on mainly 11.1.0.7 but also 10.2.0.4.

Symptoms

Some customers who have recently upgraded to 11.1.0.7 or rolled out Peoplesoft Business Intelligence application have experienced this ora-7445.    The ora-7445 is described in bug 8581595 which is marked as a duplicate of bug 7637178.

----- Current SQL Statement for this session (sql_id=90jsj0at2vd2f) -----
SELECT COUNT(*) FROM PS_REQ_PO_LN_VW2 A WHERE BUSINESS_UNIT = :1 AND :2 = ' ' and :3 = ' ' and BUYER_ID = :4 and :5 = ' ' and :6 = ' ' and :7 = ' '

----- Call Stack Trace -----

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd <- 4750 <- evaopn2 <- FFFFFFFFFFF6A50 <- qerixTunnelGetKey <- qerixStart <- FFFFFFFFFFF70B0 <- 1105AB208 <- 000000004 <- qertbStart <- qerjotFetch <- qerflFetch <- qerghFetch

+++++++++++++
----- Current SQL Statement for this session -----


/* SQL Analyze(445,1) */ SELECT DISTINCT INSTITUTION, SUBJECT, CATALOG_NBR, CAMPUS, CRSE_ID, DESCR FROM PS_CRSE_CATLG_SCTY WHERE INSTITUTION=:1 AND SUBJECT=:2 AND OPRID=:3 ORDER BY INSTITUTION, SUBJECT, CATALOG_NBR, CAMPUS, CRSE_ID
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xd4c59d00 7294 package body SYS.DBMS_SQLTUNE_INTERNAL
0xd8508190 8 SYS.WRI$_ADV_SQLTUNE
0xf3bd0938 545 package body SYS.PRVT_ADVISOR
0xf3bd0938 2597 package body SYS.PRVT_ADVISOR
0xf47e5950 241 package body SYS.DBMS_ADVISOR
0xd83f0198 702 package body SYS.DBMS_SQLTUNE
0xce6ca610 4 anonymous block

Changes

It seems to mainly manifest itself when the DBMS_SQLTUNE is invoked on a query.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms