ORA-00600: internal error code, arguments: [ktsapsblk-1]

Hello all,
Had this ORA-600?

ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []

Investigating on issue:


Alert Log:

Wed Mar 29 22:01:04 2017
Errors in file /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc  (incident=56945):
ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56945/PRODDB_j001_44375_i56945.trc
Errors in file /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc  (incident=56946):
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56946/PRODDB_j001_44375_i56946.trc
Wed Mar 29 22:01:07 2017
Trace dumping is performing id=[cdmp_20170329220107]
Wed Mar 29 22:01:08 2017
Sweep [inc][56945]: completed
Sweep [inc2][56945]: completed
Wed Mar 29 22:01:08 2017
Sweep [inc][56946]: completed
Sweep [inc2][56946]: completed
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

You already saw that I left the auto task ending there, right? You’ll see. 🙂

Trace: /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc

Trace file /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/app/product/11.2.0/
System name:    Linux
Node name:      DBSERVER.domain.com
Release:        2.6.32-431.el6.x86_64
Version:        #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine:        x86_64
Instance name: PRODDB
Redo thread mounted by this instance: 1
Oracle process number: 118
Unix process pid: 44375, image: oracle@DBSERVER.domain.com (J001)


*** 2017-03-29 22:00:05.312
*** SESSION ID:(1167.61110) 2017-03-29 22:00:05.312
*** CLIENT ID:() 2017-03-29 22:00:05.312
*** SERVICE NAME:(SYS$USERS) 2017-03-29 22:00:05.312
*** MODULE NAME:(DBMS_SCHEDULER) 2017-03-29 22:00:05.312
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_3987) 2017-03-29 22:00:05.312

  status=(pst=SUCCESS)
**************************************************************
Execution Statistics
  Exec count:         1
  CR gets:            16408
  CU gets:            0
  Disk Reads:         0
  Disk Writes:        0
  IO Read Requests:   0
  IO Write Requests:  0
  Bytes Read:         0
  Bytes Written:      0
[...]
Execution Statistics
  Exec count:         1
  CR gets:            504
  CU gets:            0
  Disk Reads:         0
  Disk Writes:        0
  IO Read Requests:   0
  IO Write Requests:  0
  Bytes Read:         0
  Bytes Written:      0
  Bytes Exchanged with Storage:  0
  Bytes Exchanged with Disk:  0
  Bytes Simulated Read:  0
  Bytes Simulated Returned:  0
  Elapsed Time: 757 (us)
  CPU Time: 799 (us)
  User I/O Time: 0 (us)
  status=(pst=ERROR)

*** 2017-03-29 22:01:04.987
Incident 56945 created, dump file: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56945/PRODDB_j001_44375_i56945.trc
ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []

Incident 56946 created, dump file: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56946/PRODDB_j001_44375_i56946.trc
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []

 

OK, don’t worry!
This is a know issue described as per MOS ORA-600:internal Error Code, Arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], [] (Doc ID 1490663.1).

It applies to 11.2.0.1 to 11.2.0.3, being fixed on 11.2.0.4. There is also patch 13814203 for 11.2.0.3, but need a port request if you are in different PSU.

The workaround?
Easy, disable SQL Running Advisor Task:

SQL> SELECT client_name, status FROM dba_autotask_operation;

CLIENT_NAME                                                      STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection                                  ENABLED
auto space advisor                                               ENABLED
sql tuning advisor                                               ENABLED

SQL> exec dbms_auto_task_admin.disable('sql tuning advisor',NULL,NULL)

PL/SQL procedure successfully completed.

SQL> SELECT client_name, status FROM dba_autotask_operation;

CLIENT_NAME                                                      STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection                                  ENABLED
auto space advisor                                               ENABLED
sql tuning advisor                                               DISABLED

See you next week!

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