| 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: warehouse gets very strange - sys corrupted - sev1 tar
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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
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.
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |