devbox
繁依Fanyi0
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Oracle Database 11.2.0.4升级到 12.2.0.1_database time zone version is 26. it is older than

作者：繁依Fanyi0 | 2024-05-14 20:50:41

赞

踩

database time zone version is 26. it is older than current release time zone

参考MOS ：
手动升级到 Non-CDB Oracle Database 12c Release 2（12.2）的完整核对清单 (Doc ID 2297983.1)
Updating the RDBMS DST version in 12c Release 1 (12.1.0.1 and up) using DBMS_DST (Doc ID 1509653.1)
Scripts to update the RDBMS DST (timezone) version in an 11gR2 or 12c database . (Doc ID 1585343.1)
"CATPROC.SQL" EXECUTION HANGS IF DATABASE HAS JOBS RUNNING (Doc ID 1077852.6)
Oracle 12.2.0.1 Installation Fails With "PRVG-0449 : Proper soft limit for maximum stack size was not found on node "node1" [Expected >= "10240" ; Found = "8192"]" (Doc ID 2287806.1)

 

OS :radhat7.6
RDBMS: 11.2.0.4 ---> 12.2.0.1

步骤：
1 安装12.2.0.1的Sofeware，安装目录/u01/app/oracle/product/12.2.0/dbhome_1。其中11.2.0.4的目录是/u01/app/oracle/product/11.2.0/dbhome_1
2 执行dbupgdiag.sql(可以从 note 556610.1 下载这个脚本).主要是确认是否有失效对象或组件。
3 清空回收站  
4 检查物化视图是否刷新完毕 。
5 收集统计信息 ，目的是为了减少停机时间。
6 检查时区设置 。
7 检查是否存在备份 。
8 升级前先解决Outstanding分布式事务 。
9 Preupgrade 检查 。
10 进行升级
11 升级后步骤(环境变量，oratab文件更新，升级catalog，post-upgrade fixup脚本等等)

详细步骤
1  安装software，略。在安装的时候，提示错误，参考上面的MOS Doc ID 2287806.1解决。

2  执行dbupgdiag.sql

  1. sql> alter session set nls_language='American';
  2. sql> @dbupgdiag.sql
  3. sql> exit

--- 上面步骤过程 -

  1. [oracle@wls10306-02 12.2.0]$ cd dbhome_1/rdbms/admin/
  2. [oracle@wls10306-02 admin]$ ll dbup*
  3. -rw-r--r-- 1 oracle oinstall 24633 Jan 16 16:14 dbupgdiag.sql
  4. [oracle@wls10306-02 admin]$ sqlplus /nolog
  5.  
  6. SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 16 16:14:52 2020
  8. Copyright (c) 1982, 2013, Oracle.  All rights reserved.
  9.  
  10. SQL> conn / as sysdba
  11. Connected.
  12. SQL> alter session set nls_language='American';
  13.  
  14. Session altered.
  15.  
  16. SQL> @dbupgdiag.sql
  17.  
  18. Enter location for Spooled output:
  19.  
  20. Enter value for 1: /tmp
  21.  
  22. 16_Jan_2020_0415	  .log
  23.  
  24. test_
  25.  
  26.  
  27.  
  28. 			  *** Start of LogFile ***
  29.  
  30.   Oracle Database Upgrade Diagnostic Utility	   01-16-2020 16:15:40
  31.  
  32. ===============
  33. Hostname
  34. ===============
  35.  
  36. wls10306-02
  37.  
  38. ===============
  39. Database Name
  40. ===============
  41.  
  42. TEST
  43.  
  44. ===============
  45. Database Uptime
  46. ===============
  47.  
  48. 16:08 16-JAN-20
  49.  
  50. =================
  51. Database Wordsize
  52. =================
  53.  
  54. This is a 64-bit database
  55.  
  56. ================
  57. Software Version
  58. ================
  59.  
  60. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  61. PL/SQL Release 11.2.0.4.0 - Production
  62. CORE	11.2.0.4.0	Production
  63. TNS for Linux: Version 11.2.0.4.0 - Production
  64. NLSRTL Version 11.2.0.4.0 - Production
  65.  
  66. =============
  67. Compatibility
  68. =============
  69.  
  70. Compatibility is set as 11.2.0.4.0
  71.  
  72. ================
  73. Archive Log Mode
  74. ================
  75.  
  76. Database log mode	       No Archive Mode
  77. Automatic archival	       Disabled
  78. Archive destination	       USE_DB_RECOVERY_FILE_DEST
  79. Oldest online log sequence     7
  80. Current log sequence	       9
  81.  
  82. ================
  83. Auditing Check
  84. ================
  85.  
  86.  
  87. NAME				     TYPE	 VALUE
  88. ------------------------------------ ----------- ------------------------------
  89. audit_file_dest 		     string	 /u01/app/oracle/admin/test/adu
  90. 						 mp
  91. audit_sys_operations		     boolean	 FALSE
  92. audit_syslog_level		     string
  93. audit_trail			     string	 DB
  94.  
  95. ================
  96. Cluster Check
  97. ================
  98.  
  99. NAME				     TYPE	 VALUE
  100. ------------------------------------ ----------- ------------------------------
  101. cluster_database		     boolean	 FALSE
  102. cluster_database_instances	     integer	 1
  103.  
  104. DOC>################################################################
  105. DOC>
  106. DOC> If CLUSTER_DATABASE is set to TRUE, change it to FALSE before
  107. DOC> upgrading the database
  108. DOC>
  109. DOC>################################################################
  110. DOC>#
  111.  
  112. ===========================================
  113. Tablespace and the owner of the aud$ table  ( IF Oracle Label Security and Oracle Database Vault are installed then aud$ will be in SYSTEM.AUD$)
  114. ===========================================
  115.  
  116. OWNER	     TABLESPACE_NAME
  117. ------------ ------------------------------
  118. SYS	     SYSTEM
  119.  
  120. ============================================================================
  121. count of records in the sys.aud$ table where dbid is null- Standard Auditing
  122. ============================================================================
  123.  
  124.  
  125. 	 0
  126.  
  127.  
  128. ============================================================================================
  129. count of records in the system.aud$ when dbid is null, Std Auditing with OLS or DV installed
  130. ============================================================================================
  131. select count(*) from system.aud$ where dbid is null
  132.                             *
  133. ERROR at line 1:
  134. ORA-00942: table or view does not exist
  135.  
  136.  
  137.  
  138.  
  139. =============================================================================
  140. count of records in the sys.fga_log$ when dbid is null, Fine Grained Auditing
  141. =============================================================================
  142.  
  143. 	 0
  144.  
  145.  
  146.  
  147. ==========================================
  148. Oracle Label Security is installed or not
  149. ==========================================
  150.  
  151. Oracle Label Security is NOT installed at database level
  152.  
  153. ================
  154. Number of AQ Records in Message Queue Tables
  155. ================
  156.  
  157. SYS - ALERT_QT - 11
  158. SYS - AQ$_MEM_MC - 0
  159. SYS - AQ_EVENT_TABLE - 0
  160. SYS - AQ_PROP_TABLE - 0
  161. SYS - KUPC$DATAPUMP_QUETAB - 0
  162. SYS - KUPC$DATAPUMP_QUETAB_1 - 0
  163. SYS - SCHEDULER$_EVENT_QTAB - 0
  164. SYS - SCHEDULER$_REMDB_JOBQTAB - 0
  165. SYS - SCHEDULER_FILEWATCHER_QT - 0
  166. SYS - SYS$SERVICE_METRICS_TAB - 0
  167. SYSMAN - MGMT_LOADER_QTABLE - 0
  168. SYSMAN - MGMT_NOTIFY_INPUT_QTABLE - 0
  169. SYSMAN - MGMT_NOTIFY_QTABLE - 0
  170. SYSMAN - MGMT_PAF_MSG_QTABLE_1 - 0
  171. SYSMAN - MGMT_PAF_MSG_QTABLE_2 - 0
  172. SYSMAN - MGMT_TASK_QTABLE - 28
  173. SYSTEM - DEF$_AQCALL - 0
  174. SYSTEM - DEF$_AQERROR - 0
  175. WMSYS - WM$EVENT_QUEUE_TABLE - 0
  176.  
  177. ================
  178. Time Zone version
  179. ================
  180.  
  181.  
  182. 	14
  183.  
  184. ================
  185. Local Listener
  186. ================
  187.  
  188.  
  189.  
  190.  
  191. ================
  192. Default and Temporary Tablespaces By User
  193. ================
  194.  
  195.  
  196. USERNAME		     TEMPORARY_TABLESPACE   DEFAULT_TABLESPACE
  197. ---------------------------- ---------------------- ----------------------
  198. MGMT_VIEW		     TEMP		    SYSTEM
  199. SYS			     TEMP		    SYSTEM
  200. SYSTEM			     TEMP		    SYSTEM
  201. DBSNMP			     TEMP		    SYSAUX
  202. SYSMAN			     TEMP		    SYSAUX
  203. WEBLOGIC		     TEMP		    USERS
  204. APPS			     TEMP		    USERS
  205. OUTLN			     TEMP		    SYSTEM
  206. FLOWS_FILES		     TEMP		    SYSAUX
  207. MDSYS			     TEMP		    SYSAUX
  208. ORDSYS			     TEMP		    SYSAUX
  209. EXFSYS			     TEMP		    SYSAUX
  210. WMSYS			     TEMP		    SYSAUX
  211. APPQOSSYS		     TEMP		    SYSAUX
  212. APEX_030200		     TEMP		    SYSAUX
  213. OWBSYS_AUDIT		     TEMP		    SYSAUX
  214. ORDDATA 		     TEMP		    SYSAUX
  215. CTXSYS			     TEMP		    SYSAUX
  216. ANONYMOUS		     TEMP		    SYSAUX
  217. XDB			     TEMP		    SYSAUX
  218. ORDPLUGINS		     TEMP		    SYSAUX
  219. OWBSYS			     TEMP		    SYSAUX
  220. SI_INFORMTN_SCHEMA	     TEMP		    SYSAUX
  221. OLAPSYS 		     TEMP		    SYSAUX
  222. SCOTT			     TEMP		    USERS
  223. ORACLE_OCM		     TEMP		    USERS
  224. XS$NULL 		     TEMP		    USERS
  225. BI			     TEMP		    USERS
  226. PM			     TEMP		    USERS
  227. MDDATA			     TEMP		    USERS
  228. IX			     TEMP		    USERS
  229. SH			     TEMP		    USERS
  230. DIP			     TEMP		    USERS
  231. OE			     TEMP		    USERS
  232. APEX_PUBLIC_USER	     TEMP		    USERS
  233. HR			     TEMP		    USERS
  234. SPATIAL_CSW_ADMIN_USR	     TEMP		    USERS
  235. SPATIAL_WFS_ADMIN_USR	     TEMP		    USERS
  236.  
  237.  
  238. ================
  239. Component Status
  240. ================
  241.  
  242. Comp ID Component			   Status    Version	    Org_Version    Prv_Version
  243. ------- ---------------------------------- --------- -------------- -------------- --------------
  244. AMD	OLAP Catalog			   VALID     11.2.0.4.0
  245. APEX	Oracle Application Express	   VALID     3.2.1.00.12
  246. APS	OLAP Analytic Workspace 	   VALID     11.2.0.4.0
  247. CATALOG Oracle Database Catalog Views	   VALID     11.2.0.4.0
  248. CATJAVA Oracle Database Java Packages	   VALID     11.2.0.4.0
  249. CATPROC Oracle Database Packages and Types VALID     11.2.0.4.0
  250. CONTEXT Oracle Text			   VALID     11.2.0.4.0
  251. EM	Oracle Enterprise Manager	   VALID     11.2.0.4.0
  252. EXF	Oracle Expression Filter	   VALID     11.2.0.4.0
  253. JAVAVM	JServer JAVA Virtual Machine	   VALID     11.2.0.4.0
  254. ORDIM	Oracle Multimedia		   VALID     11.2.0.4.0
  255. OWB	OWB				   VALID     11.2.0.4.0
  256. OWM	Oracle Workspace Manager	   VALID     11.2.0.4.0
  257. RUL	Oracle Rules Manager		   VALID     11.2.0.4.0
  258. SDO	Spatial 			   VALID     11.2.0.4.0
  259. XDB	Oracle XML Database		   VALID     11.2.0.4.0
  260. XML	Oracle XDK			   VALID     11.2.0.4.0
  261. XOQ	Oracle OLAP API 		   VALID     11.2.0.4.0
  262.  
  263.  
  264.  
  265. ======================================================
  266. List of Invalid Database Objects Owned by SYS / SYSTEM
  267. ======================================================
  268.  
  269.  
  270. Number of Invalid Objects
  271. ------------------------------------------------------------------
  272. There are no Invalid Objects
  273.  
  274. DOC>################################################################
  275. DOC>
  276. DOC> If there are no Invalid objects below will result in zero rows.
  277. DOC>
  278. DOC>################################################################
  279. DOC>#
  280.  
  281.  
  282. no rows selected
  283.  
  284.  
  285. ================================
  286. List of Invalid Database Objects
  287. ================================
  288.  
  289.  
  290. Number of Invalid Objects
  291. ------------------------------------------------------------------
  292. There are no Invalid Objects
  293.  
  294. DOC>################################################################
  295. DOC>
  296. DOC> If there are no Invalid objects below will result in zero rows.
  297. DOC>
  298. DOC>################################################################
  299. DOC>#
  300.  
  301.  
  302. no rows selected
  303.  
  304.  
  305. ======================================================
  306. Count of Invalids by Schema
  307. ======================================================
  308.  
  309. ==============================================================
  310. Identifying whether a database was created as 32-bit or 64-bit
  311. ==============================================================
  312.  
  313. DOC>###########################################################################
  314. DOC>
  315. DOC> Result referencing the string 'B023' ==> Database was created as 32-bit
  316. DOC> Result referencing the string 'B047' ==> Database was created as 64-bit
  317. DOC> When String results in 'B023' and when upgrading database to 10.2.0.3.0
  318. DOC> (64-bit) , For known issue refer below articles
  319. DOC>
  320. DOC> Note 412271.1 ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While
  321. DOC>		   Upgrading Or Patching Databases To 10.2.0.3
  322. DOC> Note 579523.1 ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and
  323. DOC>		  OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6
  324. DOC>
  325. DOC>###########################################################################
  326. DOC>#
  327.  
  328.  
  329. Metadata Initial DB Creation Info
  330. -------- -----------------------------------
  331. B047	 Database was created as 64-bit
  332.  
  333. ===================================================
  334. Number of Duplicate Objects Owned by SYS and SYSTEM
  335. ===================================================
  336.  
  337. Counting duplicate objects ....
  338.  
  339.  
  340.   COUNT(1)
  341. ----------
  342. 	 0
  343.  
  344. =========================================
  345. Duplicate Objects Owned by SYS and SYSTEM
  346. =========================================
  347.  
  348. Querying duplicate objects ....
  349.  
  350.  
  351. DOC>
  352. DOC>################################################################################
  353. DOC>Below are expected and required duplicates objects and OMITTED in the report .
  354. DOC>
  355. DOC>Without replication installed:
  356. DOC>INDEX	    AQ$_SCHEDULES_PRIMARY
  357. DOC>TABLE	    AQ$_SCHEDULES
  358. DOC>
  359. DOC>If replication is installed by running catrep.sql:
  360. DOC>INDEX	    AQ$_SCHEDULES_PRIMARY
  361. DOC>PACKAGE	    DBMS_REPCAT_AUTH
  362. DOC>PACKAGE BODY	DBMS_REPCAT_AUTH
  363. DOC>TABLE	    AQ$_SCHEDULES
  364. DOC>
  365. DOC>If any objects found please follow below article.
  366. DOC>Note 1030426.6 How to Clean Up Duplicate Objects Owned by SYS and SYSTEM schema
  367. DOC>Read the Exceptions carefully before taking actions.
  368. DOC>
  369. DOC>################################################################################
  370. DOC>#
  371.  
  372. ========================
  373. Password protected roles
  374. ========================
  375.  
  376. DOC>
  377. DOC>################################################################################
  378. DOC>
  379. DOC> In version 11.2 password protected roles are no longer enabled by default so if
  380. DOC> an application relies on such roles being enabled by default and no action is
  381. DOC> performed to allow the user to enter the password with the set role command, it
  382. DOC> is recommended to remove the password from those roles (to allow for existing
  383. DOC> privileges to remain available). For more information see:
  384. DOC>
  385. DOC> Note 745407.1 : What Roles Can Be Set as Default for a User?
  386. DOC>
  387. DOC>################################################################################
  388. DOC>#
  389.  
  390. Querying for password protected roles ....
  391.  
  392.  
  393. Password protected Role        Assigned by default to user
  394. ------------------------------ ------------------------------
  395. OWB$CLIENT		       OWBSYS
  396.  
  397. ================
  398. JVM Verification
  399. ================
  400.  
  401.  
  402. ================================================
  403. Checking Existence of Java-Based Users and Roles
  404. ================================================
  405.  
  406. DOC>
  407. DOC>################################################################################
  408. DOC>
  409. DOC> There should not be any Java Based users for database version 9.0.1 and above.
  410. DOC> If any users found, it is faulty JVM.
  411. DOC>
  412. DOC>################################################################################
  413. DOC>#
  414.  
  415.  
  416. User Existence
  417. ---------------------------
  418. No Java Based Users
  419.  
  420. DOC>
  421. DOC>###############################################################
  422. DOC>
  423. DOC> Healthy JVM Should contain Six Roles. For 12.2 Seven Roles
  424. DOC> If there are more or less than six role, JVM is inconsistent.
  425. DOC>
  426. DOC>###############################################################
  427. DOC>#
  428.  
  429.  
  430. Role
  431. ------------------------------
  432. There are 6 JAVA related roles
  433.  
  434. Roles
  435.  
  436.  
  437. ROLE
  438. ------------------------------
  439. JAVA_DEPLOY
  440. JAVAUSERPRIV
  441. JAVAIDPRIV
  442. JAVASYSPRIV
  443. JAVADEBUGPRIV
  444. JAVA_ADMIN
  445.  
  446. =========================================
  447. List of Invalid Java Objects owned by SYS
  448. =========================================
  449.  
  450. There are no SYS owned invalid JAVA objects
  451.  
  452. DOC>
  453. DOC>#################################################################
  454. DOC>
  455. DOC> Check the status of the main JVM interface packages DBMS_JAVA
  456. DOC> and INITJVMAUX and make sure it is VALID.
  457. DOC>
  458. DOC> If there are no Invalid objects below will result in zero rows.
  459. DOC>
  460. DOC>#################################################################
  461. DOC>#
  462.  
  463.  
  464. no rows selected
  465.  
  466.  
  467. DOC>
  468. DOC>#################################################################
  469. DOC>
  470. DOC> If the JAVAVM component is not installed in the database (for
  471. DOC> example, after creating the database with custom scripts), the
  472. DOC> next query will report the following error:
  473. DOC>
  474. DOC>   select dbms_java.longname('foo') "JAVAVM TESTING" from dual
  475. DOC>   *
  476. DOC>   ERROR at line 1:
  477. DOC>   ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier
  478. DOC>
  479. DOC> If the JAVAVM component is installed, the query should succeed
  480. DOC> with 'foo' as result.
  481. DOC>
  482. DOC>#################################################################
  483. DOC>#
  484.  
  485.  
  486. JAVAVM TESTING
  487. ---------------
  488. foo
  489.  
  490. ===================================
  491. Oracle Multimedia/InterMedia status
  492. ===================================
  493.  
  494. .
  495. Oracle Multimedia/interMedia is installed and listed with the following version: 11.2.0.4.0 and status: VALID
  496. .
  497. Checking for installed Database Schemas...
  498. ORDSYS user exists.
  499. ORDPLUGINS user exists.
  500. MDSYS user exists.
  501. SI_INFORMTN_SCHEMA user exists.
  502. ORDDATA user exists.
  503. .
  504. Checking for Prerequisite Components...
  505. JAVAVM installed and listed as valid
  506. XDK installed and listed as valid
  507. XDB installed and listed as valid
  508. Validating Oracle Multimedia/interMedia...(no output if component status is valid)
  509.  
  510. PL/SQL procedure successfully completed.
  511.  
  512.  
  513. 			    *** End of LogFile ***
  514.  
  515.  
  516.  
  517. Upload db_upg_diag_test_16_Jan_2020_0415.log from "/tmp" directory
  518.  
  519. SQL>

