Question

Oracle trace file error

  • 15 July 2020
  • 2 replies
  • 746 views

Userlevel 4
Badge +9

Hi All,

 

I was just wondering if anyone has seen this trace log error before, and how to fit it? 

 

Trace file C:\APP\diag\rdbms\ifsl9\ifsl9\trace\ifsl9_q004_5240.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Windows NT Version V6.2  
CPU                 : 8 - type 8664, 8 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:26114M/65535M, Ph+PgF:27936M/75263M 
VM name             : VMWare Version (6)
Instance name: ifsl9
Redo thread mounted by this instance: 1
Oracle process number: 237
Windows thread id: 5240, image: ORACLE.EXE (Q004)


*** 2020-07-14 13:45:03.084
*** SESSION ID:(495.41833) 2020-07-14 13:45:03.084
*** CLIENT ID:() 2020-07-14 13:45:03.084
*** SERVICE NAME:(SYS$BACKGROUND) 2020-07-14 13:45:03.084
*** MODULE NAME:(Streams) 2020-07-14 13:45:03.084
*** CLIENT DRIVER:() 2020-07-14 13:45:03.084
*** ACTION NAME:(QMON Slave) 2020-07-14 13:45:03.084
 
Dumping Short Stack
ksedsts()+320<-kcbgtcr()+32206<-ktrgtc2()+838<-kdiixs1()+1586<-kwqmsiots()+114<-kwqmScanScIndexSeg()+384<-kwqitFreeIndexBlocks()+631<-kwqitremb()+5251<-kwqitmmit()+4372<-kwqitmmsgs()+3476<-kwqitptmcb()+2330<-kwqitptm()+4833<-kwqmnslv()+1371<-kwsbsmspm()+2278
<-kwsbgcbkms()+16<-ksvrdp()+2673<-opirip()+861<-opidrv()+809<-sou2o()+94<-opimai_real()+208<-opimai()+170<-BackgroundThreadStart()+681<-00007FFFF17813D2<-00007FFFF40B54F4
kwqitremb: Error 8103 in Queue Table IFSAPP.BATCH_PROC_QUEUE_TAB
kwqicaclcur: Error 8103
             Cursor Session Number : 547
             Cursor Session Serial : 36599
             Cursor Pin     Number : 16801800
kwqitmmit during kwqitmmit:end proc: Error 8103 in Queue Table IFSAPP.BATCH_PROC_QUEUE_TAB
kwqitptmcb: error 8103 encountered during serving 111263
KSV 8103 error in slave process

*** 2020-07-14 13:45:03.207
ORA-08103: object no longer exists
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-08103: object no longer exists
 

Regards,

 

Gary 


2 replies

Userlevel 4
Badge +9

I think it might be due to an index corruption but need to look into this. 

Userlevel 7
Badge +18

http://www.dba-oracle.com/t_ora_08103_object_no_longer_exists.htm

 

Cause: The object has been deleted by another user since the operation began.  Or a prior incomplete recovery restored the database to a point in time during the deletion of the object  

Action: Remove references to the object or delete the object if this is the result of an incomplete recovery.

Reply