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

You might want to run UTLRP.SQL on your database. Do this as SYS or INTERNAL. Also remember to do a SET ORACLE_SID=your_sid first.

Dave

-----Original Message-----
Sent: Thursday, March 21, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L 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: Farnsworth, Dave
  INET: DFarnsworth_at_Ashleyfurniture.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).