Re: after upgrade 10.2.0.1 to 10.2.0.2

On Mar 23, 10:39 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Thank you. The problem is the catupgrd.sql failure. I reset plsql_native_library_dir parameter and rerun catupgrd.sql and everything works fine now.

Happy Received on Fri Mar 23 2007 - 11:33:00 CDT