Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

Did you try to startup with UPGRADE and then run CATALOG and CATPROC as suggested?

Have you read the Administrator's Guide for your version? Pay particular attention to Chapter 2 - Creating an Oracle Database.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown