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 FEBRUARY 17, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.2 and laterInformation 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
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 =$ORACLE_BASE/cfgtoollogs/dbua/<SID>/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
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$ORACLE_BASE/admin/<SID>/udump/<SID>_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 =$ORACLE_BASE/product/10.2.0
System name: SunOS
Node name: hostname
Release: 5.10
Version: Generic_147440-25
Machine: sun4v
Instance name: <SID>
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 1008, image: oracle@hostname (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
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME =$ORACLE_BASE/product/10.2.0
System name: SunOS
Node name: hostname
Release: 5.10
Version: Generic_147440-25
Machine: sun4v
Instance name: <SID>
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 1008, image: oracle@hostname (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
<- strlen <- ndoprnt <- vsnprintf <- vsyslog <- syslog
<- kzasydmp <- opiosq0 <- kpooprx <- kpoal8 <- opiodr
<- ttcpip <- opitsk <- opiino <- opiodr <- opidrv
<- sou2o <- opimai_real <- main <- start
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! |
In this Document
Symptoms |
Cause |
Solution |
References |