Ora-00600 Internal Error Code Arguments 4194 14
Contents |
in India. With rich experience In Oracle E-Business, Oracle Database, Oracle Application Express (APEX), Oracle J Developer, Oracle OBIEE and E-Business Suite DOYENSYS Knowledge Portal We Welcome you to ora 00600 internal error code arguments kdsgrp1 visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal Thursday, April 17, 2014 ora-00600 internal error code arguments 4194 11g ORA-00600: internal error code, arguments: [4194] ERROR: ====== ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], [] kpndbcon-svchpnotnull CAUSE: ====== This also can be cause by the following defect Bug 8240762 Abstract: Undo corruptions with ORA-600 [4193]/ORA-600 [4194] or ORA-600 [4137] after SHRINK Details: Undo corruption may be caused after a shrink
Ora-00600 Internal Error Code Arguments 4193
and the same undo block may be used for two different transactions causing several internal errors like: SOLUTION: ========= startup mount SQL> select * from v$logfile; GROUP# STATUS TYPE ---------- ------- ------- MEMBER -------------------------------------------------------------------------------- IS_ --- 3 ONLINE /u03/app/oracle/oradata/star/redo03.log NO 2 ONLINE /u03/app/oracle/oradata/star/redo02.log NO GROUP# STATUS TYPE ---------- ora-03113: end-of-file on communication channel ------- ------- MEMBER -------------------------------------------------------------------------------- IS_ --- 1 ONLINE /u03/app/oracle/oradata/star/redo01.log NO /u03/app/oracle/oradata/star/undotbs01.dbf SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS1 If We are using pfile then edit pfile and change the parameter : ========================================= undo_management=MANUAL If you are using spfile then ==================== alter system set undo_management = MANUAL scope=spfile; alter database open; Now drop the undo file ================ alter database datafile '/u03/app/oracle/oradata/star/undotbs01.dbf' offline drop; Drop the tablespace : ============= drop tablespace UNDOTBS1; Got the following error while droping the tablespace: =================================== ERROR at line 1: ORA-01548: active rollback segment ‘_SYSSMU11$' found, terminate dropping tablespace Inorder to ignore this error, ================== SQL> select segment_name,status,tablespace_name from dba_rollback_segs where status='NEEDS RECOVERY'; SEGMENT_NAME STATUS TABLESPACE_NAME ------------------------------ ---------------- -
Redo records and rollback (Undo) records. ORA-600[4194] / ORA-600[4193] error comes with two more arguments within bracket. Arg [a] indicates Maximum Undo record number in Undo block Arg [b] metalink indicates Undo record number from Redo block Sample error is below: ORA-00600: internal error code, arguments: [4194], [19], [33], [], [], [] OR ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] PMON (ospid: 27869): terminating the instance due to error 472 Instance terminated by PMON, pid = 27869 Solution of http://allappsdba.blogspot.com/2014/04/ora-00600-internal-error-code-arguments.html the Problem - Drop the undo tablespace This solution does not deal with Oracle unsupported parameter like _offline_rollback_segments and @_corrupted_rollback_segments to resolve ora-00600[4193]/[4194]. Step 01: Startup the database in nomount stage using spfile. SQL> Startup nomount; In this case ensure you have started your database using spfile. "show parameter spfile" will display the location of spfile. Create pfile from http://oracledbasolution.com/?p=123 spfile. SQL> Create pfile from spfile ; Shutdown the database. SQL> Shutdown immediate; Step 02: Modify the pfile.ora and set Undo_managment=Manual $vi /u01/app/oracle/product/11.2.0/db_1/dbs/initoblprod.ora *.undo_management=’MANUAL’ Start the database in mount mode using modified pfile. SQL> Startup mount pfile=/u01/app/oracle/product/11.2.0/db_1/dbs/initoblprod.ora Ensure that you have undo_managment initialization parameter set to manual. SQL> Show parameter undo SQL> Alter database open ; Once it open, create a rollback segment. SQL> Create rollback segment r01 ; SQL> Alter rollback segment r01 online ; Create a new undo tablespace SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE ‘/u02/app/oracle/oradata/OBLPROD/undotbs02_01.dbf’ size 100M autoextend on; Drop the old undo tablespace SQL> Drop tablespace undotbs1 including contents and datafiles; Step 03: Shutdown the database. SQL> Shutdown immediate; Start the database using spfile where it had undo_managment initialization parameter set to AUTO. SQL> Startup nomount ; Change the undo_tablespace parameter to use new tablespace. SQL>Alter system set undo_tablespace=UNDOTBS2 scope=spfile; SQL> Shutdown immediate ; SQL> Startup Check if error is reported. In case of RAC database instances from Instance which is up and running do the following: SQL> Create undo tablespace undo_new datafile
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle http://www.dba-oracle.com/t_ora_00600_internal_error_code_arguments_string_%20string_string_string_string_string_string.htm Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-00600: internal error code, arguments string tips http://3zecisi3.blogspot.com/2013/06/ora-00600-internal-error-code-arguments_14.html Oracle Error Tips by Stephanie F. The Oracle docs note this on the ORA-00600 error: Error: ORA 00600 Text: internal error code, arguments: [%s], [%s], [%s], internal error [%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 number On the Oracle DBA Forums, a user needs help with ORA-00600, as well as internal error code 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 internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Support Services after gathering the following iSQL> shutdown immediate ORA-03135: connection lost contact SQL> SQL> bash-3.2$ less alert_tetris11.log Dumping diagnostic data in directory=[cdmp_20130614165402], requested by (instance=1, osid=1193 (MMON)), summary=[incident=2314801]. Errors in file /u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_mmon_1193.trc (incident=2314803): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u02/app/oracle/diag/rdbms/tetris11/tetris11/incident/incdir_2314803/tetris11_mmon_1193_i2314803.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_mmon_1193.trc (incident=2314804): ORA-00603: ORACLE server session terminated by fatal error ORA-24557: error 600 encountered while handling error 600; exiting server process ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u02/app/oracle/diag/rdbms/tetris11/tetris11/incident/incdir_2314804/tetris11_mmon_1193_i2314804.trc Dumping diagnostic data in directory=[cdmp_20130614165404], requested by (instance=1, osid=1193 (MMON)), summary=[incident=2314802]. opidrv aborting process MMON ospid (1193) as a result of ORA-603 Dumping diagnostic data in directory=[cdmp_20130614165405], requested by (instance=1, osid=1193 (MMON)), summary=[incident=2314804]. Fri Jun 14 16:54:07 2013 Errors in file /u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_pmon_1165.trc (incident=2314697): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /u02/app/oracle/diag/rdbms/tetris11/tetris11/trace/tetris11_pmon_1165.trc: ORA-0