cannot startup 10gR2: ORA-01092 + ORA-00704 + ORA-39700 [message #140680] |
Wed, 05 October 2005 03:28 |
robert.koltai
Messages: 7 Registered: June 2005
|
Junior Member |
|
|
Hello, I cannot startup a newly created 10gR2.
I use the same scripts that perfectly worked on 10gR1.
(Solaris 10)
At database open time I get:
ORA-01092: ORACLE instance terminated. Disconnection forced
In the used dump directory there is this message:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
This is the whole dump file:
<< START TRACE >>
Dump file /opt/oracle/admin/instances/omc/udump/omc_ora_23941.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/product/10.1.0/db_1
System name: SunOS
Node name: ssrv47sd
Release: 5.10
Version: Generic
Machine: sun4u
Instance name: omc
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 23941, image: oracle@ssrv47sd (TNS V1-V3)
*** SERVICE NAME:() 2005-10-04 16:38:00.999
*** SESSION ID:(1039.3) 2005-10-04 16:38:00.999
Successfully allocated 2 recovery slaves
Using 550 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 65, block 4992, scn 248174
start recovery at logseq 65, block 4992, scn 248174
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.17s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.0003c96f (248175)
----------------------------------------------
----- 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
----------------------------------------------
*** 2005-10-04 16:38:01.323
KCRA: start recovery claims for 0 data blocks
*** 2005-10-04 16:38:01.324
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2005-10-04 16:38:01.326
Recovery of Online Redo Log: Thread 1 Group 2 Seq 65 Reading mem 0
----- 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
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
<< END TRACE >>
Any suggestion?
Thanks,
Robert
|
|
|
Re: cannot startup 10gR2: ORA-01092 + ORA-00704 + ORA-39700 [message #140702 is a reply to message #140680] |
Wed, 05 October 2005 05:09 |
JSI2001
Messages: 1016 Registered: March 2005 Location: Scotland
|
Senior Member |
|
|
From the documentation:
Quote: | ORA-39700: database must be opened with UPGRADE option
Cause: A normal database open was attempted, but the database has not been upgraded to the current server version.
Action: Use the UPGRADE option when opening the database to run catupgrd.sql (for database upgrade), or to run catalog.sql and catproc.sql (after initial database creation).
|
Check out tahiti.oracle.com for the docs.
HTH
Jim
|
|
|
|