SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 9 19:21:08 2015

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

Enter user-name: user11/userpass
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:

C:\windows\system32>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 9 19:14:25 2015

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

Enter user-name: sys /as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup open
ORACLE instance started.

Total System Global Area 1269366784 bytes
Fixed Size                  2175368 bytes
Variable Size             956305016 bytes
Database Buffers          301989888 bytes
Redo Buffers                8896512 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[272], [113], [164], [], [], [], [], [], [], []

show parameter diag
show parameter dump_dest

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile C:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 1216M
  control_files            = "C:\APP\ORADATA\ORCL\CONTROL01.CTL"
  control_files            = "C:\APP\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "C:\app\flash_recovery_area"
  db_recovery_file_dest_size= 3912M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = "attlocal.net"
Thu Apr 09 19:16:05 2015
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  local_listener           = "LISTENER_ORCL"
  audit_file_dest          = "C:\APP\ADMIN\ORCL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  diagnostic_dest          = "C:\APP"
Thu Apr 09 19:16:08 2015
PMON started with pid=2, OS id=4916 
Thu Apr 09 19:16:09 2015
MMAN started with pid=9, OS id=7048 
Thu Apr 09 19:16:09 2015
DBW0 started with pid=10, OS id=7188 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Apr 09 19:16:08 2015
DBRM started with pid=6, OS id=7796 
Thu Apr 09 19:16:09 2015
LGWR started with pid=11, OS id=5888 
Thu Apr 09 19:16:08 2015
PSP0 started with pid=7, OS id=7908 
Thu Apr 09 19:16:09 2015
CKPT started with pid=12, OS id=7104 
Thu Apr 09 19:16:08 2015
GEN0 started with pid=4, OS id=7924 
ORACLE_BASE from environment = C:\app
Thu Apr 09 19:16:14 2015
ALTER DATABASE   MOUNT
Thu Apr 09 19:16:08 2015
VKTM started with pid=3, OS id=4480 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Apr 09 19:16:08 2015
DIAG started with pid=5, OS id=7184 
Thu Apr 09 19:16:09 2015
RECO started with pid=14, OS id=6760 
Thu Apr 09 19:16:09 2015
SMON started with pid=13, OS id=5900 
Thu Apr 09 19:16:09 2015
MMNL started with pid=16, OS id=2784 
Successful mount of redo thread 1, with mount id 1404336383
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Thu Apr 09 19:16:22 2015
ALTER DATABASE OPEN
Thu Apr 09 19:16:23 2015
Errors in file c:\app\diag\rdbms\orcl\orcl\trace\orcl_m000_8092.trc:
ORA-01155: the database is being opened, closed, mounted or dismounted
Beginning crash recovery of 1 threads
 parallel recovery started with 2 processes
Started redo scan
Completed redo scan
 read 55 KB redo, 0 data blocks need recovery
Errors in file c:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_7844.trc  (incident=131012):
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [272], [113], [164], [], [], [], [], [], [], []
Incident details in: c:\app\diag\rdbms\orcl\orcl\incident\incdir_131012\orcl_ora_7844_i131012.trc
Aborting crash recovery due to error 600
Thu Apr 09 19:16:30 2015
Trace dumping is performing id=[cdmp_20150409191630]
Errors in file c:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_7844.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [272], [113], [164], [], [], [], [], [], [], []
Errors in file c:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_7844.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [272], [113], [164], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Thu Apr 09 19:17:24 2015
Sweep [inc][131012]: completed
Sweep [inc2][131012]: completed
Thu Apr 09 19:31:27 2015
db_recovery_file_dest_size of 3912 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

Trace file c:\app\diag\rdbms\orcl\orcl\trace\orcl_m000_8092.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1 
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:1163M/3032M, Ph+PgF:814M/6137M 
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 19
Windows thread id: 8092, image: ORACLE.EXE (M000)


*** 2015-04-09 19:16:23.570
*** SESSION ID:(125.7) 2015-04-09 19:16:23.570
*** CLIENT ID:() 2015-04-09 19:16:23.570
*** SERVICE NAME:() 2015-04-09 19:16:23.570
*** MODULE NAME:(MMON_SLAVE) 2015-04-09 19:16:23.570
*** ACTION NAME:(Monitor FRA Space) 2015-04-09 19:16:23.570
 
ORA-01155: the database is being opened, closed, mounted or dismounted

Trace file c:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_7844.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1 
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:1119M/3032M, Ph+PgF:3449M/9179M 
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 22
Windows thread id: 7844, image: ORACLE.EXE (SHAD)


*** 2015-03-27 10:29:46.988
*** CLIENT ID:() 2015-03-27 10:29:46.988
*** SERVICE NAME:() 2015-03-27 10:29:46.988
*** MODULE NAME:() 2015-03-27 10:29:46.988
*** ACTION NAME:() 2015-03-27 10:29:46.988
 
opiino: Attach failed due to ORA-12570 
Trace file c:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_7844.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1 
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:1163M/3032M, Ph+PgF:814M/6137M 
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 20
Windows thread id: 7844, image: ORACLE.EXE (SHAD)


*** 2015-04-09 19:16:24.456
*** SESSION ID:(9.1) 2015-04-09 19:16:24.456
*** CLIENT ID:() 2015-04-09 19:16:24.456
*** SERVICE NAME:() 2015-04-09 19:16:24.456
*** MODULE NAME:(sqlplus.exe) 2015-04-09 19:16:24.456
*** ACTION NAME:() 2015-04-09 19:16:24.456
 
Successfully allocated 2 recovery slaves
Using 66 overflow buffers per recovery slave

*** 2015-04-09 19:16:25.204
Thread 1 checkpoint: logseq 272, block 2, scn 6754025
  cache-low rba: logseq 272, block 3
    on-disk rba: logseq 272, block 164, scn 6754352
  start recovery at logseq 272, block 3, scn 0

*** 2015-04-09 19:16:25.878
Started writing zeroblks thread 1 seq 272 blocks 113-120

*** 2015-04-09 19:16:25.892
Completed writing zeroblks thread 1 seq 272
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 55Kb in 0.70s => 0.08 Mb/sec
Longest record: 2Kb, moves: 0/144 (0%)
Longest LWN: 3Kb, moves: 0/47 (0%), moved: 0Mb
Last redo scn: 0x0000.00670fee (6754286)
----------------------------------------------

*** 2015-04-09 19:16:26.708
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
WARNING! Crash recovery of thread 1 seq 272 is
ending at redo block 113 but should not have ended before
redo block 164

*** 2015-04-09 19:16:27.457
Incident 131012 created, dump file: c:\app\diag\rdbms\orcl\orcl\incident\incdir_131012\orcl_ora_7844_i131012.trc
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [272], [113], [164], [], [], [], [], [], [], []


*** 2015-04-09 19:16:30.309
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [272], [113], [164], [], [], [], [], [], [], []

*** 2015-04-09 19:16:31.859
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [272], [113], [164], [], [], [], [], [], [], []