ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997

最新推荐文章于 2024-07-29 08:45:00 发布

转载最新推荐文章于 2024-07-29 08:45:00 发布 · 176 阅读

本文详细解析了Oracle数据库在启动过程中遇到的OS系统依赖操作错误，包括ORA-27300、ORA-27301和ORA-27302等错误代码的含义，以及重叠I/O操作在进行中导致的问题。提供了调整应用内存使用、减少SGA分配、限制连接数和转换为多线程服务器连接等解决方案。

Thu Dec 27 22:04:27 2007
Process m000 died, see its trace file
Thu Dec 27 22:04:27 2007
ksvcreate: Process(m000) creation failed
Thu Dec 27 22:05:27 2007
Process startup failed, error stack:
Thu Dec 27 22:05:27 2007
Errors in file d:oracleproduct10.2.0adminzhjxkhbdumpzhjxkh_psp0_2608.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: 重叠 I/O 操作在进行中。
ORA-27302: failure occurred at: skgpspawn

Thu Dec 27 22:05:28 2007
Process m000 died, see its trace file
Thu Dec 27 22:05:28 2007
ksvcreate: Process(m000) creation failed
Thu Dec 27 22:06:28 2007
Process startup failed, error stack:
Thu Dec 27 22:06:28 2007
Errors in file d:oracleproduct10.2.0adminzhjxkhbdumpzhjxkh_psp0_2608.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: 重叠 I/O 操作在进行中。
ORA-27302: failure occurred at: skgpspawnThu Dec 27 22:04:27 2007
Process m000 died, see its trace file
Thu Dec 27 22:04:27 2007
ksvcreate: Process(m000) creation failed
Thu Dec 27 22:05:27 2007
Process startup failed, error stack:
Thu Dec 27 22:05:27 2007
Errors in file d:oracleproduct10.2.0adminzhjxkhbdumpzhjxkh_psp0_2608.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: 重叠 I/O 操作在进行中。
ORA-27302: failure occurred at: skgpspawn

Note:371074.1

To implement the solution, please execute the following steps:

Tune the application running on the 32-bit environment so that it will not consume greater than
2.7GB of virtual memory when the '/3GB' switch is set in the 'boot.ini' file.
In the case of Oracle encountering the OS resource issue, the options are:

1) Reduce the amount of SGA needed to be allocated for the database.
2) Limit the number of dedicated connections to the database and the amount of memory each user
process will consume.
3) Change from dedicated connections to multi-threaded server (MTS) connections as MTS only
uses a fraction of the amount of memory allocated to each user process when initial connection to
the database is established.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/594850/viewspace-577996/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/594850/viewspace-577996/