My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
JFS2 filesystem mounted with CIO option (introduced with AIX 5.2)


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;




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.