Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 数据库错误ORA-27300 ORA-27301 ORA 27302
发新帖
alonedba

12

积分

0

好友

3

主题

数据库错误ORA-27300 ORA-27301 ORA 27302

1#
发表于 2011-10-25 10:54:04 | 查看: 10888| 回复: 10
检查日志文件发现错误信息如下：
Fri Oct 21 18:59:27 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 18:59:27 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 18:59:27 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 18:59:27 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:00:16 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:00:16 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:00:16 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:00:16 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:01:17 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:01:17 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:01:17 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:01:17 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:02:18 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:02:18 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:02:18 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:02:18 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:02:19 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:02:19 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:02:19 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:02:19 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:09:29 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:09:29 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:09:29 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:09:29 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:19:30 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:19:30 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:19:30 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:19:30 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:29:31 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:29:31 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:29:32 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:29:32 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:39:32 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:39:32 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:39:33 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:39:33 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 19:49:33 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 19:49:33 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 19:49:34 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 19:49:34 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 20:00:17 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 20:00:17 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 20:00:17 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 20:00:17 BEIST 2011
ksvcreate: Process(m000) creation failed
Fri Oct 21 20:01:18 BEIST 2011
Process startup failed, error stack:
Fri Oct 21 20:01:18 BEIST 2011
Errors in file /ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Oct 21 20:01:18 BEIST 2011
Process m000 died, see its trace file
Fri Oct 21 20:01:18 BEIST 2011
ksvcreate: Process(m000) creation failed

数据库版本：
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production

SWAP的使用情况：
ora10g[yjhdbb2]/ora10g/nxcdr/admin/bdump> lsps -s
Total Paging Space   Percent Used
      16896MB               3%
ora10g[yjhdbb2]/ora10g/nxcdr/admin/bdump> lsps -a
Page Space      Physical Volume   Volume Group    Size %Used Active  Auto  Type
paging00        hdisk1            rootvg       16384MB     1   yes   yes    lv
hd6             hdisk0            rootvg         512MB    71   yes   yes    lv
用户进程限制情况：
ora10g[yjhdbb2]/ora10g/nxcdr/admin/bdump> ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
2#
发表于 2011-10-25 11:05:53
跟踪日志文件：
/ora10g/nxcdr/admin/bdump/cdr2_psp0_954464.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /ora10g/OracleHomes/db10g
System name:    AIX
Node name:      yjhdbb2
Release:        3
Version:        5
Machine:        00CAFE504C00
Instance name: cdr2
Redo thread mounted by this instance: 2
Oracle process number: 4
Unix process pid: 954464, image: [email=oracle@yjhdbb2]oracle@yjhdbb2[/email] (PSP0)
*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-21 18:59:27.139
*** SESSION ID:(883.1) 2011-10-21 18:59:27.139
*** 2011-10-21 18:59:27.139
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:00:16.134
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:01:17.135
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:02:18.147
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:02:19.434
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:09:29.244
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:19:30.227
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:29:31.353
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:39:32.883
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 19:49:33.979
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 20:00:17.170
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2011-10-21 20:01:18.210
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

回复 只看该作者 道具 举报

3#
发表于 2011-10-25 11:51:27
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.

回复 只看该作者 道具 举报

4#
发表于 2011-10-25 20:11:56
报错的具体原因是什么？得出的结论是什么？从哪里得出来的解决办法？

回复 只看该作者 道具 举报

5#
发表于 2011-10-26 21:16:22
我觉得重点是OS error 信息，比如errpt /errpt -aj xxx ,soft/hard limit，space情况等

回复 只看该作者 道具 举报

6#
发表于 2011-10-27 09:34:13
ORA-27301: OS failure message: Not enough space

在OS层面找原因。

回复 只看该作者 道具 举报

7#
发表于 2012-2-6 09:16:42
这个错误是操作系统设置的问题

回复 只看该作者 道具 举报

8#
发表于 2012-2-6 09:19:02

ORA-27154 ORA-27300 ORA-27301 ORA-27302

