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 <Mike.Hately_at_churchill.com> 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: Mike.Hately_at_churchill.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).
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).
Received on Wed Jun 12 2002 - 10:38:32 CDT
