Hi, today I shutdown and attempted to restart a database here and got this error:
-bash-3.2$ sqlplus sys/qwer1234 as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Dec 14 17:24:02 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 1241514856 bytes
Database Buffers 889192448 bytes
Redo Buffers 4964352 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 29710
Session ID: 108 Serial number: 3
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option
-bash-3.2$
Alert log:
Fri Dec 14 17:24:11 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Started redo scan
Completed redo scan
read 0 KB redo, 0 data blocks need recovery
Started redo application at
Thread 1: logseq 25827, block 2, scn 733308421
Recovery of Online Redo Log: Thread 1 Group 3 Seq 25827 Reading mem 0
Mem# 0: /u01/data/oracle/V34WCPRF/onlinelog/o1_mf_3_6fjq6f8d_.log
Completed redo application of 0.00MB
Completed crash recovery at
Thread 1: logseq 25827, block 3, scn 733328423
0 data blocks read, 0 data blocks written, 0 redo k-bytes read
Thread 1 advanced to log sequence 25828 (thread open)
Thread 1 opened at log sequence 25828
Current log# 1 seq# 25828 mem# 0: /u01/data/oracle/V34WCPRF/onlinelog/o1_mf_1_6fjq6dgq_.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Errors in file /u01/app/oracle/diag/rdbms/v34wcprf/V34WCPRF/trace/V34WCPRF_ora_29710.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Errors in file /u01/app/oracle/diag/rdbms/v34wcprf/V34WCPRF/trace/V34WCPRF_ora_29710.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER (ospid: 29710): terminating the instance due to error 704
Instance terminated by USER, pid = 29710
ORA-1092 signalled during: ALTER DATABASE OPEN...
opiodr aborting process unknown ospid (29710) as a result of ORA-1092
Fri Dec 14 17:24:13 2012
ORA-1092 : opitsk aborting process
Trace file:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option
ORACLE_HOME = /u01/app/oracle/product/11.2.0
System name: Linux
Node name:
Release: 2.6.18-194.17.1.0.1.el5
Version: #1 SMP Wed Sep 29 15:57:39 EDT 2010
Machine: x86_64
Instance name: V34WCPRF
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 30492, image: oracle@
*** 2012-12-14 17:29:22.270
*** SESSION ID:(108.3) 2012-12-14 17:29:22.270
*** CLIENT ID:() 2012-12-14 17:29:22.270
*** SERVICE NAME:() 2012-12-14 17:29:22.270
*** MODULE NAME:(sqlplus@com (TNS V1-V3)) 2012-12-14 17:29:22.270
*** ACTION NAME:() 2012-12-14 17:29:22.270
Successfully allocated 15 recovery slaves
Using 75 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 25829, block 2, scn 733348431
cache-low rba: logseq 25829, block 3
on-disk rba: logseq 25829, block 93, scn 733348540
start recovery at logseq 25829, block 3, scn 0
*** 2012-12-14 17:29:22.326
Started writing zeroblks thread 1 seq 25829 blocks 93-100
*** 2012-12-14 17:29:22.327
Completed writing zeroblks thread 1 seq 25829
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 45Kb in 0.02s => 2.20 Mb/sec
Longest record: 0Kb, moves: 0/93 (0%)
Longest LWN: 2Kb, moves: 0/45 (0%), moved: 0Mb
Last redo scn: 0x0000.2bb602bb (733348539)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 21/21 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 163/184 = 0.9
----------------------------------------------
*** 2012-12-14 17:29:22.328
KCRA: start recovery claims for 21 data blocks
*** 2012-12-14 17:29:22.341
KCRA: blocks processed = 21/21, claimed = 21, eliminated = 0
*** 2012-12-14 17:29:22.343
Recovery of Online Redo Log: Thread 1 Group 2 Seq 25829 Reading mem 0
*** 2012-12-14 17:29:22.344
Completed redo application of 0.03MB
*** 2012-12-14 17:29:22.359
Completed recovery checkpoint
IR RIA: redo_size 46080 bytes, time_taken 4 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 21/21 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 184/184 = 1.0
----------------------------------------------
Recovery sets nab of thread 1 seq 25829 to 93 with 8 zeroblks
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
*** 2012-12-14 17:29:22.523
USER (ospid: 30492): terminating the instance due to error 704
Not sure what is going on - this database was upgraded from 11.1 to 11.2 (person who performed the upgrade no longer here)over a year ago and I have not run into any issues with it since then.
Note that above I'm using an 11.1.0.7 version of SQL*Plus but the database is actually 11.2.0.1:
-bash-3.2$ sqlplus sys/qwer1234 as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Dec 14 17:27:54 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 1241514856 bytes
Database Buffers 889192448 bytes
Redo Buffers 4964352 bytes
Database mounted.
Database opened.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
I tried changing the environment to use 11.2.0.3 SQL*Plus but get the same thing:
-bash-3.2$ sqlplus sys/qwer1234 as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 14 17:29:09 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 1241514856 bytes
Database Buffers 889192448 bytes
Redo Buffers 4964352 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 30492
Session ID: 108 Serial number: 3
SQL>
Anybody have any idea what is going on here? Again, this system was working fine for a while and as far as I Know there have been no changes to the configuration or any patches applied or anything. Confused at what coudl have caused this. I appreciate any advice and let me know if there is any important information missing from my post.
Thanks!
Edited by: user6310347 on Dec 14, 2012 2:23 PM
Edited by: user6310347 on Dec 14, 2012 2:23 PM
Edited by: user6310347 on Dec 14, 2012 2:24 PM
Edited by: user6310347 on Dec 14, 2012 2:25 PM