| ora 00600 internal error [message #424080] |
Wed, 30 September 2009 03:52  |
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)
|
|
|
|
| Re: ora 00600 internal error [message #424081 is a reply to message #424080] |
Wed, 30 September 2009 03:53  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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)
|
|
|
|
|
|
|
|
| Re: ora 00600 internal error [message #424092 is a reply to message #424089] |
Wed, 30 September 2009 04:12 |
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.
|
|
|
|
| Re: ora 00600 internal error [message #424104 is a reply to message #424092] |
Wed, 30 September 2009 04:43 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
