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

Our database is running 11.2.0.4 and suddenly we got the issue.
the error occurred during refresh of materialized view, its been running for a while and suddenly its having issue during refresh.

here is the error on the alert log.

 
Errors in file /opt/app/oracle/diag/rdbms/cxxxa/CXXXA/trace/CXXXA_ora_1686.trc (incident=1985798):
ORA-00600: internal error code, arguments: [kkqvmRmViewFromLst1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/app/oracle/diag/rdbms/cxxxa/CXXXA/incident/incdir_1985798/CXXXA_ora_1686_i1985798.trc
Sat Oct 11 14:12:41 2014 

as per oracle its a known bug on 11.2.0.4 and not patch available for 11.2.0.4 they just given a work around.

 
1. create a view on the select statement on materialized view
2. create/refresh the materialized view and using the view created earlier.

for now it is working for us. here’s a note from oracle support:

 
Based on the symptoms and call stack trace, your issue seems similar to Bug 17345064 : XF12.1.0.2APPLY - TRC - KKQVMRMVIEWFROMLST, which is in status 11, still being worked by Oracle Development team. 

thanks for visiting..

Advertisements

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