Re: sql*load on HPUX 11

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 23 Feb 2000 19:08:25 +0800
Message-ID: <38B3BFA9.33FA@yahoo.com>

jonathan marsh wrote:
>
> Dear All,
>
> Has anyone experienced problems using sql*load in oracle 8.0.5 on HPUX 11.
> errors such as.
> Record 233: Rejected - Error on table SACUPROD.
> ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [],
> []
>
> Any ideas appreciated..
>
> Regards
>
> Jon Marsh

As with any ORA-600 code, its time to call Oracle support.

I searched for 17090 on Metalink, and got this recommendation (relating to a different problem but it may assist)

---

Set the initialization parameter "close_cached_open_cursors" in the init(sid).ora equal to true.

Solution Explanation:

This parameter, when set to false, leaves opened cursors opened in memory for reuse. If procedures are constantly opening new cursors, soon memory resources will be locked, resulting in the ORA-00600 error.

We are explicitly creating open cursors for procedures to be executed in different open cursors areas.  

Possibly look at setting this parameter or maybe increasing your 'open_cursors' value.

Cheers
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Wed Feb 23 2000 - 05:08:25 CST