Table of Contents

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