Home » RDBMS Server » Server Administration » ORA-00600/00601/00604/01001
ORA-00600/00601/00604/01001 [message #53096] Wed, 28 August 2002 04:58 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
*******************************************************

Report message to a moderator

Re: ORA-00600/00601/00604/01001 [message #53103 is a reply to message #53096] Wed, 28 August 2002 05:46 Go to previous messageGo to next message
SKS
Messages: 26
Registered: February 2002
Junior Member
set java_pool_size greater then 4M. since the java_pool_size is adjusted to a multiple of 4M. In this case the java_pool_size would be 8M.

Report message to a moderator

Re: ORA-00600/00601/00604/01001 [message #53109 is a reply to message #53096] Wed, 28 August 2002 07:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive, your are still using 8i JDBC thin client against a 9i database??
if so, try using a 8.1.7.2 thin client or higher version

Report message to a moderator

Re: ORA-00600/00601/00604/01001 [message #56221 is a reply to message #53096] Thu, 13 March 2003 04:05 Go to previous messageGo to next message
syed
Messages: 8
Registered: October 1999
Junior Member
Sir

This the problem ora-00600 internal error arguments
[[4511]],[[]],[[]],[[]],[[]],[[]],[[]]

row is locked or not.

Pl. give me solution.

thanks

Report message to a moderator

Re: ORA-00600/00601/00604/01001 [message #60012 is a reply to message #53109] Fri, 09 January 2004 02:43 Go to previous message
ingo
Messages: 1
Registered: January 2004
Junior Member
thanks that was the problem

Report message to a moderator

Previous Topic: Theoretical Archive Question
Next Topic: How to wash out Oracle Contents.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:24:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.