Topic: Database Administration >> ORA-00600: internal error code, arguments: [kfnDisconnect], [
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-00600: internal error code, arguments: [kfnDisconnect], [ |
| Justin P |
Posted: Jan 21, 2008 10:02:08 PM |
Total Post: 4
Joined: Jan, 2008
|
All,
My Dev Oracle instance is crashed with the below mentioned error
message ,could somebody help me on this plz .
*** 22/01/08 09:45 ***
TAR:
----
UNABLE TO CONNECT ASM
.
.
--------------------
Mon Aug 22/01/08 09:45
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl1_arc1_8516.trc:
ORA-00600: internal error code, arguments: [kfnDisconnect], [not connected],
[], [], [], [], [], []
ORA-15055: unable to connect to ASM instance
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00603: ORACLE server session terminated by fatal error
.
Cheers ,
Justin
|
|
|
 Taj_0 |
| Posted: Jan 21, 2008 10:17:34 PM |  |
|
Total Post: 2
Joined: Jan, 2008
|
Please copy paste the contents of alert log and trace files (if any )
Taj 1
|
|
|
|
|
| MOH_DBA |
| Posted: Jan 23, 2008 02:53:44 PM | |
|
Total Post: 161
Joined: Nov, 2007
|
what is ORA-00600 or some other internal
error. Is there anything we can do with them?
The short answer is that in general, they are not for you and me. They are useful to Oracle Support. However, they can be useful when we are filing an iTAR with Oracle Support. That point is crucial: if you are getting internal errors, then the only way they will ever be corrected
is if you file an iTAR. If you just ignore them, they will not get fixed by themselves, except by accident.
For example, in Oracle 10g Release 1, if you create the following table and run the query,
you may well get an internal error (or not—it was filed as a bug and is corrected in later patch
releases):
SQL> create table t ( x int primary key );
Table created.
SQL> insert into t values ( 1 );
1 row created.
SQL> exec dbms_stats.gather_table_stats( user, 'T' );
PL/SQL procedure successfully completed.
SQL> select count(x) over ()
2 from t;
from t
*
ERROR at line 2:
ORA-00600: internal error code, arguments: [12410], [], [], [], [], [], [], [].
Now, you are the DBA and all of a sudden this trace file pops up in the user dump destination.
Or you are the developer and your application raises an ORA-00600 error and you want
to find out what happened. There is a lot of information in that trace file (some 35,000 lines
more in fact), but in general it is not useful to you and me. We would generally just compress
the trace file and upload it as part of our iTAR processing.
However, there is some information in there that can help you track down the “who,”
“what,” and “where” of the error, and also help you find out if the problem is something others
have experienced—many times, the “why”—on http://metalink.oracle.com. A quick inspection
of the very top of the trace file will provide you with some useful information.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
