ora 00600

Database Version: 11.2.0.3 Symptom: When I started a test database today, I found that the database cannot be open. The error is as follows: ERROR at line 1:ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], [] Solution Process: 1. Check alert logs Mon Jul 22 11:35:12 2013 ALTER DATABASE OPENBeginning crash recovery of 1 threadsParallel recovery started

Today, someone is looking for me in Taobao, need Oracle Database recovery support Remote login to see the database mount when the report Ora-600[kccpb_sanity_check_2] Error C:\Documents and Settings\administrator>sqlplus/as SysdbaSql*plus:release 10.2.0.3.0-production on Wed June 29 16:23:18 2015Copyright (c) 1982, 2006, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-productionWith the partitioni

dbms_flashback.transaction_backout (1, xids, options => dbms_flashback.nocascade ); 6 end; 7/ Declare * ERROR at line 1: ORA-00600: internal error code, arguments: [ktgRunStmt_5], [25153], [ORA-25153: Temporary Tablespace is Empty ORA-00600: internal error code, arguments:

stuck at block 439938 of FILE 19Fri May 29 11:00:45 2015Trace dumping is performing id=[cdmp_20150529110045]Aborting crash recovery due to error 1172ORA-1172 signalled during:alter database open ...Set _allow_resetlogs_corruption and Resetlogs try to open the databaseassigning activation ID 4272042346 (0XFEA2316A)Thread 1 opened at log sequence 1Current log# 1 seq# 1 mem# 0:f:\app\administrator\oradata\xff\redo01. LOGSuccessful open of Redo thread 1MTTR advisory is disabled because fast_start_m

> oradebug poke 0x06001AE70 4 0x859AFABEFORE: [06001AE70, 06001AE74) = 00000000AFTER: [06001AE70, 06001AE74) = 00859AFASQL> alter database open; Database altered. SQL> Here, we will briefly explain that 4 is the length, and 0x859AFA is in hexadecimal notation. Based on the original v $ datafile_header.checkpoint_change #,Add up to 1000000 to get this value. We can see that the database is successfully opened. Finally, observe alert log found that there is a

) = 00000000AFTER: [06001ae70, 06001ae74) = 00859afasql> ALTER DATABASE open; Database altered. Sql> Here is a brief explanation, 4 is the length, 0x859afa is 16, I am on the basis of the original v$datafile_header.checkpoint_change#Plus 1000000 gets the value.We can see that the database has been successfully opened. Finally, I looked at alert log and found that there was a ora-00600 4194 erro

This article summarizes the ORA-00600Kcfrbd_3 appears in the query DBA_EXTENTS solution, encountered such problems can look at friends. This article summarizes the ORA-00600 Kcfrbd_3 appear in the query DBA_EXTENTS solution, encountered such problems of friends can look. This article summarizes the ORA-

For listeners that are not on the default port (1521), The pmon process does not register the service/instance to the listener, that is, dynamic registration is not implemented. Similar to a single instance, listeners with non-default RAC ports also set the local_listener parameter. In addition, you can remotely register an instance to achieve load balancing. This is achieved through the remote_listener parameter. For more information about the basics and concepts of Oracle network configuratio

be copied if the sourcedatabase is shutdown first before copying the online redo logs. thesource database needed to remain open so, The datafiles were copied again (withthe tablespaces in backup mode) and then a number of archivelogs weretransferred over to the new server and after the last archivelog was appliedthe database cocould be opened with resetlogs and new online redo logs werecreated on the destination server. -- When the tablespace is set to backup mode, you can copy data files, but

Problem description: 2014-06-10 in the checking database warning file, Ora-00600 error, and RmanL1 backup failed, query related information, it is known that the Bug: 9835218. Therefore, we asked SR for official Oracle technical support. Oracle reply: YourServiceRequesthasbeensubmittedasanORA-600ORA-7445iss Problem description: on February 10, 00600, the

Friend database start encounter ora-00600[2663] Mon Sep 22 19:24:20 2014Thread 1 advanced to log sequence (thread open)Thread 1 opened at log sequence 17Current log# seq# mem# 0:/u02/orayali2/redo17.logSuccessful open of Redo thread 1MTTR advisory is disabled because fast_start_mttr_target are not setMon Sep 22 19:24:20 2014Smon:enabling Cache RecoveryErrors in File/u01/app/oracle/diag/rdbms/orayali2/oraya

29836773, the implementation of the thing Flash backSql> Declare2 XIDs Sys.xid_array;3 begin4 XIDs: = Sys.xid_array (' 13001a0061010000 ');5 dbms_flashback.transaction_backout (1,xids,options = Dbms_flashback.nocascade);6 end;7/Declare*ERROR at line 1:Ora-00600:internal error code, arguments: [Ktgrunstmt_5], [25153], [ORA-25153:Temporary tablespace is EmptyOra-

A ORA-00119 and ORA-00132 error was received when the recent system was started, which is actually related to LISTENER, the usual solution is to dump spfile to pfile and then start from pfile And generate a new spfile. However, this operation method is too costly and you need to restart the database. Another way is to directly modify the service name in tnsnames. ora