Logical Standby fails with ORA-01722: Invalid Number (Doc ID 2082298.1)

Last updated on DECEMBER 13, 2015

Applies to:

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

Symptoms

Logical Standby database returns ORA-01722 in alert.log

 

The Standby alert.log shows:

  Thu Nov 12 10:31:10 2015

  Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_lsp0_10799.trc:

  ORA-26808: Apply process AS01 died unexpectedly.

  ORA-01722: invalid number

 

 

The corresponding Trace file shows something similar to:

knasplcr: eager error was not rolled back

++ LCR Dump Begin: 0x7f5ae82d7d58 - update
op: 3, Original op: 3, baseobjn: 110682, objn: 110690, objv: 2
DF: 0x00000003, DF2: 0x00004010, MF: 0x00020810, MF2: 0x00000000
PF: 0x00000000, PF2: 0x0c00a000, PF3: 0x00000000
MergeFlag: 0x00, FilterFlag: 0x00
Id: 0, iotPrimaryKeyCount: 0, numChgRec: 6, NumCrSpilled: 0
RedoThread#: 1, rba: 0x0002d1.002af23b.00f4, PDB Id: 0, PDB Uid: 0, MetaDataHdl: 0x1
xid: 0x00a7.021.00000b30 chunk[11] , parentxid: 0x00a7.021.00000b30
proxyxid: 0x0000.000.00000000
scn: 0x0000.0eb86021, LID: (scn: 0x0000.00000000, scn_sqn: 0, lcr_sqn: 0)
ncol: 0 newcount: 38, oldcount: 39
LUBA: 0x4.11fd418.21.18.3.1b062
++ LCR Dump Begin: 0x25aa43d08 - commitop: 7, Original op: 7, baseobjn: 0, objn: 0, objv: 0
DF: 0x00000002, DF2: 0x00000010, MF: 0x00220000, MF2: 0x02000000
PF: 0x00000000, PF2: 0x00040000, PF3: 0x00000000
MergeFlag: 0x03, FilterFlag: 0x00
Id: 0, iotPrimaryKeyCount: 0, numChgRec: 0, NumCrSpilled: 0
RedoThread#: 1, rba: 0x0002d1.002afe42.019c, PDB Id: 0, PDB Uid: 0, MetaDataHdl: 0x1
xid: 0x00a7.021.00000b30 chunk[11] , parentxid: 0x00a7.021.00000b30
proxyxid: 0x00a7.021.00000b30
scn: 0x0000.0eb86082, LID: (scn: 0x0000.0eb86082, scn_sqn: 1, lcr_sqn: 1)
ncol: 0 newcount: 0, oldcount: 0
LUBA: 0x4.11fd418.21.29.3.0
LOGSTDBY: SQL Apply about to stop with ORA-1722

 

   

Changes

 N/A

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