Prev: Easy Way To Get Google Adsense Account Approval.
Next: group by/order by problem
From: Sybrand Bakker on 23 May 2010 07:35
On Sat, 22 May 2010 15:45:56 -0700 (PDT), zigzagdna
<zigzagdna(a)yahoo.com> wrote:

>On May 22, 10:24�am, Mark D Powell <Mark.Powe...(a)hp.com> wrote:
>> On May 21, 10:38�pm, zigzagdna <zigzag...(a)yahoo.com> wrote:
>>
>>
>>
>>
>>
>> > On May 21, 9:57�am, Mark D Powell <Mark.Powe...(a)hp.com> wrote:
>>
>> > > On May 21, 4:56�am, "Vladimir M. Zakharychev"
>>
>> > > <vladimir.zakharyc...(a)gmail.com> wrote:
>> > > > On May 21, 7:54�am, zigzagdna <zigzag...(a)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.

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

 | 
Pages: 1
Prev: Easy Way To Get Google Adsense Account Approval.
Next: group by/order by problem