Two bugs for Oracle 11gR2 RAC

Source: Internet
Author: User

Oracle 11.2.0.2 bugs are still a lot of.
Many libraries have encountered problems after relocating to Oracle 11.2.0.2.
Questions on the two Oracle 11.2.0.2 that are now being followed:
1.ora-00600:internal error code, arguments: [Ktecgsc:kcbz_objdchk], [0], [0], [1],

2. This is even more, encountered several times. If you want to enable block change tracking will hang.
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 is 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 [email protected] DFS Lock handle 1 610
[Email protected] (CTWR). Enq:ct-state Chan GE Gate 2 1 321
610 [email protected] (CKPT). RDBMS IPC reply 1 350

This implementation of the Enable BCT session 321, activates the CTWR process 350, Results 321,350, and then the cycle through the 610 ckpt process. Just hang in there.

Two bugs for Oracle 11gR2 RAC

Related Article

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.