Home > DBA > ORA-600[qsmmixInitKey-2]) detected

ORA-600[qsmmixInitKey-2]) detected

 

I encountered several times this week a critical incident alert in Enterprise Manager as generic internal error notifying for Internal error (ORA-600[qsmmixInitKey-2]) detected in alert\log.xml file.

After investigation it turned out that the reason can be in SQL Tuning Advisor.

The database is 11.2.0.1 . I have Automatic Maintenance Tasks configured and the Automatic SQL Tuning is also enabled.

 

 

 

 

 

 

 

You can refer to Metalink  [ID 9602359.8] that gives overview of this Bug 9602359  OERI[qsmmixInitKey-2] using SQL Tuning Advisor.

Version confirmed as being affected is 11.1.0.7 and 11.2.0.1 for most platforms. In my case the production database is 11.2.0.1. The symptom is occurring internal ORA-600 [qsmmixInitKey-2]. Metalink says that this error can occur when SQL being tuned has duplicate columns. This issue is fixed in 11.2.0.2(Server Patch Set).

In my case I temporary disabled Automatic SQL Tuning and start planning the upgrade to 11.2.0.2.

 

 

 

 

 

BEGIN
dbms_auto_task_admin.disable(client_name => 'sql tuning advisor', operation => NULL, window_name => NULL);
END;

 

This week I had one successful upgrade from  11.2.0.1 to 11.2.0.2 for Database and Grid Infrastructure on RHEL5.

 

This time I will plan and do the upgrade but on Windows Platform.

 

Cheers,
Maria

 

 

About these ads
Categories: DBA
  1. Julian Dontcheff
    March 21, 2011 at 11:48 am

    Interesno dali tova e bug 5309690 ili bug 9602359. I kakvi sa tezi duplicated koloni? Internalni v Oracle ili stava na vapros za SQL koito se tunva?

  2. March 21, 2011 at 12:33 pm

    duplicated coloni v smisul che imash edni i sushti koloni izbroeni v selecta, koito se tune-va.

  1. No trackbacks yet.

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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: