| 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: system packages status is invalid Oracle 8.1.7 on red hat 7.2
Run rdbms/admin/utlrp.sql or utlrep.sql.
Then query again for invalid packages.
If there are still many, then not enough room to hold them all in your shared pool.
Packages are invalid when the db starts up, because no one has accessed them yet. Utlrp.sql forces Oracle to do the work up front.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
-----Original Message-----
Sent: Thursday, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: system packages status is invalid Oracle 8.1.7 on redhat 7.2
And you can't compile them?
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
> -----Original Message-----
> From: Praveen Sahni [SMTP:Praveen.Sahni_at_kshema.com]
> Sent: Wednesday, March 20, 2002 5:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: system packages status is invalid Oracle 8.1.7 on red hat
> 7.2
>
> Hi All,
>
> I have installed Oracle 8.1.7 on red hat linux 7.2.
> Every thing has gone fine. I even gone and installed the application on
> that.
> My problem is I saw now that there are some system packages listed below
> having status as 'INVALID'.
> Can anyone please let me know why and if we have any solution now.
> Is there any script I missed that's need to run and can I run it now after
> creating the application.
>
> Thanks in Advance
> Praveen
>
> PACKAGE DBMS_AQADM
> PACKAGE DBMS_AQADM_SYS
> PACKAGE DBMS_AQIN
> PACKAGE DBMS_AQIN
> PACKAGE DBMS_AQ_EXP_HISTORY_TABLES
> PACKAGE DBMS_AQ_EXP_INDEX_TABLES
> PACKAGE DBMS_AQ_EXP_QUEUES
> PACKAGE DBMS_AQ_EXP_QUEUE_TABLES
> PACKAGE DBMS_AQ_EXP_SUBSCRIBER_TABLES
> PACKAGE DBMS_AQ_EXP_TIMEMGR_TABLES
> PACKAGE DBMS_AQ_IMPORT_INTERNAL
> PACKAGE DBMS_AQ_IMP_INTERNAL
> PACKAGE DBMS_AQ_SYS_EXP_INTERNAL
> PACKAGE DBMS_AQ_SYS_IMP_INTERNAL
> PACKAGE DBMS_DDL
> PACKAGE DBMS_HS
> PACKAGE DBMS_HS_ALT
> PACKAGE DBMS_HS_UTL
> PACKAGE DBMS_IAS_CONFIGURE
> PACKAGE DBMS_IAS_QUERY
> PACKAGE DBMS_IAS_SESSION
> PACKAGE DBMS_IREFRESH
> PACKAGE DBMS_ISNAPSHOT
> PACKAGE DBMS_PRVTAQIM
> PACKAGE DBMS_PRVTAQIP
> PACKAGE DBMS_RULE_ADM
> PACKAGE DBMS_SNAPSHOT
> PACKAGE DBMS_SNAPSHOT_UTL
> PACKAGE DBMS_SNAP_REPAPI
> PACKAGE DBMS_SNAP_REPAPI
> PACKAGE DBMS_STATS
> PACKAGE DBMS_SUMADV
> PACKAGE DBMS_SUMMARY
> PACKAGE DBMS_SUMREF_CHILD
> PACKAGE DBMS_SUMREF_PARENT
> PACKAGE DBMS_UTILITY
> PACKAGE HTP
> PACKAGE OWA
> PACKAGE OWA_COOKIE
> PACKAGE OWA_CUSTOM
> PACKAGE OWA_TEXT
> PACKAGE OWA_UTIL
> PACKAGE PRVT_EGUTL
> PACKAGE PRVT_EPGC
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Praveen Sahni
> INET: Praveen.Sahni_at_kshema.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: lisa.koivu_at_efairfield.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: BoivinP_at_mar.dfo-mpo.gc.ca Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Mar 21 2002 - 09:23:24 CST
 |
 |