Re: after upgrade 10.2.0.1 to 10.2.0.2

On Mar 22, 4:56 pm, "Anurag Varma" <avora..._at_gmail.com> wrote:
> On Mar 22, 2:38 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > On Mar 22, 1:32 pm, "Happy" <Haibin.T..._at_gmail.com> wrote:
>
> > > I had 10.2.0.1 RAC installation in Redhat EL4. Everything run fine. I
> > > did upgrade from 10.2.0.1 to 10.2.0.2 today. I did clusterware first
> > > and RAC second. Both are successful. After that, I run catupgrd.sql in
> > > my database. Afterward, my database won't start. If I used srvctl
> > > start database -d name, then I got CRS-0215: Could not start resource
> > > 'ora.....inst' error. If I use sqlplus, I can do startup mount, but
> > > not open. Please help!
>
> > > Happy
>
> > You should not have tried to 'upgrade' from 10.2.0.1 to 10.2.0.2 as an
> > upgrade changes the *base* release and you did nothing of the sort.
> > You should have run catpatch.sql, as that is all you accomplished,
> > *patching* your 10.2 database to the latest patch level.
>
> > I hope you have a backup as you'll need it.
>
> > David Fitzjarrell
>
> There is no catpatch.sql in 10gR2 ... in 10gR2 catpatch.sql has
> been renamed to catupgrd.sql
>
> Anurag- Hide quoted text -
>
> - Show quoted text -

Thank you, and that is an interesting note since such patches are not upgrades. And the OP still needs a valid backup so he/she can restore and start over with the script.

David Fitzjarrell Received on Fri Mar 23 2007 - 09:39:30 CDT