4 Replies Latest reply: Jul 10, 2012 4:25 AM by user2608330 RSS

    upgrade to 11.2.0.3 on windows

    Nagaraju - Oracle-Oracle
      Upgrade to 11.2.0.3 with patch bundle 5 installed reports ORA-00942: table or view does not exist

      The below is error is reported while executing c1102000.sql as part of the upgrade process

      Rem
      Rem Set capture file id equal to replay file id. This is the correct behavior
      Rem for non-consolidated replays. Since this is an upgrade, this rule holds.
      Rem
      update sys.WRR$_REPLAY_DIVERGENCE set cap_file_id = file_id;
      update sys.WRR$_REPLAY_DIVERGENCE set cap_file_id = file_id
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist


      The file c1102000.sql located under /rdbms/admin of 11.2.0.3 patchset doesn't contain the above update statement which is failing

      Rem =======================================================================
      Rem Begin Changes for Database Replay
      Rem =======================================================================
      Rem
      Rem add columns to WRR$_CAPTURES and WRR$_REPLAYS
      Rem
      Rem wrr$_captures
      alter table WRR$_CAPTURES add (sqlset_owner varchar2(30));
      alter table WRR$_CAPTURES add (sqlset_name varchar2(30));
      Rem wrr$_replays
      alter table WRR$_REPLAYS add (sqlset_owner varchar2(30));
      alter table WRR$_REPLAYS add (sqlset_name varchar2(30));
      alter table WRR$_REPLAYS add (sqlset_cap_interval number);
      alter table WRR$_REPLAYS add (filter_set_name varchar2(1000));
      alter table WRR$_REPLAY_FILTER_SET add (default_action varchar2(20));

      Rem =======================================================================
      Rem End Changes for Database Replay
      Rem =======================================================================

      But as part of Patch bundle the file is being replaced (Information collected from actions.xml)

      </oracle.rdbms.tg4msql>
      <oracle.rdbms.dbscripts version="11.2.0.3.0" opt_req="O">
      <copy name="prvtlmcb.plb" path="%ORACLE_HOME%/rdbms/admin" file_name="rdbms/admin/prvtlmcb.plb"/>
      <copy name="prvtbxstr.plb" path="%ORACLE_HOME%/rdbms/admin" file_name="rdbms/admin/prvtbxstr.plb"/>
      <copy name="c1102000.sql" path="%ORACLE_HOME%/rdbms/admin" file_name="rdbms/admin/c1102000.sql"/>


      The new file c1102000.sql after patch bundle 5  install on 11.2.0.3 contains the update statement which fails

      Rem =======================================================================
      Rem Begin Changes for Database Replay
      Rem =======================================================================
      Rem
      Rem add columns to WRR$_CAPTURES and WRR$_REPLAYS
      Rem
      Rem wrr$_captures
      alter table WRR$_CAPTURES add (sqlset_owner varchar2(30));
      alter table WRR$_CAPTURES add (sqlset_name varchar2(30));
      Rem wrr$_replays
      alter table WRR$_REPLAYS add (sqlset_owner varchar2(30));
      alter table WRR$_REPLAYS add (sqlset_name varchar2(30));
      alter table WRR$_REPLAYS add (sqlset_cap_interval number);
      alter table WRR$_REPLAYS add (filter_set_name varchar2(1000));
      alter table WRR$_REPLAYS add (schedule_name varchar2(100));
      alter table WRR$_REPLAYS add (num_admins number);
      alter table WRR$_REPLAY_SEQ_DATA add (schedule_cap_id number);
      alter table WRR$_CONNECTION_MAP add (schedule_cap_id number);
      alter table WRR$_REPLAY_DATA add (schedule_cap_id number);
      alter table WRR$_REPLAY_DEP_GRAPH add (schedule_cap_id number);
      alter table WRR$_REPLAY_COMMITS add (schedule_cap_id number);
      alter table WRR$_REPLAY_REFERENCES add (schedule_cap_id number);
      alter table WRR$_REPLAY_FILTER_SET add (default_action varchar2(20));
      alter table WRR$_REPLAY_DIVERGENCE add (cap_file_id number);
      alter table WRR$_REPLAY_SQL_BINDS add (cap_file_id number);

      Rem
      Rem Set capture file id equal to replay file id. This is the correct behavior
      Rem for non-consolidated replays. Since this is an upgrade, this rule holds.
      Rem
      update sys.WRR$_REPLAY_DIVERGENCE set cap_file_id = file_id;
      commit;

      Rem =======================================================================
      Rem End Changes for Database Replay
      Rem =======================================================================


      During the upgrade the error "ORA-00942: table or view does not exist" reports ,

      Want to know whether is this issue with query or patch bundle ?