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 9.2.0.1 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)

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;