DBUA 12.2 Upgrade fails with below error ORA-65295

刘泽宇

现象：
12.2 DBUA fails below error

ERRORS FOUND: During Upgrade
FILENAME: /u01/app/oracle/cfgtoollogs/dbua/upgrade2017-08-24_01-13-43-AM/cdb2/catupgrdcdbroot2R0.log AT LINE NUMBER: 11029
------------------------------------------------------
Identifier 17-08-24 04:12:00
SCRIPT = [/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catendappupg.sql]
ERROR = [ORA-65295: service name or module name mismatch ORA-06512: at line 13
ORA-06512: at line 7
]
STATEMENT = [declare
newvsn varchar2(30);
begin
select tgtver into newvsn from fed$versions v, fed$apps a
where a.app_status=2 and a.appid#=v.appid# and v.ver#=a.ver#+1
and a.app_name='APP$CDB$CATALOG';
execute immediate 'alter pluggable database application APP$CDB$CATALOG ' ||
'end upgrade to ''' || newvsn || '''';
exception
when no_data_found then null;
when others then
if sqlcode in (-65090, -65212, -65214, -1403) then null;
else raise;
end if;
end;]


原因：
Unpublished Bug 24740425

处理方法：
Edit catendappupg.sql inside $ORACLE_HOME/rdbms/admin of 12.2 home and add parameter " alter system set "_enable_module_match"=FALSE; " within the file and save and later click on Resume Option of DBUA to resume Upgrade .

EDIT catendappupg.sql file as shown below

vi $ORACLE_HOME/rdbms/admin/catendappupg.sql

@@?/rdbms/admin/sqlsessstart.sql

alter system set events '10520 level 0';
alter system set "_upgrade_optim"=FALSE;
alter system set "_upgrade_capture_noops"=FALSE;
alter system set "_enable_module_match"=FALSE; ******************Newly added parameter