Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: The Following Error at the sql prompt? What is the problem and Solution

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

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 1 Aug 2000 20:24:40 +1000
Message-Id: <10576.113462@fatcity.com>


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 Received on Tue Aug 01 2000 - 05:24:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US