3 清空回收站 ，略 。
4 检查物化视图是否刷新完毕。

  1. SQL> SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;
  2.  
  3. no rows selected
  4.  
  5. SQL>

5 收集统计信息

  1. SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
  2.  
  3. PL/SQL procedure successfully completed.
  4.  
  5. SQL>

6 检查时区设置

  1. SQL> select * from v$timezone_file;
  2.  
  3. FILENAME		VERSION     CON_ID
  4. -------------------- ---------- ----------
  5. timezlrg_14.dat 	     14 	 0
  6.  
  7. SQL> 
  8. SQL> col property_name for a30
  9. SQL> SELECT property_name, SUBSTR(property_value, 1, 30) value
  10. FROM database_properties
  11. WHERE property_name LIKE 'DST_%'
  12. ORDER BY property_name;  2    3    4  
  13.  
  14. PROPERTY_NAME		       VALUE
  15. ------------------------------ ------------------------------------------------------------------------------------------------------------------------
  16. DST_PRIMARY_TT_VERSION	       14
  17. DST_SECONDARY_TT_VERSION       0
  18. DST_UPGRADE_STATE	       NONE
  19.  
  20. SQL>

7 检查没有文件处于backup mode

  1. SQL> SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';  
  2.  
  3. SQL> SELECT * FROM v$backup WHERE status != 'NOT ACTIVE'; 
  4.  
  5. no rows selected
  6.  
  7. SQL>

8 检查升级前是否有分布式事务，如果有，执行purge.

  1. SQL> Select * from dba_2pc_pending;
  2.  
  3. SQL> select local_tran_id FROM dba_2pc_pending;
  4. SQL> execute dbms_transaction.purge_lost_db_entry('');
  5. SQL> commit;

9 检查Preupgrade，在源库执行，会生成一些建议之类的等等。按照建议执行脚本即可，本次测试没有执行这个
$Earlier_release_Oracle_home/jdk/bin/java -jar $New_release_Oracle_home/rdbms/admin/preupgrade.jar FILE TEXT DIR output_dir

10 进行升级
用12c的软件路径启动数据库，启动到upgrade模式 ，在linux命令行下执行dbupgrade命令，该命令调用catctl.pl文件和catupgrd.sql脚本。

  1. CONNECT / AS SYSDBA
  2. SQL> startup upgrade;
  3. SQL> exit
  4.  
  5. ./dbupgrade

-- 或者执行下面的命令

  1. cd $ORACLE_HOME/rdbms/admin
  2. catctl
  3.  
  4. or
  5.  
  6. cd $ORACLE_HOME/rdbms/admin
  7. $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql

