[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]
------------------------------------------------------ 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