ORA-27300: OS system dependent operation错误

本文记录了Windows2003企业版下Oracle10.2.0.1.0出现ORA-04030及ORA-27300等错误的问题,并提供了详细的错误日志及解决步骤,包括调整应用程序内存使用、更改连接类型等。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Windows 2003 企业版的Oracle 10.2.0.1.0的警告日志alter_SID.log出现下面错误
Wed Aug 18 17:10:47 2010
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_q000_5968.trc:
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)

Trace日志文件:
Dump file d:\oracle\product\10.2.0\admin\test\bdump\test_psp0_928.trc
Fri Aug 20 13:31:24 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU                 : 16 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1034M/4085M, Ph+PgF:3589M/8516M, VA:34M/4095M
Instance name: test
Redo thread mounted by this instance: 1

Oracle process number: 4

Windows thread id: 928, image: ORACLE.EXE (PSP0)


*** SERVICE NAME:(SYS$BACKGROUND) 2010-08-20 13:31:24.384
*** SESSION ID:(442.1) 2010-08-20 13:31:24.384
*** 2010-08-20 13:31:24.384
Wed Aug 18 17:11:17 2010
Process startup failed, error stack:
Wed Aug 18 17:11:17 2010
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_psp0_4996.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
Process startup failed, error stack:
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
*** 2010-08-20 13:45:48.712
Process startup failed, error stack:
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的一个bug

Check Metalink note:
ORA-27300 ORA-27301 ORA-27302 in alert log. Cannot connect to database-371074.1

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.

在命令行打开c:\boot.ini 文件
在文件的末尾加上 “/3GB”

如:c:\boot.ini文件内容:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003 Enterprise x64 Edition" /noexecute=optout /fastdetect /3GB

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

转载于:http://blog.itpub.net/12778571/viewspace-671476/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值