Oracle Database Commands and Practical Examples

Friday 17 July 2020

Upgrade - PART2 | DBUA Upgrade 12.1.0.2.0 to 12.2.0.1.0

Oracle 2 node RAC database Upgrade 12.1 to 12.2

################## Install Database Software Only ##################################

Create directory on both nodes /u01/app/oracle/product/12.2.0/db_1

chown -R oracle:oinstall /u01/app/oracle/product/12.2.0/db_1
chmod -R 775 /u01/app/oracle/product/12.2.0/db_1

Set Oracle home and execute ./runInstaller

export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1

./runInstaller

Run the configuration scripts as root on srv1 then on srv2.

######################## DBUA ###############################

Pre -requestories

Run the Pre-Upgrade Information Tool (preupgrade.jar) by by executing command on putty or command prompt on local node.
/u01/app/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/app/oracle/product/12.2.0/db_1/rdbms/admin/preupgrade.jar FILE TEXT DIR /home/oracle/scripts

Preupgrade generated files:

/home/oracle/scripts/preupgrade.log

/home/oracle/scripts/preupgrade_fixups.sql

/home/oracle/scripts/postupgrade_fixups.sql

Examine and follow the instruction in preupgrade.log file.
We will take full Rman backup during dbua GUI execution.

[oracle@srv1 admin]$ cat /home/oracle/scripts/preupgrade.log

Report generated by Oracle Database Pre-Upgrade Information Tool Version

12.2.0.1.0

Upgrade-To version: 12.2.0.1.0

=======================================

Status of the database prior to upgrade

=======================================

Database Name: RAC

Container Name: RAC

Container ID: 0

Version: 12.1.0.2.0

Compatible: 12.1.0.2.0

Blocksize: 8192

Platform: Linux x86 64-bit

Timezone File: 18

Database log mode: ARCHIVELOG

Readonly: FALSE

Edition: EE

Oracle Component Upgrade Action Current Status

---------------- -------------- --------------

Oracle Server [to be upgraded] VALID

JServer JAVA Virtual Machine [to be upgraded] VALID

Oracle XDK for Java [to be upgraded] VALID

Real Application Clusters [to be upgraded] VALID

Oracle Workspace Manager [to be upgraded] VALID

OLAP Analytic Workspace [to be upgraded] VALID

Oracle Label Security [to be upgraded] VALID

Oracle Database Vault [to be upgraded] VALID

Oracle Text [to be upgraded] VALID

Oracle XML Database [to be upgraded] VALID

Oracle Java Packages [to be upgraded] VALID

Oracle Multimedia [to be upgraded] VALID

Oracle Spatial [to be upgraded] VALID

Oracle Application Express [to be upgraded] VALID

Oracle OLAP API [to be upgraded] VALID

==============

BEFORE UPGRADE

==============

Run <preupgradeLogDirPath>/preupgrade_fixups.sql to complete all

of the BEFORE UPGRADE action items below marked with '(AUTOFIXUP)'.

REQUIRED ACTIONS

================

+ Adjust TABLESPACE SIZES as needed.

Auto 12.2.0.1.0

Tablespace Size Extend Min Size Action

---------- ---------- -------- ---------- ------

SYSAUX 810 MB ENABLED 1705 MB None

SYSTEM 790 MB ENABLED 1293 MB None

TEMP 203 MB DISABLED 150 MB None

UNDOTBS1 145 MB ENABLED 400 MB None

Note that 12.2.0.1.0 minimum sizes are estimates.

If you plan to upgrade multiple pluggable databases concurrently,

then you must ensure that the UNDO tablespace size is equal to at least

the number of pluggable databases that you upgrade concurrently,

multiplied by that minimum. Failing to allocate sufficient space can

cause the upgrade to fail.

+ Set DB_RECOVERY_FILE_DEST_SIZE initialization parameter to at least 6083

MB. Check alert log during the upgrade to ensure there is remaining

free space available in the recovery area.

DB_RECOVERY_FILE_DEST_SIZE is set at 4785 MB. There is currently 4100

MB of free space remaining, which may not be adequate for the upgrade.

Currently:

Fast recovery area : +FRA

Limit : 4785 MB

Used : 685 MB

Available : 4100 MB

The database has archivelog mode enabled, and the upgrade process will

need free space to generate archived logs to the recovery area specified

by initialization parameter DB_RECOVERY_FILE_DEST. The logs generated

must not overflow the limit set by DB_RECOVERY_FILE_DEST_SIZE, as the

upgrade may not proceed if the database stops responding.

RECOMMENDED ACTIONS

===================

+ (AUTOFIXUP) Gather stale data dictionary statistics prior to database

upgrade in off-peak time using:

EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;

Dictionary statistics do not exist or are stale (not up-to-date).

Dictionary statistics help the Oracle optimizer find efficient SQL

execution plans and are essential for proper upgrade timing. Oracle

recommends gathering dictionary statistics in the last 24 hours before

database upgrade.

For information on managing optimizer statistics, refer to the 12.1.0.2

Oracle Database SQL Tuning Guide.

INFORMATION ONLY

================

+ Consider upgrading APEX manually, before the database upgrade.

The database contains APEX version 4.2.5.00.08 and will need to be

upgraded to at least version 5.0.4.00.12.

To reduce database upgrade time, you can upgrade APEX manually before

the database upgrade. Refer to My Oracle Support Note 1088970.1 for

information on APEX installation upgrades.

=============

AFTER UPGRADE

=============

Run <preupgradeLogDirPath>/postupgrade_fixups.sql to complete all

of the AFTER UPGRADE action items below marked with '(AUTOFIXUP)'.

REQUIRED ACTIONS

================

None

RECOMMENDED ACTIONS

===================

+ Upgrade the database time zone version using the DBMS_DST package.

The database is using timezone datafile version 18 and the target

12.2.0.1.0 database ships with timezone datafile version 26.

Oracle recommends using the most recent timezone data. For further

information, refer to My Oracle Support Note 1585343.1.

+ (AUTOFIXUP) Gather dictionary statistics after the upgrade using the

command:

EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;

Oracle recommends gathering dictionary statistics after upgrade.

Dictionary statistics provide essential information to the Oracle

optimizer to help it find efficient SQL execution plans. After a

database upgrade, statistics need to be re-gathered as there can now be

tables that have significantly changed during the upgrade or new tables

that do not have statistics gathered yet.

[oracle@srv1 admin]$

