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

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 31 Jul 2000 23:05:37 +1000
Message-Id: <10575.113355@fatcity.com>

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

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 Received on Mon Jul 31 2000 - 08:05:37 CDT