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