探索Oracle之数据库升级六11.2.0.4.3Upgrade12c(12.2.0.1) - 数据库编程

********************************************************** PL/SQL procedure successfully completed. ***************************************** ******** Fixed Object Statistics ******** ***************************************** Please create stats on fixed objects two weeks after the upgrade using the command: EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; ^^^ MANUAL ACTION SUGGESTED ^^^ PL/SQL procedure successfully completed. ************************************************** ************* Fixup Summary ************ 1 fixup routine generated an INFORMATIONAL message that should be reviewed. PL/SQL procedure successfully completed. *************** Post Upgrade Fixup Script Complete ******************** PL/SQL procedure successfully completed. SQL>

7.6 检查DST
从升级后的检查结果来看，DST目前是18，说明不需要人工处理了，如果不是需要手工来处理，参考Metalink ID: 977512.1 或者参考Metalink ID 1585343.1

SQL> r
  1 SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  2 FROM DATABASE_PROPERTIES
  3 WHERE PROPERTY_NAME LIKE \'DST_%\'
  4* ORDER BY PROPERTY_NAME

PROPERTY_NAME VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
DST_PRIMARY_TT_VERSION 18
DST_SECONDARY_TT_VERSION 0
DST_UPGRADE_STATE NONE

SQL> select * from v$timezone_file;

FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_18.dat 18 0

SQL> select TZ_VERSION from registry$database;

TZ_VERSION
----------
        18

7.7 字符集检查

检查国家字符集，如果是以下字符集则不需要做操作:

如果返回结果是 UTF8或者 AL16UTF16，那么什么都不需要做了。
如果返回结果不是 UTF8或者 AL16UTF16，那么请参考下面的文档：

Note 276914.1

ID 276914.1)

SQL> select value from nls_database_parameters where parameter=\'NLS_NCHAR_CHARACTERSET\';
 
VALUE
--------------------------------------------------------------------------------
AL16UTF16

7.8 修改参数文件中版本号

SQL> show parameter compatible
 
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 11.2.0.0.0
noncdb_compatible boolean FALSE

SQL> alter system set compatible = \'12.1.0.1.0\' scope=spfile;

System altered.

SQL> startup force;

ORACLE instance started.

Total System Global Area 2772574208 bytes
Fixed Size 2292240 bytes
Variable Size 2533361136 bytes
Database Buffers 218103808 bytes
Redo Buffers 18817024 bytes

Database mounted.
Database opened.

SQL> 
SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.1.0.1.0
noncdb_compatible boolean FALSE

SQL>

至此，经过漫长而辛苦的升级，我们已经将11.2.0.4顺利升级到了12.1.0.1，整个升级过程虽然有点长，但还是比较顺利的。故需再生产环境中升级请大家务必预留好可用于升级的时间窗口，升级时间确实是非常的长。

探索Oracle之数据库升级六11.2.0.4.3Upgrade12c(12.2.0.1)(十)