Re: Unable to start instance after SMON terminates instance

On Sat, 04 Sep 2004 03:18:17 -0700, Shailendra Mathur wrote:

> Hi,
>
> was doing an import into a table in an Oracle 8.1.5.0.0. on HP/UX.
> gave a recursive sql error (ORA-00604: error occurred at recursive SQL
> level 1). Aborted the import using ^C. Since then Oracle starts up but
> reports internal error 600 and SMON terminates the instance. Any help
> would be greatly appreciated. This is very urgent!

You should call oracle support. Here is something that I was able to find on Metalink:

Problem statement:

KILLING PROCESS DURING TRUNCATE CAUSES ORA-600[2023][5][1]. Hdr: 1537309 8.1.5.0 RDBMS 8.1.5.0 PRODID-5 PORTID-2 ORA-600 1400739

Abstract: KILLING PROCESS DURING TRUNCATE CAUSES ORA-600[2023][5][1].

• 12/10/00 06:36 pm ***

  ---

PROBLEM: Killing the process(i.e CTL-C) while truncating the partition table

that has 80000 extents caused ORA-600[2023][5][1] and the instance went down.

After that, DB cannot be started up due to the same error ORA-600[2023].

There is also another bug that can be connected to your situation:

Problem statement:

ORA-600 [6856] + ORA-600 [KTSF_RSP2] Hdr: 1186884 8.1.6.0.0 RDBMS 8.1.6.0.0 PRODID-5 PORTID-2 ORA-600

Abstract: ORA-600 [6856] + ORA-600 [KTSF_RSP2]

• 02/08/00 06:33 am ***

PROBLEM: .

Several times each day server processes crash with either ORA-600 [6856] or

ORA-600 [ktsf_rsp2]. The errors are seen in both test and production systems.

Originally we got the problem on 8.1.5 so we upgraded the test-system to

8.1.6 but that didn't change anything.

Your version is rather ancient and utterly unsupported. Call Oracle Support and ask for Frances.

-- 
A city is a large community where people are lonesome together.