 |
| 文件: |
gwdb.rar |
| 大小: |
3KB |
| 下载: |
下载 | |
错误描述：
Thu Sep 24 01:05:45 2009
Process startup failed, error stack:
Thu Sep 24 01:05:45 2009
Errors in file d:\oracle\product\10.2.0\admin\gwdb\bdump\gwdb_psp0_1960.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 Sep 24 01:05:46 2009
Process m000 died, see its trace file
Thu Sep 24 01:05:46 2009
ksvcreate: Process(m000) creation failed
Thu Sep 24 01:06:46 2009
Process startup failed, error stack:
Thu Sep 24 01:06:46 2009
Errors in file d:\oracle\product\10.2.0\admin\gwdb\bdump\gwdb_psp0_1960.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
-----------------
环境分析：
oracle 10.2.1.0
os: windows 2000 adv server 4GB内存，开启了/3GB 的选项。
----
参考文档：
------
Cause
OS resource issue.
The maximum amount of addressable memory by a process ('oracle.exe' for example) running in a
32-Bit Windows environment has been reached.
In a 32-Bit Windows environment, the total addressable memory by a single process is a 4GB. On
Windows, the OS reserves half of this memory by default for kernel memory, leaving 2GB of
addressable memory for a user process. By placing the '/3GB' switch in the 'boot.ini' file, this
changes the ratio of kernel memory and user memory. When the '/3GB' switch is in place, processes (such as 'oracle.exe’) can address 3GB of virtual memory out of the total 4GB of addressable memory. However, once the 3GB of virtual memory is depleted, the process will fail.
Solution
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.
阅读(4120) | 评论(0) | 转发(0) |
