![](https://csdnimg.cn/release/download_crawler_static/87517500/bg3.jpg)
/u01/app/oracle/cfgtoollogs/orcl/preupgrade/postupgrade_fixups.sql
2. Review logs under /u01/app/oracle/cfgtoollogs/orcl/preupgrade/
Preupgrade complete: 2020-12-28T14:23:15
根据上面的输出,在升级时候要遵守 preupgrade.log 里面的建议。整个升级过程都在严
格遵守 preupgrade.log 的建议。
在升级前执行 preupgrade_fixups.sql 脚本,在升级后执行 postupgrade_fixups.sql 脚
本。
preupgrade.log 报告如下,需要根据报告的建议进行修改
执行 fixup 脚本:
如下命令会在所有的 PDB 中执行 preupgrade_fixups.sql。
@ /u01/app/oracle/cfgtoollogs/orcl/preupgrade/preupgrade_fixups.sql
3、检查源库失效的组件及对象
set pagesize 500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version
from dba_registry order by comp_name;
select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type
from dba_objects where status='INVALID' order by owner,object_type;
select owner,object_type,count(*) from dba_objects where status='INVALID' group
by owner,object_type order by owner,object_type ;