ORA-07445: exception encountered: core dump [strlen()+24][SIGSEGV] while executing utlu(nnn)i.sql or when DBUA executing preupgrade script (Doc ID 1520710.1)

Last updated on MAY 02, 2014

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Executing pre-upgrade utlu112i.sql script exits with error

SQL> @utlu112i.sql
SQL> SET ECHO OFF FEEDBACK OFF PAGESIZE 0 LINESIZE 100;
ERROR:
ORA-03114: not connected to ORACLE


DECLARE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


ERROR:
ORA-03114: not connected to ORACLE

 

OR if you are using DBUA it exits with error ora-03114 error and aborts the upgrade.  Upgrade trace.log file contains

[Thread-12] [ 2013-01-17 14:00:08.036 CST ] [SQLEngine.spoolOff:2013]  Setting spool off = /usr/apps/oracle/cfgtoollogs/dbua/lcon10g/upgrade12/upgrade.xml
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-03114: not connected to ORACLE

    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1005)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)
    at oracle.sysman.assistants.dbma.backend.CompManager.executeServerUtility(CompManager.java:1867)
    at oracle.sysman.assistants.dbma.backend.CompManager.doPreMigrationChecks(CompManager.java:2951)
    at oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:4136)
    at oracle.sysman.assistants.dbma.ui.DatabasesPage.doProcessing(DatabasesPage.java:810)
    at oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:187)
    at java.lang.Thread.run(Thread.java:595)
[Thread-12] [ 2013-01-17 14:00:08.044 CST ] [SQLEngine.done:2167]  Done called

 
The following message is seen in alert log.

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

 

udump trace file contains

Dump file /usr/apps/oracle/admin/lcon10g/udump/lcon10g_ora_1008.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /usr/apps/oracle/product/10.2.0
System name:    SunOS
Node name:    txslnocwpdv2a
Release:    5.10
Version:    Generic_147440-25
Machine:    sun4v
Instance name: lcon10g
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 1008, image: oracle@txslnocwpdv2a (TNS V1-V3)

*** SERVICE NAME:(SYS$USERS) 2013-01-17 14:00:03.665
*** SESSION ID:(159.46) 2013-01-17 14:00:03.665
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x38001d, PC: [0xffffffff7c13c718, strlen()+24]
*** 2013-01-17 14:00:03.669
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [strlen()+24] [SIGSEGV] [Address not mapped to object] [0x00038001D] [] []
Current SQL statement for this session:
DECLARE
-- *****************************************************************
-- Release Specific Constants
-- These constants must be updated for each new patch release
-- *****************************************************************
  utlu_banner      CONSTANT VARCHAR2(50) := 'Oracle Database 11.2 Pre-Upgrade Information Tool ';
  utlu_support_ver CONSTANT VARCHAR2(40) := '9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0';
  utlu_version     CONSTANT VARCHAR2(30) := '11.2.0.2';
  utlu_patchset    CONSTANT VARCHAR2(3)  := '.0';
  utlu_buildrev    CONSTANT VARCHAR2(3)  := '001';
  utlu_tz_version  CONSTANT NUMBER := 14;  -- Match with catupstr.sql

call stack is

ksedmp <- ssexhd <- sighndlr <- call_user_handler <- sigacthandler
      <- strlen <- ndoprnt <- vsnprintf <- vsyslog <- syslog
       <- kzasydmp <- opiosq0 <- kpooprx <- kpoal8 <- opiodr
        <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv
         <- sou2o <- opimai_real <- main <- start

 

 

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