Home » SQL & PL/SQL » SQL & PL/SQL » ora 00600 internal error (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
ora 00600 internal error [message #424080] Wed, 30 September 2009 03:52 Go to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
When I run the following query I get following error message

ORA-00600: internal error code, arguments: [25027], [29], [806021860], [], [], [], [], []
ORA-00600: internal error code, arguments: [25027], [29], [806021860], [], [], [], [], []

I can make select from all tables in that query but when I run the whole query it gives me the error what could be the reason ?

/* Formatted on 9/30/2009 11:43:01 AM (QP5 v5.115.810.9015) */
SELECT (SELECT BSC_NAME
FROM temp_northi.OMC_BSC_BTS_CELL_LIST
WHERE CELL_ID = TTT.NETWORK_ID AND ROWNUM = 1)
BSC_NAME,
(SELECT BTS_NAME
FROM temp_northi.OMC_BSC_BTS_CELL_LIST
WHERE CELL_ID = TTT.NETWORK_ID AND ROWNUM = 1)
BTS_NAME,
(SELECT NAME
FROM temp_northi.OBJECTS TT
WHERE TT.NETWORK_ID = TTT.NETWORK_ID AND ROWNUM = 1)
OBJ_NAME,
FRAGMENT_DATE,
ROUND ( (PC_AVAILPDTCH), 2) AVAIL_PD_MEAN,
ROUND ( (CCH_AVAILCH), 2) AVAIL_SDCCH,
ROUND ( (CCH_DEFINEDCH), 2) AVAIL_SDCCH_MAX,
ROUND ( (CCH_AVAILCH), 2) AVAIL_SDCCH_MEAN,
ROUND ( (AVAIL_TCH_MAX), 2) AVAIL_TCH_MAX,
ROUND ( (TCH_AVAILCH), 2) AVAIL_TCH_MEAN
FROM temp_northi.CELLSTS TTT
WHERE NETWORK_ID IN (SELECT CELL_ID
FROM temp_northi.CLUSTER_CELL_LIST
WHERE CLUSTER_ID IN (10, 11, 12))
AND (FRAGMENT_DATE BETWEEN :P_FRAGMENT_DATE1 AND :P_FRAGMENT_DATE2)

Report message to a moderator

Re: ora 00600 internal error [message #424081 is a reply to message #424080] Wed, 30 September 2009 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support.

From your previous post:
Michel Cadot wrote on Mon, 28 September 2009 21:14
...
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.
...


Regards
Michel

[Updated on: Wed, 30 September 2009 03:54]

Report message to a moderator

Re: ora 00600 internal error [message #424084 is a reply to message #424081] Wed, 30 September 2009 03:57 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
Is this ok ?

SELECT (SELECT BSC_NAME
FROM temp_northi.OMC_BSC_BTS_CELL_LIST
WHERE CELL_ID = TTT.NETWORK_ID AND ROWNUM = 1)
BSC_NAME,
(SELECT BTS_NAME
FROM temp_northi.OMC_BSC_BTS_CELL_LIST
WHERE CELL_ID = TTT.NETWORK_ID AND ROWNUM = 1)
BTS_NAME,
(SELECT NAME
FROM temp_northi.OBJECTS TT
WHERE TT.NETWORK_ID = TTT.NETWORK_ID AND ROWNUM = 1)
OBJ_NAME,
FRAGMENT_DATE,
ROUND ( (PC_AVAILPDTCH), 2) AVAIL_PD_MEAN,
ROUND ( (CCH_AVAILCH), 2) AVAIL_SDCCH,
ROUND ( (CCH_DEFINEDCH), 2) AVAIL_SDCCH_MAX,
ROUND ( (CCH_AVAILCH), 2) AVAIL_SDCCH_MEAN,
ROUND ( (AVAIL_TCH_MAX), 2) AVAIL_TCH_MAX,
ROUND ( (TCH_AVAILCH), 2) AVAIL_TCH_MEAN
FROM temp_northi.CELLSTS TTT
WHERE NETWORK_ID IN (SELECT CELL_ID
FROM temp_northi.CLUSTER_CELL_LIST
WHERE CLUSTER_ID IN (10, 11, 12))
AND (FRAGMENT_DATE BETWEEN :P_FRAGMENT_DATE1 AND :P_FRAGMENT_DATE2)

Report message to a moderator

Re: ora 00600 internal error [message #424086 is a reply to message #424084] Wed, 30 September 2009 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you see it indented and formatted?

Regards
Michel

Report message to a moderator

Re: ora 00600 internal error [message #424089 is a reply to message #424081] Wed, 30 September 2009 04:01 Go to previous messageGo to next message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member
Hi,
Try running query individualy and check which query is wrong....
may be this will help.... right Michel????

Report message to a moderator

Re: ora 00600 internal error [message #424092 is a reply to message #424089] Wed, 30 September 2009 04:12 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It's unlikely to help. This isn't a syntax error - something about this query is making Oracle throw its teddy bear out of the pram. There may be a workaround or a patch available from Metalink to fix this, or you may just have to rewrite the query to get the same data in a different way.

Report message to a moderator

Re: ora 00600 internal error [message #424104 is a reply to message #424092] Wed, 30 September 2009 04:43 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
I found the problem when I remove temp_northi.OMC_BSC_BTS_CELL_LIST from the query it runs. I will recreate indexes on this table. I hope it will work. 
    SELECT   BSC_NAME
    FROM     temp_northi.OMC_BSC_BTS_CELL_LIST
    WHERE    CELL_ID = TTT.NETWORK_ID AND ROWNUM = 1


Thanks.

Report message to a moderator

Re: ora 00600 internal error [message #424109 is a reply to message #424104] Wed, 30 September 2009 04:46 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or you could read Metalink note 284433.1 that lists 13 different known bugs that are related to this problem.

Report message to a moderator

Re: ora 00600 internal error [message #424159 is a reply to message #424109] Wed, 30 September 2009 06:26 Go to previous message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
I solved the problem rebuilding the indexes didnt solve. I dropped table than recreated the table filled the data it works now.

Thank you very much.

Report message to a moderator

Previous Topic: Row Count in Header
Next Topic: Add Check Constraints to table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 04:53:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.