My Oracle Support Banner

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

Last updated on SEPTEMBER 18, 2019

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)
***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;

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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