Re: Oracle Upgrade Concerns

From: Greg <gregcpx_at_hotmail.com>
Date: 23 Jun 2006 11:02:58 -0700
Message-ID: <1151085778.889599.315130@u72g2000cwu.googlegroups.com>

You never stated if you ran catpatch.sql. You should follow the directions for the 9.2.0.7 upgrade. There are several scripts you must run as sysdba with a startup of migrate and cluster_database=false (if you running RAC).

SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF

Then you run utlrp.sql

-Greg

art_at_chicagorsvp.com wrote:
> Jining Han wrote:
> > I assume you have run catpatch.sql and utlrp.sql scripts after the
> > upgrade?
> >
> > JH
>
> Well, I ran the UITLRP.SQL, and that seemed to take care of all the SYS
> stuff. But why are all the MATERIALIZED VIEWS invalid??
... Received on Fri Jun 23 2006 - 13:02:58 CDT