Re: 10g Database not starting after applying patch
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: Wed, 13 May 2009 09:37:22 +0200
Message-ID: <1242200264.173766_at_proxy.dienste.wien.at>
oracle, old sherwoodian wrote:
>> Here's your hint from the alert.log:
>>
>> ORA-00704: bootstrap process failure
>> ORA-39700: database must be opened with UPGRADE option
>>
>> You can use the Database Upgrade Assistant to handle this for you. (look
>> under oracle 10g , configuration and migration tools )
>
> Thank you for taking the time to reply to my post. I found a link that
> explained what i needed to do:
> http://oldlight.wordpress.com/2008/12/17/ora-39700-in-alert-log-when-recover-from-a-full-backup/
Date: Wed, 13 May 2009 09:37:22 +0200
Message-ID: <1242200264.173766_at_proxy.dienste.wien.at>
oracle, old sherwoodian wrote:
>> Here's your hint from the alert.log:
>>
>> ORA-00704: bootstrap process failure
>> ORA-39700: database must be opened with UPGRADE option
>>
>> You can use the Database Upgrade Assistant to handle this for you. (look
>> under oracle 10g , configuration and migration tools )
>
> Thank you for taking the time to reply to my post. I found a link that
> explained what i needed to do:
> http://oldlight.wordpress.com/2008/12/17/ora-39700-in-alert-log-when-recover-from-a-full-backup/
Why don't you follow the instructions in the README.html of the patch set you installed rather than trusting a web page that you found somewhere?
I'm not saying that the web page is wrong, but the instructions are right there, and they worked fine for countless upgrades in my company.
When you install *any* Oracle patch, *always* read the READMEs *before* you start.
Yours,
Laurenz Albe
Received on Wed May 13 2009 - 02:37:22 CDT