What does the arguments of ora-600 means? Are thay(or any of them) a kind of coordinates to determine the object in crysis.....or how can i trace to learn more about this?
Printable View
What does the arguments of ora-600 means? Are thay(or any of them) a kind of coordinates to determine the object in crysis.....or how can i trace to learn more about this?
ora-600 is an oracle internal error . If you want to troubleshoot this error you have to see your Alert.log file .
Alert log will got all the information regarding startup and shutdown this error is related to these things
Hi
Looing at the oracle error doc is saw this
"ORA-00600: internal error code, arguments: [ num], [ ?], [ ?], [ ?], [ ?], [ ?]
Cause: This is a catchall internal error message for Oracle program exceptions.
It indicates that a process has met a low-level, unexpected condition. Various
causes of this message include:
þ time-outs
þ file corruption
þ failed data checks in memory
þ hardware, memory, or I/O errors
þ incorrectly restored files
The first argument is the internal message number. Other arguments are vari-ous
numbers, names, and character strings. See Calling Customer Support on
page -3 for more information. The numbers may change meanings between dif-ferent
versions of the Oracle Server.
Action: Report this error to customer support after gathering the following
information:
þ events that led up to the error
þ the operations that were attempted that led to the error
þ the conditions of the operating system and database at the time of the error
þ any unusual circumstances that occurred before receiving the ORA-00600
message
þ contents of any trace files generated by the error
þ the relevant portions of the Alert file
NOTE: The cause of this message may manifest itself as different errors at dif-ferent
times. Be aware of the history of errors that occurred before this internal
error."
At the end of the day, call oracle support. if you what to get mo info on the what happed hat ou can do is:
1. insert into your programe this code
"exceptio
when others
then
tm_error := SQLCODE;
tm_message := SQLERRM (tm_error);
dbms_output.put_line(v_error);
dbms_output.put_line('The Oracle Error is: '||tm_message);"
in v_error befor every step in ypur prograe you insert a value say : 'progame at point select * from ____...'. this way ou know where the programe ren into problems and the oracle error at that point.
p.s.
all the variebles are varchar2(2000), i learned it the hard way betere have it varchar2(2000) then varchar2(200) or ay ioter number