Home » RDBMS Server » Server Administration » cannot startup 10gR2: ORA-01092 + ORA-00704 + ORA-39700
cannot startup 10gR2: ORA-01092 + ORA-00704 + ORA-39700 [message #140680] Wed, 05 October 2005 03:28 Go to next message
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 Go to previous messageGo to next message
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
Re: cannot startup 10gR2: ORA-01092 + ORA-00704 + ORA-39700 [message #140950 is a reply to message #140702] Thu, 06 October 2005 07:04 Go to previous message
robert.koltai
Messages: 7
Registered: June 2005
Junior Member
Hello,
you missed the point.
I created the database with the newly installed 10gR2 software, using the same scripts that I used for 10gR1 installation.

Therefore I MUST NOT NEED to run any upgrade script.

Robert
Previous Topic: inactive connection
Next Topic: URGENT!! Problem in Connecting to DBA Studio
Goto Forum:
  


Current Time: Fri Mar 29 03:13:22 CDT 2024