ORA-600 [srsnext_1] when running 9.2 on AIX 5.2 [ID 262851.1]
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2
AIX5L Based Systems (64-bit)
"Checked for relevance on 08-Mar-2007"
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
Problem has been investigated through bug:3391122 and was found to be caused by a problem in AIX fixed by the APAR:
IY56024: CIO WRITE RETURNS INCORRECT LENGTH
Solution
To get a permanent fix for the problem, please apply the APAR mentioned above. As an interim solution you may want to avoid having tempfiles residing on a JFS2 filesystem mounted with CIO option (there has not been any reports of this problem being encountered with regular datafiles).
References
NOTE:257338.1 - Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L
<<TAR:3744139.996>>
https://support.oracle.com/CSP/main/article?cmd=show&id=262851.1&type=NOT
分享到:
相关推荐
oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht
在启动Oracle数据库时提示:ORA-00845 MEMORY_TARGET not supported on this system错误,解决办法
Oracle_ORA-12518故障_处理,希望在此与大家分享,能够在实际的工作中提高解决问题的能力
listener_ora sqlnet_ora tnsnames_ora的关系以及手工配置举例
ORA-03113 "end_of_file on communication channel" ORA-03113 "end_of_file on communication channel" ORA-03113 "end_of_file on communication channel
ORA-20011,ORA06564错误分析
数据恢复:被注入的软件及 ORA-600 16703 灾难的恢复
ORA-00604: 递归SQL层1出现错误 ORA-03106: 致命的双工通信协议错误 ORA-02063: 紧接着line(源于dblink) 以及 ORA-04052: 在查找远程对象时出错 ORA-00604: 递归SQL层1出现错误 ORA-03120: 双工转换例行程序:整数...
oracle11G调整物理内存提示ORA-00845 MEMORY_TARGET
断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集
oracle19c缺少的函数
ORA-00904 WMSYS.WM_CONCAT标识符无效解决方案
auto undo management.pdf ,对理解常见的 ora-1555 发生原因 大有益处。
1)rpm格式包安装配置 1.1 下载以rpm后缀名的包,以11.2.0.4.0 版本为例,其中基础包basic、sql*plus、devel包建议默认下载,其他包视情况而定: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm --基础包...
该软件修复bootstrap$故障,最常见的错误ORA-00702,使用该工具能够一键修复,实现数据0丢失. 不同.NET Framework对应exe版本说明 ORA-702_Recovery.Net2.exe 为.NET Framework 2.0,3.0,3.5版本支持(比如2008及其...
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
ORACLE MOS NOTE (1432485.1)
使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查。使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查 使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查
补丁用于解决ORA-39405 TSTZ版本问题的错误 用于把oracle19.3数据库加TSTZ33版本的补丁 可通过SQL> SELECT * FROM v$timezone_file;命令查询时区版本 安装过程可以查看我的文章...
1)rpm格式包安装配置 1.1 下载以rpm后缀名的包,以11.2.0.4.0 版本为例,其中基础包basic、sql*plus、devel包建议默认下载,其他包视情况而定: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm --基础包...