ORA-00600: internal error code-Urgent

Printable View

12-07-2004, 10:49 AM
sankar

ORA-00600: internal error code-Urgent

Hi all,

While accessing the database or importing the data into some user
I am getting this error.

ORA-00600: internal error code, arguments: [17114], [0x9F4C658], [], [], [], [], [], [.

Wating for early reply

Thanks and Regards,
SankarG
12-07-2004, 10:55 AM
waitecj

Try Metalink
12-07-2004, 11:03 AM
sankar

Some times I am also getting this error.

ORA-00600: internal error code, arguments: [17112], [0x9F4A984], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x9F4A984], [], [], [], [], [], []

Thanks and Regards,
SankarG
12-07-2004, 11:20 AM
Mr.Hanky

I love threads like this, it really opens up the door for Captain Obvious.

Did you check the alert log?
What version and OS?
12-07-2004, 11:32 AM
OracleDoc

Quote:

Originally posted by Mr.Hanky
Did you check the alert log?
What version and OS?

Damit MH don't ask him things like that you'll only egg the dude on. Ohh wait a minute.. scratch that, egg the boy on I want to see Davey blow a gasket :D

Did you run the $ORACLE_HOME/rdbms/admin/catproc.sql ??
12-07-2004, 11:36 AM
Mr.Hanky

Where is Jeff, he lives for this stuff.
12-07-2004, 11:40 AM
OracleDoc

Quote:

Originally posted by Mr.Hanky
Where is Jeff, he lives for this stuff.

lol go email him and tell him his favorite topic has been posted.
Hmmm, too bad I'm out the door to go home. Guess I'll have to log in when I get there to check this out. Could be the begining of some good comedy.
12-07-2004, 11:41 AM
waitecj

I think this is where someone should suggest:

set your fix_db = TRUE in your init.ora file.
12-07-2004, 01:37 PM
Mr.Hanky

Quote:

Originally posted by waitecj
I think this is where someone should suggest:

set your fix_db = TRUE in your init.ora file.

I LIKE THAT ONE.
12-07-2004, 02:53 PM
davey23uk

Quote:

Originally posted by Mr.Hanky
I LIKE THAT ONE.

i wish my company would do this

fire_idiots=true
my databases would be fine then
12-08-2004, 01:09 AM
sankar

Hi,

First of all I would like to thanks the Members participating in this Question.

My OS is Windows 2000 Server and Oracle version is 9.2.0.4.

Note:- I am using Context indexes(Ultra Text Search) or Intermedia Indexes, in my schema.

I don't have Metalink support.Here is the Trace File Contents

Dump file d:\oracle\admin\TEST\udump\TEST_ora_2932.trc
Tue Dec 07 19:49:44 2004
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: TEST

Redo thread mounted by this instance: 1

Oracle process number: 13

Windows thread id: 2932, image: ORACLE.EXE

