How to make DBA_AUDIT_TRAIL’s status to VALID
in [Oracle]
|
Prev: Question about rman
Next: SQLLDR
From: zigzagdna on 20 May 2010 23:54 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.
From: Vladimir M. Zakharychev on 21 May 2010 04:56 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
From: Mark D Powell on 21 May 2010 09:57 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 --
From: zigzagdna on 21 May 2010 22:38 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.
From: Mark D Powell on 22 May 2010 10:24
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 -- |