SQL> SELECT 'CREATE '||DECODE(U.NAME,'PUBLIC','public ')||'DATABASE LINK '||CHR(10) WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_ĪND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS')
参照 Update Access Control Lists and Network Utility Packages 从 12c 开始,UTL 包(UTL_TCP,UTL_SMTP,UTL_MAIL,UTL_HTTP,和 UTL_INADDR)的访问控制由 Oracle Database Real Application Security 来实现,不再依赖 Oracle XML DB 功能。 'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY', SQL> 和 postupgrade_fixups.sql 文件会创建在源库的 $ORACLE_HOME/cfgtoollogs/$ORACLE_SID/preupgrade/ 目录下。
* 把 12c 的 $ORACLE_HOME/rdbms/admin 目录中的 Pre-Upgrade Information Tool 工具(即 preupgrd.sql 和 utluppkg.sql 脚本)拷贝到源库的 $ORACLE_HOME/rdbms/admin 目录下。
Note 884522.1 How to Download and Run Oracle's Database Pre-Upgrade Utility Pre-Upgrade Information Tool 需要在旧的数据库上执行。 Note 136697.1 hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g Note 556610.1 Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) 具体请参照文档 Note 2037154.1 DBMS_STATS.GATHER_DICTIONARY_STATS Fails with "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" 如果 concurrent statistics gathering 没有设置为 false,那么在升级前把它改为 false。ĭBMS_STATS.SET_GLOBAL_PREFS('CONCURRENT','FALSE')
SQL> SELECT dbms_stats.get_prefs('CONCURRENT') from dual
在11g,创建带有 timestamp with timezone 数据类型的 ACL 不会失败,但是在升级到 12c 后就会碰到"ORA-01830: date format picture ends before converting entire input string" 错误而失败,请参照 Note 1958876.1 Upgrade to 12.1 fails with ORA-01830 date format picture ends before converting entire input string ORA-06512: at "SYS.XS_OBJECT_MIGRATION"。
Note 753736.1 : Quick Reference to Patchset Patch NumbersīACKUP DATABASE FORMAT '%U' TAG before_upgrade Note 438049.1 : How To Find RDBMS patchsets on My Oracle Support Oracle Database - Standard Edition - 版本 10.2.0.5 和更高版本 Oracle Database - Enterprise Edition - 版本 10.2.0.5 和更高版本