Pages

Sunday, April 17, 2016

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

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

ERROR:
Format: ORA-600 [ktsxtffs2]

When tried to search this error on the metalink with ORA lookup tool. It redirected to the following note.

ORA-600 [ktsxtffs2] [ID 1229336.1]

Its available in the Note ID: 153788.1 (Lookup Tool)

entered the following details in respective fields:

after entering these details, just click the Lookup Error button.

The above note reports the following bug.

Bug 8223165 – ORA-600 [ktsxtffs2] During Startup When Using Temporary Tablespace Group [ID 8223165.8]

The bug says:

Fixed:

This issue is fixed in * 12.1 (Future Release)

Symptoms:

-Internal Error May Occur (ORA-600)
-ORA-600 [ktsxtffs2]
-ORA-600 [kghstack_free1]
-Instance Startup

SMON will report ORA-600 [ktsxtffs2] and/or ORA-600 [kghstack_free1] when starting the database.

Solution:

Checked and found that a temporary tablespace group was being used.

SQL> select GROUP_NAME,TABLESPACE_NAME from DBA_TABLESPACE_GROUPS;

ROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEMP                           TEMP1
TEMP                           TEMP2

SQL> select property_name, property_value from database_properties where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

PROPERTY_NAME                                          PROPERTY_VALUE
-------------                                          --------------
DEFAULT_TEMP_TABLESPACE                                TEMP

Please note that you can either have a “default tablespace group” or a “default tablespace” at a time. You can not have both at the same time.

There is no theoretical maximum limit to the number of tablespaces in a tablespace group, but it must contain at least one. The group is implicitly dropped when the last member is removed.

SQL> ALTER TABLESPACE TEMP1 TABLESPACE GROUP '';

Tablespace altered.

SQL> ALTER TABLESPACE TEMP2 TABLESPACE GROUP '';

ALTER TABLESPACE TEMP2 TABLESPACE GROUP ''

*
ERROR at line 1:

ORA-10919: Default temporary tablespace group must have at least one tablespace

The last member of a group cannot be removed if the group is still assigned as the default temporary tablespace. So we need to change the “default” from tablespace group “TEMP” to the tablespace “TEMP1”.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;
Database altered.

SQL> ALTER TABLESPACE TEMP2 TABLESPACE GROUP '';
Tablespace altered.

Once all the members have been removed from the group, the group is automatically dropped from the database.

SQL> select GROUP_NAME from DBA_TABLESPACE_GROUPS;
no rows selected

Reference metalink Doc
Note ID: 153788.1
Note ID: 8223165.8

No comments:

Post a Comment