1 Reply Latest reply: Nov 19, 2012 5:13 AM by 834639 RSS

    ORA-00904: "OBJ$EDITION": invalid identifier after upgrade to 11.2.0.3

    834639
      Hi,

      I recently performed an upgrade on a new server from oracle 10gr2 to oracle 11gr2 (11.2.0.3).

      I take the rman backup from oracle 10g server and restore it on new server where I installed oracle 11gr2.

      But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error:


      SQL> conn scott/tiger
      ERROR:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-00904: "OBJ$EDITION": invalid identifier
      ORA-02002: error while writing to audit trail
      ORA-00604: error occurred at recursive SQL level 1
      ORA-00904: "OBJ$EDITION": invalid identifier

      I got the workaround by setting the parameter audit_trail=FALSE (Previous value was DB_EXTENDED) .

      But I want my auditing to be enabled as per y requirements.


      Thank you for your cooperation.


      Kind Regards,

      Adnan Hamdussalam
        • 1. Re: ORA-00904: "OBJ$EDITION": invalid identifier after upgrade to 11.2.0.3
          834639
          Hi Guys,

          I raised the SR to MOS and got the solution. Love share it with you too.


          1) SQL>alter table aud$ add (OBJ$EDITION VARCHAR2(30) );

          2) Run cataudit.sql (to ensure all the views based on AUD$ are in place). /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin


          select OWNER,TABLE_NAME,COLUMN_NAME from dba_tab_columns where COLUMN_NAME='OBJ$EDITION';

          OWNER TABLE_NAME COLUMN_NAME
          ------------------------------ ------------------------------ ------------------------------
          SYS AUD$ OBJ$EDITION
          SYS FGA_LOG$ OBJ$EDITION


          Kind Regards,

          Adnan Hamdussalam