Ora-00600 Internal Error Code Arguments 25027 3
Contents |
Thu, 8 May 2008 14:17:10 -0400 Just wondering if any of the DBA have seen this issue before. Oracle returning ORA-00600: internal error code, arguments: [25027], [3], [0], ora 600 25027 [], [], [], [], [] We narrowed it down to an insert statement
Ora 00600 Internal Error Code Arguments 25027 9
in a message_store table which looks like this SQL> desc tracker02.message_store Name Null? Type ----------------------------------------- -------- ---------------------------- MESSAGE_ID NOT oracle support NULL VARCHAR2(100) SENDER_MESSAGE_SIZE NUMBER SENDER_SMALL_DOCUMENT VARCHAR2(4000) SENDER_DOCUMENT_DATA BLOB RECEIVER_MESSAGE_SIZE NUMBER RECEIVER_SMALL_DOCUMENT VARCHAR2(4000) RECEIVER_DOCUMENT_DATA BLOB SENDER_DOCUMENT_DATA_ON_WIRE BLOB RECEIVER_DOCUMENT_DATA_ON_WIRE BLOB COMMON_MESSAGE_SIZE NUMBER COMMON_DOCUMENT_DATA BLOB COMMON_SMALL_DOCUMENT VARCHAR2(4000) To be more specific, the error returns when inserting into a blob column. These are the facts ---------------------------------- 1) Oracle suggested "This looks like Bug 4899479 which causes memory corruptions due to the use of in-memory_undo which is a default in 10.2.0.3". - Per their suggestion, we disabled it and applied the one-off patch. It did not work. 2) we bounced the instance afterwards, still did not work. Any insert into this table will abort with above error. 3) The persistence of this error after the reboot and the patch, made us suspect logical/physical corruption. - dbv: returned no errors - RMAN validate: no errors - validate structure: returned ORA-01499: table/index cross reference failure - see trace file - the trace file returned row mismatch in index tsn: 5 rdba: 0x11c0098d when we followed the rdba hint, we isolated it to a the PK index on the table. When we rebuilt it, it errored out with duplicate value error. Eventually, we did a disable/enable on the PK and dumped dups into exceptions table. This process returned to rows with same message_id PK!!! Once we deleted one of the rows, the index rebuilt successfully. However, the 600 error persisted. - As a last resort, we truncated the table which resolved the issue. any comments or suggestions are welcome. Thank you Other related posts:» ORA-00600: internal error code, arguments: [25027], [3], [0], [], [], [], [], [] Home oracle-l Archive 05-2008 » Previous by Date» Next by Date » Related Posts » View list details » Manage your subscription © Avenir Technologies, LLC 2015
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://www.freelists.org/post/oracle-l/ORA00600-internal-error-code-arguments-25027-3-0-- VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=ORA-25027 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting http://www.dba-oracle.com/t_ora_00600_internal_error_code_arguments_string_%20string_string_string_string_string_string.htm PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB http://stackoverflow.com/questions/18826487/apex-error-by-creating-interactive-report-page-error-ora-00600 Don Burleson Blog
ORA-00600: internal error code, arguments string tips Oracle Error Tips by Stephanie F. The Oracle docs note this on the ORA-00600 internal error error: Error: ORA 00600 Text: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s] ------------------------------------------------------------------------------- Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. Action: Report as a bug - the first argument is the internal error code internal error number On the Oracle DBA Forums, a user needs help with ORA-00600, as well as understanding the accompanying arguments. The replier informed the user that because ORA-00600 is an internal error, the Oracle Corporation knows the arguments. Here are the notes which helped the user resolve ORA-00600: An ORA-00600 is an internal error, and only Oracle Corporation knows the agruments. ALWAYS open a TAR when you get a ora-600. I check MOSC, and you can see many of the "common" codes there. ****************************************** ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the inthere for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up apex error by creating interactive report page - error ORA-00600 up vote 0 down vote favorite I want to create a new site which includes a page with Interactive Report, but at the last step (Confirm the new Application) I get multiple error's displayed as: Unable to create modules. ORA-20001: Create pages error. ORA-20001: Unable to create report page. ORA-00600: internal error code, arguments: [25027], [2], [0], [], [], [], [], [], [], [], [], [] ORA-20001: Create pages error. ORA-20001: Unable to create report page. ORA-00600: internal error code, arguments: [25027], [2], [0], [], [], [], [], [], [], [], [], [] Can anybody explain to me why or how did this happen? If I try a nomal query (select * from table ), it works. oracle oracle-apex share|improve this question edited Dec 22 '15 at 3:26 Tristan 2,67781124 asked Sep 16 '13 at 11:08 user1856981 116 Looks like Apex is reporting an internal error ORA-00600. These are often due to an Oracle bug, or perhaps some corruption on your database. More help: oracle.com/technetwork/issue-archive/2011/11-sep/… –Jeffrey Kemp Sep 17 '13 at 1:26 .)after upgrade to oracle version from 11.2.02 to 11.2.03 .. same errors. .)afterward we upgradet to the new APEX Version 4.2.3.00.08 - same error by upgrading APEX. .)Deinstalled and Installed .)no error and it works :-) –user1856981 Sep 17 '13 at 13:55 Probably a corruption then. Plus, you get the benefits of the upgrades :) –Jeffrey Kemp Sep 18 '13 at 1:56 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email an