Oracle Database ORA-600 2663 Error Problem resolution

Source: Internet
Author: User
Tags session id oracle database


Friend database start encounter ora-00600[2663]

Mon Sep 22 19:24:20 2014
Thread 1 advanced to log sequence (thread open)
Thread 1 opened at log sequence 17
Current log# seq# mem# 0:/u02/orayali2/redo17.log
Successful open of Redo thread 1
MTTR advisory is disabled because fast_start_mttr_target are not set
Mon Sep 22 19:24:20 2014
Smon:enabling Cache Recovery
Errors in File/u01/app/oracle/diag/rdbms/orayali2/orayali2/trace/orayali2_ora_20722.trc (incident=336180):
Ora-00600:internal error code, arguments: [2663], [13], [3140023138], [13], [3141216403], [], [], [], [], [], [], []
Incident details in:/u01/app/oracle/diag/rdbms/orayali2/orayali2/incident/incdir_336180/orayali2_ora_20722_ I336180.trc
Use Adrci or Support Workbench to package the incident.
411.1 at my Oracle Support for error and packaging details.
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/ORAYALI2/ORAYALI2/TRACE/ORAYALI2_ORA_20722.TRC:
Ora-00600:internal error code, arguments: [2663], [13], [3140023138], [13], [3141216403], [], [], [], [], [], [], []
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/ORAYALI2/ORAYALI2/TRACE/ORAYALI2_ORA_20722.TRC:
Ora-00600:internal error code, arguments: [2663], [13], [3140023138], [13], [3141216403], [], [], [], [], [], [], []
Error happened during DB Open, shutting down database
USER (ospid:20722): Terminating the instance due to error 600
Instance terminated by USER, PID = 20722
ORA-1092 signalled during:alter database open ...
OPIODR aborting process unknown ospid (20722) as a result of ORA-1092
Mon Sep 22 19:24:24 2014
Ora-1092:opitsk aborting Process
ORA-600[2663] is similar to the common ora-600[2662, because the SCN of the block is greater than the SCN of the file head, except that the wrong object is different. For this type of problem, our approach is generally simple to push the SCN, But this library is a special 11.2.0.3.5 version, the general method does not push the SCN, because the collection operation log is limited, sticking out the core operation steps

[Oracle@orayali2 opatch]$ Uname-a
Linux orayali2 2.6.32-279.el6.x86_64 #1 SMP Wed June 18:24:36 EDT x86_64 x86_64 x86_64

[Oracle@orayali2 opatch]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.3.0 Production on Mon Sep 22 19:09:18 2014

Copyright (c) 1982, Oracle. All rights reserved.

Connected to a idle instance.

Sql> Startup Mount
ORACLE instance started.

Total System Global area 1.6535E+10 bytes
Fixed Size 2244792 bytes
Variable Size 9898561352 bytes
Database buffers 6610223104 bytes
Redo buffers 24256512 bytes
Database mounted.
Sql> Oradebug Setmypid
Statement processed.
sql> oradebug Dumpvar SGA kcsgscn_
KCSLF Kcsgscn_ [060019598, 0600195c8) = 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 60019278 00000000
Sql> oradebug Poke 0x060019598 8 0x0000000000000040
Before: [060019598, 0600195a0) = 00000000 00000000
After: [060019598, 0600195a0) = 00000040 00000000
sql> oradebug Dumpvar SGA kcsgscn_
KCSLF Kcsgscn_ [060019598, 0600195c8) = 00000040 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 60019278 00000000
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
ERROR at line 1:
Ora-01092:oracle instance terminated. Disconnection forced
Ora-30012:undo tablespace ' SYSTEM ' does not exist or of wrong type
Process id:21174
Session id:1563 Serial Number:3

Now that the mistake has changed, it's a ORA-30012 mistake.

ALTER DATABASE Open
Beginning crash recovery of 1 threads
Parallel recovery started with processes
Started Redo scan
Completed Redo Scan
Read 4 KB redo, 0 data blocks need recovery
Started Redo application at
Thread 1:LOGSEQ, Block 2, SCN 58974597984
Recovery of Online Redo log:thread 1 Group Seq Reading Mem 0
mem# 0:/u02/orayali2/redo17.log
Completed Redo Application of 0.00MB
Completed Crash Recovery at
Thread 1:LOGSEQ, Block 3, SCN 58974617986
0 data blocks read, 0 data blocks written, 4 redo K-bytes Read
Mon Sep 22 19:30:05 2014
Thread 1 advanced to log sequence (thread open)
Thread 1 opened at log sequence 18
Current log# seq# mem# 0:/u02/orayali2/redo18.log
Successful open of Redo thread 1
MTTR advisory is disabled because fast_start_mttr_target are not set
Mon Sep 22 19:30:05 2014
Smon:enabling Cache Recovery
Undo initialization errored:err:30012 serial:0 start:1143146928 end:1143147338 diff:410 (4 seconds)
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/ORAYALI2/ORAYALI2/TRACE/ORAYALI2_ORA_21174.TRC:
Ora-30012:undo tablespace ' SYSTEM ' does not exist or of wrong type
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/ORAYALI2/ORAYALI2/TRACE/ORAYALI2_ORA_21174.TRC:
Ora-30012:undo tablespace ' SYSTEM ' does not exist or of wrong type
Error 30012 happened during DB Open, shutting down database
USER (ospid:21174): Terminating the instance due to error 30012
Instance terminated by USER, PID = 21174
ORA-1092 signalled during:alter database open ...
OPIODR aborting process unknown ospid (21174) as a result of ORA-1092
Mon Sep 22 19:30:08 2014
Ora-1092:opitsk aborting Process

Guess the reason is that the undo setting has a problem causing that check sure enough to find Undo_management=auto while
Undo_tablespace=system
Sql> Startup Mount
ORACLE instance started.

Total System Global area 1.6535E+10 bytes
Fixed Size 2244792 bytes
Variable Size 9898561352 bytes
Database buffers 6610223104 bytes
Redo buffers 24256512 bytes
Database mounted.
Sql> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Undo_management string AUTO
Undo_retention integer 10800
Undo_tablespace string SYSTEM
Sql> alter system set undo_management=manual Scope=spfile;

System altered.
sql> shutdown immediate;
Ora-01109:database not open


Database dismounted.
ORACLE instance shut down.
Sql> Startup
ORACLE instance started.

Total System Global area 1.6535E+10 bytes
Fixed Size 2244792 bytes
Variable Size 9898561352 bytes
Database buffers 6610223104 bytes
Redo buffers 24256512 bytes
Database mounted.
Database opened.

Fix this problem modify undo_management=manual can

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.