*** 2004-12-07 19:49:44.381
*** SESSION ID:(9.3687) 2004-12-07 19:49:44.350
********** Internal heap ERROR 17114 addr=09F4C658 *********
***** Dump of memory around addr 09F4C658:
9F4C450 00000000 00000000 [........]
9F4C460 00000000 00000000 00000000 00000000 [................]
9F4C470 00000000 00000000 00000000 AED81300 [................]
9F4C480 00000000 00000000 00000000 00000000 [................]
9F4C490 00000000 0013D8AE 00000000 00000000 [................]
9F4C4A0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C4C0 00000000 00000000 00000000 AED81300 [................]
9F4C4D0 00000000 00000000 00000000 00000000 [................]
9F4C4E0 00000000 0013D8AE 00000000 00000000 [................]
9F4C4F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C510 00000000 00000000 00000000 AED81300 [................]
9F4C520 00000000 00000000 00000000 00000000 [................]
9F4C530 00000000 0013D8AE 00000000 00000000 [................]
9F4C540 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C560 00000000 00000000 00000000 AED81300 [................]
9F4C570 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C590 D00000C9 09F4BB4C 05410258 09F4F53C [....L...X.A.<...]
9F4C5A0 000000C9 00000D51 00400D57 00000007 [....Q...W.@.....]
9F4C5B0 00000000 00000001 00000000 0C651E00 [..............e.]
9F4C5C0 000000C9 00000D58 00400D5B 00000004 [....X...[.@.....]
9F4C5D0 00000001 00000001 00000000 0C661E00 [..............f.]
9F4C5E0 000000C9 00000D43 00400D49 00000007 [....C...I.@.....]
9F4C5F0 00000002 00000001 00000000 0C671E00 [..............g.]
9F4C600 000000C9 00000D4A 00400D50 00000007 [....J...P.@.....]
9F4C610 00000003 00000001 00000000 0000004C [............L...]
9F4C620 D0000039 09F4C590 05410258 09F4F53C [9.......X.A.<...]
9F4C630 00000004 0B43F9D8 0000013C 00000000 [......C.<.......]
9F4C640 00000000 0000001C 00000000 00A6D3C0 [................]
9F4C650 00A6D440 05410210 00000000 09F40214 [@.....A.........]
9F4C660 05410BF0 05410210 09F4CA94 40000201 [..A...A........@]
9F4C670 00000000 09F4F384 00000200 0013D8AE [................]
9F4C680 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C6B0 00000000 0013D8AE 00000000 00000000 [................]
9F4C6C0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C6E0 00000000 00000000 00000000 0013D8AE [................]
9F4C6F0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C720 00000000 AED81300 00000000 00000000 [................]
9F4C730 00000000 00000000 00000000 0013D8AE [................]
9F4C740 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C770 00000000 0013D8AE 00000000 00000000 [................]
9F4C780 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C7A0 00000000 00000000 00000000 AED81300 [................]
9F4C7B0 00000000 00000000 00000000 00000000 [................]
9F4C7C0 00000000 0013D8AE 00000000 00000000 [................]
9F4C7D0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C7F0 00000000 00000000 00000000 0013D8AE [................]
9F4C800 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C830 00000000 0013D8AE 00000000 00000000 [................]
9F4C840 00000000 00000000 00000000 00000000 [................]
9F4C850 00000000 00000000 [........]
******************************************************
HEAP DUMP heap name="callheap" desc=05410210
extent sz=0x424 alt=32767 het=32767 rec=0 flg=2 opc=6
parent=05410BF0 owner=00000000 nex=00000000 xsz=0xe214
EXTENT 0 addr=09F4C664
Chunk 9f4c66c sz= 512 perm "perm " alo=512
Chunk 9f4c86c sz= 376 perm "perm " alo=376
Chunk 9f4c9e4 sz= 164 perm "perm " alo=152
EXTENT 1 addr=09F4CA94
Chunk 9f4ca9c sz= 4144 freeable "sql area " ds=09F4F210
EXTENT 2 addr=09F4DAD8
Chunk 9f4dae0 sz= 492 freeable "sql area " ds=09F4F210
Chunk 9f4dccc sz= 560 freeable "library cache " ds=09F4F4C4
EXTENT 3 addr=09F4DF08
Chunk 9f4df10 sz= 4144 recreate "sql area " latch=00000000
ds 9f4f210 sz= 19896 ct= 6
b369610 sz= 4144
b33efd0 sz= 4144
9f4b02c sz= 2828
9f4ca9c sz= 4144
9f4dae0 sz= 492
EXTENT 4 addr=09F4EF4C
Chunk 9f4ef54 sz= 492 freeable "library cache " ds=09F4F4C4
Chunk 9f4f140 sz= 560 recreate "library cache " latch=00000000
ds 9f4f4c4 sz= 1612 ct= 3
9f4dccc sz= 560
9f4ef54 sz= 492
EXTENT 5 addr=09F4F37C
Chunk 9f4f384 sz= 432 perm "perm " alo=432
Chunk 9f4f534 sz= 60 free " "
Chunk 9f4f570 sz= 560 freeable "library cache " ds=09F4F9D4
EXTENT 6 addr=09F4F7BC
Chunk 9f4f7c4 sz= 608 perm "perm " alo=608
Chunk 9f4fa24 sz= 428 recreate "library cache " latch=00000000
ds 9f4f9d4 sz= 988 ct= 2
9f4f570 sz= 560
Total heap size = 13532
FREE LISTS:
Bucket 0 size=76
Bucket 1 size=268
Bucket 2 size=1036
Total free space = 0
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Permanent space = 0
******************************************************
Hla: 0
*** 2004-12-07 19:49:44.678
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17114], [0x9F4C658], [], [], [], [], [], []
No current SQL statement being executed.

