Oracle 10g toad view tablespace error ORA-00600 internal error code arguments [ktfbhget-4], [6], [5]

 

Toad 10.6 queries the Oracle 10g tablespace. The following message is displayed on the toad return page:

Selectprivileges on following are required: dba_data_files, dba_free_space, V $ temp_space_header, V $ temp_extent_pool, dba_temp_files.

 

Check the alert log of the database:

Fri Jun 3 00:05:46 2011

Errors in file/u01/APP/Oracle/admin/dave1/udump/dave1_ora_21187.trc:

ORA-00600: Internal error code, arguments: [ktfbhget-4], [6], [5], [], [], [], [], [], []

Fri Jun 300: 09: 37 2011.

ORA-1000 encountered when generating server alertSMG-3503

Fri Jun 300: 10: 41 2011.

Errors in file/u01/APP/Oracle/admin/dave1/udump/dave1_ora_21187.trc:

ORA-00600: Internal error code, arguments: [ktfbhget-4], [6], [5], [], [], [], [], [], []

Fri Jun 3 00:12:48 2011

Errors in file/u01/APP/Oracle/admin/dave1/udump/dave1_ora_21187.trc:

ORA-00600: Internal error code, arguments: [ktfbhget-4], [6], [5], [], [], [], [], [], []

Fri Jun 3 00:16:40 2011

ORA-1000 encountered whengenerating server alert SMG-3503

Take a look at the trace file:

[Oracle @ db1 bdump] $ head-100/u01/APP/Oracle/admin/dave1/udump/dave1_ora_21187.trc

/U01/APP/Oracle/admin/dave1/udump/davegion ora_21187.trc

Oracle Database 10g enterprise editionrelease 10.2.0.1.0-Production

With the partitioning, OLAP and data miningoptions

ORACLE_HOME =/u01/APP/Oracle/product/10.2.0/db_1

System name: Linux

Node name: db1

Release: 2.6.18-164. el5xen

Version: #1 SMP Tue Aug 18 16:06:30 EDT 2009

MACHINE: i686

Instance name: dave1

Redo thread mounted by this instance: 1

Oracle process number: 17

UNIX process PID: 21187, image: oracledave1 @ db1

 

* ** Action name :() 00:05:46. 731

* ** Module name :( toad 10.6.0.42) 2011-06-0300: 05: 46.731

* ** Service name :( dave1) 2011-06-0300: 05: 46.731

* ** Session ID: (151.46) 2011-06-0300: 05: 46.731

* ** 00:05:46. 731

Ksedmp: internal or fatalError

ORA-00600: Internal error code, arguments: [ktfbhget-4], [6], [5], [], [], [], [], [], []

Current SQL statement for this session:

Select a. tablespace_name,

Round (A. bytes_alloc/1024/1024) megs_alloc,

Round (nvl (B. bytes_free, 0)/1024/1024) megs_free,

Round (A. bytes_alloc-nvl (B. bytes_free, 0)/1024/1024) megs_used,

Round (nvl (B. bytes_free, 0)/A. bytes_alloc) * 100) pct_free,

100-round (nvl (B. bytes_free, 0)/A. bytes_alloc) * 100) pct_used,

Round (maxbytes/1048576) max

From (select F. tablespace_name,

Sum (F. bytes) bytes_alloc,

Sum (decode (F. autoextensible, 'yes', F. maxbytes, 'No', F. bytes) maxbytes

From dba_data_files F

Group by tablespace_name),

(Select F. tablespace_name,

Sum (F. bytes) bytes_free

From dba_free_space F

Group by tablespace_name) B

Where a. tablespace_name = B. tablespace_name (+)

Union all

Select H. tablespace_name,

Round (sum (H. bytes_free + H. bytes_used)/1048576) megs_alloc,

Round (sum (H. bytes_free + H. bytes_used)-nvl (P. bytes_used, 0)/1048576) megs_free,

Round (sum (nvl (P. bytes_used, 0)/1048576) megs_used,

Round (sum (h. bytes_free + H. bytes_used)-nvl (P. bytes_used, 0)/sum (H. bytes_used + H. bytes_free) * 100) pct_free,

100-round (sum (h. bytes_free + H. bytes_used)-nvl (P. bytes_used, 0)/sum (H. bytes_used + H. bytes_free) * 100) pct_used,

Round (sum (F. maxbytes)/1048576) max

From SYS. V _ $ temp_space_header H, SYS. V _ $ temp_extent_poolp, dba_temp_files F

Where p. file_id (+) = H. file_id

And P. tablespace_name (+) = H. tablespace_name

And F. file_id = H. file_id

And F. tablespace_name = H. tablespace_name

Group by H. tablespace_name

Order by 1

----- Call stack trace -----

Calling call entry argument values in hex

Location Type Point (? Means dubious value)

----------------------------------------------------------------------------

Ksedst () + 27 call ksedst1 () 0? 1?

Ksedmp () + 557 call ksedst () 0? Bf000000? 0? 0?

Bfe161c8? 9749978?

...

 

-- First look at the ORA-1000 Error

[Oracle @ db1 u01] $ oerr ora 1000

01000,000 00, "maximum open cursorsexceeded"

// * Cause:

// * Action:

 

SQL> show parameter open_cursors

Name type value

-----------------------------------------------------------------------------

Open_cursors integer 300

SQL>

 

SQL> select name, value, display_valuefrom v $ parameter where name like '% cursor % ';

NAME value display_value

-------------------------------------------------

Cursor_space_for_time False false

Session_cached_cursors 20 20

Cursor_sharing exact

Open _cursors 5000 5000

 

SQL> select count (*) fromv $ open_cursor;

Count (*)

----------

5115

 

SQL> alter system setopen_cursors = 10000 scope = both;

System altered.

SQL> show parameteropen_cursors

Name type value

-----------------------------------------------------------------------------

Open_cursors integer 10000

 

After modification, the problem persists.

 

When you view dba_data_files, an error is returned:

SQL> select * fromdba_data_files;

Error:

ORA-00600: Internal errorcode, arguments: [ktfbhget-4], [6], [5], [], [], [],

[], []

No rows selected

 

According to the definition of the dba_data_files view, it is determined that the x $ tkfbhc dictionary has a problem.

SQL> select text from dba_views whereview_name = 'dba _ data_files ';

 

SQL> select * from x $ ktfbhc;

Error:

ORA-00600: Internal error code, arguments: [ktfbhget-4], [6], [5], [], [], [], [], [], []

No rows selected

 

The name of this dictionary is the same as the first parameter name in our ORA-600. The x $ ktfbhc object is the kernel tablespace file bitmapheader control, which records the Bitmap header control information of the local tablespace.

 

After studying for a long time, I failed to solve this problem. I am connected by a sys user, so the permission issue is unlikely. After searching for MOS for half a day, ktfbhget has some bugs. I searched the ktfbhget-4 and there was no result. I guess this 4 may represent the file No of datafile.

This library is my test library, DB version 10.2.0.1, OS Version: RedHat 5.4. I wanted to clarify this problem, but it is beyond my current capabilities. Finally, the database is rebuilt.

Some problems still need to be studied in depth.

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 chat group: 40132017 chat group 2: 69087192

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.