ORA-00600: internal error code, arguments: [krvuffl_5]

Recently, I started getting ORA-00600: internal error code, arguments: [krvuffl_5], error on my Logical Standby database. Standby Apply processes use to crash, with following error trace in alert.log

Errors in file /u02/app/oracle/admin/STDBYDB/bdump/stdbydb2_lsp0_25282.trc:
ORA-12801: error signalled in parallel query server P001, instance drdb2:STDBYDB2 (2)
ORA-00600: internal error code, arguments: [krvuffl_5], [14416], [45376], [], [], [], [], []
Fri Sep 26 07:06:57 2008
TLCR process death detected. Shutting down TLCR
logminer process death detected, exiting logical standby
LOGSTDBY Analyzer process P006 pid=100 OS id=13263 stopped
LOGSTDBY Apply process P010 pid=104 OS id=13279 stopped
LOGSTDBY Apply process P007 pid=101 OS id=13265 stopped

This behaviour was seen, when large transactions were getting applied. Metalink ORA-600 lookup tool did not returned any results for krvuffl_5 argument.

In the trace file, following stack trace(s) was generated at different times.

ksedmp()<-kgerinv()<-kgeasnmierr()<-krvuffl()<-krvuftl()<-krvxbtpp_TransferTx
<-PublicQ()<-krvxmrs2()<-krvxmrs()<-kxfprdp()<-opirip()
<-opidrv()<-sou2o()<-opimai_real()<-main()<-start()


——————————————————————————-

ksedmp()<-kgerinv()<-kgeasnmierr()<-krvuffl()<-krvuftl()<-krvxbtpp_TransferTx
<-PublicQ()<-krvxbuild()<-krvxmrs2()<-krvxmrs()<-kxfprdp()<-opirip()
<-opidrv()<-sou2o()<-opimai_real()<-main()<-start()

Following are most probable reasons, if you are hittng this error

1. Over sizing of LCR cache (SGA_MAX parameter).

Although according to documentation we can set it up to 4G (10gR2 onwards), it starts creating problems for large transactions. Setting the value in the range of 2-3G worked for me.

2. Check if the SYSAUX TBS (default Log Miner tablespace) or dedicated TBS created for Log Miner, is running out of space.

Check following link for more details for “Changing default tablespace for LogMiner”
https://oraclehandson.wordpress.com/2008/09/23/how-to-change-default-tablespace-for-logminer-tables-in-oracle-streams/

Advertisements
This entry was posted in Oracle ORA-600 errors and tagged . Bookmark the permalink.

One Response to ORA-00600: internal error code, arguments: [krvuffl_5]

  1. Thanks for the info. It helped me solve the same Logical Standby problem.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s