Thanking you,
SankarG
12-08-2004, 01:12 AM
sankar

Hi Thanks to every one for quick response. Here is the Trace file contents. I don't have MetaLink Support, Please help any body.

Dump file d:\oracle\admin\TEST\udump\TEST_ora_2932.trc
Tue Dec 07 19:49:44 2004
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: TEST

Redo thread mounted by this instance: 1

Oracle process number: 13

Windows thread id: 2932, image: ORACLE.EXE

*** 2004-12-07 19:49:44.381
*** SESSION ID:(9.3687) 2004-12-07 19:49:44.350
********** Internal heap ERROR 17114 addr=09F4C658 *********
***** Dump of memory around addr 09F4C658:
9F4C450 00000000 00000000 [........]
9F4C460 00000000 00000000 00000000 00000000 [................]
9F4C470 00000000 00000000 00000000 AED81300 [................]
9F4C480 00000000 00000000 00000000 00000000 [................]
9F4C490 00000000 0013D8AE 00000000 00000000 [................]
9F4C4A0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C4C0 00000000 00000000 00000000 AED81300 [................]
9F4C4D0 00000000 00000000 00000000 00000000 [................]
9F4C4E0 00000000 0013D8AE 00000000 00000000 [................]
9F4C4F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C510 00000000 00000000 00000000 AED81300 [................]
9F4C520 00000000 00000000 00000000 00000000 [................]
9F4C530 00000000 0013D8AE 00000000 00000000 [................]
9F4C540 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C560 00000000 00000000 00000000 AED81300 [................]
9F4C570 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C590 D00000C9 09F4BB4C 05410258 09F4F53C [....L...X.A.<...]
9F4C5A0 000000C9 00000D51 00400D57 00000007 [....Q...W.@.....]
9F4C5B0 00000000 00000001 00000000 0C651E00 [..............e.]
9F4C5C0 000000C9 00000D58 00400D5B 00000004 [....X...[.@.....]
9F4C5D0 00000001 00000001 00000000 0C661E00 [..............f.]
9F4C5E0 000000C9 00000D43 00400D49 00000007 [....C...I.@.....]
9F4C5F0 00000002 00000001 00000000 0C671E00 [..............g.]
9F4C600 000000C9 00000D4A 00400D50 00000007 [....J...P.@.....]
9F4C610 00000003 00000001 00000000 0000004C [............L...]
9F4C620 D0000039 09F4C590 05410258 09F4F53C [9.......X.A.<...]
9F4C630 00000004 0B43F9D8 0000013C 00000000 [......C.<.......]
9F4C640 00000000 0000001C 00000000 00A6D3C0 [................]
9F4C650 00A6D440 05410210 00000000 09F40214 [@.....A.........]
9F4C660 05410BF0 05410210 09F4CA94 40000201 [..A...A........@]
9F4C670 00000000 09F4F384 00000200 0013D8AE [................]
9F4C680 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C6B0 00000000 0013D8AE 00000000 00000000 [................]
9F4C6C0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C6E0 00000000 00000000 00000000 0013D8AE [................]
9F4C6F0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C720 00000000 AED81300 00000000 00000000 [................]
9F4C730 00000000 00000000 00000000 0013D8AE [................]
9F4C740 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C770 00000000 0013D8AE 00000000 00000000 [................]
9F4C780 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C7A0 00000000 00000000 00000000 AED81300 [................]
9F4C7B0 00000000 00000000 00000000 00000000 [................]
9F4C7C0 00000000 0013D8AE 00000000 00000000 [................]
9F4C7D0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
9F4C7F0 00000000 00000000 00000000 0013D8AE [................]
9F4C800 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
9F4C830 00000000 0013D8AE 00000000 00000000 [................]
9F4C840 00000000 00000000 00000000 00000000 [................]
9F4C850 00000000 00000000 [........]
******************************************************
HEAP DUMP heap name="callheap" desc=05410210
extent sz=0x424 alt=32767 het=32767 rec=0 flg=2 opc=6
parent=05410BF0 owner=00000000 nex=00000000 xsz=0xe214
EXTENT 0 addr=09F4C664
Chunk 9f4c66c sz= 512 perm "perm " alo=512
Chunk 9f4c86c sz= 376 perm "perm " alo=376
Chunk 9f4c9e4 sz= 164 perm "perm " alo=152
EXTENT 1 addr=09F4CA94
Chunk 9f4ca9c sz= 4144 freeable "sql area " ds=09F4F210
EXTENT 2 addr=09F4DAD8
Chunk 9f4dae0 sz= 492 freeable "sql area " ds=09F4F210
Chunk 9f4dccc sz= 560 freeable "library cache " ds=09F4F4C4
EXTENT 3 addr=09F4DF08
Chunk 9f4df10 sz= 4144 recreate "sql area " latch=00000000
ds 9f4f210 sz= 19896 ct= 6
b369610 sz= 4144
b33efd0 sz= 4144
9f4b02c sz= 2828
9f4ca9c sz= 4144
9f4dae0 sz= 492
EXTENT 4 addr=09F4EF4C
Chunk 9f4ef54 sz= 492 freeable "library cache " ds=09F4F4C4
Chunk 9f4f140 sz= 560 recreate "library cache " latch=00000000
ds 9f4f4c4 sz= 1612 ct= 3
9f4dccc sz= 560
9f4ef54 sz= 492
EXTENT 5 addr=09F4F37C
Chunk 9f4f384 sz= 432 perm "perm " alo=432
Chunk 9f4f534 sz= 60 free " "
Chunk 9f4f570 sz= 560 freeable "library cache " ds=09F4F9D4
EXTENT 6 addr=09F4F7BC
Chunk 9f4f7c4 sz= 608 perm "perm " alo=608
Chunk 9f4fa24 sz= 428 recreate "library cache " latch=00000000
ds 9f4f9d4 sz= 988 ct= 2
9f4f570 sz= 560
Total heap size = 13532
FREE LISTS:
Bucket 0 size=76
Bucket 1 size=268
Bucket 2 size=1036
Total free space = 0
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Permanent space = 0
******************************************************
Hla: 0
*** 2004-12-07 19:49:44.678
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17114], [0x9F4C658], [], [], [], [], [], []
No current SQL statement being executed.

