ORA-00604 and ORA-00904 after upgrade

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:10:01 CST