Home » RDBMS Server » Server Administration » ORA 600: Internal Error
ORA 600: Internal Error [message #60843] Tue, 09 March 2004 18:40 Go to next message
Neha
Messages: 20
Registered: July 2000
Junior Member
Hi

Ihave oracle 9i (9.2.0.1) server installed on windows 2000 platform.I am getting the ORA 600: Internal error very frequently every day. Due to this everyday a large no. of trace files get generated. Sometimes it so happens that a very big trace file of 11 to 12 GB gets generated and it hangs everything else. The errors that usually comes are: 

ORA-600 [[KGHSSGFR2]]

ORA-600[[17182]]

ORA-600[[KGHFRF2]]

ORA-600 [[12333]]

ORA-600[[4602]]

ORA-600 ARGUMENT [[KXSCLSR-1]]

ORA-600 [[QES3TUNPTMPTABL:1]]

ORA-600 [[KXSMBB: LBND]]

The oracle guys say that this is due to memory corruption. A patch is needed for the same.Suggest me what can I do get rid of this problem.

Rgds

NEHA
Re: ORA 600: Internal Error [message #60879 is a reply to message #60843] Thu, 11 March 2004 17:06 Go to previous messageGo to next message
Tushaar
Messages: 4
Registered: March 2004
Junior Member
Neha,
If Oracle Support states that a patch is needed, please apply the patch.
They should be able to direct you to the right location for this patch.
-Tushaar
Re: ORA 600: Internal Error [message #61392 is a reply to message #60843] Tue, 20 April 2004 21:49 Go to previous messageGo to next message
Mayuresh Mahagaonkar
Messages: 1
Registered: April 2004
Junior Member
Yes You need to apply a patchset of 9.2.0.4 to rectify the memory related issues. Also try to gather statistics for the object mentioned in the trace files.
Re: ORA 600: Internal Error [message #61396 is a reply to message #61392] Wed, 21 April 2004 05:17 Go to previous message
ramesh
Messages: 123
Registered: August 2000
Senior Member
hai neha, some times if blocks are corrpted so u will get ora-600 error,for avoiding this, once please checksum ur blocks, or apply patches correctly.
Previous Topic: ORA-060 error!
Next Topic: Shared memory and semaphores
Goto Forum:
  


Current Time: Fri Sep 20 14:31:26 CDT 2024