Thanks and Regards,
SankarG
12-08-2004, 01:14 AM
akhadar

For this particular type of error Contact oracle support if u have.
12-08-2004, 03:02 AM
OracleDoc

If no one else is going to say it.....

sankar, How is it that (I assume) you're a DBA working for a company who is paying money to administer their database and yet you do not have access to Metalink. Would you mind telling us your companies name and where it's located at?

I would advise you to seek another profession because you are doing a disservice to the company by being a fraud.
12-08-2004, 05:37 AM
davey23uk

Re: If no one else is going to say it.....

Quote:

Originally posted by OracleDoc
sankar, How is it that (I assume) you're a DBA working for a company who is paying money to administer their database and yet you do not have access to Metalink. Would you mind telling us your companies name and where it's located at?

I would advise you to seek another profession because you are doing a disservice to the company by being a fraud.

and you expect us to read the trace file.

i think I know the problem - you dont know what you are doing
12-08-2004, 09:41 AM
sankar

Hi all,

Note that the Database is Test Database server not Production Database, and also I am a Programmer not DBA. I have little knowledge on Oracle DBA, and even I can't understand the trace files also. Please excuse me If u people felt that I am demanding. I am learning Oracle DBA, as a part of that I got this error. Otherwise I will formate the system, and try once, no issues.

Thanks,
Sankar
12-08-2004, 09:44 AM
pando

I think if you report your company to Oracle saying they use the software with no license you will get a reward. Or try BSA, Business Software Alliance, www.bsa.org
12-08-2004, 09:55 AM
marist89

Quote:

Originally posted by davey23uk
i wish my company would do this

fire_idiots=true
my databases would be fine then

But then what would you do??? :D :D :D
12-08-2004, 10:07 AM
Horace

Now that IS funny =]
12-08-2004, 10:14 AM
DaPi

Re: Re: If no one else is going to say it.....

Quote:

Originally posted by davey23uk
i think I know the problem - you dont know what you are doing

Happens to me a lot ;)
12-08-2004, 10:44 AM
davey23uk

Quote:

Originally posted by marist89
But then what would you do??? :D :D :D

very droll
12-08-2004, 11:01 AM
Horace

Yeah, i get that.....