[oracle@srv1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 15 13:36:37 2020

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> @/home/oracle/scripts/preupgrade_fixups.sql

Executing Oracle PRE-Upgrade Fixup Script

Auto-Generated by: Oracle Preupgrade Script

Version: 12.2.0.1.0 Build: 1

Generated on: 2020-07-15 13:22:01

For Source Database: RAC

Source Database Version: 12.1.0.2.0

For Upgrade to Version: 12.2.0.1.0

Fixup

Check Name Status Further DBA Action

---------- ------ ------------------

min_recovery_area_size Passed None

dictionary_stats Passed None

apex_upgrade_msg Failed Manual fixup recommended.

PL/SQL procedure successfully completed.

SQL> EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;

PL/SQL procedure successfully completed.

SQL> SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS='INVALID';

no rows selected

SQL> SELECT OWNER, OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE LIKE '%MATERIA%';

no rows selected

SQL> PURGE DBA_RECYCLEBIN;

DBA Recyclebin purged.

SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON (Value should beset to TRUE )

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon boolean TRUE

SQL> exit

Upgrading Oracle RAC Database

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH
cd $ORACLE_HOME/bin

./dbua

CDB RAC DBUA Screenshot (This is different upgrade only for reference)

Post-upgrade Tasks

Change oracle home and grid home on .bash_profile on both the node using oracle and grid user .bash_profile .
Copy tnsnames.ora file from old location to new db location.(cp /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/*.ora /u01/app/oracle/product/12.2.0/db_1/network/admin)
Delete archivelog from rman generated during upgradation
Execute postupgrade_fixups.sql script

[oracle@srv1 ~]$ . oraenv

ORACLE_SID = [rac1] ?

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@srv1 ~]$ export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1

[oracle@srv1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH

[oracle@srv1 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jul 15 20:29:30 2020

connected to target database: RAC (DBID=2631155449)

RMAN> delete archivelog all;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=68 instance=rac1 device type=DISK

List of Archived Log Copies for database with db_unique_name RAC

=====================================================================

Key Thrd Seq S Low Time

------- ---- ------- - ---------

63 1 38 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_38.323.1045322661

65 1 39 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_39.325.1045328511

68 1 40 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_40.328.1045329577

69 1 41 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_41.329.1045329581

71 1 42 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_42.331.1045334199

73 1 43 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_43.333.1045334211

74 1 44 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_44.335.1045764749

76 1 45 A 14-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_45.336.1045764775

78 1 46 A 14-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_46.338.1045769549

79 1 47 A 14-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_47.339.1045769549

80 1 48 A 14-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_48.340.1045829415

83 1 49 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_49.343.1045834081

84 1 50 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_50.344.1045835241

86 1 51 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_51.346.1045836399

87 1 52 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_52.347.1045836483

88 1 53 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_53.348.1045836591

89 1 54 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_54.349.1045836697

90 1 55 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_55.350.1045836779

91 1 56 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_56.351.1045836903

92 1 57 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_57.352.1045836991

93 1 58 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_58.353.1045837059

94 1 59 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_59.354.1045837113

95 1 60 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_60.355.1045837215

96 1 61 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_61.356.1045837291

97 1 62 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_62.357.1045837365

98 1 63 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_63.358.1045837413

99 1 64 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_64.359.1045837463

100 1 65 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_65.360.1045837499

101 1 66 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_66.361.1045837553

102 1 67 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_67.362.1045837611

103 1 68 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_68.363.1045837691

104 1 69 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_69.364.1045837765

105 1 70 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_70.365.1045838075

106 1 71 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_71.366.1045838485

107 1 72 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_72.367.1045838809

108 1 73 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_73.368.1045838889

109 1 74 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_74.369.1045839025

110 1 75 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_75.370.1045839181

111 1 76 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_76.261.1045839231

112 1 77 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_77.262.1045839535

113 1 78 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_78.263.1045842871

114 1 79 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_79.264.1045843019

115 1 80 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_80.265.1045843361

116 1 81 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_81.266.1045843599

117 1 82 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_82.267.1045843757

118 1 83 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_83.268.1045843893

119 1 84 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_84.269.1045844039

120 1 85 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_85.270.1045844087

121 1 86 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_86.271.1045844111

122 1 87 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_87.272.1045844137

123 1 88 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_88.273.1045844161

124 1 89 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_89.274.1045844189

125 1 90 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_90.275.1045844219

126 1 91 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_91.276.1045844249

127 1 92 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_92.277.1045844275

128 1 93 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_93.278.1045844379

129 1 94 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_94.279.1045844575

130 1 95 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_95.280.1045844727

131 1 96 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_96.281.1045844883

132 1 97 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_97.282.1045845035

133 1 98 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_98.283.1045845139

134 1 99 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_99.284.1045845187

135 1 100 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_100.285.1045845335

136 1 101 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_101.286.1045845411

137 1 102 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_102.287.1045845537

138 1 103 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_103.288.1045845659

139 1 104 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_104.289.1045845925

140 1 105 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_105.290.1045846117

141 1 106 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_106.291.1045846325

142 1 107 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_107.292.1045847171

143 1 108 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_108.293.1045847333

144 1 109 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_109.294.1045847383

145 1 110 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_110.295.1045847493

146 1 111 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_111.296.1045847599

147 1 112 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_112.297.1045847707

148 1 113 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_113.298.1045847795

149 1 114 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_114.299.1045847895

150 1 115 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_115.300.1045848003

151 1 116 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_116.301.1045848049

152 1 117 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_117.302.1045848119

153 1 118 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_118.303.1045848159

154 1 119 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_119.304.1045848205

155 1 120 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_120.305.1045848271

156 1 121 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_121.306.1045848337

157 1 122 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_122.307.1045848439

158 1 123 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_123.308.1045848603

159 1 124 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_124.309.1045848649

160 1 125 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_125.310.1045848747

161 1 126 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_126.311.1045848793

162 1 127 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_127.312.1045848861

163 1 128 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_128.313.1045848901

164 1 129 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_129.314.1045848957

165 1 130 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_130.315.1045849015

166 1 131 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_131.316.1045849221

167 1 132 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_132.317.1045849399

168 1 133 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_133.318.1045849507

169 1 134 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_134.319.1045849571

170 1 135 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_135.320.1045849659

171 1 136 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_136.371.1045849717

172 1 137 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_137.372.1045849923

173 1 138 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_138.373.1045850181

174 1 139 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_139.374.1045850309

175 1 140 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_140.375.1045850443

176 1 141 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_141.376.1045850473

177 1 142 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_142.377.1045850493

178 1 143 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_143.378.1045850575

179 1 144 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_144.379.1045850675

180 1 145 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_145.380.1045850709

181 1 146 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_146.381.1045850891

182 1 147 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_147.382.1045850929

183 1 148 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_148.383.1045850961

184 1 149 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_149.384.1045850991

185 1 150 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_150.385.1045851265

186 1 151 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_151.386.1045851515

187 1 152 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_152.387.1045851901

188 1 153 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_153.388.1045852173

189 1 154 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_154.389.1045852475

190 1 155 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_155.390.1045852775

191 1 156 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_156.391.1045853067

192 1 157 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_157.392.1045853473

193 1 158 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_158.393.1045853507

194 1 159 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_159.394.1045853531

195 1 160 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_160.395.1045854085

196 1 161 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_161.396.1045854153

197 1 162 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_162.397.1045854187

198 1 163 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_163.398.1045854275

199 1 164 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_164.399.1045854291

200 1 165 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_165.400.1045854373

201 1 166 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_166.401.1045854709

202 1 167 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_167.402.1045854967

203 1 168 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_168.403.1045855659

204 1 169 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_169.404.1045855781

205 1 170 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_170.405.1045855905

206 1 171 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_171.406.1045856163

207 1 172 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_172.407.1045856297

208 1 173 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_173.408.1045856383

209 1 174 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_174.409.1045856475

210 1 175 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_175.410.1045856641

211 1 176 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_176.411.1045856863

212 1 177 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_177.412.1045857027

213 1 178 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_178.413.1045857253

214 1 179 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_179.414.1045857517

215 1 180 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_180.415.1045857755

61 2 32 A 06-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_32.321.1045309215

62 2 33 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_33.322.1045310807

64 2 34 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_34.324.1045322671

66 2 35 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_35.326.1045328531

67 2 36 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_36.327.1045328539

70 2 37 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_37.330.1045330819

72 2 38 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_38.332.1045334201

75 2 39 A 09-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_39.334.1045764743

77 2 40 A 14-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_40.337.1045769547

81 2 41 A 14-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_41.341.1045829427

82 2 42 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_42.342.1045829431

85 2 43 A 15-JUL-20

Name: +FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_43.345.1045835981

Do you really want to delete the above objects (enter YES or NO)? yes

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_38.323.1045322661 RECID=63 STAMP=1045322665

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_39.325.1045328511 RECID=65 STAMP=1045328524

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_40.328.1045329577 RECID=68 STAMP=1045329579

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_41.329.1045329581 RECID=69 STAMP=1045329581

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_42.331.1045334199 RECID=71 STAMP=1045334204

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_1_seq_43.333.1045334211 RECID=73 STAMP=1045334212

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_44.335.1045764749 RECID=74 STAMP=1045764758

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_45.336.1045764775 RECID=76 STAMP=1045764778

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_46.338.1045769549 RECID=78 STAMP=1045769548

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_1_seq_47.339.1045769549 RECID=79 STAMP=1045769549

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_48.340.1045829415 RECID=80 STAMP=1045829422

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_49.343.1045834081 RECID=83 STAMP=1045834083

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_50.344.1045835241 RECID=84 STAMP=1045835242

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_51.346.1045836399 RECID=86 STAMP=1045836402

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_52.347.1045836483 RECID=87 STAMP=1045836485

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_53.348.1045836591 RECID=88 STAMP=1045836595

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_54.349.1045836697 RECID=89 STAMP=1045836700

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_55.350.1045836779 RECID=90 STAMP=1045836781

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_56.351.1045836903 RECID=91 STAMP=1045836905

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_57.352.1045836991 RECID=92 STAMP=1045836993

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_58.353.1045837059 RECID=93 STAMP=1045837061

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_59.354.1045837113 RECID=94 STAMP=1045837115

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_60.355.1045837215 RECID=95 STAMP=1045837218

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_61.356.1045837291 RECID=96 STAMP=1045837294

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_62.357.1045837365 RECID=97 STAMP=1045837369

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_63.358.1045837413 RECID=98 STAMP=1045837417

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_64.359.1045837463 RECID=99 STAMP=1045837469

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_65.360.1045837499 RECID=100 STAMP=1045837503

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_66.361.1045837553 RECID=101 STAMP=1045837559

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_67.362.1045837611 RECID=102 STAMP=1045837615

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_68.363.1045837691 RECID=103 STAMP=1045837694

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_69.364.1045837765 RECID=104 STAMP=1045837767

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_70.365.1045838075 RECID=105 STAMP=1045838078

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_71.366.1045838485 RECID=106 STAMP=1045838488

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_72.367.1045838809 RECID=107 STAMP=1045838813

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_73.368.1045838889 RECID=108 STAMP=1045838890

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_74.369.1045839025 RECID=109 STAMP=1045839026

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_75.370.1045839181 RECID=110 STAMP=1045839185

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_76.261.1045839231 RECID=111 STAMP=1045839237

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_77.262.1045839535 RECID=112 STAMP=1045839537

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_78.263.1045842871 RECID=113 STAMP=1045842873

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_79.264.1045843019 RECID=114 STAMP=1045843021

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_80.265.1045843361 RECID=115 STAMP=1045843369

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_81.266.1045843599 RECID=116 STAMP=1045843602

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_82.267.1045843757 RECID=117 STAMP=1045843759

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_83.268.1045843893 RECID=118 STAMP=1045843895

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_84.269.1045844039 RECID=119 STAMP=1045844041

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_85.270.1045844087 RECID=120 STAMP=1045844101

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_86.271.1045844111 RECID=121 STAMP=1045844120

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_87.272.1045844137 RECID=122 STAMP=1045844144

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_88.273.1045844161 RECID=123 STAMP=1045844175

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_89.274.1045844189 RECID=124 STAMP=1045844193

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_90.275.1045844219 RECID=125 STAMP=1045844232

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_91.276.1045844249 RECID=126 STAMP=1045844255

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_92.277.1045844275 RECID=127 STAMP=1045844281

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_93.278.1045844379 RECID=128 STAMP=1045844382

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_94.279.1045844575 RECID=129 STAMP=1045844576

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_95.280.1045844727 RECID=130 STAMP=1045844730

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_96.281.1045844883 RECID=131 STAMP=1045844885

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_97.282.1045845035 RECID=132 STAMP=1045845038

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_98.283.1045845139 RECID=133 STAMP=1045845142

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_99.284.1045845187 RECID=134 STAMP=1045845190

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_100.285.1045845335 RECID=135 STAMP=1045845337

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_101.286.1045845411 RECID=136 STAMP=1045845413

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_102.287.1045845537 RECID=137 STAMP=1045845540

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_103.288.1045845659 RECID=138 STAMP=1045845664

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_104.289.1045845925 RECID=139 STAMP=1045845928

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_105.290.1045846117 RECID=140 STAMP=1045846119

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_106.291.1045846325 RECID=141 STAMP=1045846328

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_107.292.1045847171 RECID=142 STAMP=1045847173

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_108.293.1045847333 RECID=143 STAMP=1045847342

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_109.294.1045847383 RECID=144 STAMP=1045847392

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_110.295.1045847493 RECID=145 STAMP=1045847496

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_111.296.1045847599 RECID=146 STAMP=1045847602

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_112.297.1045847707 RECID=147 STAMP=1045847710

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_113.298.1045847795 RECID=148 STAMP=1045847798

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_114.299.1045847895 RECID=149 STAMP=1045847898

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_115.300.1045848003 RECID=150 STAMP=1045848006

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_116.301.1045848049 RECID=151 STAMP=1045848050

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_117.302.1045848119 RECID=152 STAMP=1045848122

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_118.303.1045848159 RECID=153 STAMP=1045848163

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_119.304.1045848205 RECID=154 STAMP=1045848207

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_120.305.1045848271 RECID=155 STAMP=1045848274

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_121.306.1045848337 RECID=156 STAMP=1045848339

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_122.307.1045848439 RECID=157 STAMP=1045848447

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_123.308.1045848603 RECID=158 STAMP=1045848605

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_124.309.1045848649 RECID=159 STAMP=1045848650

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_125.310.1045848747 RECID=160 STAMP=1045848752

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_126.311.1045848793 RECID=161 STAMP=1045848797

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_127.312.1045848861 RECID=162 STAMP=1045848864

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_128.313.1045848901 RECID=163 STAMP=1045848904

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_129.314.1045848957 RECID=164 STAMP=1045848959

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_130.315.1045849015 RECID=165 STAMP=1045849019

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_131.316.1045849221 RECID=166 STAMP=1045849222

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_132.317.1045849399 RECID=167 STAMP=1045849401

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_133.318.1045849507 RECID=168 STAMP=1045849510

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_134.319.1045849571 RECID=169 STAMP=1045849575

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_135.320.1045849659 RECID=170 STAMP=1045849661

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_136.371.1045849717 RECID=171 STAMP=1045849721

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_137.372.1045849923 RECID=172 STAMP=1045849924

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_138.373.1045850181 RECID=173 STAMP=1045850183

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_139.374.1045850309 RECID=174 STAMP=1045850311

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_140.375.1045850443 RECID=175 STAMP=1045850445

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_141.376.1045850473 RECID=176 STAMP=1045850477

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_142.377.1045850493 RECID=177 STAMP=1045850496

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_143.378.1045850575 RECID=178 STAMP=1045850577

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_144.379.1045850675 RECID=179 STAMP=1045850678

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_145.380.1045850709 RECID=180 STAMP=1045850710

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_146.381.1045850891 RECID=181 STAMP=1045850897

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_147.382.1045850929 RECID=182 STAMP=1045850934

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_148.383.1045850961 RECID=183 STAMP=1045850965

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_149.384.1045850991 RECID=184 STAMP=1045850997

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_150.385.1045851265 RECID=185 STAMP=1045851266

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_151.386.1045851515 RECID=186 STAMP=1045851517

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_152.387.1045851901 RECID=187 STAMP=1045851903

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_153.388.1045852173 RECID=188 STAMP=1045852175

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_154.389.1045852475 RECID=189 STAMP=1045852476

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_155.390.1045852775 RECID=190 STAMP=1045852778

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_156.391.1045853067 RECID=191 STAMP=1045853069

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_157.392.1045853473 RECID=192 STAMP=1045853475

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_158.393.1045853507 RECID=193 STAMP=1045853510

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_159.394.1045853531 RECID=194 STAMP=1045853533

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_160.395.1045854085 RECID=195 STAMP=1045854087

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_161.396.1045854153 RECID=196 STAMP=1045854161

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_162.397.1045854187 RECID=197 STAMP=1045854193

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_163.398.1045854275 RECID=198 STAMP=1045854281

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_164.399.1045854291 RECID=199 STAMP=1045854294

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_165.400.1045854373 RECID=200 STAMP=1045854375

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_166.401.1045854709 RECID=201 STAMP=1045854712

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_167.402.1045854967 RECID=202 STAMP=1045854969

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_168.403.1045855659 RECID=203 STAMP=1045855661

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_169.404.1045855781 RECID=204 STAMP=1045855787

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_170.405.1045855905 RECID=205 STAMP=1045855906

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_171.406.1045856163 RECID=206 STAMP=1045856164

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_172.407.1045856297 RECID=207 STAMP=1045856300

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_173.408.1045856383 RECID=208 STAMP=1045856385

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_174.409.1045856475 RECID=209 STAMP=1045856478

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_175.410.1045856641 RECID=210 STAMP=1045856642

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_176.411.1045856863 RECID=211 STAMP=1045856865

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_177.412.1045857027 RECID=212 STAMP=1045857029

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_178.413.1045857253 RECID=213 STAMP=1045857254

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_179.414.1045857517 RECID=214 STAMP=1045857519

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_1_seq_180.415.1045857755 RECID=215 STAMP=1045857756

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_32.321.1045309215 RECID=61 STAMP=1045309221

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_33.322.1045310807 RECID=62 STAMP=1045310812

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_34.324.1045322671 RECID=64 STAMP=1045322679

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_35.326.1045328531 RECID=66 STAMP=1045328534

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_36.327.1045328539 RECID=67 STAMP=1045328541

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_37.330.1045330819 RECID=70 STAMP=1045330821

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_09/thread_2_seq_38.332.1045334201 RECID=72 STAMP=1045334205

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_39.334.1045764743 RECID=75 STAMP=1045764768

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_14/thread_2_seq_40.337.1045769547 RECID=77 STAMP=1045769546

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_41.341.1045829427 RECID=81 STAMP=1045829429

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_42.342.1045829431 RECID=82 STAMP=1045829431

deleted archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2020_07_15/thread_2_seq_43.345.1045835981 RECID=85 STAMP=1045835982

Deleted 155 objects

RMAN> exit

Recovery Manager complete.

[oracle@srv1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 15 20:35:21 2020

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> @/home/oracle/scripts/postupgrade_fixups.sql

Session altered.

PL/SQL procedure successfully completed.

Package created.

No errors.

Package body created.

No errors.

Package created.

No errors.

Package body created.

No errors.

Executing Oracle POST-Upgrade Fixup Script

Auto-Generated by: Oracle Preupgrade Script

Version: 12.2.0.1.0 Build: 1

Generated on: 2020-07-15 13:22:15

For Source Database: RAC

Source Database Version: 12.1.0.2.0

For Upgrade to Version: 12.2.0.1.0

Fixup

Check Name Status Further DBA Action

---------- ------ ------------------

old_time_zones_exist Passed None

post_dictionary Passed None

PL/SQL procedure successfully completed.

Session altered.

SQL>

Check the status of clusterware and database

[grid@srv2 ~]$ crsctl status resource -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ASMIBNETLSNR_ASM.lsnr

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.CRS.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.DATA.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.FRA.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE srv1 STABLE

ONLINE OFFLINE srv2 STABLE

ora.chad

ONLINE OFFLINE srv1 STABLE

ONLINE OFFLINE srv2 STABLE

ora.net1.network

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.ons

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.proxy_advm

OFFLINE OFFLINE srv1 STABLE

OFFLINE OFFLINE srv2 STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE srv1 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE srv1 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE srv1 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE srv1 169.254.224.241 192.

168.10.1,STABLE

ora.asm

1 ONLINE ONLINE srv1 Started,STABLE

2 ONLINE ONLINE srv2 Started,STABLE

ora.cvu

1 ONLINE ONLINE srv1 STABLE

ora.mgmtdb

1 ONLINE OFFLINE Instance Shutdown,ST

ABLE

ora.qosmserver

1 ONLINE ONLINE srv1 STABLE

ora.rac.db

1 ONLINE ONLINE srv1 Open,HOME=/u01/app/o

racle/product/12.2.0

/db_1,STABLE

2 ONLINE ONLINE srv2 Open,HOME=/u01/app/o

racle/product/12.2.0

/db_1,STABLE

ora.scan1.vip

1 ONLINE ONLINE srv1 STABLE

ora.scan2.vip

1 ONLINE ONLINE srv1 STABLE

ora.scan3.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv1.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv2.vip

1 ONLINE ONLINE srv2 STABLE

--------------------------------------------------------------------------------

[grid@srv2 ~]$ srvctl status database -d rac

Instance rac1 is running on node srv1

Instance rac2 is running on node srv2

[grid@srv2 ~]$

Thursday 16 July 2020

Patching - Apply PSU Patch 21255373 on 12.1.0.2.0 grid before upgrade.

Oracle Grid Infrastructure upgrade required patch number 21255373. So we are applying PSU patch 21255373 before upgrade 12.1.0.2.0 to 12.2.0.1.0

Details:

Node 1 : srv1

Node2 : srv2

OS : OEL Linux 6.7 X 64

Database Grid version : 12.1.0.2.0

Download patch number 21255373

OPatch Utility Information

You must use the OPatch utility version 12.1.0.1.2 or later to apply this patch. Oracle recommends that you use the latest released OPatch for 12.1 releases, which is available for download from My Oracle Support patch 6880880. It is recommended that you download the Opatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node.
Take tar level backup of grid |oraInventory| database

Check the status of clusterware (Not required)

[root@srv1 u01]# . oraenv

ORACLE_SID = [root] ? +ASM1

The Oracle base has been set to /u01/app/grid

[root@srv1 u01]# crsctl status resource -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.DATA.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.FRA.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.asm

ONLINE ONLINE srv1 Started,STABLE

ONLINE ONLINE srv2 Started,STABLE

ora.net1.network

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.ons

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE srv2 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE srv1 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE srv1 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE srv1 169.254.41.197 192.1

68.10.1,STABLE

ora.cvu

1 ONLINE ONLINE srv1 STABLE

ora.mgmtdb

1 ONLINE ONLINE srv1 Open,STABLE

ora.oc4j

1 ONLINE ONLINE srv1 STABLE

ora.rac.db

1 ONLINE ONLINE srv1 Open,STABLE

2 ONLINE ONLINE srv2 Open,STABLE

ora.scan1.vip

1 ONLINE ONLINE srv2 STABLE

ora.scan2.vip

1 ONLINE ONLINE srv1 STABLE

ora.scan3.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv1.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv2.vip

1 ONLINE ONLINE srv2 STABLE

--------------------------------------------------------

Check Optach utility information status

[grid@srv1 OPatch]$ ./opatch lsinventory -detail | ./opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.21

Oracle Home : /u01/app/12.1.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/12.1.0/grid/oraInst.loc

OPatch version : 12.2.0.1.21

OUI version : 12.1.0.2.0

Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2020-06-14_17-48-33PM_1.log

Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2020-06-14_17-48-33PM.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: srv1.example.com

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c 12.1.0.2.0

There are 1 products installed in this Oracle Home.

Installed Products (101):

Assistant Common Files 12.1.0.2.0

Automatic Storage Management Assistant 12.1.0.2.0

Buildtools Common Files 12.1.0.2.0

Cluster Ready Services Files 12.1.0.2.0

Cluster Verification Utility Common Files 12.1.0.2.0

Cluster Verification Utility Files 12.1.0.2.0

Database Configuration and Upgrade Assistants 12.1.0.2.0

Database Migration Assistant for Unicode 12.1.0.2.0

Database SQL Scripts 12.1.0.2.0

DB TOOLS Listener 12.1.0.2.0

Deinstallation Tool 12.1.0.2.0

Expat libraries 2.0.1.0.2

Hadoopcore Component 12.1.0.2.0

HAS Common Files 12.1.0.2.0

HAS Files for DB 12.1.0.2.0

Installation Common Files 12.1.0.2.0

Installation Plugin Files 12.1.0.2.0

Installer SDK Component 12.1.0.2.0

Java Development Kit 1.6.0.75.0

LDAP Required Support Files 12.1.0.2.0

OLAP SQL Scripts 12.1.0.2.0

Oracle Advanced Security 12.1.0.2.0

Oracle Bali Share 11.1.1.6.0

Oracle Clusterware RDBMS Files 12.1.0.2.0

Oracle Configuration Manager Deconfiguration 10.3.1.0.0

Oracle Containers for Java 12.1.0.2.0

Oracle Core Required Support Files 12.1.0.2.0

Oracle Core Required Support Files for Core DB 12.1.0.2.0

Oracle Database 12c 12.1.0.2.0

Oracle Database 12c Multimedia Files 12.1.0.2.0

Oracle Database Deconfiguration 12.1.0.2.0

Oracle Database User Interface 11.0.0.0.0

Oracle Database Utilities 12.1.0.2.0

Oracle DBCA Deconfiguration 12.1.0.2.0

Oracle Extended Windowing Toolkit 11.1.1.6.0

Oracle Globalization Support 12.1.0.2.0

Oracle Globalization Support For Core 12.1.0.2.0

Oracle Grid Infrastructure 12c 12.1.0.2.0

Oracle Grid Infrastructure Bundled Agents 12.1.0.2.0

Oracle Grid Management Database 12.1.0.2.0

Oracle Help for Java 11.1.1.7.0

Oracle Help Share Library 11.1.1.7.0

Oracle Ice Browser 11.1.1.7.0

Oracle Internet Directory Client 12.1.0.2.0

Oracle Java Client 12.1.0.2.0

Oracle Java Layout Engine 11.0.0.0.0

Oracle JDBC/OCI Instant Client 12.1.0.2.0

Oracle JDBC/THIN Interfaces 12.1.0.2.0

Oracle JFC Extended Windowing Toolkit 11.1.1.6.0

Oracle JVM 12.1.0.2.0

Oracle JVM For Core 12.1.0.2.0

Oracle LDAP administration 12.1.0.2.0

Oracle Locale Builder 12.1.0.2.0

Oracle Multimedia 12.1.0.2.0

Oracle Multimedia Client Option 12.1.0.2.0

Oracle Multimedia Java Advanced Imaging 12.1.0.2.0

Oracle Multimedia Locator 12.1.0.2.0

Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0

Oracle Multimedia Locator RDBMS Files 12.1.0.2.0

Oracle Net 12.1.0.2.0

Oracle Net Java Required Support Files 12.1.0.2.0

Oracle Net Listener 12.1.0.2.0

Oracle Net Required Support Files 12.1.0.2.0

Oracle Netca Client 12.1.0.2.0

Oracle Notification Service 12.1.0.2.0

Oracle Notification Service (eONS) 12.1.0.2.0

Oracle Notification Service for Instant Client 12.1.0.2.0

Oracle One-Off Patch Installer 12.1.0.1.2

Oracle Quality of Service Management (Client) 12.1.0.2.0

Oracle Quality of Service Management (Server) 12.1.0.2.0

Oracle RAC Deconfiguration 12.1.0.2.0

Oracle RAC Required Support Files-HAS 12.1.0.2.0

Oracle Recovery Manager 12.1.0.2.0

Oracle Security Developer Tools 12.1.0.2.0

Oracle Text Required Support Files 12.1.0.2.0

Oracle Universal Connection Pool 12.1.0.2.0

Oracle Universal Installer 12.1.0.2.0

Oracle USM Deconfiguration 12.1.0.2.0

Oracle Wallet Manager 12.1.0.2.0

oracle.swd.oui.core.min 12.1.0.2.0

Parser Generator Required Support Files 12.1.0.2.0

Perl Interpreter 5.14.1.0.0

Perl Modules 5.14.1.0.0

PL/SQL 12.1.0.2.0

PL/SQL Embedded Gateway 12.1.0.2.0

Platform Required Support Files 12.1.0.2.0

Precompiler Required Support Files 12.1.0.2.0

RDBMS Required Support Files 12.1.0.2.0

RDBMS Required Support Files for Instant Client 12.1.0.2.0

RDBMS Required Support Files Runtime 12.1.0.2.0

Required Support Files 12.1.0.2.0

Secure Socket Layer 12.1.0.2.0

SQL*Plus 12.1.0.2.0

SQL*Plus Files for Instant Client 12.1.0.2.0

SQL*Plus Required Support Files 12.1.0.2.0

SSL Required Support Files for InstantClient 12.1.0.2.0

Tracle File Analyzer 12.1.0.2.0

Universal Storage Manager Files 12.1.0.2.0

XDK Required Support Files 12.1.0.2.0

XML Parser for Java 12.1.0.2.0

There are 101 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Set path andApply Patch on grid using root user as we are using opatchauto utility.

[root@srv1 21255373]# export ORACLE_HOME=/u01/app/12.1.0/grid/

[root@srv1 21255373]# export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin

[root@srv1 21255373]# export PATH=$ORACLE_HOME/perl/bin:$PATH

[root@srv1 21255373]# $ORACLE_HOME/OPatch/opatchauto apply /u01/21255373 -log /u01/21255373_response.txt

OPatchauto session is initiated at Sun Jun 14 17:53:00 2020

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-06-14_05-53-13PM.log.

Session log file is /u01/21255373_response.txt

The id for this session is MRLJ

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1

No step execution required.........

Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/dbhome_1

Successfully prepared home /u01/app/oracle/product/12.1.0/dbhome_1 to bring down database service

Bringing down CRS service on home /u01/app/12.1.0/grid

Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_srv1_2020-06-14_05-56-30PM.log

CRS service brought down successfully on home /u01/app/12.1.0/grid

Performing prepatch operation on home /u01/app/oracle/product/12.1.0/dbhome_1

Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Start applying binary patch on home /u01/app/oracle/product/12.1.0/dbhome_1

Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Performing postpatch operation on home /u01/app/oracle/product/12.1.0/dbhome_1

Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Start applying binary patch on home /u01/app/12.1.0/grid

Binary patch applied successfully on home /u01/app/12.1.0/grid

Starting CRS service on home /u01/app/12.1.0/grid

Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_srv1_2020-06-14_06-06-05PM.log

CRS service started successfully on home /u01/app/12.1.0/grid

Preparing home /u01/app/oracle/product/12.1.0/dbhome_1 after database service restarted

No step execution required.........

Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0/dbhome_1

No step execution required.........

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:srv1

RAC Home:/u01/app/oracle/product/12.1.0/dbhome_1

Version:12.1.0.2.0

Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/21255373/21255373

Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-06-14_18-00-41PM_1.log

Host:srv1

CRS Home:/u01/app/12.1.0/grid

Version:12.1.0.2.0

Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/21255373/21255373

Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-06-14_18-01-45PM_1.log

OPatchauto session completed at Sun Jun 14 18:21:31 2020

Time taken to complete the session 28 minutes, 32 seconds

NOTE: As we Apply patch one node at a time so application connection not hammpered. apply same setup on 2nd node

Check Result command :

[grid@srv1 OPatch]$ ./opatch lsinventory

[grid@srv1 OPatch]$ ./opatch lsinventory | grep 21255373

Patch 21255373 : applied on Sun Jun 14 18:05:57 IST 2020

Patch description: "OCW Patch Set Update : 12.1.0.2.0 (21255373)"

21394146, 19916737, 19049721, 19368917, 21255373, 19635215, 20408163

[grid@srv1 OPatch]$

[grid@srv2 OPatch]$ ./opatch lsinventory | grep 21255373
Patch 21255373 : applied on Sun Jun 14 18:46:17 IST 2020
Patch description: "OCW Patch Set Update : 12.1.0.2.0 (21255373)"
21394146, 19916737, 19049721, 19368917, 21255373, 19635215, 20408163

SQL> select * from registry$history order by id;

Monday 13 July 2020

RAC - Change OCR Vote disk and ASM Spfile location to new disk group

Scenario:

Hi all , As per current scenario we have to upgrade 12.1 grid to 12.2 grid on linux suse 12.5, We have CRS disk group having size 10 GB with normal redundancy. CRS diskgoup having OCR VOTING DISK and ASM spfile location.

As per documentation 33GB CRS disk size required for up-gradation 12.2grid. So we add new diskgroup CRSNEW and remove old CRS and move all files before drop.

STEPS:

Create New disk group CRSNEW with normal redundancy.

Mount CRSNEW diskgroup on all cluster nodes , By default it is dismounted state on remote cluster node.

Move OCR and VOTING DISK from CRS to NEWCRS diskgroup.

Create pfile of asm and change the asm location to the NEW CRS diskgroup by creating asm spfile from asm pfile.

Verify diskgroup on all clusterware

Stop and start CRS individually one by one on all clusterware node

Check clusterware status

############################################################

1. Create disk crs1_1, crs2_2 crs2_2 using oracleasm command below.

oracleasm createdisk crs1_1 /dev/sdh1

oracleasm createdisk crs2_2 /dev/sdk1

oracleasm createdisk crs3_3 /dev/sdj1

srv1:~ # ps -ef |grep pmon

grid 2680 1 0 Jul10 ? 00:00:05 mdb_pmon_-MGMTDB

oracle 6945 1 0 Jul10 ? 00:00:08 ora_pmon_smrplm1

root 15886 7522 0 18:11 pts/0 00:00:00 grep --color=auto pmon

grid 19349 1 0 Jul10 ? 00:00:07 asm_pmon_+ASM1

2. Check OracleAsm disk status ( do oracleasm scandisk on another nodes)

srv1:~ # oracleasm listdisks

CRS1

CRS1_1

CRS2

CRS2_2

CRS3

CRS3_3

DATA

FRA

srv1:~ #

3. Check status of disk group.

SQL> set lines 200

SQL> /

DISK_GROUP_NAME DISK_FILE_PATH DISK_FILE_NAME

------------------------------ -------------------------------------------------- ------------------------------

CRS ORCL:CRS1 CRS1

CRS ORCL:CRS3 CRS3

CRS ORCL:CRS2 CRS2

DATA ORCL:DATA DATA

FRA ORCL:FRA FRA

[CANDIDATE] ORCL:CRS2_2

[CANDIDATE] ORCL:CRS1_1

[CANDIDATE] ORCL:CRS3_3

8 rows selected.

4. Create new disk group CRSNEW with normal redundancy.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

grid@srv1:~> sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 10 16:41:12 2020

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL>

SQL> create diskgroup CRSNEW normal redundancy disk 'ORCL:CRS1_1' ,'ORCL:CRS2_2' ,'ORCL:CRS3_3' attribute 'compatible.rdbms'='12.1.0.0', 'compatible.asm'='12.1.0.0';

Diskgroup created.

5. Mount disk group on all nodes and check status

SQL> alter diskgroup CRSNEW mount;

SQL> /

DISK_GROUP_NAME DISK_FILE_PATH DISK_FILE_NAME

------------------------------ -------------------------------------------------- ------------------------------

CRS ORCL:CRS3 CRS3

CRS ORCL:CRS1 CRS1

CRS ORCL:CRS2 CRS2

CRSNEW ORCL:CRS1_1 CRS1_1

CRSNEW ORCL:CRS2_2 CRS2_2

CRSNEW ORCL:CRS3_3 CRS3_3

DATA ORCL:DATA DATA

FRA ORCL:FRA FRA

8 rows selected.

SQL>

SQL> select NAME,STATE,TYPE,TOTAL_MB from v$asm_diskgroup;

NAME STATE TYPE TOTAL_MB

------------------------------ ----------- ------ ----------

FRA MOUNTED EXTERN 12287

DATA MOUNTED EXTERN 12287

CRSNEW MOUNTED NORMAL 122877

CRS MOUNTED NORMAL 30717

SQL>

6. Mount disk group on node srv2 hostname

ORACLE_SID = [grid] ? +ASM2

The Oracle base has been set to /u01/app/grid

grid@srv2:~> sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 10 17:01:56 2020

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select NAME,STATE,TYPE,TOTAL_MB from v$asm_diskgroup;

NAME STATE TYPE TOTAL_MB

------------------------------ ----------- ------ ----------

FRA MOUNTED EXTERN 12287

CRSNEW DISMOUNTED 0

DATA MOUNTED EXTERN 12287

CRS MOUNTED NORMAL 30717

SQL> alter diskgroup CRSNEW mount;

Diskgroup altered.

7. go to /u01/app/12.1.0/grid/bin directory with root user register add new diskgroup using ocrconfig command

SQL>

grid@srv1:~> cd /u01/app/12.

12.1.0/ 12.2.0/

grid@srv1:~> cd /u01/app/12.1.0/grid/bin/

grid@srv1:/u01/app/12.1.0/grid/bin> ls -ltr ocrconfig

-rwxr-xr-x 1 root oinstall 9422 Jul 3 18:10 ocrconfig

grid@srv1:/u01/app/12.1.0/grid/bin> su root

Password:

su: Authentication failure

grid@srv1:/u01/app/12.1.0/grid/bin> su root

Password:

srv1:/u01/app/12.1.0/grid/bin # . oraenv

ORACLE_SID = [+ASM1] ?

srv1:/u01/app/12.1.0/grid/bin # ocrconfig -add +CRSNEW

PROT-30: The Oracle Cluster Registry location to be added is not usable

PROC-50: The Oracle Cluster Registry location to be added is inaccessible on nodes srv2.

8. Delete old CRS diskgroup using ocrconfig

srv1:/u01/app/12.1.0/grid/bin # ocrconfig -delete +CRS

srv1:/u01/app/12.1.0/grid/bin # crsctl replace votedisk +CRSNEW

Successful addition of voting disk 5920eeae52e04f40bf92cee3be7ca3e3.

Successful addition of voting disk 6e4c2f38cbe84f76bf941e58abc48035.

Successful addition of voting disk 7af1964f8e3a4ff7bf1a366cffd81af0.

Successful deletion of voting disk f968ab1dfafa4fa1bfc69cec3995c776.

Successful deletion of voting disk e8a2780969fd4f90bfa04544d728c489.

Successful deletion of voting disk a15c1f7048904f4dbfe02381989863ef.

Successfully replaced voting disk group with +CRSNEW.

CRS-4266: Voting file(s) successfully replaced

9. Check the status of votedisk

srv1:/u01/app/12.1.0/grid/bin # crsctl query css votedisk

## STATE File Universal Id File Name Disk group

-- ----- ----------------- --------- ---------

1. ONLINE 5920eeae52e04f40bf92cee3be7ca3e3 (ORCL:CRS1_1) [CRSNEW]

2. ONLINE 6e4c2f38cbe84f76bf941e58abc48035 (ORCL:CRS2_2) [CRSNEW]

3. ONLINE 7af1964f8e3a4ff7bf1a366cffd81af0 (ORCL:CRS3_3) [CRSNEW]

Located 3 voting disk(s).

srv1:/u01/app/12.1.0/grid/bin # ocrcheck

Status of Oracle Cluster Registry is as follows :

Version : 4

Total space (kbytes) : 409568

Used space (kbytes) : 1752

Available space (kbytes) : 407816

ID : 486030082

Device/File Name : +CRSNEW

Device/File integrity check succeeded

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

srv1:/u01/app/12.1.0/grid/bin #

-------------------------------------------------------------

9. Change spfile location by creating first asm pfile then using pfile create new ASMPFILE with NEWCRS diskgroup location.

create pfile='/u01/app/grid' from spfile;

/u01/app/grid

grid@srv1:/u01/app> sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 10 17:41:56 2020

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> create pfile='/u01/app/grid/asmfile.ora' from spfile;

File created.

SQL>

create spfile='+CRSNEW' from pfile='/u01/app/grid/asmfile.ora';

SQL> create pfile='/u01/app/grid/asmfile.ora' from spfile;

File created.

SQL> create spfile='+CRSNEW' from pfile='/u01/app/grid/asmfile.ora';

File created.

SQL>

10. Using gpnptool get command check the location of new asmspfile.

$ORACLE_HOME/bin/gpnptool get

------gpnptool information

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

grid@srv1:/u01/app> cd 12.1.0/grid/bin/

grid@srv1:/u01/app/12.1.0/grid/bin> pwd

/u01/app/12.1.0/grid/bin

grid@srv1:/u01/app/12.1.0/grid/bin> ls -ltr gpnptool

-rwxr-xr-x 1 grid oinstall 9422 Jul 3 18:10 gpnptool

grid@srv1:/u01/app/12.1.0/grid/bin> ./gpnptool get

Warning: some command line parameters were defaulted. Resulting command line:

./gpnptool.bin get -o-

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="12" ClusterUId="90521a2aafd3ef6bbfdec9507ff8dc0d" ClusterName="smrplm" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.56.0" Adapter="eth0" Use="public"/><gpnp:Network id="net2" IP="192.168.10.0" Adapter="eth1" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="" SPFile="+CRSNEW/smrplm/ASMPARAMETERFILE/registry.253.1045417681" Mode="legacy"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>bqJG+H/ZAK6chk6GRRDzintmnUY=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>B5Dv3kVGKEyY467rOxrr0Ss0sQ6w91M+XfHvDuLGPOW+AExaEWZBpzZ/e8srJCW9yOezxsSMp8YToPbnE9VadmChikYTjJrTBUFjv/wBHO4js7bMCtUB3d3rAR1uIw7xKvqH3bwQWaQLODqI/EDAuvWsOzf9eOnBULhpHJGfrds=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>

Success.

grid@srv1:/u01/app/12.1.0/grid/bin>

11. Stop and start Cluster node on local node then remote node

srv1:/u01/app/12.1.0/grid/bin # crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'srv1'

CRS-2673: Attempting to stop 'ora.crsd' on 'srv1'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'srv1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'srv1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'srv1'

CRS-2673: Attempting to stop 'ora.mgmtdb' on 'srv1'

CRS-2673: Attempting to stop 'ora.smrplm.pretaf_preconnect.svc' on 'srv2'

CRS-2677: Stop of 'ora.smrplm.pretaf_preconnect.svc' on 'srv2' succeeded

CRS-2673: Attempting to stop 'ora.smrplm.pretaf.svc' on 'srv1'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'srv1'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'srv1' succeeded

CRS-2677: Stop of 'ora.smrplm.pretaf.svc' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.smrplm.db' on 'srv1'

CRS-2672: Attempting to start 'ora.smrplm.pretaf.svc' on 'srv2'

CRS-2677: Stop of 'ora.scan1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'srv2'

CRS-2677: Stop of 'ora.smrplm.db' on 'srv1' succeeded

CRS-2677: Stop of 'ora.mgmtdb' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'srv1'

CRS-2676: Start of 'ora.scan1.vip' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'srv2'

CRS-2677: Stop of 'ora.MGMTLSNR' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'srv2'

CRS-2676: Start of 'ora.smrplm.pretaf.svc' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.smrplm.pretaf_preconnect.svc' on 'srv2'

CRS-2674: Start of 'ora.smrplm.pretaf_preconnect.svc' on 'srv2' failed

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'srv1'

CRS-2677: Stop of 'ora.DATA.dg' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.FRA.dg' on 'srv1'

CRS-2677: Stop of 'ora.FRA.dg' on 'srv1' succeeded

CRS-2676: Start of 'ora.MGMTLSNR' on 'srv2' succeeded

CRS-2679: Attempting to clean 'ora.mgmtdb' on 'srv2'

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'srv2' succeeded

CRS-2681: Clean of 'ora.mgmtdb' on 'srv2' succeeded

CRS-2672: Attempting to start 'ora.mgmtdb' on 'srv2'

CRS-2676: Start of 'ora.mgmtdb' on 'srv2' succeeded

CRS-2673: Attempting to stop 'ora.CRS.dg' on 'srv1'

CRS-2673: Attempting to stop 'ora.CRSNEW.dg' on 'srv1'

CRS-2673: Attempting to stop 'ora.srv1.vip' on 'srv1'

CRS-2677: Stop of 'ora.CRSNEW.dg' on 'srv1' succeeded

CRS-2677: Stop of 'ora.CRS.dg' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'srv1'

CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded

CRS-2677: Stop of 'ora.srv1.vip' on 'srv1' succeeded

CRS-2672: Attempting to start 'ora.srv1.vip' on 'srv2'

CRS-2676: Start of 'ora.srv1.vip' on 'srv2' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'srv1'

CRS-2677: Stop of 'ora.ons' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'srv1'

CRS-2677: Stop of 'ora.net1.network' on 'srv1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'srv1' has completed

CRS-2677: Stop of 'ora.crsd' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.crf' on 'srv1'

CRS-2673: Attempting to stop 'ora.storage' on 'srv1'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'srv1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'srv1'

CRS-2673: Attempting to stop 'ora.gpnpd' on 'srv1'

CRS-2677: Stop of 'ora.storage' on 'srv1' succeeded

CRS-2677: Stop of 'ora.crf' on 'srv1' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.evmd' on 'srv1'

CRS-2673: Attempting to stop 'ora.asm' on 'srv1'

CRS-2677: Stop of 'ora.gpnpd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'srv1' succeeded

CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'srv1'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'srv1'

CRS-2677: Stop of 'ora.cssd' on 'srv1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'srv1'

CRS-2677: Stop of 'ora.gipcd' on 'srv1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'srv1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

srv1:/u01/app/12.1.0/grid/bin #

srv1:/u01/app/12.1.0/grid/bin # pwd

/u01/app/12.1.0/grid/bin

srv1:/u01/app/12.1.0/grid/bin #

srv1:/u01/app/12.1.0/grid/bin # crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

srv1:/u01/app/12.1.0/grid/bin # ps -ef |grep pmon

root 2180 4539 0 18:46 pts/0 00:00:00 grep --color=auto pmon

oracle 6945 1 0 18:44 ? 00:00:00 ora_pmon_smrplm1

grid 19349 1 0 18:44 ? 00:00:00 asm_pmon_+ASM1

srv1:/u01/app/12.1.0/grid/bin # crsctl status resource -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.CRSNEW.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.DATA.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.FRA.dg

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.asm

ONLINE ONLINE srv1 Started,STABLE

ONLINE ONLINE srv2 Started,STABLE

ora.net1.network

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

ora.ons

ONLINE ONLINE srv1 STABLE

ONLINE ONLINE srv2 STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE srv1 STABLE

ora.LISTENER_SCAN2.lsnr

1 ONLINE ONLINE srv2 STABLE

ora.LISTENER_SCAN3.lsnr

1 ONLINE ONLINE srv2 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE srv2 169.254.70.63 192.16

8.10.2,STABLE

ora.cvu

1 ONLINE ONLINE srv2 STABLE

ora.mgmtdb

1 ONLINE ONLINE srv2 Open,STABLE

ora.oc4j

1 ONLINE ONLINE srv2 STABLE

ora.scan1.vip

1 ONLINE ONLINE srv1 STABLE

ora.scan2.vip

1 ONLINE ONLINE srv2 STABLE

ora.scan3.vip

1 ONLINE ONLINE srv2 STABLE

ora.smrplm.db

1 ONLINE ONLINE srv1 Open,STABLE

2 ONLINE ONLINE srv2 Open,STABLE

ora.smrplm.pretaf.svc

1 ONLINE ONLINE srv2 STABLE

ora.smrplm.pretaf_preconnect.svc

1 ONLINE ONLINE srv1 STABLE

ora.srv1.vip

1 ONLINE ONLINE srv1 STABLE

ora.srv2.vip

1 ONLINE ONLINE srv2 STABLE

--------------------------------------------------------------------------------

srv1:/u01/app/12.1.0/grid/bin #

12. Check phyiscial location of new file

grid@srv2:~> asmcmd

ASMCMD> lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED NORMAL N 512 4096 1048576 30717 21401 10239 5581 0 Y CRS/

MOUNTED NORMAL N 512 4096 1048576 122877 122250 40959 40645 0 N CRSNEW/

MOUNTED EXTERN N 512 4096 1048576 12287 3289 0 3289 0 N DATA/

MOUNTED EXTERN N 512 4096 1048576 12287 9154 0 9154 0 N FRA/

ASMCMD> cd CRSNEW/

ASMCMD> ls

smrplm/

ASMCMD> cd smrplm

ASMCMD> ls

OCRFILE/

ASMCMD> cd OCRFILE/

ASMCMD> ls

REGISTRY.255.1045415429

ASMCMD> exit

13. Check the disk group and instance status

SQL> select name,state,usable_file_mb,total_mb,free_mb,required_mirror_free_mb from v$asm_diskgroup;

NAME STATE USABLE_FILE_MB TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB

-------------------- ----------- -------------- ---------- ---------- -----------------------

FRA MOUNTED 9134 12287 9134 0

DATA MOUNTED 3289 12287 3289 0

CRSNEW MOUNTED 40596 122877 122152 40959

CRS DISMOUNTED 0 0 0 0

SQL>

srv1:/u01/app/12.1.0/grid/bin # su oracle

oracle@srv1:/u01/app/12.1.0/grid/bin> . oraenv

ORACLE_SID = [+ASM1] ? smrplm1

The Oracle base has been changed from /u01/app/grid to /u01/app/oracle

oracle@srv1:/u01/app/12.1.0/grid/bin> sqlplus sys/123@pretaf as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 10 18:57:52 2020

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> select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME from gv$instance;

INSTANCE_NUMBER INSTANCE_NAME HOST_NAME

--------------- ---------------- ----------------------------------------------------------------

1 smrplm1 srv1

2 smrplm2 srv2

srv1:~ # crsctl check cluster -all

**************************************************************

srv1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

srv2:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

HOME

Friday 17 July 2020

Upgrade - PART2 | DBUA Upgrade 12.1.0.2.0 to 12.2.0.1.0

Thursday 16 July 2020

Patching - Apply PSU Patch 21255373 on 12.1.0.2.0 grid before upgrade.

OPatch Utility Information

Monday 13 July 2020

RAC - Change OCR Vote disk and ASM Spfile location to new disk group