All, thanks for the input. Looks like someone implemented a login trigger. haven't seen the code yet, but I would venture a guess he used the unsupported "alter system set current_schema=x".
sometimes you live and learn, sometimes you just live! thx, jack silvey --- Hately Mike <[EMAIL PROTECTED]> wrote: > I don't hold out much hope here Jack. > It sounds like data dictionary corruption; maybe > somewhere round user$(?). > That's not to say the situation's irretrievable; > I've seen OTS fix some bad > situations in my time but I'm not sure that I'd want > to keep the database > even if Oracle Support can fix the problem. > > Regards, > Mike > > -----Original Message----- > Sent: 12 June 2002 14:23 > To: Multiple recipients of list 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 > > > > ____________________________________________________________________________ > ________________________ > > This email and any attached to it are confidential > and intended only for the > individual or > entity to which it is addressed. If you are not the > intended recipient, > please let us know > by telephoning or emailing the sender. You should > also delete the email and > any attachment > from your systems and should not copy the email or > any attachment or > disclose their content > to any other person or entity. The views expressed > here are not necessarily > those of > Churchill Insurance Group plc or its affiliates or > subsidiaries. Thank you. > Churchill Insurance Group plc. Company Registration > Number - 2280426. > England. > Registered Office: Churchill Court, Westmoreland > Road, Bromley, Kent BR1 > 1DP. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hately Mike > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
