In article <947183698.27424.1.nnrp-07.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> At a guess, you may have missed running
> some of the 'catalogue upgrade' scripts, with
> names like cat7303.sql etc. Check the instructions
> and then look in $ORACLE_HOME/rdbms/admin
>
> Typically there are 3 or 4 to run, connected internal
> from svrmgrl.
>
> --
> Jason wrote in message <3876da1e.267801916_at_207.126.101.97>...
> >Subject: ORA-00604 and ORA-00904 after upgrade
> >
> > RDBMS Version: 7.3.3
> > Operating System and Version: MPRAS 3.02
> > Error Number (if applicable): ORA-00604 and ORA-00904
> > Product (i.e. SQL*Loader, Import, etc.): sqlplus
> > Product Version: 3.3.3.0.0
> >
> >
> > I recently upgraded from 7.2.2.3.0 to 7.3.3. When I start up sqlplus
> >from unix I get this:
> >
> > $PWD-> sqlplus user/password
> >
> > SQL*Plus: Release 3.3.3.0.0 - Production on Wed Jan 5 14:49:55 2000
> >
> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> >
> > ERROR:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-00904: invalid column name
> >
> > Error accessing package DBMS_APPLICATION_INFO
> > ERROR:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-00904: invalid column name
> >
My guess is that you did not run catproc which is required for pl/sql.
Also whenever you upgrade you lose all your grants done as sys to
others since the catalog and catproc scripts pretty much recreate
everything sys could have done a grant on. This means if you have DBA
provided routines that reply on privileges to v$ tables and/or
dictionary base tables you will need to re-grant them.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jan 07 2000 - 11:41:57 CST
