OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SYS Invalid Objects (11.2.0.1.0 Win 2008 R2 64Bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYS Invalid Objects [message #569441]

Fri, 26 October 2012 05:41

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

Report message to a moderator

Re: SYS Invalid Objects [message #569447 is a reply to message #569441]

Fri, 26 October 2012 06:09

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: SYS Invalid Objects [message #569449 is a reply to message #569447]

Fri, 26 October 2012 06:25

shiva_J
Messages: 5
Registered: October 2012
Location: Chennai

Junior Member

Michel

i have attached the invalid object list please check that image attached

Attachment: Invalid_Sys.JPG
(Size: 150.58KB, Downloaded 1393 times)

Report message to a moderator

Re: SYS Invalid Objects [message #569450 is a reply to message #569449]

Fri, 26 October 2012 06:26

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: SYS Invalid Objects [message #569462 is a reply to message #569458]

Fri, 26 October 2012 10:18

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

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: SYS Invalid Objects [message #569464 is a reply to message #569462]

Fri, 26 October 2012 10:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: SYS Invalid Objects [message #569917 is a reply to message #569463]

Sat, 03 November 2012 01:54

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...!

Report message to a moderator

Previous Topic:	how to migrate database from windows 2003 to windows 2008 server
Next Topic:	from dictionary to locally

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 21:24:48 CDT 2024