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

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

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: 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/