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
,