(wrong string) ‚€™s status to VALID

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sat, 22 May 2010 15:45:56 -0700 (PDT)
Message-ID: <e01473f2-6fc5-4526-9f49-7a4b29e1683c_at_q33g2000vbt.googlegroups.com>



On May 22, 10:24†am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On May 21, 10:38†pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
>
>
>
>
> > On May 21, 9:57†am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
>
> > > On May 21, 4:56†am, "Vladimir M. Zakharychev"
>
> > > <vladimir.zakharyc..._at_gmail.com> wrote:
> > > > On May 21, 7:54†am, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
> > > > > I am on Oracle 11g 11.1.0.7.1 on HP UNIX 11i. I have run utilrp.sql
> > > > > yet I see
> > > > > DBA_AUIT_TRAIL is INVALID
>
> > > > > When I try to recompile DBA_AUIT_TRAIL it errors out with a message:
> > > > > SQL> show errors view DBA_AUDIT_TRAIL;
> > > > > Errors for VIEW DBA_AUDIT_TRAIL:
> > > > > 0/0 † † †ORA-00904: "OBJ$EDITION": invalid identifier
> > > > > SQL>
>
> > > > > So where is OBJ$EDITON; † how to make this view valid.
>
> > > > Huh? Edition-Based Redefinition is a new feature in 11g Release 2,
> > > > isn't it? OBJ$EDITION seems to be related to this feature, it
> > > > shouldn't be present in 11.1 (at least, not officially.) You probably
> > > > installed a backport patch that should not had been installed or they
> > > > backported it wrong.
>
> > > > Regards,
> > > > † †Vladimir M. Zakharychev
> > > > † †N-Networks, makers of Dynamic PSP(tm)
> > > > † †http://www.dynamicpsp.com
>
> > > I do not currently have an 11g install I can access however in past
> > > versions the $ORACLE_HOME/rdbms/admin/cataudit.sql script contained
> > > the view definition. †Have you tried rerunning this script?
>
> > > HTH -- Mark D Powell --- Hide quoted text -
>
> > > - Show quoted text -I ran cataudit.slq, did not fix the problem becase aud$ doe snot have obj$edition.- Hide quoted text -
>
> > - Show quoted text -
>
> Did you search the $ORACLE_HOME/rdbms/admin directory to see which
> script creats obj$edition? †Did you check dba_registry to see any
> features/components are invalid and need to be fixed?
>
> HTH -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -

I found that somehow aud$ in my instalation has some columns missing. I think these cloumns have o do with extended database auditing and also includ eobj$editio. I was looking at a correct installtion which had these columns. I just added the columns using alter table aud$ and pproblem went away. Received on Sat May 22 2010 - 17:45:56 CDT

Original text of this message