-- 在dbupgrade里面有一段如下，可以看出，执行那个perl命令和执行dbupgrade命令效果是一样的，我这里直接执行dbupgrade命令了。

  1. if [[ $# -gt 0 ]]
  2. then
  3.          $ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib $ORACLE_HOME/rdbms/admin/catctl.pl "$@" $ORACLE_HOME/rdbms/admin/catupgrd.sql
  4. else
  5.         $ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib $ORACLE_HOME/rdbms/admin/catctl.pl $ORACLE_HOME/rdbms/admin/catupgrd.sql
  6. fi
  7.  
  8. exit $?

-- 执行过程 ，其中23步这里卡了大约4小时，原因是job_queue_processes参数。设置为0后，立刻通过。（可能和之前没有进行preupgrade脚本执行有关）（之前怀疑是这个脚本运行的时候，以4个并-行来运行导致的，测试机只有1个cpu，现在看应该不是并-行引起的。）

  1. [oracle@wls10306-02 bin]$ ls dbup*
  2. dbupgrade
  3. [oracle@wls10306-02 bin]$ ./dbupgrade
  4.  
  5. Argument list for [/u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl]
  6. Run in                c = 0
  7. Do not run in         C = 0
  8. Input Directory       d = 0
  9. Echo OFF              e = 1
  10. Simulate              E = 0
  11. Forced cleanup        F = 0
  12. Log Id                i = 0
  13. Child Process         I = 0
  14. Log Dir               l = 0
  15. Priority List Name    L = 0
  16. Upgrade Mode active   M = 0
  17. SQL Process Count     n = 0
  18. SQL PDB Process Count N = 0
  19. Open Mode Normal      o = 0
  20. Start Phase           p = 0
  21. End Phase             P = 0
  22. Reverse Order         r = 0
  23. AutoUpgrade Resume    R = 0
  24. Script                s = 0
  25. Serial Run            S = 0
  26. RO User Tablespaces   T = 0
  27. Display Phases        y = 0
  28. Debug catcon.pm       z = 0
  29. Debug catctl.pl       Z = 0
  30.  
  31. catctl.pl VERSION: [12.2.0.1.0]
  32.            STATUS: [production]
  33.             BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]
  34.  
  35.  
  36.  
  37. Unable to Create [/tmp/cfgtoollogs/upgrade20200116165036]
  38. Defaulting to [/tmp]
  39. /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0/dbhome_1]
  40. /u01/app/oracle/product/12.2.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/12.2.0/dbhome_1]
  41. catctlGetOrabase = [/u01/app/oracle/product/12.2.0/dbhome_1]
  42.  
  43. Analyzing file /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catupgrd.sql
  44.  
  45. Log file directory = [/tmp]
  46.  
  47. catcon: ALL catcon-related output will be written to [/tmp/catupgrd_catcon_16733.lst]
  48. catcon: See [/tmp/catupgrd*.log] files for output generated by scripts
  49. catcon: See [/tmp/catupgrd_*.lst] files for spool files, if any
  50.  
  51. Number of Cpus        = 1
  52. Database Name         = test
  53. DataBase Version      = 11.2.0.4.0
  54. catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037/catupgrd_catcon_16733.lst]
  55. catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037/catupgrd*.log] files for output generated by scripts
  56. catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037/catupgrd_*.lst] files for spool files, if any
  57.  
  58. Log file directory = [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037]
  59.  
  60. cannot remove directory for /tmp/.X11-unix: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  61. cannot remove directory for /tmp/.XIM-unix: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  62. cannot remove directory for /tmp/.Test-unix: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  63. cannot remove directory for /tmp/.font-unix: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  64. cannot remove directory for /tmp/.ICE-unix: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  65. cannot remove directory for /tmp/hsperfdata_root: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  66. cannot chdir to child for /tmp/vmware-root_6977-3879638603: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  67. cannot chdir to child for /tmp/vmware-root_7058-2856323751: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  68. cannot unlink file for /tmp/cfgtoollogs/upgrade20200116163737/catupgrd_trace.log: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  69. cannot restore permissions to 0100644 for /tmp/cfgtoollogs/upgrade20200116163737/catupgrd_trace.log: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  70. cannot unlink file for /tmp/cfgtoollogs/upgrade20200116163737/catupgrd0.log: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  71. cannot restore permissions to 0100644 for /tmp/cfgtoollogs/upgrade20200116163737/catupgrd0.log: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  72. cannot remove directory for /tmp/cfgtoollogs/upgrade20200116163737: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  73. cannot remove directory for /tmp/cfgtoollogs: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  74. cannot chdir to child for /tmp/wlstTemproot: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  75. cannot remove directory for /tmp/.oracle: 1 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  76. cannot chdir to child for /tmp/vmware-root_9576-3126016563: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  77. cannot chdir to child for /tmp/vmware-root_6997-3853881822: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  78. cannot chdir to child for /tmp/vmware-root_7076-2822900872: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  79. cannot chdir to child for /tmp/vmware-root_7016-2864909219: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  80. cannot chdir to child for /tmp/vmware-root_7060-2856454816: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  81. cannot chdir to child for /tmp/vmware-root_7007-3879114322: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  82. cannot chdir to child for /tmp/vmware-root_7027-3854537185: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  83. cannot chdir to child for /tmp/vmware-root_7045-3887961966: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  84. cannot remove directory for /tmp: 13 at /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/catctl.pl line 3024.
  85. Parallel SQL Process Count            = 4
  86. Components in [test]
  87.     Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM ORDIM OWM SDO XDB XML XOQ]
  88. Not Installed [DV MGW ODM OLS RAC WK]
  89.  
  90. ------------------------------------------------------
  91. Phases [0-115]         Start Time:[2020_01_16 16:50:38]
  92. ------------------------------------------------------
  93. ***********   Executing Change Scripts   ***********
  94. Serial   Phase #:0    [test] Files:1    Time: 181s
  95. ***************   Catalog Core SQL   ***************
  96. Serial   Phase #:1    [test] Files:5    Time: 81s
  97. Restart  Phase #:2    [test] Files:1    Time: 1s
  98. ***********   Catalog Tables and Views   ***********
  99. Parallel Phase #:3    [test] Files:19   Time: 51s
  100. Restart  Phase #:4    [test] Files:1    Time: 0s
  101. *************   Catalog Final Scripts   ************
  102. Serial   Phase #:5    [test] Files:6    Time: 33s
  103. *****************   Catproc Start   ****************
  104. Serial   Phase #:6    [test] Files:1    Time: 24s
  105. *****************   Catproc Types   ****************
  106. Serial   Phase #:7    [test] Files:2    Time: 25s
  107. Restart  Phase #:8    [test] Files:1    Time: 0s
  108. ****************   Catproc Tables   ****************
  109. Parallel Phase #:9    [test] Files:69   Time: 113s
  110. Restart  Phase #:10   [test] Files:1    Time: 1s
  111. *************   Catproc Package Specs   ************
  112. Serial   Phase #:11   [test] Files:1    Time: 75s
  113. Restart  Phase #:12   [test] Files:1    Time: 1s
  114. **************   Catproc Procedures   **************
  115. Parallel Phase #:13   [test] Files:97   Time: 38s
  116. Restart  Phase #:14   [test] Files:1    Time: 0s
  117. Parallel Phase #:15   [test] Files:118  Time: 40s
  118. Restart  Phase #:16   [test] Files:1    Time: 1s
  119. Serial   Phase #:17   [test] Files:13   Time: 4s
  120. Restart  Phase #:18   [test] Files:1    Time: 1s
  121. *****************   Catproc Views   ****************
  122. Parallel Phase #:19   [test] Files:33   Time: 95s
  123. Restart  Phase #:20   [test] Files:1    Time: 1s
  124. Serial   Phase #:21   [test] Files:3    Time: 15s
  125. Restart  Phase #:22   [test] Files:1    Time: 0s
  126. Parallel Phase #:23   [test] Files:24   Time: 13912s
  127. Restart  Phase #:24   [test] Files:1    Time: 0s
  128. Parallel Phase #:25   [test] Files:11   Time: 102s
  129. Restart  Phase #:26   [test] Files:1    Time: 0s
  130. Serial   Phase #:27   [test] Files:1    Time: 0s
  131. Serial   Phase #:28   [test] Files:3    Time: 6s
  132. Serial   Phase #:29   [test] Files:1    Time: 0s
  133. Restart  Phase #:30   [test] Files:1    Time: 1s
  134. ***************   Catproc CDB Views   **************
  135. Serial   Phase #:31   [test] Files:1    Time: 1s
  136. Restart  Phase #:32   [test] Files:1    Time: 0s
  137. Serial   Phase #:34   [test] Files:1    Time: 0s
  138. *****************   Catproc PLBs   *****************
  139. Serial   Phase #:35   [test] Files:283  Time: 137s
  140. Serial   Phase #:36   [test] Files:1    Time: 0s
  141. Restart  Phase #:37   [test] Files:1    Time: 0s
  142. Serial   Phase #:38   [test] Files:1    Time: 7s
  143. Restart  Phase #:39   [test] Files:1    Time: 0s
  144. ***************   Catproc DataPump   ***************
  145. Serial   Phase #:40   [test] Files:3    Time: 80s
  146. Restart  Phase #:41   [test] Files:1    Time: 1s
  147. ******************   Catproc SQL   *****************
  148. Parallel Phase #:42   [test] Files:13   Time: 119s
  149. Restart  Phase #:43   [test] Files:1    Time: 0s
  150. Parallel Phase #:44   [test] Files:12   Time: 31s
  151. Restart  Phase #:45   [test] Files:1    Time: 0s
  152. Parallel Phase #:46   [test] Files:2    Time: 1s
  153. Restart  Phase #:47   [test] Files:1    Time: 1s
  154. *************   Final Catproc scripts   ************
  155. Serial   Phase #:48   [test] Files:1    Time: 8s
  156. Restart  Phase #:49   [test] Files:1    Time: 0s
  157. **************   Final RDBMS scripts   *************
  158. Serial   Phase #:50   [test] Files:1    Time: 31s
  159. ************   Upgrade Component Start   ***********
  160. Serial   Phase #:51   [test] Files:1    Time: 1s
  161. Restart  Phase #:52   [test] Files:1    Time: 0s
  162. ****************   Upgrading Java   ****************
  163. Serial   Phase #:53   [test] Files:1    Time: 332s
  164. Restart  Phase #:54   [test] Files:1    Time: 1s
  165. *****************   Upgrading XDK   ****************
  166. Serial   Phase #:55   [test] Files:1    Time: 58s
  167. Restart  Phase #:56   [test] Files:1    Time: 0s
  168. *********   Upgrading APS,OLS,DV,CONTEXT   *********
  169. Serial   Phase #:57   [test] Files:1    Time: 77s
  170. *****************   Upgrading XDB   ****************
  171. Restart  Phase #:58   [test] Files:1    Time: 0s
  172. Serial   Phase #:60   [test] Files:3    Time: 33s
  173. Serial   Phase #:61   [test] Files:3    Time: 9s
  174. Parallel Phase #:62   [test] Files:9    Time: 4s
  175. Parallel Phase #:63   [test] Files:24   Time: 6s
  176. Serial   Phase #:64   [test] Files:4    Time: 7s
  177. Serial   Phase #:65   [test] Files:1    Time: 0s
  178. Serial   Phase #:66   [test] Files:30   Time: 4s
  179. Serial   Phase #:67   [test] Files:1    Time: 0s
  180. Parallel Phase #:68   [test] Files:6    Time: 4s
  181. Serial   Phase #:69   [test] Files:2    Time: 20s
  182. Serial   Phase #:70   [test] Files:3    Time: 101s
  183. Restart  Phase #:71   [test] Files:1    Time: 0s
  184. *********   Upgrading CATJAVA,OWM,MGW,RAC   ********
  185. Serial   Phase #:72   [test] Files:1    Time: 109s
  186. ****************   Upgrading ORDIM   ***************
  187. Restart  Phase #:73   [test] Files:1    Time: 0s
  188. Serial   Phase #:75   [test] Files:1    Time: 1s
  189. Parallel Phase #:76   [test] Files:2    Time: 99s
  190. Serial   Phase #:77   [test] Files:1    Time: 86s
  191. Restart  Phase #:78   [test] Files:1    Time: 1s
  192. Parallel Phase #:79   [test] Files:2    Time: 14s
  193. Serial   Phase #:80   [test] Files:2    Time: 1s
  194. *****************   Upgrading SDO   ****************
  195. Restart  Phase #:81   [test] Files:1    Time: 0s
  196. Serial   Phase #:83   [test] Files:1    Time: 47s
  197. Serial   Phase #:84   [test] Files:1    Time: 2s
  198. Restart  Phase #:85   [test] Files:1    Time: 0s
  199. Serial   Phase #:86   [test] Files:1    Time: 32s
  200. Restart  Phase #:87   [test] Files:1    Time: 1s
  201. Parallel Phase #:88   [test] Files:3    Time: 184s
  202. Restart  Phase #:89   [test] Files:1    Time: 0s
  203. Serial   Phase #:90   [test] Files:1    Time: 6s
  204. Restart  Phase #:91   [test] Files:1    Time: 0s
  205. Serial   Phase #:92   [test] Files:1    Time: 3s
  206. Restart  Phase #:93   [test] Files:1    Time: 0s
  207. Parallel Phase #:94   [test] Files:4    Time: 146s
  208. Restart  Phase #:95   [test] Files:1    Time: 0s
  209. Serial   Phase #:96   [test] Files:1    Time: 1s
  210. Restart  Phase #:97   [test] Files:1    Time: 0s
  211. Serial   Phase #:98   [test] Files:2    Time: 62s
  212. Restart  Phase #:99   [test] Files:1    Time: 0s
  213. Serial   Phase #:100  [test] Files:1    Time: 1s
  214. Restart  Phase #:101  [test] Files:1    Time: 0s
  215. ***********   Upgrading Misc. ODM, OLAP   **********
  216. Serial   Phase #:102  [test] Files:1    Time: 36s
  217. ****************   Upgrading APEX   ****************
  218. Restart  Phase #:103  [test] Files:1    Time: 0s
  219. Serial   Phase #:104  [test] Files:1    Time: 792s
  220. Restart  Phase #:105  [test] Files:1    Time: 1s
  221. ***********   Final Component scripts    ***********
  222. Serial   Phase #:106  [test] Files:1    Time: 0s
  223. *************   Final Upgrade scripts   ************
  224. Serial   Phase #:107  [test] Files:1    Time: 144s
  225. **********   End PDB Application Upgrade   *********
  226. Serial   Phase #:108  [test] Files:1    Time: 1s
  227. *******************   Migration   ******************
  228. Serial   Phase #:109  [test] Files:1    Time: 51s
  229. Serial   Phase #:110  [test] Files:1    Time: 0s
  230. Serial   Phase #:111  [test] Files:1    Time: 92s
  231. *****************   Post Upgrade   *****************
  232. Serial   Phase #:112  [test] Files:1    Time: 775s
  233. ****************   Summary report   ****************
  234. Serial   Phase #:113  [test] Files:1    Time: 1s
  235. Serial   Phase #:114  [test] Files:1    Time: 0s
  236. Serial   Phase #:115  [test] Files:1     Time: 24s
  237.  
  238. ------------------------------------------------------
  239. Phases [0-115]         End Time:[2020_01_16 22:00:27]
  240. ------------------------------------------------------
  241.  
  242. Grand Total Time: 18602s 
  243.  
  244.  LOG FILES: (/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037/catupgrd*.log)
  245.  
  246. Upgrade Summary Report Located in:
  247. /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037/upg_summary.log
  248.  
  249. Grand Total Upgrade Time:    [0d:5h:10m:2s]
  250. [oracle@wls10306-02 bin]$ 
  251.  
  252. [END] 2020/1/17 8:18:03

-- 检查组件，已经都是12.2.0.1的了 。但是下面提示timezone版本还是比较低的。

  1. SQL> @?/rdbms/admin/utlu122s.sql
  2.  
  3.  
  4.  
  5.  
  6. Oracle Database 12.2 Post-Upgrade Status Tool		01-17-2020 08:22:55
  7.  
  8. Component				Current 	Version  Elapsed Time
  9. Name					Status		Number	 HH:MM:SS
  10.  
  11. Oracle Server			       UPGRADED      12.2.0.1.0  04:13:32
  12. JServer JAVA Virtual Machine	       UPGRADED      12.2.0.1.0  00:05:31
  13. Oracle Workspace Manager	       UPGRADED      12.2.0.1.0  00:01:27
  14. OLAP Analytic Workspace 	       UPGRADED      12.2.0.1.0  00:00:19
  15. OLAP Catalog			     OPTION OFF      11.2.0.4.0  00:00:00
  16. Oracle OLAP API 		       UPGRADED      12.2.0.1.0  00:00:19
  17. Oracle XDK			       UPGRADED      12.2.0.1.0  00:00:57
  18. Oracle Text			       UPGRADED      12.2.0.1.0  00:00:56
  19. Oracle XML Database		       UPGRADED      12.2.0.1.0  00:03:06
  20. Oracle Database Java Packages	       UPGRADED      12.2.0.1.0  00:00:20
  21. Oracle Multimedia		       UPGRADED      12.2.0.1.0  00:03:20
  22. Spatial 			       UPGRADED      12.2.0.1.0  00:08:02
  23. Oracle Application Express	       UPGRADED     5.0.4.00.12  00:13:10
  24. Final Actions							 00:03:15
  25. Post Upgrade							 00:12:52
  26.  
  27. Total Upgrade Time: 05:07:42
  28.  
  29. Database time zone version is 14. It is older than current release time
  30. zone version 26. Time zone upgrade is needed using the DBMS_DST package.
  31.  
  32. Summary Report File = /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200116165037/upg_summary.log
  33.  
  34. 08:22:56 SQL> 
  35. 08:22:56 SQL>

-- 检查组件状态

  1. set line 200
  2. col COMP_ID format a10
  3. col COMP_NAME format a35
  4. select substr(comp_id,1,15) comp_id,substr(comp_name,1,30)
  5. comp_name,substr(version,1,10) version,status
  6. from dba_registry order by modified;
  7.  
  8. COMP_ID    COMP_NAME			       VERSION					STATUS
  9. ---------- ----------------------------------- ---------------------------------------- --------------------------------------------
  10. CATALOG    Oracle Database Catalog Views       12.2.0.1.0				UPGRADED
  11. CATPROC    Oracle Database Packages and T      12.2.0.1.0				UPGRADED
  12. JAVAVM	   JServer JAVA Virtual Machine        12.2.0.1.0				UPGRADED
  13. XML	   Oracle XDK			       12.2.0.1.0				UPGRADED
  14. APS	   OLAP Analytic Workspace	       12.2.0.1.0				UPGRADED
  15. AMD	   OLAP Catalog 		       11.2.0.4.0				OPTION OFF
  16. CONTEXT    Oracle Text			       12.2.0.1.0				UPGRADED
  17. XDB	   Oracle XML Database		       12.2.0.1.0				UPGRADED
  18. CATJAVA    Oracle Database Java Packages       12.2.0.1.0				UPGRADED
  19. OWM	   Oracle Workspace Manager	       12.2.0.1.0				UPGRADED
  20. ORDIM	   Oracle Multimedia		       12.2.0.1.0				UPGRADED
  21.  
  22. COMP_ID    COMP_NAME			       VERSION					STATUS
  23. ---------- ----------------------------------- ---------------------------------------- --------------------------------------------
  24. SDO	   Spatial			       12.2.0.1.0				UPGRADED
  25. XOQ	   Oracle OLAP API		       12.2.0.1.0				UPGRADED
  26. APEX	   Oracle Application Express	       5.0.4.00.1				UPGRADED
  27.  
  28. 14 rows selected.

-- 检查兼容性 ，因为之前使用的是11.2.0.4的spfile，里面的兼容性是11.2.0.4.0 。需要修改下 。

  1. SQL> show parameter compatible
  2.  
  3. NAME				     TYPE	 VALUE
  4. ------------------------------------ ----------- ------------------------------
  5. compatible			     string	 11.2.0.4.0
  6. noncdb_compatible		     boolean	 FALSE
  7.  
  8. SQL> show parameter compatible
  9.  
  10. NAME				     TYPE	 VALUE
  11. ------------------------------------ ----------- ------------------------------
  12. compatible			     string	 12.2.0.1.0
  13. noncdb_compatible		     boolean	 FALSE
  14. SQL>

11 升级后步骤，升级timezone，其他的略。
-- 升级timezone
Download the DBMS_DST_scriptsV1.9.zip file and unzip, it contains 4 files: upg_tzv_check.sql and upg_tzv_apply.sql , countstatsTSTZ.sql and countstarTSTZ.sql .
Copy the 4 files to your database server, the location of the scripts can be any directory on the server.

  1. [oracle@wls10306-02 DBMS_DST_scriptsV1.9]$ ll
  2. total 68
  3. -rw-r--r-- 1 oracle oinstall  6294 Jan  8  2015 countstarTSTZ.sql
  4. -rw-r--r-- 1 oracle oinstall  7213 Mar 17  2018 countstatsTSTZ.sql
  5. -rw-r--r-- 1 oracle oinstall 19502 Aug 22  2014 upg_tzv_apply.sql
  6. -rw-r--r-- 1 oracle oinstall 31010 Aug 22  2014 upg_tzv_check.sql
  7. [oracle@wls10306-02 DBMS_DST_scriptsV1.9]$

执行countstatsTSTZ.sql 、upg_tzv_check.sql、upg_tzv_apply.sql

