ORA-00600: problem with internalerrorcode, arguments..
ORA-00600: problem with internal error code, arguments.. the Symptoms: When querying the wwl005 table, an internal error is reported. We just performed inconsistency recovery for this table, and then the following error is reported in the query. This phenomenon is generally caused by bugs or bad blocks. 15:43:53 SQL> select * from wwl005; select * from wwl005 * ERROR at line 1: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], [] Analysis failure: First check the alert log and find that there is an error, but it is not clear: Errors in file /DBSoft/admin/WWL/udump/wwl_ora_4724.trc: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], [] www.2cto.com the Then check the corresponding trace file to see: [root@wwldb ~]# cat /DBSoft/admin/WWL/udump/wwl_ora_4724.trc |more Dump file /DBSoft/admin/WWL/udump/wwl_ora_4724.trc Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /DBSoft/product/10.2.0/db_1 System name: Linux Node name: wwldb.localdomain Release: 2.6.18-164.el5 Version: #1 SMP Thu Sep 3 02:16:47 EDT 2009 Machine: i686 Instance name: WWL Redo thread mounted by this instance: 1 Oracle process number: 12 Unix process pid: 4724, image: [email protected] (TNS V1-V3) *** ACTION NAME: () 2012-07-10 15:44:04.239 *** MODULE NAME: (SQL*Plus)…
ORA-00600: problem with internalerrorcode…
ORA-00600: problem with internal error code… the Tonight, there was a problem with remote support. I was a little dumbfounded when I first saw the 600 error. the And the on-site staff reminded that the login to sqlplus was also very slow. Finally, the reason was found. the turn out to be: www.2cto.com /etc/hosts the /etc/sysconfig/network the The host names under these two files are inconsistent. After modification, everything is normal. the the Author huang_xw
