Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: warehouse gets very strange - sys corrupted - sev1 tar

Re: warehouse gets very strange - sys corrupted - sev1 tar

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 12 Jun 2002 07:49:13 -0800
Message-ID: <F001.0047BEBE.20020612074913@fatcity.com>

My sentiments exactly. If you can't drop the schema, go to dba_objects and drop everything that has a CREATED that matches the time when the catalog.sql was mis-run.

Sounds as if someone decided to clean up the database and dropped all those PUBLIC SYNONYMS that they didn't understand.

You're probably going to have to re-run catalog.sql as SYS also.

It doesn't sound too serious, just don't mess up the database anymore. Make sure that you understand what you're doing and why you're doing it.

                                                                                           
                    Jack van                                                               
                    Zanen                To:     Multiple recipients of list ORACLE-L      
                    <nlzanen1            <ORACLE-L_at_fatcity.com>                            
                    @EY.NL>              cc:                                               
                    Sent by: root        Subject:     Re: warehouse gets very strange -    
                                         sys corrupted - sev1 tar                          
                                                                                           
                    06/12/2002                                                             
                    09:48 AM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L                                                               
                                                                                           
                                                                                           





Hi

Did the oncall run catalog.sql as dma_rbate2?? If so he should have been in bed.

You now have all the packages and procedures created in catalog living in dma_rbate2 schema? can you drop that schema?

You can desc sys.dbms_backup_restore. Did you loose a public/private synonym here that can solve the problem of rman not being able to find the package??

Jack

                      Jack Silvey
                      <jack_silvey_at_yaho        To:       Multiple
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
                      o.com>                   cc:       (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
                      Sent by:                 Subject:  warehouse gets
very strange - sys corrupted - sev1 tar
                      root_at_fatcity.com


                      12-06-2002 15:23
                      Please respond to
                      ORACLE-L





Listers,

Our warehouse now has a split personality and we have a sev1 open on it. Suspect recovery is in the cards, but want to avoid if possible.

Yesterday, users unable to get to their own functions. Soon after, RMAN cannot find package
dbms_backup_restore, even though it exists under sys. Oncall ran the sql script to recreate - and the pacakge was recreated under a schema called dma_rbate2. RMAN now finds the package under dma_rbate2, although it is invalid. Drop the package under dma_rbate2, and now RMAN cannot find the package any longer, although it still exists under sys.

Logged in as sys. Tried to desc dbms_backup_restore - no luck. Tried to desc sys.dbms_backup_restore - success.

Analyst reccomends running catalog.sql. Oncall does so, and it creates as many packages as it is able under dma_rbate2.

I get up this AM and can't login, because the sessions can't find the package
dma_rbate2.dbms_application_info.

Anyone? Buhler? Buhler?

thx,

jack



Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jack Silvey
  INET: jack_silvey_at_yahoo.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).

De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden.



The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.


--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jack van Zanen
  INET: nlzanen1_at_EY.NL

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: Thomas Day
  INET: tday6_at_csc.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). Received on Wed Jun 12 2002 - 10:49:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US