ORA-600 [12209]

victorymoshui

ORA-600 [12209] [ID 138325.1]

今天生产数据库出现ORA-600 [12209] 报错，在查询了metalink后，发现该问题并不严重，因为很少报该类错误。但是对于文档中描述的

DESCRIPTION:

  Oracle is trying to map a cursor.

  Checks are made to ensure the cursor number passed in is within the
  expected range.

  If the cursor number is found to be invalid, this error is reported.

不是很明白，什么是“Oracle is trying to map a cursor”？ 映射游标？还请高手帮着解答下，或者有相关资料讲解该问题，谢谢了！

victorymoshui

今天又出现了一次同样的报警，trace文件一会附件中上传，不明白DESCRIPTION中的描述。

Liu Maclean(刘相兵

10.2.0.4.0 +[12209], [0], [], [], [], [], [], []

      SO: c00000025eb3c1a0, type: 53, owner: c0000001003ab450, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c00000025eb3c1a0 handle=c0000002761628d0 mode=N
      call pin=0000000000000000 session pin=0000000000000000 hpc=0000 hlc=0000
      htl=c00000025eb3c220[c0000002b3c8a350,c00000025eb3d868] htb=c0000002b3c8a350 ssga=c0000002b3c894f8
      user=c0000001003ab450 session=c0000001003ab450 count=1 flags=[0000] savepoint=0x52a5225e
      LIBRARY OBJECT HANDLE: handle=c0000002761628d0 mtx=c000000276162a00(1) cdp=1
      name=SELECT dmCOL_CFG.* FROM dmCOL_CFG WHERE  Audit_Authorized ='Y' and Audit_IsHistory ='N'  ORDER BY dmCOL_CFG.Company, dmCOL_CFG.Desk, dmCOL_CFG.Audit_Version

kpocana=>opiomc=>ksesic1=>kgesiv

Liu Maclean(刘相兵

Bug 9434367 : GETTING ORA-600 [12209] WHEN DEQUEUING WITH MULTIPLE SESSIONS
此BUG 目前原因仍不明确。

首先确定是否每次执行 均报错？

SELECT dmCOL_CFG.* FROM dmCOL_CFG WHERE  Audit_Authorized ='Y' and Audit_IsHistory ='N'  ORDER BY dmCOL_CFG.Company, dmCOL_CFG.Desk, dmCOL_CFG.Audit_Version

Liu Maclean(刘相兵

opiomc map to a cursor
怀疑该BUG与 游标查找有关，按照以往的经验 往往 alter system flush shared_pool可以绕过该问题

victorymoshui

谢谢坛主的帮助。:)

刚才看了下，该语句确实每天都会执行的，但是从现有的情况看，今年就报了两次。所以根据[ID 138325.1]中的描述，这个问题是可以忽略的。

就是关于游标查找这块，从DESCRIPTION中来看，写的也十分的模糊。不理解map cursor的机制和描述中的"Checks are made to ensure the cursor number passed in is within the expected range",每次游标在SGA中生成后，还是有序号的并且还要在指定的范围值内？

victorymoshui

从trace中还看到了一些其他的select语句

name= select o.name from obj$ o, refcon$ r where o.oid$ = r.expctoid and r.obj# = :1

name= select /*+ no_parallel_index(t,"TM51857729_SECSTPOS_T2_IDX1") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"TM51857729_SECSTPOS_T2_IDX1") */ count(*) as nrw,count(distinct sys_op_lbid(9362015,'L',t.rowid)) as nlb,count(distinct hextoraw(sys_op_descend("POSID")||sys_op_descend("TRADEDATE")||sys_op_descend("SETTLEDATE")||sys_op_descend("POSVIEW")||sys_op_descend("POSITIONSTYLE"))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SUMMIT"."TM

等等....
不知道这些语句是否跟这个问题相关？