Home » RDBMS Server » Server Administration » SYS Invalid Objects (11.2.0.1.0 Win 2008 R2 64Bit)
icon5.gif  SYS Invalid Objects [message #569441] Fri, 26 October 2012 05:41 Go to next message
shiva_J
Messages: 5
Registered: October 2012
Location: Chennai
Junior Member
we have upgraded from win 2003 32bit 10.2.0.4 to 11.2.0.1.0 - 64bit win 2008 r2
using export and import we have invalid objects in SYS user

Please let me know to clear the invalid objects in sys Schema
Re: SYS Invalid Objects [message #569447 is a reply to message #569441] Fri, 26 October 2012 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on which SYS objects are invalid but in most of the cases it is by executing the associated scripts in rbms/admin directory.

Regards
Michel
Re: SYS Invalid Objects [message #569449 is a reply to message #569447] Fri, 26 October 2012 06:25 Go to previous messageGo to next message
shiva_J
Messages: 5
Registered: October 2012
Location: Chennai
Junior Member
Michel

i have attached the invalid object list please check that image attached
Re: SYS Invalid Objects [message #569450 is a reply to message #569449] Fri, 26 October 2012 06:26 Go to previous messageGo to next message
shiva_J
Messages: 5
Registered: October 2012
Location: Chennai
Junior Member
when i try to compile the view its says
table or view does not exits

i have used this below sql to compile

catalog.sql
catproc.sql
utlrp.sql

Still getting same error

[Updated on: Fri, 26 October 2012 07:27]

Report message to a moderator

Re: SYS Invalid Objects [message #569458 is a reply to message #569450] Fri, 26 October 2012 08:46 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: SYS Invalid Objects [message #569462 is a reply to message #569458] Fri, 26 October 2012 10:18 Go to previous messageGo to next message
shiva_J
Messages: 5
Registered: October 2012
Location: Chennai
Junior Member
Please check this updated post

after running this three catalog.sql,catproc.sql,utlrp.sql Package

i recompiled all sys invalid objects and i got this error

SQL>  alter PACKAGE DBMS_XS_DATA_SECURITY_EVENTS compile  package;

Warning: Package altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_DATA_SECURITY_EVENTS compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_SECCLASS_EVENTS compile     package;

Warning: Package altered with compilation errors.

SQL>  alter VIEW AQ$SCHEDULER$_JOBQTAB compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW USER_XML_INDEXES compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$ALERT_QT_R compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_AQ_SRVNTFN_TABLE_F compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_AQ$_MEM_MC_F compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_SYS$SERVICE_METRICS_TAB_F compile ;

Warning: View altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_PRINCIPAL_EVENTS_INT compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter VIEW V_$TEMP_HISTOGRAM compile ;
 alter VIEW V_$TEMP_HISTOGRAM compile
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL>  alter VIEW AQ$SCHEDULER$_EVENT_QTAB_R compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_ALERT_QT_F compile ;

Warning: View altered with compilation errors.

SQL>  alter PACKAGE DBMS_NETWORK_ACL_ADMIN compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter VIEW AQ$SCHEDULER$_EVENT_QTAB compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$AQ$_MEM_MC compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$SYS$SERVICE_METRICS_TAB compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW DBA_XML_INDEXES compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$SCHEDULER$_JOBQTAB_R compile ;

Warning: View altered with compilation errors.

SQL>  alter TYPE SCHEDULER$_JOB_EXTERNAL compile ;
 alter TYPE SCHEDULER$_JOB_EXTERNAL compile
*
ERROR at line 1:
ORA-06545: PL/SQL: compilation error - compilation aborted


SQL>  alter VIEW GV_$STANDBY_APPLY_SNAPSHOT compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$AQ_SRVNTFN_TABLE compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$ALERT_QT_S compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$SYS$SERVICE_METRICS_TAB_S compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_SCHEDULER$_EVENT_QTAB_F compile ;

Warning: View altered with compilation errors.

SQL>  alter PROCEDURE SET_TABLESPACE compile ;

Warning: Procedure altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_SECCLASS_EVENTS compile     body;

Warning: Package Body altered with compilation errors.

SQL>  alter VIEW AQ$AQ$_MEM_MC_S compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_SCHEDULER$_JOBQTAB_F compile ;

Warning: View altered with compilation errors.

SQL>  alter TRIGGER AURORA$SERVER$STARTUP compile ;

Warning: Trigger altered with compilation errors.

SQL>  alter VIEW AQ$SCHEDULER$_JOBQTAB_S compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$KUPC$DATAPUMP_QUETAB_S compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$KUPC$DATAPUMP_QUETAB compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$ALERT_QT compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW DBA_EPG_DAD_AUTHORIZATION compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW ALL_XML_INDEXES compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$SYS$SERVICE_METRICS_TAB_R compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW KU$_XMLSCHEMA_VIEW compile ;

Warning: View altered with compilation errors.

SQL>  alter PACKAGE DBMS_EPG compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_ROLESET_EVENTS_INT compile  package;

Warning: Package altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_ROLESET_EVENTS_INT compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter PACKAGE DBMS_XS_PRINCIPAL_EVENTS_INT compile  package;

Warning: Package altered with compilation errors.

SQL>  alter PACKAGE DBMS_NETWORK_ACL_UTILITY compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter VIEW GV_$TEMP_HISTOGRAM compile ;
 alter VIEW GV_$TEMP_HISTOGRAM compile
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL>  alter VIEW DBA_ADVISOR_DIRECTIVES compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW USER_ADVISOR_DIRECTIVES compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW DBMS_UPG_STATUS compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW DBMS_UPG_CURRENT_STATUS compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW AQ$_KUPC$DATAPUMP_QUETAB_F compile ;

Warning: View altered with compilation errors.

SQL>  alter PACKAGE DBMS_SCHEMA_COPY compile  body;

Warning: Package Body altered with compilation errors.

SQL>  alter PACKAGE DBMS_SUMADVISOR compile     body;

Warning: Package Body altered with compilation errors.

SQL>  alter TRIGGER AURORA$SERVER$SHUTDOWN compile ;

Warning: Trigger altered with compilation errors.

SQL>  alter PACKAGE XS$CATVIEW_UTIL compile     body;

Warning: Package Body altered with compilation errors.

SQL>  alter PACKAGE DBMS_NETWORK_ACL_ADMIN compile  package;

Warning: Package altered with compilation errors.

SQL>  alter VIEW V_$STANDBY_APPLY_SNAPSHOT compile ;
 alter VIEW V_$STANDBY_APPLY_SNAPSHOT compile
            *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL>  alter VIEW AQ$SCHEDULER$_EVENT_QTAB_S compile ;

Warning: View altered with compilation errors.

SQL>  alter VIEW USER_EPG_DAD_AUTHORIZATION compile ;

Warning: View altered with compilation errors.

SQL>  alter PACKAGE DBMS_UPGRADE_INTERNAL compile  body;

Warning: Package Body altered with compilation errors.

SQL> SQL> spool off
SP2-0734: unknown command beginning "SQL> spool..." - rest of line ignored.
SQL> set pagesize 200
SQL> set heading on
SQL> spool off
not spooling currently
SQL> spool D:\spool.log
SQL> show error
Errors for PACKAGE BODY DBMS_UPGRADE_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
100/5    PL/SQL: SQL Statement ignored
100/44   PL/SQL: ORA-00942: table or view does not exist
113/5    PL/SQL: SQL Statement ignored
113/44   PL/SQL: ORA-00942: table or view does not exist
129/7    PL/SQL: SQL Statement ignored
132/12   PL/SQL: ORA-00942: table or view does not exist
161/5    PL/SQL: SQL Statement ignored
161/39   PL/SQL: ORA-00942: table or view does not exist
183/5    PL/SQL: SQL Statement ignored
183/39   PL/SQL: ORA-00942: table or view does not exist
186/5    PL/SQL: SQL Statement ignored
187/13   PL/SQL: ORA-00942: table or view does not exist
202/16   PL/SQL: Item ignored
202/16   PLS-00201: identifier 'DBMS_UPG_STATUS$.SOURCE_SCHEMA' must be
         declared

203/16   PL/SQL: Item ignored
203/16   PLS-00201: identifier 'DBMS_UPG_STATUS$.TARGET_SCHEMA' must be
         declared

239/5    PL/SQL: SQL Statement ignored
239/17   PL/SQL: ORA-00942: table or view does not exist
336/7    PL/SQL: SQL Statement ignored
336/14   PL/SQL: ORA-00942: table or view does not exist
SQL>


[Updated on: Fri, 26 October 2012 10:20]

Report message to a moderator

Re: SYS Invalid Objects [message #569463 is a reply to message #569462] Fri, 26 October 2012 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My advice: destroy this database, recreate a new one and import in schema mode not FULL one.

Regards
Michel
Re: SYS Invalid Objects [message #569464 is a reply to message #569462] Fri, 26 October 2012 10:50 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
Senior Member
it works for me


SQL> alter PACKAGE DBMS_XS_DATA_SECURITY_EVENTS compile package;

Package altered.

>using export and import we have invalid objects in SYS user
SYS object are NOT exported & therefore can NOT be imported.
SYS objects exist as part of the basic DB at DB creation time.
The status of invalid SYS objects should have been checked & resolved PRIOR to any import.
Consider trashing this DB & starting again, again

>11.2.0.1.0 - 64bit win 2008 r2
exactly how did above come into existence?
Re: SYS Invalid Objects [message #569917 is a reply to message #569463] Sat, 03 November 2012 01:54 Go to previous message
shiva_J
Messages: 5
Registered: October 2012
Location: Chennai
Junior Member
Thanks for your help

i have recreated the DB with out SYS import
now every thing is good

thanks...!
Previous Topic: how to migrate database from windows 2003 to windows 2008 server
Next Topic: from dictionary to locally
Goto Forum:
  


Current Time: Thu Oct 23 14:21:18 CDT 2014

Total time taken to generate the page: 0.05062 seconds