Wednesday, September 23, 2009

Learn ORA-00600: internal error code, arguments: [17059]

My Database traced many files with ORA-00600
Errors in file $ORACLE_BASE/admin/db/udump/db1_ora_13255.trc:
ORA-00600: internal error code, arguments: [17059], [0x0D36AD8A8], [], [], [], [], [], []
Checked trace file, I found many sql statements and etc...
.
.
.
KGL recovered in-flux handle for lock 0xd4ee3178
----------------------------------------
SO: 0xd4ee3178, type: 53, owner: 0xdf985d88, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=d4ee3178 handle=0
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0xd4ee31f8[0xd4ee31f8,0xd4ee31f8] htb=(nil) ssga=0xaf9cf7e0
user=0 session=0 count=0 flags=[0000] savepoint=0x0
That's a bad thing with oracle bugs, when checked on metalink (138554.1). but still no idea to solve(10.2.0.4 linux x86_64 RAC).

One thing i can do it now... flush buffer_cache and shared_pool.
SQL> ALTER SYSTEM FLUSH BUFFER_CACHE;

SQL> ALTER SYSTEM FLUSH SHARED_POOL;
I know this's not good idea to do... but it helped(... but may error again, again, ...).
However I still check Memory misconfiguration and SQL statements. Anyway this case made me need Oracle Support as well ;)

0 ความคิดเห็น: