| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: The Following Error at the sql prompt? What is the problem and Solution
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>
 |
 |