Two bugs in Oracle 11gR2 RAC

Source: Internet
Author: User

Oracle 11.2.0.2 has many bugs.
Many databases have encountered problems after being migrated to Oracle 11.2.0.2.
Two Oracle 11.2.0.2 problems are being resolved:
ORA-00600: internal error code, arguments: [ktecgsc: kcbz_objdchk], [0], [0], [1],

2. This is even more difficult. If you want enable block change tracking, hang will occur.
SQL> select SID from v $ mystat where rownum <2;
SID
----------
321
SQL> alter database enable block change tracking using file '/prod/dba/oracle/jporp/admin/ctf/block_change.ctf' reuse;
---- Hang here


At this time, open another session to see:
SQL> select SID, program, event, blocking_INSTANCE, BLOCKING_SESSION from v $ session where sid = 321 or BLOCKING_SESSION = 321 or sid = 610;
Sid program event BLOCKING_INSTANCE BLOCKING_SESSION
-----------------------------------------------------------------------------------
321 sqlplus @ xxxx DFS lock handle 1 610
350 oracle @ xxxx (CTWR). enq: CT-state chan ge gate 2 1 321
610 oracle @ xxxx (CKPT). rdbms ipc reply 1 350

This execution of enable BCT session 321 activates CTWR process 350, result 321,350, and then generates a cycle through the 610 CKPT process. The hang is there.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.