countstatsTSTZ.sql  -- list the stats num_row of all tables that have a TSTZ column (= processed by DBMS_DST ) and have actual data according to the stats.
upg_tzv_check.sql   -- it will detect the highest installed DST patch automatically and needs no downtime, this can be executed on a live production database but it WILL purge the dba_recyclebin.
upg_tzv_apply.sql   -- 这个应该是应用timezone ，真正的安装timezone

  1. SQL> @/home/oracle/DBMS_DST_scriptsV1.9/countstatsTSTZ.sql
  2. .
  3. Amount of TSTZ data using num_rows stats info in DBA_TABLES.
  4. .
  5. For SYS tables first...
  6. Note: empty tables are not listed.
  7. Stat date  - Owner.Tablename.Columnname - num_rows
  8. 16/01/2020 - SYS.AQ$_ALERT_QT_S.CREATION_TIME - 5
  9. 16/01/2020 - SYS.AQ$_ALERT_QT_S.DELETION_TIME - 5
  10. 16/01/2020 - SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 5
  11. 24/08/2013 - SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
  12. 24/08/2013 - SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
  13. 24/08/2013 - SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
  14. 24/08/2013 - SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
  15. 24/08/2013 - SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
  16. 24/08/2013 - SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
  17. 24/08/2013 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 1
  18. 24/08/2013 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 1
  19. 24/08/2013 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 1
  20. 24/08/2013 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 1
  21. 24/08/2013 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 1
  22. 24/08/2013 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 1
  23. 24/08/2013 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 1
  24. 24/08/2013 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 1
  25. 24/08/2013 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 1
  26. 16/01/2020 - SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 1
  27. 16/01/2020 - SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 1
  28. 16/01/2020 - SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 1
  29. 24/08/2013 - SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 1
  30. 24/08/2013 - SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 1
  31. 24/08/2013 - SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 1
  32. 24/08/2013 - SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 1
  33. 24/08/2013 - SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 1
  34. 24/08/2013 - SYS.KET$_CLIENT_CONFIG.FIELD_2 - 7
  35. 24/08/2013 - SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 7
  36. 16/01/2020 - SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 19
  37. 16/01/2020 - SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 19
  38. 16/01/2020 - SYS.RADM_FPTM$.TSWTZ_COL - 1
  39. 16/01/2020 - SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 85
  40. 24/08/2013 - SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 11
  41. 16/01/2020 - SYS.SCHEDULER$_JOB.END_DATE - 14
  42. 16/01/2020 - SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 14
  43. 16/01/2020 - SYS.SCHEDULER$_JOB.LAST_END_DATE - 14
  44. 16/01/2020 - SYS.SCHEDULER$_JOB.LAST_START_DATE - 14
  45. 16/01/2020 - SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 14
  46. 16/01/2020 - SYS.SCHEDULER$_JOB.START_DATE - 14
  47. 16/01/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - 85
  48. 16/01/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - 85
  49. 16/01/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - 85
  50. 24/08/2013 - SYS.SCHEDULER$_SCHEDULE.END_DATE - 3
  51. 24/08/2013 - SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 3
  52. 16/01/2020 - SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 9
  53. 16/01/2020 - SYS.SCHEDULER$_WINDOW.END_DATE - 9
  54. 16/01/2020 - SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 9
  55. 16/01/2020 - SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 9
  56. 16/01/2020 - SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 9
  57. 16/01/2020 - SYS.SCHEDULER$_WINDOW.START_DATE - 9
  58. 16/01/2020 - SYS.WRI$_ALERT_HISTORY.CREATION_TIME - 6
  59. 16/01/2020 - SYS.WRI$_ALERT_HISTORY.TIME_SUGGESTED - 6
  60. 16/01/2020 - SYS.WRI$_ALERT_OUTSTANDING.CREATION_TIME - 1
  61. 16/01/2020 - SYS.WRI$_ALERT_OUTSTANDING.TIME_SUGGESTED - 1
  62. 16/01/2020 - SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - 1126
  63. 16/01/2020 - SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - 1126
  64. 16/01/2020 - SYS.WRI$_OPTSTAT_OPR.END_TIME - 224
  65. 16/01/2020 - SYS.WRI$_OPTSTAT_OPR.SPARE6 - 224
  66. 16/01/2020 - SYS.WRI$_OPTSTAT_OPR.START_TIME - 224
  67. 16/01/2020 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - 735
  68. 16/01/2020 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - 735
  69. Total numrow of SYS TSTZ columns is : 5000
  70. There are in total 154 non-SYS TSTZ columns.
  71. .
  72. For non-SYS tables ...
  73. Note: empty tables are not listed.
  74. Stat date  - Owner.Tablename.Columnname - num_rows
  75. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_L.DEQUEUE_TIME - 2
  76. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_S.CREATION_TIME - 4
  77. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_S.DELETION_TIME - 4
  78. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_S.MODIFICATION_TIME - 4
  79. 24/08/2013 - IX.AQ$_STREAMS_QUEUE_TABLE_S.CREATION_TIME - 1
  80. 24/08/2013 - IX.AQ$_STREAMS_QUEUE_TABLE_S.DELETION_TIME - 1
  81. 24/08/2013 - IX.AQ$_STREAMS_QUEUE_TABLE_S.MODIFICATION_TIME - 1
  82. Total numrow of non-SYS TSTZ columns is : 17
  83. There are in total 32 non-SYS TSTZ columns.
  84. Total Minutes elapsed : 0
  85. SQL> 
  1. SQL> @/home/oracle/DBMS_DST_scriptsV1.9/upg_tzv_check.sql
  2. INFO: Starting with RDBMS DST update preparation.
  3. INFO: NO actual RDBMS DST update will be done by this script.
  4. INFO: If an ERROR occurs the script will EXIT sqlplus.
  5. INFO: Doing checks for known issues ...
  6. INFO: Database version is 12.2.0.1 .
  7. INFO: Database RDBMS DST version is DSTv14 .
  8. INFO: No known issues detected.
  9. INFO: Now detecting new RDBMS DST version.
  10. A prepare window has been successfully started.
  11. INFO: Newest RDBMS DST version detected is DSTv26 .
  12. INFO: Next step is checking all TSTZ data.
  13. INFO: It might take a while before any further output is seen ...
  14. A prepare window has been successfully ended.
  15. INFO: A newer RDBMS DST version than the one currently used is found.
  16. INFO: Note that NO DST update was yet done.
  17. INFO: Now run upg_tzv_apply.sql to do the actual RDBMS DST update.
  18. INFO: Note that the upg_tzv_apply.sql script will
  19. INFO: restart the database 2 times WITHOUT any confirmation or prompt.
  20. SQL>

--第三个脚本执行错误了，后面有解决方法。

  1. SQL> @/home/oracle/DBMS_DST_scriptsV1.9/upg_tzv_apply.sql   -- 这个地方出错了，后面有处理过程
  2. INFO: If an ERROR occurs the script will EXIT sqlplus.
  3. INFO: The database RDBMS DST version will be updated to DSTv26 .
  4. WARNING: This script will restart the database 2 times
  5. WARNING: WITHOUT asking ANY confirmation.
  6. WARNING: Hit control-c NOW if this is not intended.
  7. INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
  8. Database closed.
  9. Database dismounted.
  10. ORACLE instance shut down.
  11. ORACLE instance started.
  12.  
  13. Total System Global Area  830472192 bytes
  14. Fixed Size		    8626144 bytes
  15. Variable Size		  511705120 bytes
  16. Database Buffers	  306184192 bytes
  17. Redo Buffers		    3956736 bytes
  18. Database mounted.
  19. Database opened.
  20. INFO: Starting the RDBMS DST upgrade.
  21. INFO: Upgrading all SYS owned TSTZ data.
  22. INFO: It might take time before any further output is seen ...
  23. An upgrade window has been successfully started.
  24. INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
  25. Database closed.
  26. Database dismounted.
  27. ORACLE instance shut down.
  28. SP2-1540: Oracle Database cannot startup in an Edition session.
  29. ERROR:
  30. ORA-01034: ORACLE not available
  31. Process ID: 72111
  32. Session ID: 32 Serial number: 36090
  33.  
  34.  
  35. Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

-- 再次检查timezone，变成了26 。

  1. SQL>  select * from v$timezone_file;
  2.  
  3. FILENAME		VERSION     CON_ID
  4. -------------------- ---------- ----------
  5. timezlrg_26.dat 	     26 	 0
  6.  
  7. SQL> 
  8.  
  9. SQL> SELECT property_name, SUBSTR(property_value, 1, 30) value
  10. FROM database_properties
  11. WHERE property_name LIKE 'DST_%'
  12. ORDER BY property_name;   2    3    4  
  13.  
  14. PROPERTY_NAME
  15. ------------------------------
  16. VALUE
  17. ------------------------------------------------------------------------------------------------------------------------
  18. DST_PRIMARY_TT_VERSION
  19. 26
  20.  
  21. DST_SECONDARY_TT_VERSION
  22. 14
  23.  
  24. DST_UPGRADE_STATE
  25. UPGRADE

-- 正常情况下，上面的查询DST_SECONDARY_TT_VERSION应该是0，DST_UPGRADE_STATE应该是None 。根据MOS 1509653.1 进行处理。

  1. CONN / as sysdba
  2. alter session set "_with_subquery"=materialize;
  3. alter session set "_simple_view_merging"=TRUE;
  4. set serveroutput on
  5. VAR numfail number
  6. BEGIN
  7. DBMS_DST.UPGRADE_DATABASE(:numfail,
  8. parallel => TRUE,
  9. log_errors => TRUE,
  10. log_errors_table => 'SYS.DST$ERROR_TABLE',
  11. log_triggers_table => 'SYS.DST$TRIGGER_TABLE',
  12. error_on_overlap_time => FALSE,
  13. error_on_nonexisting_time => FALSE);
  14. DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
  15. END;
  16. /
  17.  
  18. VAR fail number
  19. BEGIN
  20. DBMS_DST.END_UPGRADE(:fail);
  21. DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);
  22. END;
  23. /
  24.  
  25. SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  26. FROM DATABASE_PROPERTIES
  27. WHERE PROPERTY_NAME LIKE 'DST_%'
  28. ORDER BY PROPERTY_NAME;
  29.  
  30. SQL> alter session set "_with_subquery"=materialize;
  31.  
  32. Session altered.
  33.  
  34. SQL> alter session set "_simple_view_merging"=TRUE;
  35.  
  36. Session altered.
  37.  
  38. SQL> set serveroutput on
  39. SQL> VAR numfail number
  40. BEGIN
  41. DBMS_DST.UPGRADE_DATABASE(:numfail,
  42. parallel => TRUE,
  43. log_errors => TRUE,
  44. log_errors_table => 'SYS.DST$ERROR_TABLE',
  45. log_triggers_table => 'SYS.DST$TRIGGER_TABLE',
  46. error_on_overlap_time => FALSE,
  47. error_on_nonexisting_time => FALSE)SQL>   2    3    4    5    6    7    8  ;
  48. DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
  49. END;  9   10  
  50.  11  /
  51. Table list: "IX"."AQ$_ORDERS_QUEUETABLE_L"
  52. Number of failures: 0
  53. Table list: "IX"."AQ$_ORDERS_QUEUETABLE_S"
  54. Number of failures: 0
  55. Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_L"
  56. Number of failures: 0
  57. Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_S"
  58. Number of failures: 0
  59. Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
  60. Number of failures: 0
  61. Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
  62. Number of failures: 0
  63. Table list: "APEX_050000"."WWV_FLOW_DEBUG_MESSAGES"
  64. Number of failures: 0
  65. Table list: "APEX_050000"."WWV_FLOW_DEBUG_MESSAGES2"
  66. Number of failures: 0
  67. Table list: "APEX_050000"."WWV_FLOW_FEEDBACK"
  68. Number of failures: 0
  69. Table list: "APEX_050000"."WWV_FLOW_FEEDBACK_FOLLOWUP"
  70. Number of failures: 0
  71. Table list: "APEX_050000"."WWV_FLOW_WORKSHEET_NOTIFY"
  72. Number of failures: 0
  73. Failures:0
  74.  
  75. PL/SQL procedure successfully completed.
  76.  
  77. SQL> VAR fail number
  78. BEGIN
  79. DBMS_DST.END_UPGRADE(:fail);
  80. DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);
  81. END;SQL>   2    3    4  
  82.   5  /
  83. An upgrade window has been successfully ended.
  84. Failures:0
  85.  
  86. PL/SQL procedure successfully completed.

-- 处理完毕后，再次查看时区，正常了。

  1. SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  2. FROM DATABASE_PROPERTIES
  3. WHERE PROPERTY_NAME LIKE 'DST_%'
  4. ORDER BY PROPERTY_NAME;  2    3    4  
  5.  
  6. PROPERTY_NAME
  7. ----------------------------------------
  8. VALUE
  9. ------------------------------------------------------------------------------------------------------------------------
  10. DST_PRIMARY_TT_VERSION
  11. 26
  12.  
  13. DST_SECONDARY_TT_VERSION
  14. 0
  15.  
  16. DST_UPGRADE_STATE
  17. NONE
  18.  
  19.  
  20. SQL>

11.2.0.4 ---> 12.2.0.1 到此结束。
END

---- 2010-01-17 下午，在另一个机器上做升级，还是11.2.0.4升级到12.2.0.1

