ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [23], [23], [], [], [], [], []

DBA

When user upload a xml file into schema, it was hang during upload operation and then it shows Ora-12801 error. So I focused at alert log file, it show a error message like

ORA-00600: internal error code, arguments: [kxspoac : EXL 1], [23], [23], [], [], [], [], []

The issues happen due to this error if a SQL statement fails with Ora-600 [kxspoac : EXL 1] when executed by a parallel execution slave and that SQL statement has numeric binds then you are probably seeing this bug and this is bug for Oracle 10.2.0.1, So we need to upgrade 10.2.0.4 But We can fix this errors after disable parallel query operation during session level or system level. Here I’m used to resolved  by system level operation…

Conn / as sysdba

SQL> alter system set PARALLEL_MIN_SERVERS=0 scope=spfile;

System altered.

SQL> alter system set PARALLEL_MAX_SERVERS=0 SCOPE=SPFILE;

System altered.

** SQL> alter…

View original post 60 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s