源库19.8，dg库19.20，切换dg库刷视图升级补丁报错：
./datapatch -verbose
Error: prereg checks failed!
patch 31281355: Error reading descriptor from registry: Couldn't open encmap gbk.enc:
such file or directory
at /oracle/app/product/19.3.0/db 1/perl/lib/site perl/5.360/x86 64-linux-thread-multi/xM./Parser.om line 187
XML ::Simple called at /oracle/app/product/19.3.0/db 1/sglpatch/salpatchpm line 8564.
由于dg库没有不油19.8的补丁，所以导致刷视图时报错，所以先清理数据库内的补丁信息
SQL> drop table registry$sqlpatch;
SQL> drop table registry$sqlpatch_ru_info;
SQL> commit;
SQL>@$ORACLE_HOME/rdbms/admin/catsqlreg.sql
Check if registry$sqlpatch can be queried without fail :
SQL> select * from registry$sqlpatch;
重新执行数据库补丁应用:
./datapatch -verbose
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22967847/viewspace-3008409/ ，如需转载，请注明出处，否则将追究法律责任。
