Re: ORA-00600 Error: arguments: [opibnd0: oaccsid]

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Oct 2004 06:14:14 -0700
Message-ID: <2687bb95.0410190514.1afb91c9@posting.google.com>

tnjeditor_at_gmail.com (dan) wrote in message news:<3ae70c4e.0410181813.6cbe4a7d_at_posting.google.com>...
> I have a perl program using DBD::Oracle and I have a query using the
> same db handle as another query:
>
> for each row from first query, run second query.
>
> The second query is this:
>
> select user_id from rbac_user_role where user_id > 1 and role_id = ?
>
> Which then gives me this:
>
> DBD::Oracle::st execute failed: ORA-12801: error signaled in parallel
> query server P002
> ORA-00600: internal error code, arguments: [opibnd0: oaccsid], [1],
> [1], [1], [], [], [], [] (DBD ERROR: OCIStmtExecute)
>
> any ideas?

Internal errors and bugs are usually version specific. There is a 9.2.0.5 bug that produces the 00600 first argument: Bug 3356103 - OERI[opibnd0: oaccsid] possible from parallel query. It is fixed in 9.2.0.6.

There is also an nls translation bug that can produce this pattern for version 9.0 - 9.2 Bug #2222763.

If you have a support contract you can look the bug(s) up on metalink.

HTH -- Mark D Powell -- Received on Tue Oct 19 2004 - 08:14:14 CDT