Two bugs in Oracle11gR2RAC

Source: Internet
Author: User
There are still many bugs in oracle11.2.0.2. Many databases have encountered problems after being migrated to Oracle11.2.0.2. The problem with two Oracle11.2.0.2 is now: 1. ORA-0

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: 1. ORA-0

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 the Oracle topic page? 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.