This discussion is archived
1 Reply Latest reply: Nov 19, 2012 3:13 AM by 834639 RSS

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

834639 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points