Re: ORA-00604 and ORA-00904 after upgrade

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.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

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
>
>
> Error accessing package DBMS_APPLICATION_INFO
> You may need to install the Oracle Procedural option
> SET APPINFO requires Oracle Server Release 7.2 or later
>
> Connected to:
> Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed option
> PL/SQL Release 2.3.3.0.0 - Production
>
>
>
> Also when I try to connect via a 3rd party reporting tool it gets the
>same error.
>
> I try running pupbld.sql and get the same errors:
>
> ERROR at line 4:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00904: invalid column name
>
>
> grant select, update, insert, delete on user_privs to public
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00904: invalid column name
>
>
> create public synonym user_profile for system.user_privs
> *
> ERROR at line 1:
> ORA-00955: name is already used by an existing object
>
>
>
> 0 rows updated.
>
>
>
> Any ideas?
>
Received on Thu Jan 06 2000 - 12:30:08 CST