My Oracle Support Banner

ORA-07445 [strlen()+24] Errors on SuperCluster (Doc ID 2121850.1)

Last updated on OCTOBER 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

For a scheduled SQL Analyze task, ORA-07445 errors are reported in the alert log like:

ORA-07445: exception encountered: core dump [strlen()+24] [SIGSEGV] [ADDR:0x20011] [PC:0xFFFFFFFF72DBD558] [Address not mapped to object] []

This was seen on 12.1.0.2.12 database on Oracle Solaris SPARC (64-bit) on a Supercluster running Exadata software
Here is an example of the trace file header of a failing instance:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/dbhome_1
System name: SunOS
...
Release: 5.11
Version: 11.3
Machine: sun4v
Storage: Exadata
...
Unix process pid:... (J002)

*** 2016-01-25 23:18:13.895
*** SESSION ID:(1262.43300) 2016-01-25 23:18:13.895
*** CLIENT ID:() 2016-01-25 23:18:13.895
*** SERVICE NAME:(SYS$USERS) 2016-01-25 23:18:13.895
*** MODULE NAME:(DBMS_SCHEDULER) 2016-01-25 23:18:13.895
*** CLIENT DRIVER:() 2016-01-25 23:18:13.895
*** ACTION NAME:(ORA$AT_OS_OPT_SY_143) 2016-01-25 23:18:13.895
*** CONTAINER ID:(1) 2016-01-25 23:18:13.895

...


The characteristics that point to SQL Tuning Advisor are:

----- Current SQL Statement for this session (sql_id=dqwah6mp###qt) -----

/* SQL Analyze(1) */ select /.....


----- PL/SQL Stack -----
----- PL/SQL Call Stack -----

object line object
handle number name
1b1f791fc0 145 package body SYS.DBMS_SQLTUNE_INTERNAL
1b1f791fc0 13094 package body SYS.DBMS_SQLTUNE_INTERNAL
1b1f791fc0 13730 package body SYS.DBMS_SQLTUNE_INTERNAL
1b1f791fc0 18936 package body SYS.DBMS_SQLTUNE_INTERNAL
1b1f719980 9350 package body SYS.DBMS_STATS_INTERNAL
1b2f3c1740 30410 package body SYS.DBMS_STATS
1b2f3c1740 31568 package body SYS.DBMS_STATS
1b2f3c1740 33260 package body SYS.DBMS_STATS
1b2f3c1740 34152 package body SYS.DBMS_STATS
1b2f3c1740 35095 package body SYS.DBMS_STATS
1b2f3c1740 44326 package body SYS.DBMS_STATS
1b2f3c1740 44389 package body SYS.DBMS_STATS

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

... strlen qerfxGCol qerfxFetch qerandvFetch qergsFetch opifch2 kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpufch0 kpufch qksanExecSql qksanAnalyzeSqlConCbk qksanAnalyzeSql qksanAnalyzeSegSql kestsGatherSqlStatistics kestsProcessSql kestsProcessSqlCallout spefcmpa spefmccallstd peftrusted psdexsp rpiswu2 kxe_push_env_internal_pp_ kkx_push_env_for_ICD_for_new_session psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run ...


...
============
Plan Table
============
--------------------------------------------+-----------------------------------+
| Id | Operation                      | Name       | Rows | Bytes | Cost | Time |
--------------------------------------------+-----------------------------------+
|  0 | SELECT STATEMENT               |            |      |       |    1 |      |
|  1 | SORT AGGREGATE                 |            |    1 |   218 |      |      |
|  2 | OPTIMIZER STATISTICS GATHERING |            |  100 |   21K |    0 |      |
|  3 | FIXED TABLE FULL               | X$QKSBGSYS |  100 |   21K |    0 |      |
--------------------------------------------+-----------------------------------+
--------------------------------------------+-----------------------------------+

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.