Skip to main content
Question

Oracle trace file error


Forum|alt.badge.img+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

Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 66 replies
  • July 16, 2020

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


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 534 replies
  • July 16, 2020

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings