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

On Mar 22, 1:32 pm, "Happy" <Haibin.T...@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

On Mar 22, 2:38 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> On Mar 22, 1:32 pm, "Happy" <Haibin.T...@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

On Mar 22, 4:56 pm, "Anurag Varma" <avora...@gmail.com> wrote:
> On Mar 22, 2:38 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
>
>
>
>
>
> > On Mar 22, 1:32 pm, "Happy" <Haibin.T...@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

On Mar 23, 10:39 am, "fitzjarr...@cox.net" <fitzjarr...@cox.net>
wrote:
> On Mar 22, 4:56 pm, "Anurag Varma" <avora...@gmail.com> wrote:
>
>
>
>
>
> > On Mar 22, 2:38 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
>
> > > On Mar 22, 1:32 pm, "Happy" <Haibin.T...@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