Home » RDBMS Server » Server Administration » ORA-06512 in AlertLog
icon8.gif  ORA-06512 in AlertLog [message #197094] Tue, 10 October 2006 00:48 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi
I have an automated schema statistics gathering running in DBMS_jobs and it runs in the basis of one day of interval.It ran well for the past two months,suddenly
yesterday and also today it throws an error message in alertlog file as follws,

AlertLog Error Stack:

Errors in file /u01/app/oracle/product/9.2.0/admin/XXX/bdump/XXX_j000_9615.trc:
ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []
Mon Oct 9 16:02:07 2006
Errors in file /u01/app/oracle/product/9.2.0/admin/XXX/bdump/XXX_j000_9615.trc:
ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []
ORA-06512: at "SYS.DBMS_STATS", line 9136
ORA-06512: at "SYS.DBMS_STATS", line 9616
ORA-06512: at "SYS.DBMS_STATS", line 9800
ORA-06512: at "SYS.DBMS_STATS", line 9854
ORA-06512: at "SYS.DBMS_STATS", line 9831
ORA-06512: at "SYS.STAT", line 9
ORA-06512: at line 1

XXX_j000_9615.trc Error Stack:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []
Current SQL statement for this session:
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN stat; :mydate := next_date; IF
broken THEN :b := 1; ELSE :b := 0; END IF; END;

----- PL/SQL Call Stack -----
object line object
handle number name
38630f288 232 package body SYS.DBMS_STATS
38630f288 3092 package body SYS.DBMS_STATS
38630f288 8923 package body SYS.DBMS_STATS
38630f288 9067 package body SYS.DBMS_STATS
38630f288 9616 package body SYS.DBMS_STATS
38630f288 9800 package body SYS.DBMS_STATS
38630f288 9854 package body SYS.DBMS_STATS
38630f288 9831 package body SYS.DBMS_STATS
386458da8 9 procedure SYS.STAT
3817bb828 1 anonymous block

Can anyone provide me with the exact cause of this problem and the solution.

Thanks
Raaj Embarassed
Re: ORA-06512 in AlertLog [message #197096 is a reply to message #197094] Tue, 10 October 2006 01:02 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []


for above err simpily call oracle support.
Previous Topic: How to recover 9i UNDO datafile damage?
Next Topic: found dead multi-threaded server 'S011', pid = (28, 120)
Goto Forum:
  


Current Time: Sun Dec 04 10:29:10 CST 2016

Total time taken to generate the page: 0.04062 seconds