-- 产生预检查修复脚-本，也可以通过MOS 1577379.1  884522.1下载 （在上午做第一次升-级的时候，跳过这个步骤了，这次升-级做一下。其实就是产生一些预升-级的脚-本，跑一些，但是这些脚本好些还是需要手-工执-行的，然后产生post脚本，检查状态。其实这个预升-级的脚-本不做也可以。做下post脚-本查看下结果，有需要修改的修改下。就可以了）

 

  1. /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/preupgrade.jar FILE TEXT DIR /u01/ 
  2.  
  3. ++++++++++++++++++++++++++++
  4. [oracle@wls10306-01 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/preupgrade.jar FILE TEXT DIR /u01/  
  5. Preupgrade generated files:
  6.     /u01/preupgrade.log
  7.     /u01/preupgrade_fixups.sql
  8.     /u01/postupgrade_fixups.sql
  9. [oracle@wls10306-01 ~]$ 
  10. [oracle@wls10306-01 ~]$ 
  11.  
  12. [oracle@wls10306-01 u01]$ ll
  13. total 508
  14. drwxrwxr-x. 4 oracle oinstall     40 Jan  6 15:31 app
  15. drwxr-xr-x  7 oracle oinstall    136 Aug 27  2013 database
  16. -rw-r--r--  1 oracle oinstall   5373 Jan 17 13:52 dbms_registry_basic.sql
  17. -rw-r--r--  1 oracle oinstall  12693 Jan 17 13:52 dbms_registry_extended.sql
  18. drwxr-xr-x  3 oracle oinstall     21 Jan 17 13:52 oracle
  19. -rw-r--r--  1 oracle oinstall   8129 Jan 17 13:53 postupgrade_fixups.sql
  20. -rw-r--r--  1 oracle oinstall   7027 Jan 17 13:52 preupgrade_driver.sql
  21. -rw-r--r--  1 oracle oinstall   9196 Jan 17 13:53 preupgrade_fixups.sql
  22. -rw-r--r--  1 oracle oinstall  10685 Jan 17 13:53 preupgrade.log
  23. -rw-r--r--  1 oracle oinstall  60144 Jan 17 13:52 preupgrade_messages.properties
  24. -rw-r--r--  1 oracle oinstall 390244 Jan 17 13:52 preupgrade_package.sql
  25. drwxr-xr-x  3 oracle oinstall     24 Jan 17 13:52 upgrade
  26. [oracle@wls10306-01 u01]$

-- 执行preupgrade_fixups.sql 。大部分失败了，需要手-工执-行。

  1. SQL> @/u01/preupgrade_fixups.sql
  2.  
  3. Executing Oracle PRE-Upgrade Fixup Script
  4.  
  5. Auto-Generated by:       Oracle Preupgrade Script
  6.                          Version: 12.2.0.1.0 Build: 1
  7. Generated on:            2020-01-17 13:53:04
  8.  
  9. For Source Database:     TEST
  10. Source Database Version: 11.2.0.4.0
  11. For Upgrade to Version:  12.2.0.1.0
  12.  
  13.                           Fixup
  14. Check Name                Status  Further DBA Action
  15. ----------                ------  ------------------
  16. em_present                Failed  Manual fixup recommended.
  17. amd_exists                Failed  Manual fixup recommended.
  18. dictionary_stats          Passed  None
  19. trgowner_no_admndbtrg     Failed  Manual fixup recommended.
  20. mv_refresh                Failed  Manual fixup recommended.
  21. apex_upgrade_msg          Failed  Manual fixup recommended.
  22.  
  23. PL/SQL procedure successfully completed.
  24.  
  25. SQL> SQL>

-- 删除em
从12c的ORACLE_HOME中copy emremove.sql 到11.2.0.4的oracle home

  1. emctl stop dbconsole 
  2. cp /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/emremove.sql /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/
  3.  
  4. SQL> @?/rdbms/admin/emremove.sql
  5. old  70:     IF (upper('&LOGGING') = 'VERBOSE')
  6. new  70:     IF (upper('VERBOSE') = 'VERBOSE')
  7.  This script will drop the Oracle Enterprise Manager related schemas and objects.
  8.  This script might take few minutes to complete; it has 6 phases to complete the process.
  9.  The script may take longer if you have SYSMAN and related sessions are active
  10.  from Oracle Enterprise Manager(OEM) application.
  11.  
  12.  
  13.  Recommendations:
  14.  
  15.  
  16.  You are recommended to shutdown DB Control application immediately before running this
  17.  OEM repository removal script.
  18.  To shutdown DB Control application, you need to run: emctl stop dbconsole
  19.  
  20.  
  21.  Steps to be performed manually (after this script is run):
  22.  
  23.  
  24.  Please note that you need to remove the DB Control Configuration Files
  25.  manually to remove DB Control completly; remove the following
  26.  directories from your filesystem:
  27.  <ORACLE_HOME>/<hostname_sid>
  28.  <ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>
  29.  
  30.  If the dbcontrol is upgraded from lower version, for example, from 10.2.0.3 to 10.2.0.4,
  31.  then the following directory also needs to be removed from the file system.
  32.  <ORACLE_HOME>/<hostname_sid>.upgrade
  33.  <ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>.upgrade
  34.  
  35.  On Microsoft platforms, also delete the DB Console service, generally with name
  36.  OracleDBConsole<sid>
  37. Starting phase 1 : Dropping AQ related objests, EM jobs and all Oracle Enterprise Manager related schemas; except SYSMAN ...
  38. dropping AQ related objests from SYSMAN ...
  39. saved job_queue_process=1000, set to 0, now removing Oracle EM jobs ...
  40. finding users who needs to be dropped ...
  41. found user name: MGMT_VIEW
  42. found [sql%notfound]: no session found; or already killed.
  43.  Dropping user : "MGMT_VIEW"...
  44. Finished phase 1
  45. Starting phase 2 : Dropping SYSMAN schema ...
  46. found [sql%notfound]: SYSMAN related sessions are already killed; no session found
  47. dropping user :  MGMT_VIEW...
  48. SYSMAN dropped
  49. Finished phase 3
  50. Starting phase 4 : Dropping Oracle Enterprise Manager related MGMT_USER role ...
  51. Finished phase 4
  52. Starting phase 5 : Dropping Oracle Enterprise Manager related public synonyms ...
  53. Dropping synonym : ECM_UTIL ...
  54. Dropping synonym : EMD_MNTR ...
  55. Dropping synonym : MGMT$ALERT_ANNOTATIONS ...
  56. Dropping synonym : MGMT$ALERT_CURRENT ...
  57. Dropping synonym : MGMT$ALERT_HISTORY ...
  58. Dropping synonym : MGMT$ALERT_NOTIF_LOG ...
  59. Dropping synonym : MGMT$APPLIED_PATCHES ...
  60. Dropping synonym : MGMT$APPLIED_PATCHSETS ...
  61. Dropping synonym : MGMT$APPL_PATCH_AND_PATCHSET ...
  62. Dropping synonym : MGMT$AUDIT_LOG ...
  63. Dropping synonym : MGMT$AVAILABILITY_CURRENT ...
  64. Dropping synonym : MGMT$AVAILABILITY_HISTORY ...
  65. Dropping synonym : MGMT$BLACKOUTS ...
  66. Dropping synonym : MGMT$BLACKOUT_HISTORY ...
  67. Dropping synonym : MGMT$CLUSTER_INTERCONNECTS ...
  68. Dropping synonym : MGMT$CPF_ADVISORY_INFO ...
  69. Dropping synonym : MGMT$CPF_HOMES_INFO ...
  70. Dropping synonym : MGMT$CPF_PATCH_DATA ...
  71. Dropping synonym : MGMT$CPF_PATCH_INFO ...
  72. Dropping synonym : MGMT$CSA_CLIENTS ...
  73. Dropping synonym : MGMT$CSA_CLIENT_RULE_VIOLS ...
  74. Dropping synonym : MGMT$CSA_COLLECTIONS ...
  75. Dropping synonym : MGMT$CSA_FAILED ...
  76. Dropping synonym : MGMT$CSA_HOST_COOKIES ...
  77. Dropping synonym : MGMT$CSA_HOST_CPUS ...
  78. Dropping synonym : MGMT$CSA_HOST_CUSTOM ...
  79. Dropping synonym : MGMT$CSA_HOST_IOCARDS ...
  80. Dropping synonym : MGMT$CSA_HOST_NICS ...
  81. Dropping synonym : MGMT$CSA_HOST_OS_COMPONENTS ...
  82. Dropping synonym : MGMT$CSA_HOST_OS_FILESYSTEMS ...
  83. Dropping synonym : MGMT$CSA_HOST_OS_PROPERTIES ...
  84. Dropping synonym : MGMT$CSA_HOST_RULES ...
  85. Dropping synonym : MGMT$CSA_HOST_SW ...
  86. Dropping synonym : MGMT$CSM_DOMAIN_DAILY ...
  87. Dropping synonym : MGMT$CSM_DOMAIN_DIST_DAILY ...
  88. Dropping synonym : MGMT$CSM_DOMAIN_DIST_HOURLY ...
  89. Dropping synonym : MGMT$CSM_DOMAIN_HOURLY ...
  90. Dropping synonym : MGMT$CSM_IP_DAILY ...
  91. Dropping synonym : MGMT$CSM_IP_DIST_DAILY ...
  92. Dropping synonym : MGMT$CSM_IP_DIST_HOURLY ...
  93. Dropping synonym : MGMT$CSM_IP_HOURLY ...
  94. Dropping synonym : MGMT$CSM_METRIC_DETAILS ...
  95. Dropping synonym : MGMT$CSM_MT_DSR_DAILY ...
  96. Dropping synonym : MGMT$CSM_MT_DSR_DIST_DAILY ...
  97. Dropping synonym : MGMT$CSM_MT_DSR_DIST_HOURLY ...
  98. Dropping synonym : MGMT$CSM_MT_DSR_HOURLY ...
  99. Dropping synonym : MGMT$CSM_MT_IP_DAILY ...
  100. Dropping synonym : MGMT$CSM_MT_IP_DIST_DAILY ...
  101. Dropping synonym : MGMT$CSM_MT_IP_DIST_HOURLY ...
  102. Dropping synonym : MGMT$CSM_MT_IP_HOURLY ...
  103. Dropping synonym : MGMT$CSM_MT_METRIC_DETAILS ...
  104. Dropping synonym : MGMT$CSM_MT_URL_DAILY ...
  105. Dropping synonym : MGMT$CSM_MT_URL_DIST_DAILY ...
  106. Dropping synonym : MGMT$CSM_MT_URL_DIST_HOURLY ...
  107. Dropping synonym : MGMT$CSM_MT_URL_HOURLY ...
  108. Dropping synonym : MGMT$CSM_REGION ...
  109. Dropping synonym : MGMT$CSM_REGION_DAILY ...
  110. Dropping synonym : MGMT$CSM_REGION_DIST_DAILY ...
  111. Dropping synonym : MGMT$CSM_REGION_DIST_HOURLY ...
  112. Dropping synonym : MGMT$CSM_REGION_HOURLY ...
  113. Dropping synonym : MGMT$CSM_SUBNET_DAILY ...
  114. Dropping synonym : MGMT$CSM_SUBNET_DIST_DAILY ...
  115. Dropping synonym : MGMT$CSM_SUBNET_DIST_HOURLY ...
  116. Dropping synonym : MGMT$CSM_SUBNET_HOURLY ...
  117. Dropping synonym : MGMT$CSM_URL_DAILY ...
  118. Dropping synonym : MGMT$CSM_URL_DIST_DAILY ...
  119. Dropping synonym : MGMT$CSM_URL_DIST_HOURLY ...
  120. Dropping synonym : MGMT$CSM_URL_HOURLY ...
  121. Dropping synonym : MGMT$CSM_WATCHLIST ...
  122. Dropping synonym : MGMT$CS_CONFIG_STANDARDS ...
  123. Dropping synonym : MGMT$CS_EVAL_SUMMARY_RULE ...
  124. Dropping synonym : MGMT$CS_EVAL_SUMMARY_STANDARD ...
  125. Dropping synonym : MGMT$DB_CONTROLFILES ...
  126. Dropping synonym : MGMT$DB_CONTROLFILES_ALL ...
  127. Dropping synonym : MGMT$DB_DATAFILES ...
  128. Dropping synonym : MGMT$DB_DATAFILES_ALL ...
  129. Dropping synonym : MGMT$DB_DBNINSTANCEINFO ...
  130. Dropping synonym : MGMT$DB_DBNINSTANCEINFO_ALL ...
  131. Dropping synonym : MGMT$DB_FEATUREUSAGE ...
  132. Dropping synonym : MGMT$DB_INIT_PARAMS ...
  133. Dropping synonym : MGMT$DB_INIT_PARAMS_ALL ...
  134. Dropping synonym : MGMT$DB_LICENSE ...
  135. Dropping synonym : MGMT$DB_LICENSE_ALL ...
  136. Dropping synonym : MGMT$DB_OPTIONS ...
  137. Dropping synonym : MGMT$DB_OPTIONS_ALL ...
  138. Dropping synonym : MGMT$DB_REDOLOGS ...
  139. Dropping synonym : MGMT$DB_REDOLOGS_ALL ...
  140. Dropping synonym : MGMT$DB_ROLLBACK_SEGS ...
  141. Dropping synonym : MGMT$DB_ROLLBACK_SEGS_ALL ...
  142. Dropping synonym : MGMT$DB_SGA ...
  143. Dropping synonym : MGMT$DB_SGA_ALL ...
  144. Dropping synonym : MGMT$DB_TABLESPACES ...
  145. Dropping synonym : MGMT$DB_TABLESPACES_ALL ...
  146. Dropping synonym : MGMT$DELTA_COMPONENTS ...
  147. Dropping synonym : MGMT$DELTA_COMPONENT_DETAILS ...
  148. Dropping synonym : MGMT$DELTA_FS_MOUNT ...
  149. Dropping synonym : MGMT$DELTA_HARDWARE ...
  150. Dropping synonym : MGMT$DELTA_HOST_CONFIG ...
  151. Dropping synonym : MGMT$DELTA_INIT ...
  152. Dropping synonym : MGMT$DELTA_ONEOFF_PATCHES ...
  153. Dropping synonym : MGMT$DELTA_ORACLE_HOME ...
  154. Dropping synonym : MGMT$DELTA_OS_COMPONENTS ...
  155. Dropping synonym : MGMT$DELTA_OS_COMP_DETAILS ...
  156. Dropping synonym : MGMT$DELTA_OS_KERNEL_PARAMS ...
  157. Dropping synonym : MGMT$DELTA_PATCHSETS ...
  158. Dropping synonym : MGMT$DELTA_PATCHSET_DETAILS ...
  159. Dropping synonym : MGMT$DELTA_VENDOR_SW ...
  160. Dropping synonym : MGMT$DELTA_VIEW ...
  161. Dropping synonym : MGMT$DELTA_VIEW_DETAILS ...
  162. Dropping synonym : MGMT$E2E_1DAY ...
  163. Dropping synonym : MGMT$E2E_HOURLY ...
  164. Dropping synonym : MGMT$E2E_RAW ...
  165. Dropping synonym : MGMT$ECM_CONFIG_HISTORY ...
  166. Dropping synonym : MGMT$ECM_CONFIG_HISTORY_KEY1 ...
  167. Dropping synonym : MGMT$ECM_CONFIG_HISTORY_KEY2 ...
  168. Dropping synonym : MGMT$ECM_CONFIG_HISTORY_KEY3 ...
  169. Dropping synonym : MGMT$ECM_CONFIG_HISTORY_KEY4 ...
  170. Dropping synonym : MGMT$ECM_CONFIG_HISTORY_KEY5 ...
  171. Dropping synonym : MGMT$ECM_CONFIG_HISTORY_KEY6 ...
  172. Dropping synonym : MGMT$ECM_CURRENT_SNAPSHOTS ...
  173. Dropping synonym : MGMT$ECM_VISIBLE_SNAPSHOTS ...
  174. Dropping synonym : MGMT$EM_HOMES_PLATFORM ...
  175. Dropping synonym : MGMT$ESA_ALL_PRIVS_REPORT ...
  176. Dropping synonym : MGMT$ESA_ANY_DICT_REPORT ...
  177. Dropping synonym : MGMT$ESA_ANY_PRIV_REPORT ...
  178. Dropping synonym : MGMT$ESA_AUDIT_SYSTEM_REPORT ...
  179. Dropping synonym : MGMT$ESA_BECOME_USER_REPORT ...
  180. Dropping synonym : MGMT$ESA_CATALOG_REPORT ...
  181. Dropping synonym : MGMT$ESA_CONN_PRIV_REPORT ...
  182. Dropping synonym : MGMT$ESA_CREATE_PRIV_REPORT ...
  183. Dropping synonym : MGMT$ESA_DBA_GROUP_REPORT ...
  184. Dropping synonym : MGMT$ESA_DBA_ROLE_REPORT ...
  185. Dropping synonym : MGMT$ESA_DIRECT_PRIV_REPORT ...
  186. Dropping synonym : MGMT$ESA_EXMPT_ACCESS_REPORT ...
  187. Dropping synonym : MGMT$ESA_KEY_OBJECTS_REPORT ...
  188. Dropping synonym : MGMT$ESA_OH_OWNERSHIP_REPORT ...
  189. Dropping synonym : MGMT$ESA_OH_PERMISSION_REPORT ...
  190. Dropping synonym : MGMT$ESA_POWER_PRIV_REPORT ...
  191. Dropping synonym : MGMT$ESA_PUB_PRIV_REPORT ...
  192. Dropping synonym : MGMT$ESA_SYS_PUB_PKG_REPORT ...
  193. Dropping synonym : MGMT$ESA_TABSP_OWNERS_REPORT ...
  194. Dropping synonym : MGMT$ESA_TRC_AUD_PERM_REPORT ...
  195. Dropping synonym : MGMT$ESA_TRC_AUD_PERM_REP_NT ...
  196. Dropping synonym : MGMT$ESA_WITH_ADMIN_REPORT ...
  197. Dropping synonym : MGMT$ESA_WITH_GRANT_REPORT ...
  198. Dropping synonym : MGMT$GROUP_DERIVED_MEMBERSHIPS ...
  199. Dropping synonym : MGMT$GROUP_FLAT_MEMBERSHIPS ...
  200. Dropping synonym : MGMT$GROUP_MEMBERS ...
  201. Dropping synonym : MGMT$GRP_METRICS_DAILY ...
  202. Dropping synonym : MGMT$GRP_METRICS_HOURLY ...
  203. Dropping synonym : MGMT$GRP_METRICS_RAW ...
  204. Dropping synonym : MGMT$HA_BACKUP ...
  205. Dropping synonym : MGMT$HA_FILES ...
  206. Dropping synonym : MGMT$HA_FILES_ALL ...
  207. Dropping synonym : MGMT$HA_INFO ...
  208. Dropping synonym : MGMT$HA_INFO_ALL ...
  209. Dropping synonym : MGMT$HA_INIT_PARAMS ...
  210. Dropping synonym : MGMT$HA_INIT_PARAMS_ALL ...
  211. Dropping synonym : MGMT$HA_MTTR ...
  212. Dropping synonym : MGMT$HA_RMAN_CONFIG ...
  213. Dropping synonym : MGMT$HA_RMAN_CONFIG_ALL ...
  214. Dropping synonym : MGMT$HOMES_AFFECTED ...
  215. Dropping synonym : MGMT$HOSTPATCH_GROUPS ...
  216. Dropping synonym : MGMT$HOSTPATCH_GRP_COMPL_HIST ...
  217. Dropping synonym : MGMT$HOSTPATCH_HOSTS ...
  218. Dropping synonym : MGMT$HOSTPATCH_HOST_COMPL ...
  219. Dropping synonym : MGMT$HW_NIC ...
  220. Dropping synonym : MGMT$INTERFACE_STATS ...
  221. Dropping synonym : MGMT$JOBS ...
  222. Dropping synonym : MGMT$JOB_ANNOTATIONS ...
  223. Dropping synonym : MGMT$JOB_EXECUTION_HISTORY ...
  224. Dropping synonym : MGMT$JOB_NOTIFICATION_LOG ...
  225. Dropping synonym : MGMT$JOB_STEP_HISTORY ...
  226. Dropping synonym : MGMT$JOB_TARGETS ...
  227. Dropping synonym : MGMT$MESSAGES ...
  228. Dropping synonym : MGMT$METRIC_CATEGORIES ...
  229. Dropping synonym : MGMT$METRIC_COLLECTION ...
  230. Dropping synonym : MGMT$METRIC_CURRENT ...
  231. Dropping synonym : MGMT$METRIC_DAILY ...
  232. Dropping synonym : MGMT$METRIC_DETAILS ...
  233. Dropping synonym : MGMT$METRIC_ERROR_CURRENT ...
  234. Dropping synonym : MGMT$METRIC_ERROR_HISTORY ...
  235. Dropping synonym : MGMT$METRIC_HOURLY ...
  236. Dropping synonym : MGMT$MISSING_TARGETS ...
  237. Dropping synonym : MGMT$MISSING_TARGETS_IN_GROUPS ...
  238. Dropping synonym : MGMT$ORACLE_SW_ENT_INSTALL ...
  239. Dropping synonym : MGMT$ORACLE_SW_ENT_TARGETS ...
  240. Dropping synonym : MGMT$ORACLE_SW_GRP_INSTALL ...
  241. Dropping synonym : MGMT$ORACLE_SW_GRP_TARGETS ...
  242. Dropping synonym : MGMT$OS_COMPONENTS ...
  243. Dropping synonym : MGMT$OS_FS_MOUNT ...
  244. Dropping synonym : MGMT$OS_HW_SUMMARY ...
  245. Dropping synonym : MGMT$OS_KERNEL_PARAMS ...
  246. Dropping synonym : MGMT$OS_PATCHES ...
  247. Dropping synonym : MGMT$OS_PROPERTIES ...
  248. Dropping synonym : MGMT$OS_SUMMARY ...
  249. Dropping synonym : MGMT$PATCH_ADVISORIES ...
  250. Dropping synonym : MGMT$POLICIES ...
  251. Dropping synonym : MGMT$POLICY_PARAMETERS ...
  252. Dropping synonym : MGMT$POLICY_VIOLATION_CONTEXT ...
  253. Dropping synonym : MGMT$POLICY_VIOLATION_CTXT ...
  254. Dropping synonym : MGMT$POLICY_VIOLATION_CURRENT ...
  255. Dropping synonym : MGMT$POLICY_VIOLATION_HISTORY ...
  256. Dropping synonym : MGMT$POLICY_VIOL_ANNOTATIONS ...
  257. Dropping synonym : MGMT$POLICY_VIOL_NOTIF_LOG ...
  258. Dropping synonym : MGMT$RACDB_INTERCONNECTS ...
  259. Dropping synonym : MGMT$SOFTWARE_COMPONENTS ...
  260. Dropping synonym : MGMT$SOFTWARE_COMPONENT_ONEOFF ...
  261. Dropping synonym : MGMT$SOFTWARE_COMP_PATCHSET ...
  262. Dropping synonym : MGMT$SOFTWARE_DEPENDENCIES ...
  263. Dropping synonym : MGMT$SOFTWARE_HOMES ...
  264. Dropping synonym : MGMT$SOFTWARE_HOME_PROPERTIES ...
  265. Dropping synonym : MGMT$SOFTWARE_ONEOFF_PATCHES ...
  266. Dropping synonym : MGMT$SOFTWARE_OTHERS ...
  267. Dropping synonym : MGMT$SOFTWARE_PATCHES_IN_HOMES ...
  268. Dropping synonym : MGMT$SOFTWARE_PATCHSETS ...
  269. Dropping synonym : MGMT$STEPS ...
  270. Dropping synonym : MGMT$STEP_GROUPS ...
  271. Dropping synonym : MGMT$STEP_METRICS_DAILY ...
  272. Dropping synonym : MGMT$STEP_METRICS_HOURLY ...
  273. Dropping synonym : MGMT$STEP_METRICS_RAW ...
  274. Dropping synonym : MGMT$STORAGE_REPORT_DATA ...
  275. Dropping synonym : MGMT$STORAGE_REPORT_DISK ...
  276. Dropping synonym : MGMT$STORAGE_REPORT_ISSUES ...
  277. Dropping synonym : MGMT$STORAGE_REPORT_KEYS ...
  278. Dropping synonym : MGMT$STORAGE_REPORT_LOCALFS ...
  279. Dropping synonym : MGMT$STORAGE_REPORT_NFS ...
  280. Dropping synonym : MGMT$STORAGE_REPORT_PATHS ...
  281. Dropping synonym : MGMT$STORAGE_REPORT_VOLUME ...
  282. Dropping synonym : MGMT$TARGET ...
  283. Dropping synonym : MGMT$TARGET_ASSOCIATIONS ...
  284. Dropping synonym : MGMT$TARGET_COMPONENTS ...
  285. Dropping synonym : MGMT$TARGET_COMPOSITE ...
  286. Dropping synonym : MGMT$TARGET_FLAT_MEMBERS ...
  287. Dropping synonym : MGMT$TARGET_MEMBERS ...
  288. Dropping synonym : MGMT$TARGET_METRIC_COLLECTIONS ...
  289. Dropping synonym : MGMT$TARGET_METRIC_SETTINGS ...
  290. Dropping synonym : MGMT$TARGET_POLICIES ...
  291. Dropping synonym : MGMT$TARGET_POLICY_EVAL_SUMM ...
  292. Dropping synonym : MGMT$TARGET_POLICY_SETTINGS ...
  293. Dropping synonym : MGMT$TARGET_PROPERTIES ...
  294. Dropping synonym : MGMT$TARGET_TYPE ...
  295. Dropping synonym : MGMT$TARGET_TYPE_DEF ...
  296. Dropping synonym : MGMT$TARGET_TYPE_PROPERTIES ...
  297. Dropping synonym : MGMT$TEMPLATES ...
  298. Dropping synonym : MGMT$TEMPLATE_METRICCOLLECTION ...
  299. Dropping synonym : MGMT$TEMPLATE_METRIC_SETTINGS ...
  300. Dropping synonym : MGMT$TEMPLATE_POLICY_SETTINGS ...
  301. Dropping synonym : MGMT$TXN_PERF_DAY ...
  302. Dropping synonym : MGMT$TXN_PERF_HOUR ...
  303. Dropping synonym : MGMT$TXN_PERF_RAW ...
  304. Dropping synonym : MGMT_ADMIN ...
  305. Dropping synonym : MGMT_AVAILABILITY ...
  306. Dropping synonym : MGMT_TARGET_BLACKOUTS ...
  307. Dropping synonym : MGMT_COLLECTION_PROPERTIES ...
  308. Dropping synonym : MGMT_CREDENTIAL ...
  309. Dropping synonym : MGMT_CURRENT_AVAILABILITY ...
  310. Dropping synonym : MGMT_CURRENT_METRICS ...
  311. Dropping synonym : MGMT_CURRENT_METRIC_ERRORS ...
  312. Dropping synonym : MGMT_CURRENT_SEVERITY ...
  313. Dropping synonym : MGMT_DELTA ...
  314. Dropping synonym : MGMT_DELTA_ENTRY ...
  315. Dropping synonym : MGMT_DELTA_ENTRY_VALUES ...
  316. Dropping synonym : MGMT_DELTA_IDS ...
  317. Dropping synonym : MGMT_DELTA_ID_VALUES ...
  318. Dropping synonym : MGMT_DELTA_VALUE ...
  319. Dropping synonym : MGMT_DELTA_VALUES ...
  320. Dropping synonym : MGMT_GLOBAL ...
  321. Dropping synonym : MGMT_GUID_ARRAY ...
  322. Dropping synonym : MGMT_GUID_OBJ ...
  323. Dropping synonym : MGMT_IP_TGT_GUID_ARRAY ...
  324. Dropping synonym : MGMT_JOB ...
  325. Dropping synonym : MGMT_JOBS ...
  326. Dropping synonym : MGMT_JOB_EXECPLAN ...
  327. Dropping synonym : MGMT_JOB_EXECUTION ...
  328. Dropping synonym : MGMT_JOB_EXEC_SUMMARY ...
  329. Dropping synonym : MGMT_JOB_OUTPUT ...
  330. Dropping synonym : MGMT_JOB_PARAMETER ...
  331. Dropping synonym : MGMT_JOB_SCHEDULE ...
  332. Dropping synonym : MGMT_JOB_TARGET ...
  333. Dropping synonym : MGMT_LOG ...
  334. Dropping synonym : MGMT_LONG_TEXT ...
  335. Dropping synonym : MGMT_MESSAGES ...
  336. Dropping synonym : MGMT_METRICS ...
  337. Dropping synonym : MGMT_METRICS_1DAY ...
  338. Dropping synonym : MGMT_METRICS_1HOUR ...
  339. Dropping synonym : MGMT_METRICS_COMPOSITE_KEYS ...
  340. Dropping synonym : MGMT_METRICS_RAW ...
  341. Dropping synonym : MGMT_METRIC_COLLECTIONS ...
  342. Dropping synonym : MGMT_METRIC_ERRORS ...
  343. Dropping synonym : MGMT_METRIC_THRESHOLDS ...
  344. Dropping synonym : MGMT_NAME_VALUE ...
  345. Dropping synonym : MGMT_NAME_VALUES ...
  346. Dropping synonym : MGMT_PAF$APPLICATIONS ...
  347. Dropping synonym : MGMT_PAF$INSTANCES ...
  348. Dropping synonym : MGMT_PAF$PROCEDURES ...
  349. Dropping synonym : MGMT_PAF$STATES ...
  350. Dropping synonym : MGMT_PAF_JOBS ...
  351. Dropping synonym : MGMT_PAF_PROCS_LATEST ...
  352. Dropping synonym : MGMT_PREFERENCES ...
  353. Dropping synonym : MGMT_SEVERITY ...
  354. Dropping synonym : MGMT_SEVERITY_ARRAY ...
  355. Dropping synonym : MGMT_SEVERITY_OBJ ...
  356. Dropping synonym : MGMT_STRING_METRIC_HISTORY ...
  357. Dropping synonym : MGMT_TARGET ...
  358. Dropping synonym : MGMT_TARGETS ...
  359. Dropping synonym : MGMT_TARGET_MEMBERSHIPS ...
  360. Dropping synonym : MGMT_TARGET_PROPERTIES ...
  361. Dropping synonym : MGMT_TYPE_PROPERTIES ...
  362. Dropping synonym : MGMT_USER ...
  363. Dropping synonym : MGMT_VIEW_UTIL ...
  364. Dropping synonym : SETEMVIEWUSERCONTEXT ...
  365. Dropping synonym : SMP_EMD_AVAIL_OBJ ...
  366. Dropping synonym : SMP_EMD_DELETE_REC_ARRAY ...
  367. Dropping synonym : SMP_EMD_INTEGER_ARRAY ...
  368. Dropping synonym : SMP_EMD_INTEGER_ARRAY_ARRAY ...
  369. Dropping synonym : SMP_EMD_NVPAIR ...
  370. Dropping synonym : SMP_EMD_NVPAIR_ARRAY ...
  371. Dropping synonym : SMP_EMD_STRING_ARRAY ...
  372. Dropping synonym : SMP_EMD_STRING_ARRAY_ARRAY ...
  373. Dropping synonym : SMP_EMD_TARGET_OBJ ...
  374. Dropping synonym : SMP_EMD_TARGET_OBJ_ARRAY ...
  375. Finished phase 5
  376. Starting phase 6 : Dropping Oracle Enterprise Manager related other roles ...
  377. Process DBSNMP user
  378. User DBSNMP is locked
  379. Done processing DBSNMP user
  380. Finished phase 6
  381. The Oracle Enterprise Manager related schemas and objects are dropped.
  382. Do the manual steps to studown the DB Control if not done before running this script and then delete the DB Control configuration files
  383.  
  384. PL/SQL procedure successfully completed.
  385.  
  386. SQL>

-- 删除olap Remove OLAP Catalog by running the 11.2.0.4.0， 大量的synonym,view,type,role等drop。

  1. SQL> @?/olap/admin/catnoamd.sql
  2.  
  3. Synonym dropped.
  4. View dropped.
  5. Type dropped.
  6. View dropped.
  7. Type dropped.
  8. PL/SQL procedure successfully completed.
  11. Role dropped.
  14. PL/SQL procedure successfully completed.
  17. 1 row deleted.
  19. SQL>

-- Gather stale data dictionary statistics prior to database upgrade in off-peak time using

  1. SQL> EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
  2.  
  3. PL/SQL procedure successfully completed.
  4.  
  5. SQL> 
  6.  
  7. --授予ADMINISTER DATABASE TRIGGER权限，查询没有值，不授予 
  8. SQL> SELECT OWNER,
  9.      TRIGGER_NAME FROM DBA_TRIGGERS WHERE BASE_OBJECT_TYPE='DATABASE' AND
  10.      OWNER NOT IN (SELECT GRANTEE FROM DBA_SYS_PRIVS WHERE
  11.      PRIVILEGE='ADMINISTER DATABASE TRIGGER')  2    3    4  ;
  12.  
  13. no rows selected
  14.  
  15. SQL>

--刷新物化视图 ，略
--手动升-级apex，根据1088970.1 。目的是为了减少升-级时间。这里不升-级。

开始升-级 ,job_queue_process=0 后， 23步没有卡，很快就结束了。耗时大约90分钟（虚拟机电脑配置差，2G内存）。
./dbupgrade 

  1. [oracle@wls10306-01 bin]$ ./dbupgrade 
  2.  
  3. Argument list for [/u01/app/oracle/product/12.2.0/dbhome_1//rdbms/admin/catctl.pl]
  4. Run in                c = 0
  5. Do not run in         C = 0
  6. Input Directory       d = 0
  7. Echo OFF              e = 1
  8. Simulate              E = 0
  9. Forced cleanup        F = 0
  10. Log Id                i = 0
  11. Child Process         I = 0
  12. Log Dir               l = 0
  13. Priority List Name    L = 0
  14. Upgrade Mode active   M = 0
  15. SQL Process Count     n = 0
  16. SQL PDB Process Count N = 0
  17. Open Mode Normal      o = 0
  18. Start Phase           p = 0
  19. End Phase             P = 0
  20. Reverse Order         r = 0
  21. AutoUpgrade Resume    R = 0
  22. Script                s = 0
  23. Serial Run            S = 0
  24. RO User Tablespaces   T = 0
  25. Display Phases        y = 0
  26. Debug catcon.pm       z = 0
  27. Debug catctl.pl       Z = 0
  28.  
  29. catctl.pl VERSION: [12.2.0.1.0]
  30.            STATUS: [production]
  31.             BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]
  32.  
  33.  
  34. /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0/dbhome_1/]
  35. /u01/app/oracle/product/12.2.0/dbhome_1//bin/orabasehome = [/u01/app/oracle/product/12.2.0/dbhome_1/]
  36. catctlGetOrabase = [/u01/app/oracle/product/12.2.0/dbhome_1/]
  37.  
  38. Analyzing file /u01/app/oracle/product/12.2.0/dbhome_1//rdbms/admin/catupgrd.sql
  39.  
  40. Log file directory = [/tmp/cfgtoollogs/upgrade20200117143709]
  41.  
  42. catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20200117143709/catupgrd_catcon_17337.lst]
  43. catcon: See [/tmp/cfgtoollogs/upgrade20200117143709/catupgrd*.log] files for output generated by scripts
  44. catcon: See [/tmp/cfgtoollogs/upgrade20200117143709/catupgrd_*.lst] files for spool files, if any
  45.  
  46. Number of Cpus        = 1
  47. Database Name         = test
  48. DataBase Version      = 11.2.0.4.0
  49. catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711/catupgrd_catcon_17337.lst]
  50. catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711/catupgrd*.log] files for output generated by scripts
  51. catcon: See [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711/catupgrd_*.lst] files for spool files, if any
  52.  
  53. Log file directory = [/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711]
  54.  
  55. Parallel SQL Process Count            = 4
  56. Components in [test]
  57.     Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM SDO XDB XML XOQ]
  58. Not Installed [DV EM MGW ODM OLS RAC WK]
  59.  
  60. ------------------------------------------------------
  61. Phases [0-115]         Start Time:[2020_01_17 14:37:12]
  62. ------------------------------------------------------
  63. ***********   Executing Change Scripts   ***********
  64. Serial   Phase #:0    [test] Files:1    Time: 233s
  65. ***************   Catalog Core SQL   ***************
  66. Serial   Phase #:1    [test] Files:5    Time: 72s
  67. Restart  Phase #:2    [test] Files:1    Time: 0s
  68. ***********   Catalog Tables and Views   ***********
  69. Parallel Phase #:3    [test] Files:19   Time: 47s
  70. Restart  Phase #:4    [test] Files:1    Time: 0s
  71. *************   Catalog Final Scripts   ************
  72. Serial   Phase #:5    [test] Files:6    Time: 32s
  73. *****************   Catproc Start   ****************
  74. Serial   Phase #:6    [test] Files:1    Time: 28s
  75. *****************   Catproc Types   ****************
  76. Serial   Phase #:7    [test] Files:2    Time: 24s
  77. Restart  Phase #:8    [test] Files:1    Time: 0s
  78. ****************   Catproc Tables   ****************
  79. Parallel Phase #:9    [test] Files:69   Time: 74s
  80. Restart  Phase #:10   [test] Files:1    Time: 1s
  81. *************   Catproc Package Specs   ************
  82. Serial   Phase #:11   [test] Files:1    Time: 54s
  83. Restart  Phase #:12   [test] Files:1    Time: 0s
  84. **************   Catproc Procedures   **************
  85. Parallel Phase #:13   [test] Files:97   Time: 38s
  86. Restart  Phase #:14   [test] Files:1    Time: 1s
  87. Parallel Phase #:15   [test] Files:118  Time: 34s
  88. Restart  Phase #:16   [test] Files:1    Time: 0s
  89. Serial   Phase #:17   [test] Files:13   Time: 4s
  90. Restart  Phase #:18   [test] Files:1    Time: 1s
  91. *****************   Catproc Views   ****************
  92. Parallel Phase #:19   [test] Files:33   Time: 60s
  93. Restart  Phase #:20   [test] Files:1    Time: 0s
  94. Serial   Phase #:21   [test] Files:3    Time: 13s
  95. Restart  Phase #:22   [test] Files:1    Time: 1s
  96. Parallel Phase #:23   [test] Files:24   Time: 261s
  97. Restart  Phase #:24   [test] Files:1    Time: 0s
  98. Parallel Phase #:25   [test] Files:11   Time: 122s
  99. Restart  Phase #:26   [test] Files:1    Time: 0s
  100. Serial   Phase #:27   [test] Files:1    Time: 0s
  101. Serial   Phase #:28   [test] Files:3    Time: 5s
  102. Serial   Phase #:29   [test] Files:1    Time: 0s
  103. Restart  Phase #:30   [test] Files:1    Time: 1s
  104. ***************   Catproc CDB Views   **************
  105. Serial   Phase #:31   [test] Files:1    Time: 1s
  106. Restart  Phase #:32   [test] Files:1    Time: 0s
  107. Serial   Phase #:34   [test] Files:1    Time: 0s
  108. *****************   Catproc PLBs   *****************
  109. Serial   Phase #:35   [test] Files:283  Time: 136s
  110. Serial   Phase #:36   [test] Files:1    Time: 0s
  111. Restart  Phase #:37   [test] Files:1    Time: 0s
  112. Serial   Phase #:38   [test] Files:1    Time: 8s
  113. Restart  Phase #:39   [test] Files:1    Time: 1s
  114. ***************   Catproc DataPump   ***************
  115. Serial   Phase #:40   [test] Files:3    Time: 77s
  116. Restart  Phase #:41   [test] Files:1    Time: 1s
  117. ******************   Catproc SQL   *****************
  118. Parallel Phase #:42   [test] Files:13   Time: 124s
  119. Restart  Phase #:43   [test] Files:1    Time: 1s
  120. Parallel Phase #:44   [test] Files:12   Time: 42s
  121. Restart  Phase #:45   [test] Files:1    Time: 1s
  122. Parallel Phase #:46   [test] Files:2    Time: 2s
  123. Restart  Phase #:47   [test] Files:1    Time: 0s
  124. *************   Final Catproc scripts   ************
  125. Serial   Phase #:48   [test] Files:1    Time: 12s
  126. Restart  Phase #:49   [test] Files:1    Time: 0s
  127. **************   Final RDBMS scripts   *************
  128. Serial   Phase #:50   [test] Files:1    Time: 38s
  129. ************   Upgrade Component Start   ***********
  130. Serial   Phase #:51   [test] Files:1    Time: 0s
  131. Restart  Phase #:52   [test] Files:1    Time: 1s
  132. ****************   Upgrading Java   ****************
  133. Serial   Phase #:53   [test] Files:1    Time: 678s
  134. Restart  Phase #:54   [test] Files:1    Time: 1s
  135. *****************   Upgrading XDK   ****************
  136. Serial   Phase #:55   [test] Files:1    Time: 83s
  137. Restart  Phase #:56   [test] Files:1    Time: 1s
  138. *********   Upgrading APS,OLS,DV,CONTEXT   *********
  139. Serial   Phase #:57   [test] Files:1    Time: 100s
  140. *****************   Upgrading XDB   ****************
  141. Restart  Phase #:58   [test] Files:1    Time: 1s
  142. Serial   Phase #:60   [test] Files:3    Time: 43s
  143. Serial   Phase #:61   [test] Files:3    Time: 15s
  144. Parallel Phase #:62   [test] Files:9    Time: 6s
  145. Parallel Phase #:63   [test] Files:24   Time: 10s
  146. Serial   Phase #:64   [test] Files:4    Time: 15s
  147. Serial   Phase #:65   [test] Files:1    Time: 0s
  148. Serial   Phase #:66   [test] Files:30   Time: 6s
  149. Serial   Phase #:67   [test] Files:1    Time: 0s
  150. Parallel Phase #:68   [test] Files:6    Time: 6s
  151. Serial   Phase #:69   [test] Files:2    Time: 39s
  152. Serial   Phase #:70   [test] Files:3    Time: 161s
  153. Restart  Phase #:71   [test] Files:1    Time: 1s
  154. *********   Upgrading CATJAVA,OWM,MGW,RAC   ********
  155. Serial   Phase #:72   [test] Files:1    Time: 188s
  156. ****************   Upgrading ORDIM   ***************
  157. Restart  Phase #:73   [test] Files:1    Time: 1s
  158. Serial   Phase #:75   [test] Files:1    Time: 1s
  159. Parallel Phase #:76   [test] Files:2    Time: 160s
  160. Serial   Phase #:77   [test] Files:1    Time: 126s
  161. Restart  Phase #:78   [test] Files:1    Time: 1s
  162. Parallel Phase #:79   [test] Files:2    Time: 21s
  163. Serial   Phase #:80   [test] Files:2    Time: 2s
  164. *****************   Upgrading SDO   ****************
  165. Restart  Phase #:81   [test] Files:1    Time: 0s
  166. Serial   Phase #:83   [test] Files:1    Time: 60s
  167. Serial   Phase #:84   [test] Files:1    Time: 2s
  168. Restart  Phase #:85   [test] Files:1    Time: 1s
  169. Serial   Phase #:86   [test] Files:1    Time: 43s
  170. Restart  Phase #:87   [test] Files:1    Time: 1s
  171. Parallel Phase #:88   [test] Files:3    Time: 257s
  172. Restart  Phase #:89   [test] Files:1    Time: 1s
  173. Serial   Phase #:90   [test] Files:1    Time: 9s
  174. Restart  Phase #:91   [test] Files:1    Time: 0s
  175. Serial   Phase #:92   [test] Files:1    Time: 4s
  176. Restart  Phase #:93   [test] Files:1    Time: 1s
  177. Parallel Phase #:94   [test] Files:4    Time: 218s
  178. Restart  Phase #:95   [test] Files:1    Time: 0s
  179. Serial   Phase #:96   [test] Files:1    Time: 1s
  180. Restart  Phase #:97   [test] Files:1    Time: 0s
  181. Serial   Phase #:98   [test] Files:2    Time: 85s
  182. Restart  Phase #:99   [test] Files:1    Time: 0s
  183. Serial   Phase #:100  [test] Files:1    Time: 1s
  184. Restart  Phase #:101  [test] Files:1    Time: 1s
  185. ***********   Upgrading Misc. ODM, OLAP   **********
  186. Serial   Phase #:102  [test] Files:1    Time: 41s
  187. ****************   Upgrading APEX   ****************
  188. Restart  Phase #:103  [test] Files:1    Time: 1s
  189. Serial   Phase #:104  [test] Files:1    Time: 1044s
  190. Restart  Phase #:105  [test] Files:1    Time: 0s
  191. ***********   Final Component scripts    ***********
  192. Serial   Phase #:106  [test] Files:1    Time: 1s
  193. *************   Final Upgrade scripts   ************
  194. Serial   Phase #:107  [test] Files:1    Time: 148s
  195. **********   End PDB Application Upgrade   *********
  196. Serial   Phase #:108  [test] Files:1    Time: 1s
  197. *******************   Migration   ******************
  198. Serial   Phase #:109  [test] Files:1    Time: 59s
  199. Serial   Phase #:110  [test] Files:1    Time: 0s
  200. Serial   Phase #:111  [test] Files:1    Time: 50s
  201. *****************   Post Upgrade   *****************
  202. Serial   Phase #:112  [test] Files:1    Time: 169s
  203. ****************   Summary report   ****************
  204. Serial   Phase #:113  [test] Files:1    Time: 2s
  205. Serial   Phase #:114  [test] Files:1    Time: 0s
  206. Serial   Phase #:115  [test] Files:1     Time: 19s
  207.  
  208. ------------------------------------------------------
  209. Phases [0-115]         End Time:[2020_01_17 16:07:49]
  210. ------------------------------------------------------
  211.  
  212. Grand Total Time: 5449s 
  213.  
  214.  LOG FILES: (/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711/catupgrd*.log)
  215.  
  216. Upgrade Summary Report Located in:
  217. /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711/upg_summary.log
  218.  
  219. Grand Total Upgrade Time:    [0d:1h:30m:49s]
  220. [oracle@wls10306-01 bin]$ 
  221.  
  222.  
  1. SQL> @?/rdbms/admin/utlu122s.sql
  2.  
  3.  
  4.  
  5.  
  6. Oracle Database 12.2 Post-Upgrade Status Tool		01-17-2020 16:09:04
  7.  
  8. Component				Current 	Version  Elapsed Time
  9. Name					Status		Number	 HH:MM:SS
  10.  
  11. Oracle Server			       UPGRADED      12.2.0.1.0  00:25:42
  12. JServer JAVA Virtual Machine	       UPGRADED      12.2.0.1.0  00:11:16
  13. Oracle Workspace Manager	       UPGRADED      12.2.0.1.0  00:02:33
  14. OLAP Analytic Workspace 	       UPGRADED      12.2.0.1.0  00:00:20
  15. Oracle OLAP API 		       UPGRADED      12.2.0.1.0  00:00:21
  16. Oracle XDK			       UPGRADED      12.2.0.1.0  00:01:22
  17. Oracle Text			       UPGRADED      12.2.0.1.0  00:01:18
  18. Oracle XML Database		       UPGRADED      12.2.0.1.0  00:05:00
  19. Oracle Database Java Packages	       UPGRADED      12.2.0.1.0  00:00:33
  20. Oracle Multimedia		       UPGRADED      12.2.0.1.0  00:05:10
  21. Spatial 			       UPGRADED      12.2.0.1.0  00:11:21
  22. Oracle Application Express	       UPGRADED     5.0.4.00.12  00:17:22
  23. Final Actions							 00:03:28
  24. Post Upgrade							 00:02:48
  25.  
  26. Total Upgrade Time: 01:29:17
  27.  
  28. Database time zone version is 14. It is older than current release time
  29. zone version 26. Time zone upgrade is needed using the DBMS_DST package.
  30.  
  31. Summary Report File = /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/test/upgrade20200117143711/upg_summary.log
  32.  
  33. 16:09:05 SQL> 
  34. 16:09:05 SQL>

-- 运行post 脚-本

  1. [oracle@wls10306-01 u01]$ sqlplus /nolog
  2.  
  3. SQL*Plus: Release 12.2.0.1.0 Production on Fri Jan 17 16:12:16 2020
  5. Copyright (c) 1982, 2016, Oracle.  All rights reserved.
  6.  
  7. SQL> conn / as sysdba
  8. Connected.
  9. SQL> @/u01/postupgrade_fixups.sql
  10.  
  11. Session altered.
  12.  
  13.  
  14. PL/SQL procedure successfully completed.
  15.  
  16.  
  17. PL/SQL procedure successfully completed.
  18.  
  19.  
  20. Package created.
  21.  
  22. No errors.
  23.  
  24. Package body created.
  25.  
  26. No errors.
  27.  
  28.  
  29.  
  30.  
  31.  
  32. Package created.
  33.  
  34. No errors.
  35.  
  36. Package body created.
  37.  
  38. No errors.
  39. Executing Oracle POST-Upgrade Fixup Script
  40.  
  41. Auto-Generated by:       Oracle Preupgrade Script
  42.                          Version: 12.2.0.1.0 Build: 1
  43. Generated on:            2020-01-17 13:53:06
  44.  
  45. For Source Database:     TEST
  46. Source Database Version: 11.2.0.4.0
  47. For Upgrade to Version:  12.2.0.1.0
  48.  
  49.                           Fixup
  50. Check Name                Status  Further DBA Action
  51. ----------                ------  ------------------
  52. depend_usr_tables         Failed  Manual fixup recommended.
  53. old_time_zones_exist      Failed  Manual fixup recommended.
  54. post_dictionary           Passed  None
  55. fixed_objects             Passed  None
  56. upg_by_std_upgrd          Passed  None
  57.  
  58. PL/SQL procedure successfully completed.
  59.  
  60.  
  61. Session altered.
  62.  
  63. SQL>

-- 升级time-zone。这次执行三个脚-本，没有出错。

  1. [oracle@wls10306-01 bin]$ sqlplus /nolog
  2.  
  3. SQL*Plus: Release 12.2.0.1.0 Production on Fri Jan 17 16:17:51 2020
  5. Copyright (c) 1982, 2016, Oracle.  All rights reserved.
  6.  
  7. SQL> conn / as sysdba
  8. Connected.
  9. SQL> @/home/oracle/DBMS_DST_scriptsV1.9/countstatsTSTZ.sql
  10. .
  11. Amount of TSTZ data using num_rows stats info in DBA_TABLES.
  12. .
  13. For SYS tables first...
  14. Note: empty tables are not listed.
  15. Stat date  - Owner.Tablename.Columnname - num_rows
  16. 17/01/2020 - SYS.AQ$_ALERT_QT_S.CREATION_TIME - 5
  17. 17/01/2020 - SYS.AQ$_ALERT_QT_S.DELETION_TIME - 5
  18. 17/01/2020 - SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 5
  19. 24/08/2013 - SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
  20. 24/08/2013 - SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
  21. 24/08/2013 - SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
  22. 24/08/2013 - SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
  23. 24/08/2013 - SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
  24. 24/08/2013 - SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
  25. 17/01/2020 - SYS.AQ$_KUPC$DATAPUMP_QUETAB_S.CREATION_TIME - 1
  26. 17/01/2020 - SYS.AQ$_KUPC$DATAPUMP_QUETAB_S.DELETION_TIME - 1
  27. 17/01/2020 - SYS.AQ$_KUPC$DATAPUMP_QUETAB_S.MODIFICATION_TIME - 1
  28. 17/01/2020 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 1
  29. 17/01/2020 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 1
  30. 17/01/2020 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 1
  31. 17/01/2020 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 3
  32. 17/01/2020 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 3
  33. 17/01/2020 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 3
  34. 24/08/2013 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 1
  35. 24/08/2013 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 1
  36. 24/08/2013 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 1
  37. 24/08/2013 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 1
  38. 24/08/2013 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 1
  39. 24/08/2013 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 1
  40. 17/01/2020 - SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 1
  41. 17/01/2020 - SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 1
  42. 17/01/2020 - SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 1
  43. 17/01/2020 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - 4
  44. 17/01/2020 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - 4
  45. 17/01/2020 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - 4
  46. 17/01/2020 - SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 1
  47. 17/01/2020 - SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 1
  48. 17/01/2020 - SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 1
  49. 17/01/2020 - SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 1
  50. 17/01/2020 - SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 1
  51. 17/01/2020 - SYS.KET$_CLIENT_CONFIG.FIELD_2 - 7
  52. 17/01/2020 - SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 7
  53. 17/01/2020 - SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 39
  54. 17/01/2020 - SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 39
  55. 17/01/2020 - SYS.OPTSTAT_SNAPSHOT$.TIMESTAMP - 360
  56. 17/01/2020 - SYS.OPTSTAT_USER_PREFS$.CHGTIME - 35
  57. 17/01/2020 - SYS.RADM_FPTM$.TSWTZ_COL - 1
  58. 17/01/2020 - SYS.REG$.NTFN_GROUPING_START_TIME - 2
  59. 17/01/2020 - SYS.REG$.REG_TIME - 2
  60. 17/01/2020 - SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 32
  61. 17/01/2020 - SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 11
  62. 17/01/2020 - SYS.SCHEDULER$_JOB.END_DATE - 26
  63. 17/01/2020 - SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 26
  64. 17/01/2020 - SYS.SCHEDULER$_JOB.LAST_END_DATE - 26
  65. 17/01/2020 - SYS.SCHEDULER$_JOB.LAST_START_DATE - 26
  66. 17/01/2020 - SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 26
  67. 17/01/2020 - SYS.SCHEDULER$_JOB.START_DATE - 26
  68. 17/01/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - 18
  69. 17/01/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - 18
  70. 17/01/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - 18
  71. 17/01/2020 - SYS.SCHEDULER$_SCHEDULE.END_DATE - 4
  72. 17/01/2020 - SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 4
  73. 17/01/2020 - SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 9
  74. 17/01/2020 - SYS.SCHEDULER$_WINDOW.END_DATE - 9
  75. 17/01/2020 - SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 9
  76. 17/01/2020 - SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 9
  77. 17/01/2020 - SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 9
  78. 17/01/2020 - SYS.SCHEDULER$_WINDOW.START_DATE - 9
  79. 17/01/2020 - SYS.TAB_STATS$.SPARE6 - 1122
  80. 17/01/2020 - SYS.WRI$_ALERT_HISTORY.CREATION_TIME - 53
  81. 17/01/2020 - SYS.WRI$_ALERT_HISTORY.TIME_SUGGESTED - 53
  82. 17/01/2020 - SYS.WRI$_ALERT_OUTSTANDING.CREATION_TIME - 1
  83. 17/01/2020 - SYS.WRI$_ALERT_OUTSTANDING.TIME_SUGGESTED - 1
  84. 17/01/2020 - SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SAVTIME - 33185
  85. 17/01/2020 - SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SPARE6 - 33185
  86. 17/01/2020 - SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SAVTIME - 58022
  87. 17/01/2020 - SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SPARE6 - 58022
  88. 17/01/2020 - SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - 4124
  89. 17/01/2020 - SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - 4124
  90. 17/01/2020 - SYS.WRI$_OPTSTAT_OPR.END_TIME - 200
  91. 17/01/2020 - SYS.WRI$_OPTSTAT_OPR.SPARE6 - 200
  92. 17/01/2020 - SYS.WRI$_OPTSTAT_OPR.START_TIME - 200
  93. 17/01/2020 - SYS.WRI$_OPTSTAT_OPR_TASKS.END_TIME - 6409
  94. 17/01/2020 - SYS.WRI$_OPTSTAT_OPR_TASKS.SPARE6 - 6409
  95. 17/01/2020 - SYS.WRI$_OPTSTAT_OPR_TASKS.START_TIME - 6409
  96. 17/01/2020 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - 3836
  97. 17/01/2020 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - 3836
  98. 17/01/2020 - SYS.XS$PRIN.END_DATE - 15
  99. 17/01/2020 - SYS.XS$PRIN.START_DATE - 15
  100. Total numrow of SYS TSTZ columns is : 220296
  101. There are in total 154 non-SYS TSTZ columns.
  102. .
  103. For non-SYS tables ...
  104. Note: empty tables are not listed.
  105. Stat date  - Owner.Tablename.Columnname - num_rows
  106. 17/01/2020 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 1
  107. 17/01/2020 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 1
  108. 17/01/2020 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME -
  109. 1
  110. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_L.DEQUEUE_TIME - 2
  111. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_S.CREATION_TIME - 4
  112. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_S.DELETION_TIME - 4
  113. 24/08/2013 - IX.AQ$_ORDERS_QUEUETABLE_S.MODIFICATION_TIME - 4
  114. 24/08/2013 - IX.AQ$_STREAMS_QUEUE_TABLE_S.CREATION_TIME - 1
  115. 24/08/2013 - IX.AQ$_STREAMS_QUEUE_TABLE_S.DELETION_TIME - 1
  116. 24/08/2013 - IX.AQ$_STREAMS_QUEUE_TABLE_S.MODIFICATION_TIME - 1
  117. 17/01/2020 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 1
  118. 17/01/2020 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 1
  119. 17/01/2020 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 1
  120. 17/01/2020 - WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 1
  121. 17/01/2020 - WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1
  122. Total numrow of non-SYS TSTZ columns is : 25
  123. There are in total 32 non-SYS TSTZ columns.
  124. Total Minutes elapsed : 0
  125. SQL> @/home/oracle/DBMS_DST_scriptsV1.9/upg_tzv_check.sql
  126. INFO: Starting with RDBMS DST update preparation.
  127. INFO: NO actual RDBMS DST update will be done by this script.
  128. INFO: If an ERROR occurs the script will EXIT sqlplus.
  129. INFO: Doing checks for known issues ...
  130. INFO: Database version is 12.2.0.1 .
  131. INFO: Database RDBMS DST version is DSTv14 .
  132. INFO: No known issues detected.
  133. INFO: Now detecting new RDBMS DST version.
  134. A prepare window has been successfully started.
  135. INFO: Newest RDBMS DST version detected is DSTv26 .
  136. INFO: Next step is checking all TSTZ data.
  137. INFO: It might take a while before any further output is seen ...
  138. A prepare window has been successfully ended.
  139. INFO: A newer RDBMS DST version than the one currently used is found.
  140. INFO: Note that NO DST update was yet done.
  141. INFO: Now run upg_tzv_apply.sql to do the actual RDBMS DST update.
  142. INFO: Note that the upg_tzv_apply.sql script will
  143. INFO: restart the database 2 times WITHOUT any confirmation or prompt.
  144. SQL> @/home/oracle/DBMS_DST_scriptsV1.9/upg_tzv_apply.sql
  145. INFO: If an ERROR occurs the script will EXIT sqlplus.
  146. INFO: The database RDBMS DST version will be updated to DSTv26 .
  147. WARNING: This script will restart the database 2 times
  148. WARNING: WITHOUT asking ANY confirmation.
  149. WARNING: Hit control-c NOW if this is not intended.
  150. INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
  151. Database closed.
  152. Database dismounted.
  153. ORACLE instance shut down.
  154. ORACLE instance started.
  155.  
  156. Total System Global Area  830472192 bytes
  157. Fixed Size		    8626144 bytes
  158. Variable Size		  511705120 bytes
  159. Database Buffers	  306184192 bytes
  160. Redo Buffers		    3956736 bytes
  161. Database mounted.
  162. Database opened.
  163. INFO: Starting the RDBMS DST upgrade.
  164. INFO: Upgrading all SYS owned TSTZ data.
  165. INFO: It might take time before any further output is seen ...
  166. An upgrade window has been successfully started.
  167. INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
  168. Database closed.
  169. Database dismounted.
  170. ORACLE instance shut down.
  171. ORACLE instance started.
  172.  
  173. Total System Global Area  830472192 bytes
  174. Fixed Size		    8626144 bytes
  175. Variable Size		  511705120 bytes
  176. Database Buffers	  306184192 bytes
  177. Redo Buffers		    3956736 bytes
  178. Database mounted.
  179. Database opened.
  180. INFO: Upgrading all non-SYS TSTZ data.
  181. INFO: It might take time before any further output is seen ...
  182. INFO: Do NOT start any application yet that uses TSTZ data!
  183. INFO: Next is a list of all upgraded tables:
  184. Table list: "IX"."AQ$_ORDERS_QUEUETABLE_L"
  185. Number of failures: 0
  186. Table list: "IX"."AQ$_ORDERS_QUEUETABLE_S"
  187. Number of failures: 0
  188. Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_L"
  189. Number of failures: 0
  190. Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_S"
  191. Number of failures: 0
  192. Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
  193. Number of failures: 0
  194. Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
  195. Number of failures: 0
  196. Table list: "APEX_050000"."WWV_FLOW_DEBUG_MESSAGES"
  197. Number of failures: 0
  198. Table list: "APEX_050000"."WWV_FLOW_DEBUG_MESSAGES2"
  199. Number of failures: 0
  200. Table list: "APEX_050000"."WWV_FLOW_FEEDBACK"
  201. Number of failures: 0
  202. Table list: "APEX_050000"."WWV_FLOW_FEEDBACK_FOLLOWUP"
  203. Number of failures: 0
  204. Table list: "APEX_050000"."WWV_FLOW_WORKSHEET_NOTIFY"
  205. Number of failures: 0
  206. INFO: Total failures during update of TSTZ data: 0 .
  207. An upgrade window has been successfully ended.
  208. INFO: Your new Server RDBMS DST version is DSTv26 .
  209. INFO: The RDBMS DST update is successfully finished.
  210. INFO: Make sure to exit this sqlplus session.
  211. INFO: Do not use it for timezone related selects.
  212. SQL>

-- 查看time-zone ，正常了 。

  1. SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  2. FROM DATABASE_PROPERTIES
  3. WHERE PROPERTY_NAME LIKE 'DST_%'
  4. ORDER BY PROPERTY_NAME;  2    3    4  
  5.  
  6. PROPERTY_NAME
  7. --------------------------------------------------------------------------------
  8. VALUE
  9. --------------------------------------------------------------------------------
  10. DST_PRIMARY_TT_VERSION
  11. 26
  12.  
  13. DST_SECONDARY_TT_VERSION
  14. 0
  15.  
  16. DST_UPGRADE_STATE
  17. NONE
  18.  
  19.  
  20. 3 rows selected.
  21.  
  22. SQL>

END

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/繁依Fanyi0/article/detail/570051
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号