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 ;)
Posts
2 comments:
we also we faced the similar issue
ORA-00600: internal error code, arguments: [17059], [0x248AC0338], [], [], [], [], [], []
The setup detail
OS- RHEL 4 (64 Bit)
Database- Oracle 10.2.0.4 RAC
Please note- Its a extremely critical issue in Oracle database and due to this one of the Datafile went in recover mode and my in-house application started abnormal behavior.
when checked the Oracle metalink then observed its related with max cursor etc. But I believe was the issue related with SGA memory and data flush, hence we restarted the database.
Now system is running last three days and not yet observe any issue and no error reported in Oracle Alert log files.
-sumit
Thank You
I reviewed cursors and ... but not be issue. I think my problem depended on library cache. However, A flush could help. but I have changed logic for program...
and everything ok!!!
Post a Comment