RE: The Following Error at the sql prompt? What is the problem andSolution

As Steve suggested, you may start with something like

SELECT object_name,object_type
FROM dba_objects
WHERE owner IN ('SYS','SYSTEM')
GROUP BY object_name,object_type
HAVING COUNT(*) > 1; I would think you could delete objects from SYSTEM that start with 'DBMS' and probably others.
If unsure don't delete. Only delete offending objects.

Rick

> -----Original Message-----
> From: Steve Adams [SMTP:steve.adams_at_ixora.com.au]
> Sent: Tuesday, August 01, 2000 6:25 AM
> To: tgopichand_at_visto.com
> Cc: JBECKSTROM_at_gcrta.org; oracle-l_at_fatcity.com; iouga-vms-l_at_resource.to;
> ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_quickdoc.co.uk
> Subject: RE: The Following Error at the sql prompt? What is the
> problem andSolution
>
> Hi Gopi,
>
> This is potentially messy, so I suggest that you take a backup before
> you do anything else, and then get Oracle support involved. That said,
> my approach would be to automatically generate drop command for all
> SYSTEM owned object for which there is an identical SYS owned object.
>
> Others ... ?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: tgopichand_at_visto.com [mailto:tgopichand_at_visto.com]
> Sent: Tuesday, 1 August 2000 19:06
> To: steve.adams_at_ixora.com.au
> Subject: RE: The Following Error at the sql prompt? What is the problem
> and Solution
>
>
> Hi, Thanks.
>
> First I created the Database.
>
> Then I Imported the Data as user System, this export dump is taken as
> sys user.
>
> What is the other way to clean up? My data already exist.
>
> Thanking You
> Gopi Chand T.
>
> -----Original Message-----
> From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
> Sent: Monday, 31 July 2000 23:06
> To: tgopichand_at_visto.com; JBECKSTROM_at_gcrta.org; oracle-l_at_fatcity.com;
> iouga-vms-l_at_resource.to; ORACLE-L_at_IC.SUNYSB.EDU;
> oracledba_at_QuickDoc.co.uk
> Subject: RE: The Following Error at the sql prompt? What is the problem
> and Solution
>
>
> Hi Gopi,
>
> This normally indicates that catproc.sql has been run as a user other
> than SYS (SYSTEM in this case).
> You need to drop all the incorrectly owned stuff and possibly rerun it
> as SYS.
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: tgopichand_at_visto.com [mailto:tgopichand_at_visto.com]
> Sent: Monday, 31 July 2000 22:26
> To: JBECKSTROM_at_gcrta.org; oracle-l_at_fatcity.com; iouga-vms-l_at_resource.to;
> ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_QuickDoc.co.uk
> Subject: The Following Error at the sql prompt? What is the problem and
> Solution
>
>
> $ sqlplus
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jul 31 12:24:11 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Enter user-name: system/manager
> ERROR:
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYSTEM.DBMS_OUTPUT" does not
> exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
>
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-06509: PL/SQL: ICD vector missing for this package
> ORA-06512: at "SYSTEM.DBMS_APPLICATION_INFO", line 37
> ORA-06512: at line 1
>
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> SQL>
>
> ________________________________________________________________________
> ___
> Visit http://www.visto.com/info, your free web-based communications
> center.
> Visto.com. Life on the Dot.
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Tue Aug 01 2000 - 05:44:53 CDT