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
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
32-bit Windows Error: 233: Unknown error
ORA-27300 ORA-27301 ORA-27302 in alert log. Cannot connect to database. (Doc ID 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 the following:
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/7728585/viewspace-774916/，如需转载，请注明出处，否则将追究法律责任。