Home » Infrastructure » Linux » ORA-00600/00601/00604/01001
ORA-00600/00601/00604/01001 [message #98725] Wed, 28 August 2002 05:04 Go to next message
Keshav Tripathy
Messages: 30
Registered: November 2001
Member
Dear All
I am running Oracle 9i on Linux Red Hat 7.1 on Intel
Suddenly I found that I am unable to get connection
to my database. I have look into the alert log and
have found the Error Messages Associated with ORA-
00600/00601/00604/01001. Here I am giving the content
of the alertlog.
******************************************************
Tue Jul 30 14:33:53 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Tue Jul 30 16:21:17 2002
Thread 1 advanced to log sequence 45
Current log# 2 seq# 45 mem# 0: /home/oracle/oradata/gemico/redo02.log
Thu Aug 1 15:45:01 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Fri Aug 2 11:50:19 2002
Thread 1 advanced to log sequence 46
Current log# 3 seq# 46 mem# 0: /home/oracle/oradata/gemico/redo03.log
Tue Aug 6 00:29:26 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Tue Aug 6 11:38:20 2002
Thread 1 advanced to log sequence 47
Current log# 1 seq# 47 mem# 0: /home/oracle/oradata/gemico/redo01.log
Fri Aug 9 11:34:11 2002
Thread 1 advanced to log sequence 48
Current log# 2 seq# 48 mem# 0: /home/oracle/oradata/gemico/redo02.log
Fri Aug 9 23:37:31 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Sat Aug 10 13:46:06 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:01:36 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:01:39 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:01:57 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:03:00 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:05:23 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:05:31 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Sat Aug 10 14:07:57 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Tue Aug 20 17:51:31 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Wed Aug 21 12:37:45 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[17274]], [[4]], [[]], [[]], [[]], [[]], [[]], [[]]
Wed Aug 21 12:38:58 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[17274]], [[4]], [[]], [[]], [[]], [[]], [[]], [[]]
Wed Aug 21 12:55:46 2002
Thread 1 advanced to log sequence 49
Current log# 3 seq# 49 mem# 0: /home/oracle/oradata/gemico/redo03.log
Wed Aug 21 14:39:55 2002
Errors in file /home/oracle/admin/gemico/bdump/s002_10763.trc:
ORA-07445: exception encountered: core dump [[kghudmpchk()+24]] [[SIGSEGV]] [[Address not mapped to object]] [[0x2]] [[]] [[]]
Wed Aug 21 14:41:01 2002
found dead shared server 'S002', pid = (14, 192)
Fri Aug 23 07:54:52 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Fri Aug 23 16:13:37 2002
Thread 1 advanced to log sequence 50
Current log# 1 seq# 50 mem# 0: /home/oracle/oradata/gemico/redo01.log
Fri Aug 23 18:44:25 2002
Thread 1 advanced to log sequence 51
Current log# 2 seq# 51 mem# 0: /home/oracle/oradata/gemico/redo02.log
Mon Aug 26 08:09:29 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:09:32 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:09:38 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:10:06 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:10:09 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:10:13 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:13:09 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:13:11 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 08:13:21 2002
Errors in file /home/oracle/admin/gemico/bdump/s000_1280.trc:
ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]
Mon Aug 26 12:48:22 2002
Thread 1 advanced to log sequence 52
Current log# 3 seq# 52 mem# 0: /home/oracle/oradata/gemico/redo03.log
Tue Aug 27 15:56:03 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Tue Aug 27 21:21:39 2002
Errors in file /home/oracle/admin/gemico/bdump/smon_1276.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*******************************************************

d000_1282 Trace File Content
*******************************************************
/home/oracle/admin/gemico/bdump/d000_1282.trc
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /home/oracle/product/9.0.1
System name: Linux
Node name: BBF-GE-LINUX
Release: 2.4.2-2
Version: #1 Sun Apr 8 20:41:30 EDT 2001
Machine: i686
Instance name: gemico
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 1282, image: oracle@BBF-GE-LINUX (D000)

*** 2002-08-28 12:27:38.820
async error encountered when answering new connection:
NS Primary Error: TNS-4294967Message -1 not found; product=network; facility=TNS
async error encountered when answering new connection:
NS Primary Error: TNS-4294967Message -1 not found; product=network; facility=TNS
*******************************************************
smon_1276.trc
*******************************************************
/home/oracle/admin/gemico/bdump/smon_1276.trc
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /home/oracle/product/9.0.1
System name: Linux
Node name: BBF-GE-LINUX
Release: 2.4.2-2
Version: #1 Sun Apr 8 20:41:30 EDT 2001
Machine: i686
Instance name: gemico
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 1276, image: oracle@BBF-GE-LINUX (SMON)

*** SESSION ID:(5.1) 2002-08-01 15:45:01.076
*** 2002-08-01 15:45:01.076
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2002-08-06 00:29:26.816
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2002-08-09 23:37:31.138
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2002-08-20 17:51:31.186
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2002-08-23 07:54:52.497
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2002-08-27 15:56:03.536
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2002-08-27 21:21:39.192
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*******************************************************
Re: ORA-00600/00601/00604/01001 [message #98762 is a reply to message #98725] Mon, 11 November 2002 01:57 Go to previous messageGo to next message
Yang Lin
Messages: 1
Registered: November 2002
Junior Member
Hi, all

I have the same problem for the following error:

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

If I query from a table with empty records then it is ok and just show "no records", but if there is one records in the table then it show above error.
(I am using weblogic 6.1,oracle 9i and oracle thin JDBC driver)

Please help!!!
Re: ORA-00600/00601/00604/01001 [message #98804 is a reply to message #98725] Thu, 06 February 2003 23:42 Go to previous messageGo to next message
Laxminarayan
Messages: 2
Registered: February 2003
Junior Member
You add one Datafile to ur existing System
Tablespace and verify the same.
Re: ORA-00600/00601/00604/01001 [message #99016 is a reply to message #98725] Wed, 17 March 2004 23:01 Go to previous message
jawad
Messages: 2
Registered: May 2002
Junior Member
I can't create tables, see the error msg:

SQL> create table hmmmm
2 (tkr date);
create table hmmmm
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01722: invalid number

plz gave me a solution.
Previous Topic: Oracle-Linux problem urgent
Next Topic: Errors while in Linking stage Oracle9iR2 install on Fedora
Goto Forum:
  


Current Time: Sun Nov 28 15:28:24 CST 2021