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

Last updated on JUNE 05, 2015

Applies to:

Oracle Server - 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 /oracle/admin/db/bdump/db_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 /oracle/admin/db/bdump/db_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:
/oracle/admin/db/bdump/db_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: SunOS
Node name: xyz
Release: 5.9
Version: Generic_122300-42
Machine: sun4u
Instance name: LIVE
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 2766, image: oracle@xyz (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 /backups/dbarchive/stby_db_%s.arcLIVE_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

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