ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600 [2103] 的含义

ORA-600 [2103] 的含义

原创 Linux操作系统 作者:paulyibinyi 时间:2009-04-13 23:02:31 0 删除 编辑
ORA-600 [2103] "Timeout on 'Control file' or 'Checkpoint Progress' Enqueue"
  文档 ID: 28045.1 类型: REFERENCE
  上次修订日期: 04-APR-2009 状态: PUBLISHED

Note: For additional ORA-600 related information please read Note 146580.1

PURPOSE:
            
  This article discusses the internal error "ORA-600 [2103]", what 
  it means and possible actions. The information here is only applicable 
  to the versions listed and is provided only for guidance.
 
ERROR:              
  ORA-600 [2103] [a] [b] [c] [d]
 
VERSIONS:
  versions 6.0 to 11
 
DESCRIPTION:

  Oracle is attempting to acquire an enqueue.

  If this operation times out, an ORA-600 [2103] error is reported. 

  There are three formats of this error depending on Oracle release and 
  operation. Each format is identified by the number of additional
  arguments.

  Prior to Oracle Server release 7.3.4 (one additional argument)
  ------------------------------------------------------

  ORA-600 [2103] [a]

  Meaning:   Oracle has waited too long for the control file enqueue.

  ARGUMENTS:

  Arg [a] Time out - the time waited for the enqueue, in seconds.
                     (normally 900 seconds ie 15 Minutes)

  From Oracle 7.3.4 to 9.2 and above (4 additional arguments)
  --------------------------------------------------------

  ORA-600 [2103] [a] [b] [c] [d]

  Meaning:   Oracle has waited too long for the control file enqueue.
             This error has the same meaning as the single argument 
             case above - we simply output additional information.

  ARGUMENTS:

  Arg [a] 1-2 (Read only indicator - 0 for updates, 1 for read only, 2-rac/ops)
  Arg [b] 0 (Type indicator - 0 and 4 for ENQUEUE)
  Arg [c] 1 (Wait indicator - 1 indicates we should wait for the request)
  Arg [d] Time out - the time waited for the enqueue, in seconds.
                     (normally 900 seconds ie 15 Minutes)

  Oracle Server Release 9.0 and above
  -----------------------------------

  ORA-600 [a] [b]

  Meaning:   Oracle is trying to write a Checkpoint Progress record and has 
             waited too long for the enqueue.

  ARGUMENTS:

  ORA-600 [a] [b]
  ---------------

  Arg [a]   1 (Wait indicator - 1 indicates we should wait for the request)
  Arg [b] 256 (indicates we skip to the front of the convert queue)

FUNCTIONALITY:      
  CONTROL FILE MANAGEMENT COMPONENT
 
IMPACT:             
  Possible Instance Failure
 
SUGGESTIONS:        

  Check the alert log to see how often a logfile switch is taking place.

  Try and ensure that REDO log files are sized such that a log switch 
  takes place approximately every half hour during heavy load. This will 
  reduce the number of times we need to obtain the control file enqueue.
   
  Tune your datafile layout to resolve I/O contention.
  a. Determine if async IO is in use in any form.
  b. Determine if multiple DB writers in use.
     >> If BOTH async and multiple DB writers back one out.
     >> If just AsyncIO turn this OFF using the relevant init.ora parameter
           as this usually seems to occur with async IO.
     >> If multiple DB writers back down to 1 db writer 
 
  Check with the Hardware vendor to ensure there are no hardware problems
  and that you are on the latest OS patch level. 

  In the case of IBM, see Note 1058194.6 to obtain the correct OS 
  patch.

  Known issues:

  Bug# 6267208   See Note 6267208.8
      OERI:2103 due to deadlock between PV enqueue and "slave class create" latch
      Fixed: 10.2.0.4
 
  Bug# 6144079   See Note 6144079.8
      Instance crash in RAC (OERI:2103)
      Fixed: 10.2.0.4, 11.1.0.7, 11.2
 
  Bug# 5923866   See Note 5923866.8
      OERI[2103] when database is suspended
      Fixed: 10.2.0.4, 11.1.0.6
 
  Bug# 5526987 *  See Note 5526987.8
    * This bug is alerted in Note 468572.1
      ASM instance hang / OERI [2103] on DB instance
      Fixed: 10.2.0.4, 11.1.0.6, 10.2.0.3.P11
 
  Bug# 5134663   See Note 5134663.8
      OERI[2103] with ASM
      Fixed: 10.2.0.3, 11.1.0.6
 
  Bug# 5081798 +  See Note 5081798.8
      Additional diagnostics for OERI[2103] when ASM involved
      Fixed: 10.2.0.4, 11.1.0.6, 10.2.0.3.P11
 
  Bug# 5011019   See Note 5011019.8
      OERI[2103] on bystander standby during target standby failover
      Fixed: 10.2.0.3, 11.1.0.6
 
  Bug# 4671216   See Note 4671216.8
      ASM operations on a file are blocked while it is resized
      Fixed: 10.2.0.2, 11.1.0.6, 10.2.0.1.P05, 10.1.0.5.P03
 
  Bug# 4348230   See Note 4348230.8
      OERI:2103 should try to remove the blocking session
      Fixed: 10.1.0.5, 10.2.0.2, 11.1.0.6
 
  Bug# 4164021   See Note 4164021.8
      OERI [2103] during BACKUP CONTROLFILE to TRACE
      Fixed: 9.2.0.8, 10.1.0.5, 10.2.0.2, 11.1.0.6
 
  Bug# 3724485   See Note 3724485.8
      Enqueue waits may occur with no obvious holder in RAC
      Fixed: 9.2.0.6, 10.1.0.4, 10.2.0.1
 
  Bug# 3675033   See Note 3675033.8
      Reintroduction of RAC instance can result in hang / OERI:2103
      Fixed: 9.2.0.6, 10.2.0.1
 
  Bug# 3400979   See Note 3400979.8
      Dump of FILE_HDRS may hang or error (can result in OERI [2103])
      Fixed: 9.2.0.6, 10.1.0.4, 10.2.0.1
 
  Bug# 3030298   See Note 3030298.8
      OERI:2103 from concurrent 'drop tablespace including datafiles'
      Fixed: 9.2.0.5, 10.1.0.2
 
  Bug# 2952096   See Note 2952096.8
      Poor performance / OERI:2103 possible in RAC with mirrors and volume manager
      Fixed: 9.2.0.5, 10.1.0.2
 
  Bug# 2950375   See Note 2950375.8
      OERI[2103] in RAC if LMD0 is producing a dump
      Fixed: 9.2.0.4, 10.1.0.2
 
  Bug# 2872299   See Note 2872299.8
      OERI:2103 / instance crash can occur if foreground hits data/index internal error
      Fixed: 9.2.0.4, 10.1.0.2
 
  Bug# 2843570   See Note 2843570.8
      OERI:2103 possible on PRIMARY if secondary errors
      Fixed: 9.2.0.4, 10.1.0.2
 
  Bug# 1746869   See Note 1746869.8
      OERI:2103 possible during reconfiguration
      Fixed: 9.0.1.3, 9.2.0.1
 
  Bug# 1223914   See Note 1223914.8
      OERI:2103 possible using concurrent ALTER TABLESPACE READ ONLY/WRITE
      Fixed: 8.1.6.3, 8.1.7.0
 
  Bug# 719498   See Note 719498.8
      Backup CONTROLFILE to trace could crash DB with OERI:2103
      Fixed: 8.0.5.2, 8.0.6.0

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

上一篇: 清明节
请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6596444