Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to make DBA_AUDIT_TRAIL’s status to VALID

226 views
Skip to first unread message

zigzagdna

unread,
May 20, 2010, 11:54:12 PM5/20/10
to
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.

Vladimir M. Zakharychev

unread,
May 21, 2010, 4:56:40 AM5/21/10
to

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

Mark D Powell

unread,
May 21, 2010, 9:57:36 AM5/21/10
to
On May 21, 4:56 am, "Vladimir M. Zakharychev"

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 --

zigzagdna

unread,
May 21, 2010, 10:38:40 PM5/21/10
to
> 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.

Mark D Powell

unread,
May 22, 2010, 10:24:31 AM5/22/10
to
> > - 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?

zigzagdna

unread,
May 22, 2010, 6:45:56 PM5/22/10
to

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.

Sybrand Bakker

unread,
May 23, 2010, 7:35:31 AM5/23/10
to

You are aware this invalidates your support license?
Ok, it is established now you are not a DBA, but a hacker
only!!!!!!!!!!
Luckily you don't work for me, I would fire you on the spot.

----
Sybrand Bakker
Senior Oracle DBA

0 new messages