Errors in file $ORACLE_BASE/admin/db/udump/db1_ora_13255.trc:Checked trace file, I found many sql statements and etc...
ORA-00600: internal error code, arguments: [17059], [0x0D36AD8A8], [], [], [], [], [], []
.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).
.
.
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
One thing i can do it now... flush buffer_cache and shared_pool.
SQL> ALTER SYSTEM FLUSH BUFFER_CACHE;I know this's not good idea to do... but it helped(... but may error again, again, ...).
SQL> ALTER SYSTEM FLUSH SHARED_POOL;
However I still check Memory misconfiguration and SQL statements. Anyway this case made me need Oracle Support as well ;)


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