测试过程如下
  1. [oracle@gtlions ~]$ sqlplus "/as sysdba"

  3. SQL*Plus: Release 10.2.0.5.0 - Production on Sat Feb 4 23:47:02 2012

  5. Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

  7. Connected to an idle instance.

  9. SQL> startup
  10. ORA-27154: post/wait create failed
  11. ORA-27300: OS system dependent operation:semget failed with status: 28
  12. ORA-27301: OS failure message: No space left on device
  13. ORA-27302: failure occurred at: sskgpsemsper
  14. SQL> !oerr ora 27154
  15. 27154, 0000, "post/wait create failed"
  16. // *Cause:  internal error, multiple post/wait creates attempted simultaneously
  17. // *Action: check errno and contact Oracle Support

  19. SQL> !oerr ora 27300
  20. 27300, 00000, "OS system dependent operation:%s failed with status: %s"
  21. // *Cause:  OS system call error
  22. // *Action: contact Oracle Support

  24. SQL> !oerr ora 27301
  25. 27301, 00000, "OS failure message: %s"
  26. // *Cause:  OS system call error
  27. // *Action: contact Oracle Support
  28. //

  30. SQL> !oerr ora 27302
  31. 27302, 00000, "failure occurred at: %s"
  32. // *Cause:  OS system call error
  33. // *Action: contact Oracle Support
  34. //
复制代码

回复 只看该作者 道具 举报

9#
发表于 2012-2-6 09:22:17
可以看到上面的启动过程中刨除了包含的这个错误

对于这个问题是操作系统的参数设置错误，为这个测试是在linux+10gr5下进行测试的，这个错误是在启动阶段发生的，有别于楼主的在运行过程中发现的，但是我想问题的根本原因应该是没有区别的，应该在os层面找找原因。

下面继续看测试，检查了下OS的参数设置：
  1. [root@gtlions ~]# /sbin/sysctl -p
  2. net.ipv4.ip_forward = 0
  3. net.ipv4.conf.default.rp_filter = 2
  4. net.ipv4.conf.default.accept_source_route = 0
  5. kernel.sysrq = 0
  6. kernel.core_uses_pid = 1
  7. net.ipv4.tcp_syncookies = 1
  8. kernel.msgmnb = 65536
  9. kernel.msgmax = 65536
  10. kernel.shmmax = 4294967295
  11. kernel.shmall = 268435456
  12. fs.aio-max-nr = 1048576
  13. fs.file-max = 6815744
  14. net.ipv4.ip_local_port_range = 9000 65500
  15. net.core.rmem_default = 262144
  16. net.core.rmem_max = 4194304
  17. net.core.wmem_default = 262144
  18. net.core.wmem_max = 1048586
  19. kernel.sem = 250  100
复制代码

注意上面的最后一个参数kernel.sem = 250  100这个不正常的值，现在把这个参数该成正常值。

回复 只看该作者 道具 举报

10#
发表于 2012-2-6 09:22:58
  1. [root@gtlions ~]# vi /etc/sysctl.conf
  2. [root@gtlions ~]# /sbin/sysctl -p
  3. net.ipv4.ip_forward = 0
  4. net.ipv4.conf.default.rp_filter = 2
  5. net.ipv4.conf.default.accept_source_route = 0
  6. kernel.sysrq = 0
  7. kernel.core_uses_pid = 1
  8. net.ipv4.tcp_syncookies = 1
  9. kernel.msgmnb = 65536
  10. kernel.msgmax = 65536
  11. kernel.shmmax = 4294967295
  12. kernel.shmall = 268435456
  13. fs.aio-max-nr = 1048576
  14. fs.file-max = 6815744
  15. net.ipv4.ip_local_port_range = 9000 65500
  16. net.core.rmem_default = 262144
  17. net.core.rmem_max = 4194304
  18. net.core.wmem_default = 262144
  19. net.core.wmem_max = 1048586
  20. kernel.sem = 250 32000 100 128
  21. [root@gtlions ~]#
复制代码

现在来看下是否可以正常启动数据库了。
  1. [oracle@gtlions ~]$ sqlplus "/as sysdba"

  3. SQL*Plus: Release 10.2.0.5.0 - Production on Sun Feb 5 00:00:39 2012

  5. Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

  7. Connected to an idle instance.

  9. SQL> startup
  10. ORACLE instance started.

  12. Total System Global Area  167772160 bytes
  13. Fixed Size            1272600 bytes
  14. Variable Size           62915816 bytes
  15. Database Buffers      100663296 bytes
  16. Redo Buffers            2920448 bytes
  17. Database mounted.
  18. Database opened.
  19. SQL>
复制代码

吼吼，起来了！

回复 只看该作者 道具 举报

11#
发表于 2012-2-6 15:12:49
Good!

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-15 11:01 , Processed in 0.050992 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569