ORA-600 [srsnext_1] when running 9.2 on AIX 5.2 (Doc ID 262851.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 13-May-2013***

JFS2 filesystem mounted with CIO option (introduced with AIX 5.2)


Symptoms

If tempfiles are located on a JFS2 filesystem mounted with the CIO (Concurrent I/O) option, introduced with AIX 5.2, then you might see ORA-600 [srsnext_1] being raised when extents are allocated in the tempfile, eg. when doing large sort operations.

Use the "mount" command to check for filesystems with CIO option:

$ /usr/sbin/mount | grep cio

Then check if any tempfiles are located on any of these filesystems:

SQL> select name from v$tempfile;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms