=====Upgrade Tasks=====
====Database Operations====
[oracle@lparaca admin]$ sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 23 12:48:03 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> PURGE DBA_RECYCLEBIN
2 ;
DBA Recyclebin purged.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@lparaca admin]$ srvctl stop database -d orcl
[oracle@lparaca admin]$
[oracle@lparaca admin]$ sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 23 12:48:03 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1174405120 bytes
Fixed Size 2923680 bytes
Variable Size 503317344 bytes
Database Buffers 654311424 bytes
Redo Buffers 13852672 bytes
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
SQL> alter system set cluster_database=FALSE scope=spfile;
System altered.
SQL> create pfile='/u01/app/oracle/product/12.2.0.1/dbs/initorcl_1.ora' from spfile;
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@lparaca dbs]$
[oracle@lparaca dbs]$ export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/
[oracle@lparaca dbs]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@lparaca dbs]$ which sqlplus
/u01/app/oracle/product/12.2.0.1/bin/sqlplus
[oracle@lparaca product]$ cd /u01/app/oracle/product/12.2.0.1/
[oracle@lparaca 12.2.0.1]$ cd dbs
[oracle@lparaca dbs]$ ls -lart
total 16
-rw-r--r-- 1 oracle oinstall 3079 May 15 2015 init.ora
drwxr-xr-x 73 oracle oinstall 4096 Jan 23 10:10 ..
drwxr-xr-x 2 oracle oinstall 4096 Jan 23 12:56 .
-rw-r----- 1 oracle oinstall 1272 Jan 23 12:58 initorcl_1.ora
[oracle@lparaca dbs]$ cat initorcl_1.ora
orcl_2.__data_transfer_cache_size=0
orcl_1.__data_transfer_cache_size=0
orcl_1.__db_cache_size=687865856
orcl_2.__db_cache_size=620756992
orcl_2.__java_pool_size=16777216
orcl_1.__java_pool_size=16777216
orcl_2.__large_pool_size=33554432
orcl_1.__large_pool_size=33554432
orcl_1.__oracle_base='/u01/app/oracle/product'#ORACLE_BASE set from environment
orcl_2.__oracle_base='/u01/app/oracle/product'#ORACLE_BASE set from environment
orcl_2.__pga_aggregate_target=402653184
orcl_1.__pga_aggregate_target=402653184
orcl_2.__sga_target=1174405120
orcl_1.__sga_target=1174405120
orcl_2.__shared_io_pool_size=50331648
orcl_1.__shared_io_pool_size=50331648
orcl_1.__shared_pool_size=369098752
orcl_2.__shared_pool_size=436207616
orcl_2.__streams_pool_size=0
orcl_1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/product/admin/orcl/adump'
*.audit_trail='db'
*.cluster_database=FALSE
*.compatible='12.1.0.2.0'
*.control_files='+DATA/ORCL/CONTROLFILE/current.281.965796789'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='orcl'
*.diagnostic_dest='/u01/app/oracle/product'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.open_cursors=300
*.pga_aggregate_target=370m
*.processes=300
*.remote_login_passwordfile='exclusive'
*.sga_target=1110m
[oracle@lparaca dbs]$ sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 23 13:00:37 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 1174405120 bytes
Fixed Size 8619984 bytes
Variable Size 436209712 bytes
Database Buffers 721420288 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@lparaca dbs]$ cd ..
[oracle@lparaca 12.2.0.1]$ cd bin
[oracle@lparaca bin]$ ./dbupgrade
Argument list for [/u01/app/oracle/product/12.2.0.1//rdbms/admin/catctl.pl]
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [12.2.0.1.0]
STATUS: [production]
BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]
/u01/app/oracle/product/12.2.0.1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0.1/]
/u01/app/oracle/product/12.2.0.1//bin/orabasehome = [/u01/app/oracle/product/12.2.0.1/]
catctlGetOrabase = [/u01/app/oracle/product/12.2.0.1/]
Analyzing file /u01/app/oracle/product/12.2.0.1//rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20180123130145]
catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20180123130145/catupgrd_catcon_9544.lst]
catcon: See [/tmp/cfgtoollogs/upgrade20180123130145/catupgrd*.log] files for output generated by scripts
catcon: See [/tmp/cfgtoollogs/upgrade20180123130145/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 2
Database Name = orcl
DataBase Version = 12.1.0.2.0
catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0.1/cfgtoollogs/orcl/upgrade20180123130147/catupgrd_catcon_9544.lst]
catcon: See [/u01/app/oracle/product/12.2.0.1/cfgtoollogs/orcl/upgrade20180123130147/catupgrd*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/product/12.2.0.1/cfgtoollogs/orcl/upgrade20180123130147/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/12.2.0.1/cfgtoollogs/orcl/upgrade20180123130147]
Parallel SQL Process Count = 4
Components in [orcl]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM RAC SDO XDB XML XOQ]
Not Installed [EM MGW ODM WK]
------------------------------------------------------
Phases [0-115] Start Time:[2018_01_23 13:01:48]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [orcl] Files:1 Time: 101s
*************** Catalog Core SQL ***************
Serial Phase #:1 [orcl] Files:5 Time: 61s
Restart Phase #:2 [orcl] Files:1 Time: 1s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [orcl] Files:19 Time: 22s
Restart Phase #:4 [orcl] Files:1 Time: 0s
************* Catalog Final Scripts ************
Serial Phase #:5 [orcl] Files:6 Time: 22s
***************** Catproc Start ****************
---------------------------------------------------------
***************** Post Upgrade *****************
Serial Phase #:112 [orcl] Files:1 Time: 56s
**************** Summary report ****************
Serial Phase #:113 [orcl] Files:1 Time: 2s
Serial Phase #:114 [orcl] Files:1 Time: 0s
Serial Phase #:115 [orcl] Files:1 Time: 36s
------------------------------------------------------
Phases [0-115] End Time:[2018_01_23 14:03:57]
------------------------------------------------------
Grand Total Time: 3733s
LOG FILES: (/u01/app/oracle/product/12.2.0.1/cfgtoollogs/orcl/upgrade20180123130147/catupgrd*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/12.2.0.1/cfgtoollogs/orcl/upgrade20180123130147/upg_summary.log
Grand Total Upgrade Time: [0d:1h:2m:13s]
====Summary of the Upgrade====
------------------------------------------------------
Start of Summary Report
------------------------------------------------------
Oracle Database 12.2 Post-Upgrade Status Tool 01-23-2018 14:03:20
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
Oracle Server UPGRADED 12.2.0.1.0 00:14:55
JServer JAVA Virtual Machine UPGRADED 12.2.0.1.0 00:09:19
Oracle Real Application Clusters UPGRADED 12.2.0.1.0 00:00:01
Oracle Workspace Manager UPGRADED 12.2.0.1.0 00:00:50
OLAP Analytic Workspace UPGRADED 12.2.0.1.0 00:00:26
Oracle OLAP API UPGRADED 12.2.0.1.0 00:00:21
Oracle Label Security UPGRADED 12.2.0.1.0 00:00:12
Oracle XDK UPGRADED 12.2.0.1.0 00:01:22
Oracle Text UPGRADED 12.2.0.1.0 00:01:09
Oracle XML Database UPGRADED 12.2.0.1.0 00:02:19
Oracle Database Java Packages UPGRADED 12.2.0.1.0 00:00:23
Oracle Multimedia UPGRADED 12.2.0.1.0 00:03:23
Spatial UPGRADED 12.2.0.1.0 00:06:53
Oracle Application Express UPGRADED 5.0.4.00.12 00:13:35
Oracle Database Vault UPGRADED 12.2.0.1.0 00:00:29
Final Actions 00:02:51
Post Upgrade 00:00:55