This discussion is archived
4 Replies Latest reply: Jul 10, 2012 2:25 AM by user2608330 RSS

upgrade to 11.2.0.3 on windows

Nagaraju - Oracle Explorer
Currently Being Moderated
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 ?

Legend

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