Ora-00600 Internal Error Code Arguments 2662 8
Contents |
Session and ProcessTracing Performance Faster Primary Key creation orenabling MyNotes 2014 Notes Dec-14 Jan-14 Mar-14 Apr-14 May-14 Aug-14 OCT-14 Nov-14 2013 Notes Apr-13 May-13 Jun-13 July-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13
Ora 00600 Internal Error Code Arguments 2141
2015 Notes Jun-15 Feb-15 Mar-15 Apr-15 May-15 Jul-15 Aug-15 Sep-15 Oct-15 ora 00600 internal error code arguments kdsgrp1 Feedback About Profile Home > Oracle > ORA-00600: internal error code, arguments: [2662], ORA-00600: internal error code, arguments: [2662], July 8, 2010 Ora600Tom ora 00600 internal error code arguments 25027 Leave a comment Go to comments Wed Jul 7 03:59:44 2010 Errors in file /opt/oracle/admin/xxx/bdump/xxx_smon_7875.trc: ORA-00600: internal error code, arguments: [2662], [1696], [1478225386], [1696], [1956780490], [8388610], [],
Ora 00600 Internal Error Code Arguments 15570
[] replication_dependency_tracking turned off (no async multimaster replication found) Completed: alter database open Wed Jul 7 03:59:45 2010 Fatal internal error happened while SMON was doing active transaction recovery. Wed Jul 7 03:59:45 2010 Errors in file /opt/oracle/admin/xxx/bdump/xxx_smon_7875.trc: ORA-00600: internal error code, arguments: [2662], [1696], [1478225386], [1696], [1956780490], [8388610], [], [] That was an interesting problem.
Ora 00600 Internal Error Code Arguments Qertbfetchbyrowid
Infact database was UP in READONLY mode, what the DBA did, just brought it down. When he re-started (sql> startup;) the database started throwing ORA-00600 error and instance terminated by SMON. ORA-00600: internal error code, arguments: [2662], [1696], [1478225386], [1696], [1956780490], [8388610], [], [] That was very interesting why a re-start caused an ORA-00600 and SMON terminated the instance. We search through Metalink for this specific ORa-00600 error and found the first argument [2662] points a SCN mismatch, or block corruption etc. But, since the [b] and [d] are same, shows there is no SCN mismatch. we tried to open the database in READ ONLY mode, and failed with database need recovery. Wed Jul 7 01:21:30 2010 alter database open read only Wed Jul 7 01:21:30 2010 ORA-16005 signalled during: alter database open read only… But intestingly, it was clear from the alert log, the recovery was completed! Beginning crash recovery of 1 threads Wed Jul 7 01:18:08 2010 Started redo scan Wed Jul 7 01:18:08
System table spaces are deleted, the recovery data files the way to recover the database to the start state, database ora 00600 internal error code arguments 12235 no archive mode. Open in alter database open resetlog database
Ora 00600 Internal Error Code Arguments Kcratr_nab_less_than_odr
ora-600 [2662] error when prompted. The following information: SQL> col member for a80 SQL> select group#,status,member ora 00600 internal error code arguments 17147 from v$logfile; GROUP# STATUS MEMBER ---------- ------- -------------------------------------------------------------------------------- 3 /u01/app/oracle/ORAC1/onlinelog/o1_mf_3_9r1wx0r7_.log 3 /u01/app/oracle/fast_recovery_area/ORAC1/onlinelog/o1_mf_3_9r1wx0tq_.log 2 /u01/app/oracle/ORAC1/onlinelog/o1_mf_2_9r1wwyrm_.log 2 /u01/app/oracle/fast_recovery_area/ORAC1/onlinelog/o1_mf_2_9r1wwyvm_.log 1 /u01/app/oracle/ORAC1/onlinelog/o1_mf_1_9r1www7g_.log 1 /u01/app/oracle/fast_recovery_area/ORAC1/onlinelog/o1_mf_1_9r1wwwdz_.log 6 rows selected. SQL> recover database https://ora600tom.wordpress.com/2010/07/08/ora-00600-internal-error-code-arguments-2662/ until cancel using backup controlfile ; ORA-00279: change 1104149 generated at 06/06/2014 09:50:26 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/ORAC1/archivelog/2014_06_06/o1_mf_1_23_%u_.arc ORA-00280: change 1104149 for thread 1 is in sequence #23 Specify log: {
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 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 th