shell INVALID command to compile database objects

======== INVALID COMMAND =======

Though there are many utilities and packages are there to complie the invalid database objects..But an easy approach to all these are to use invalid command at OS level. I am giving some example here for which i ran in my environment to compile the objects

====

Infrastructure Services Europe - Computer Services Midrange

If you experience technical difficulties regarding this system
please contact the Infrastructure Services Europe - IT Services Center:

24 hours 7 days a week, phone +31 (0)75 659 21 00

______________________________________________________________________________



!!! HP DISK CONVERSION IN PROGRESS. PLEASE DO NO ADD NEW DISK

TO THE EXISTING DISKGROUP. CONTACT RAZIB FOR MORE INFO !!!

SIDS on this machine are: areplm01 areplm02 arepl202 aapex001 awm71002 awm71001 owm71003 pdb2ora1 otrack1 prepl001 prepl002 midtier db10105 db10203 db10204 tonto_listener_10203 tonto_listener_10204 tonto_listener_10204_dg agent agent11g prepl101 prepl102

tonto():/home/oracle>ps -ef
grep smon

oracle 25352 1 0 Jan 17 ? 0:08 ora_smon_owm71003

oracle 9502 1 0 Dec 14 ? 3:33 ora_smon_areplm01

oracle 15795 1 0 Oct 09 ? 10:42 ora_smon_aapex001

oracle 21420 1 0 Jan 17 ? 0:11 ora_smon_awm71001

oracle 3687 3661 0 11:46:15 pts/1 0:00 grep smon

oracle 12109 1 0 Jan 10 ? 0:51 ora_smon_pdb2ora1

oracle 9855 1 0 Dec 14 ? 3:14 ora_smon_areplm02

oracle 3108 1 0 Jan 15 ? 0:18 ora_smon_arepl202

tonto():/home/oracle>. oraenv

ORACLE_SID = [oracle] ? arepl202

tonto(arepl202):/home/oracle>invalid

alter VIEW P1INTF.INTF_OM_ODFD_T1 compile ;



alter public synonym X$KCBFWAIT compile;

alter public synonym X$KSPPSV compile;

alter public synonym X$KSPPI compile;

alter public synonym X$KSQST compile;

alter public synonym X$KSLLT compile;





Warning: View altered with compilation errors.





Synonym altered.





Synonym altered.





Synonym altered.





Synonym altered.





Synonym altered.



tonto(arepl202):/home/oracle>. oraenv

ORACLE_SID = [arepl202] ? areplm01

tonto(areplm01):/home/oracle>invalid

alter VIEW SYS.DBA_HIST_FILESTATXS compile ;

alter VIEW SYS.DBA_HIST_SQLSTAT compile ;

alter VIEW SYS.DBA_HIST_SQLBIND compile ;

alter VIEW SYS.DBA_HIST_SYSTEM_EVENT compile ;

alter VIEW SYS.DBA_HIST_WAITSTAT compile ;

alter VIEW SYS.DBA_HIST_LATCH compile ;

alter VIEW SYS.DBA_HIST_LATCH_MISSES_SUMMARY compile ;

alter VIEW SYS.DBA_HIST_DB_CACHE_ADVICE compile ;

alter VIEW SYS.DBA_HIST_ROWCACHE_SUMMARY compile ;

alter VIEW SYS.DBA_HIST_SGASTAT compile ;

alter VIEW SYS.DBA_HIST_SYSSTAT compile ;

alter VIEW SYS.DBA_HIST_SYS_TIME_MODEL compile ;

alter VIEW SYS.DBA_HIST_OSSTAT compile ;

alter VIEW SYS.DBA_HIST_PARAMETER compile ;

alter VIEW SYS.DBA_HIST_SEG_STAT compile ;

alter VIEW SYS.DBA_HIST_ACTIVE_SESS_HISTORY compile ;

alter VIEW SYS.DBA_HIST_TABLESPACE_STAT compile ;

alter VIEW SYS.DBA_HIST_SERVICE_STAT compile ;

alter VIEW SYS.DBA_HIST_SERVICE_WAIT_CLASS compile ;

alter PACKAGE SYS.DBMS_SWRF_REPORT_INTERNAL compile BODY;

alter PACKAGE SYS.DBMS_SQLTUNE compile BODY;

21 rows selected.



alter public synonym DBA_HIST_FILESTATXS compile;

alter public synonym DBA_HIST_SQLSTAT compile;

alter public synonym DBA_HIST_SQLBIND compile;

alter public synonym DBA_HIST_SYSTEM_EVENT compile;

alter public synonym DBA_HIST_WAITSTAT compile;

alter public synonym DBA_HIST_LATCH compile;

alter public synonym DBA_HIST_LATCH_MISSES_SUMMARY compile;

alter public synonym DBA_HIST_DB_CACHE_ADVICE compile;

alter public synonym DBA_HIST_ROWCACHE_SUMMARY compile;

alter public synonym DBA_HIST_SGASTAT compile;

alter public synonym DBA_HIST_SYSSTAT compile;

alter public synonym DBA_HIST_SYS_TIME_MODEL compile;

alter public synonym DBA_HIST_OSSTAT compile;

alter public synonym DBA_HIST_PARAMETER compile;

alter public synonym DBA_HIST_SEG_STAT compile;

alter public synonym DBA_HIST_ACTIVE_SESS_HISTORY compile;

alter public synonym DBA_HIST_TABLESPACE_STAT compile;

alter public synonym DBA_HIST_SERVICE_STAT compile;

alter public synonym DBA_HIST_SERVICE_WAIT_CLASS compile;

19 rows selected.

View altered.

View altered.

Package body altered.

Synonym altered.

Synonym altered.

Synonym altered.

Synonym altered.

Synonym altered.

Synonym altered.
Synonym altered.
Synonym altered.
tonto(areplm01):/home/oracle>