Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ora-1405 in alert log

SaadLiaqatSep 14 2014 — edited Sep 15 2014

Dear Gurus,

I am continuously getting an error in my alert log file, below is the trace file

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

System name:    Linux

Node name:      gsm-rac2.gsm.moi.sa

Release:        2.6.18-274.el5

Version:        #1 SMP Fri Jul 8 17:36:59 EDT 2011

Machine:        x86_64

Instance name: mcnggsm5

Redo thread mounted by this instance: 12

Oracle process number: 107

Unix process pid: 2572, image: oracle@gsm-rac2.gsm.moi.sa (Q003)

*** 2014-09-09 08:47:17.958

*** SESSION ID:(2521.54085) 2014-09-09 08:47:17.958

*** CLIENT ID:() 2014-09-09 08:47:17.958

*** SERVICE NAME:(SYS$BACKGROUND) 2014-09-09 08:47:17.958

*** MODULE NAME:(STREAMS) 2014-09-09 08:47:17.958

*** ACTION NAME:(QMON Slave) 2014-09-09 08:47:17.958

kwqdlScanDeqLog during stmt fetch: retval -1, errnum 1405, errbuf ORA-01405: fetched column value is NULL

kwqitmmit during kwqitmmit:deq log proc: Error 1405 in Queue Table SYS.SYS$SERVICE_METRICS_TAB

kwqicaclcur: Error 1405

             Cursor Session Number : 2505

             Cursor Session Serial : 16173

             Cursor Pin     Number : 24585

kwqitmmit during kwqitmmit:end proc: Error 1405 in Queue Table SYS.SYS$SERVICE_METRICS_TAB

kwqitptm: error 1405 encountered during serving 12863

KSV 1405 error in slave process

*** 2014-09-09 08:47:18.354

ORA-01405: fetched column value is NULL

ORA-01405: fetched column value is NULL

OPIRIP: Uncaught error 447. Error stack:

ORA-00447: fatal error in background process

ORA-01405: fetched column value is NULL

ORA-01405: fetched column value is NULL

Trace file /u01/app/oracle/diag/rdbms/mcnggsm/mcnggsm5/trace/mcnggsm5_q003_2572.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

System name:    Linux

Node name:      gsm-rac2.gsm.moi.sa

Release:        2.6.18-274.el5

Version:        #1 SMP Fri Jul 8 17:36:59 EDT 2011

Machine:        x86_64

Instance name: mcnggsm5

Redo thread mounted by this instance: 12

Oracle process number: 158

Unix process pid: 2572, image: oracle@gsm-rac2.gsm.moi.sa (Q003)

Can you help me figure out how I can fix this error.

Thanks

Saad

This post has been answered by Srini Chavali-Oracle on Sep 14 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2014
Added on Sep 14 2014
2 comments
1,428 views