ORA-39700: database must be opened with UPGRADE option

[Former Member]

Hi!

We have installed two SAP systems on the same host (SOLMAN and ERP2005) and have problems with start (both of them). (disp+work.exe is shutting down after one minute)

We have the following error at the dabase level (>sqlplus "/ as sysdba", startup)

oracle shuting down...

In the alert<SID>.log we have the following error:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

<b>Can someone just say, whether it is fixable and, of course, how or should we consoder the the new installation?</b>

Thank you!

regards

[Former Member]

I had the same error 2 months ago and this is how I solved. XSP was the SID for the Oracle instance.

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

39700, 00000, "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).

STARTUP UPGRADE

@/oracle/XSP/102_64/rdbms/admin/catupgrd.sql

shutdwn immediate;

@/oracle/XSP/102_64/rdbms/admin/utlrp.sql

@/oracle/XSP/102_64/rdbms/admin/utlu102s.sql TEXT

[former_member204746]

have you upgraded Oracle version to a newer version while installing?

[Former Member]

Hi!

I have just patch the Oracle 10.2 after installation..

May by should I run some sql.skpits?

STARTUP UPGRADE

@/oracle/XSP/102_64/rdbms/admin/catupgrd.sql

shutdwn immediate;

@/oracle/XSP/102_64/rdbms/admin/utlrp.sql

@/oracle/XSP/102_64/rdbms/admin/utlu102s.sql TEXT

Thank you!

regards

[Former Member]

Hi Axel,

<i>> May by should I run some sql.skpits?</i>

This is from the README.html provided with the 10.2.0.2 patch set (section 7, "Postinstallation Tasks"):

Enter the following SQL*Plus commands: 
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
[...]
SQL> SHUTDOWN
SQL> STARTUP

Best regards,

Elmar.

Message was edited by:

Elmar Billen