RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2

May be running the script file resolve the problem, but i could not find that why the packages
became invalid after the application creation.

any idea anyone ahve?

Nirmal.

> -----Original Message-----
> From: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> Sent:
> To: Multiple recipients of list ORACLE-L
> Subject: 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 red
> hat 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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