My Oracle Support Banner

Ora-07445 [strlen] when Managed Standby Recovery (Doc ID 1394361.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.

Symptoms


When we try activate standby site by using following command

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

The following error noted in the alert log file

ORA-07445: exception encountered: core dump [FFFFFFFF7DC3D4AC]
Recovery interrupted.

Analyzing the alert log file shows:
Mon Jan 9 14:20:35 2012
Errors in file /<path>/bdump/<oracle_sid>_mrp0_5125.trc:
ORA-07445: exception encountered: core dump [FFFFFFFF7DC3D4AC] [SIGSEGV] [Address not mapped to object] [0x0001033FB] [] []
Mon Jan 9 14:21:36 2012
Recovery interrupted.
...
Tue Jan 10 10:04:24 2012
Errors in file /<path>/bdump/<oracle_sid>_mrp0_5481.trc:
ORA-07445: exception encountered: core dump [FFFFFFFF7DC3D4AC] [SIGSEGV] [Address not mapped to object] [0x0001033FB] [] []
Tue Jan 10 10:04:25 2012
Completed: ALTER DATABASE RECOVER managed standby database d
Tue Jan 10 10:04:49 2012
Recovery interrupted.

Analyzing the trace file shows:
/<path>/bdump/<oracle_sid>_mrp0_2766.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /oracle
System name: <system_name>
Node name: <node>
Release: 5.9
Version: Generic_122300-42
Machine: <machine>
Instance name: LIVE
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 2766, image: oracle@<service> (MRP0)

*** SESSION ID:(15.1) 2012-01-11 10:11:24.850
Background Managed Standby Recovery process started <----showing managed standby recovery started
Start recovery at thread 1 ckpt scn 29763430232 logseq 73473 block 26842
*** 2012-01-11 10:11:30.046
Managed Recovery: Active posted.
*** 2012-01-11 10:11:30.121
Media Recovery Log /<path>/<oracle_sid>_%s.arc_1_73473.arc <--media recovery log
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x1033fb, PC: [0xffffffff7dc3d4ac, FFFFFFFF7DC3D4AC]
*** 2012-01-11 10:11:30.122
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [FFFFFFFF7DC3D4AC] [SIGSEGV] [Address not mapped to object] [0x0001033FB] [] []

SO: 49977b738, type: 4, owner: 4996c6d10, flag: INIT/-/-/0x00
(session) trans: 0, creator: 4996c6d10, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0001-000E-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, sql: 0, psql: 0, user: 0/SYS
last wait for 'control file sequential read' blocking sess=0x0 seq=202 wait_time=14
file#=0, block#=10b, blocks=1 <-----------------wait on control file sequential read

Changes

----- Call Stack Trace -----
ksedmp # KSE: dump the process state
ssexhd # ** DUMP ROUTINE - IGNORE stuff above this on the stack **
sigacthandler
strlen kkfsapp: append constant text to SQL string *
doprnt
vsnprintf
ksdfmw internal macro used as a wrapper for SOSD sdpri() routine: */
ksdwra KSD: Like (ksd)wrt, but writes data to alert file only.
kcrrfmw
kcrrwra
krddmr
kcvmdp
ksbrdp KSB: run a detached (background) process
opirip # Oracle Program Interface Run Independent Process (IGNORE)
opidrv # opidrv - ORACLE Program Interface DRiVer (IGNORE)
sou2o # Main Oracle executable entry point
main # Standard executable entry point
start # C program entry point (IGNORE)

ksedmp <- ssexhd <- sigacthandler <- strlen <- doprnt
<- vsnprintf <- ksdfmw <- ksdwra <- kcrrfmw <- kcrrwra
<- krddmr <- kcvmdp <- ksbrdp <- opirip <- opidrv
<- sou2o <- 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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.