Wednesday, April 25, 2018

Patch 27338041 - Oracle Database Patch Set Update 12.1.0.2.180417


Patch 27338041 - Oracle Database Patch Set Update 12.1.0.2.180417

[oracle@testpc patch]$ export PATH=$PATH:$ORACLE_HOME/OPatch
[oracle@testpc patch]$ which opatch
/u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch
[oracle@testpc patch]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-04-25_19-01-41PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-04-25_19-01-41PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: testpc
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch  24006101     : applied on Wed Nov 16 14:04:48 AST 2016
Unique Patch ID:  20683584
Patch description:  "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
   Created on 1 Oct 2016, 12:33:50 hrs PST8PDT
Sub-patch  23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch  22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch  21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
     19791273, 19243521, 20951038, 19908836, 21281532, 19238590, 24577566
     21184223, 19134173, 20387265, 19149990, 21263635, 18886413, 17551063
     22160989, 22507210, 19703301, 19366375, 19001390, 18202441, 20267166
     19358317, 19706965, 18549238, 19068970, 18797519, 22148226, 20825533
     19649152, 19670108, 18940497, 18948177, 18964978, 19035573, 19176326
     20413820, 19176223, 20904530, 20134339, 19074147, 20868862, 18411216
     21322887, 22507234, 20425790, 18966843, 21329301, 19333670, 19468991
     20124446, 19883092, 19658708, 19591608, 19402853, 20618595, 21787056
     22380919, 21266085, 17835294, 19721304, 19791377, 19068610, 22178855
     22173980, 20746251, 20048359, 20898391, 19185876, 20281121, 20907061
     6599380, 19577410, 22092979, 20603378, 19001359, 19490948, 21387964
     20832516, 17532734, 19309466, 19081128, 20627866, 20844426, 21188532
     18791688, 21442094, 20890311, 20596234, 18973548, 21296029, 19303936
     19461270, 21479753, 20936905, 20235511, 21220620, 18964939, 19430401
     22296366, 21153266, 19409212, 22657942, 20657441, 19879746, 19684504
     20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
     20228093, 19065556, 20212067, 19524384, 17722075, 20446883, 18952989
     16870214, 19928926, 19835133, 21629064, 20466628, 24386767, 19931709
     19730508, 18819908, 23124895, 19188927, 20074391, 20356733, 14643995
     19547370, 19065677, 21960504, 21225209, 20397490, 18967382, 19174430
     21241829, 19536415, 19171086, 22465352, 22168163, 19335438, 20447445
     18856999, 20471920, 19869255, 21620471, 18990693, 17890099, 18990023
     20101006, 21300341, 20848335, 21744290, 20897759, 21668627, 19304354
     19052488, 20794034, 23260854, 18681056, 20952966, 19896336, 18618122
     20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 18743542
     20798891, 20347562, 22551446, 19777862, 19687159, 21373076, 19174942
     20424899, 21899588, 18899974, 20598042, 19032777, 19058490, 22815955
     19399918, 19434529, 21273804, 19018447, 22757364, 18851894, 19284031
     19022470, 18043064, 20173897, 22062026, 20475845, 17274537, 19440586
     16887946, 22374754, 17319928, 20708701, 17655240, 16439813, 19805359
     19155797, 20859910, 19393542, 22024071, 17210525, 21847223, 19189525
     21649497, 19075256, 22762046, 22075064, 19280225, 18845653, 20560611
     19248799, 21756699, 18988834, 20245930, 18921743, 18799063, 20373598
     20476175, 19571367, 20925795, 19018206, 20509482, 20711718, 20588502
     18849537, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
     20669434, 16863642, 22528741, 19619732, 18607546, 20348653, 19315691
     19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
     19450314, 22353346, 20361671, 20009833, 22366558, 20294666, 18191823
     19307662, 19371175, 19195895, 20043616, 19154375, 18914624, 20139391
     21291274, 19174521, 19520602, 19382851, 21875360, 19676012, 19326908
     20217801, 20093776, 21097043, 21246723, 21665897, 19143550, 20428621
     19627012, 14283239, 19518079, 18610915, 18674024, 18306996, 19524158
     19915271, 20122715, 20284155, 20017509, 19363645, 19597439, 21239530
     19888853, 20880215, 21756677, 19534363, 19354335, 19044962, 19639483
     22353199, 22243719, 22916353, 20378086, 21756661, 21260431, 22923409
     20877664, 19028800, 20879889, 19723336, 19077215, 21421886, 19604659
     19308965, 19048007, 18288842, 19689979, 21526048, 19180770, 19197175
     19902195, 20318889, 19013183, 19012119, 20464614, 19067244, 21632821
     19512341, 19841800, 20331945, 19587324, 24316947, 19578350, 19637186
     18674047, 19054077, 20898997, 19708632, 21091431, 19289642, 20869721
     19258504, 17365043, 19468347, 21373473, 16359751, 19439759, 19769480
     19272708, 19978542, 20402832, 19329654, 19873610, 23229229, 21517440
     13542050, 19291380, 21915719, 19076343, 19561643, 19990037, 19487147
     18909599, 20831538, 18250893, 19016730, 16619249, 18354830, 21188584
     19989009, 17414008, 20688221, 20704450, 20441797, 19157754, 18885870
     21785691, 21450666, 18893947, 18705806, 22223463, 16923858, 18417036
     20919320, 20474192, 22046677, 19385656, 19501299, 20920911, 20899461
     21387128, 21315084, 18122373, 20581111, 19606174, 18436647, 19023822
     19178851, 19124589, 19597583, 18499088, 19050649



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

OPatch succeeded.
 [oracle@testpc 27338041]$ opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-04-25_19-03-55PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   24732082  25171037  25755742  26609783  26713565  26925311  27338041

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/mesg/oraus.msb" because it is the same as
the file in incoming patch "/backup/patch/27338041/24732082/files/rdbms/mesg/oraus.msb"

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '25171037' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/dbhome_1/ord/jlib/OrdDicomLibrary.ear" because it is the same as
the file in incoming patch "/backup/patch/27338041/25171037/files/ord/jlib/OrdDicomLibrary.ear"

Patching component oracle.ordim.jai, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/dbhome_1/ord/jlib/ordimdcm.jar" because it is the same as
the file in incoming patch "/backup/patch/27338041/25171037/files/ord/jlib/ordimdcm.jar"

Patching component oracle.ordim.server, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.javavm.containers, 12.1.0.2.0...
Applying sub-patch '25755742' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/dbmsrman.sql" because it is the same as
the file in incoming patch "/backup/patch/27338041/25755742/files/rdbms/admin/dbmsrman.sql"

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26609783' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...
Applying sub-patch '26713565' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26925311' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/dbmsrman.sql" because it is the same as
the file in incoming patch "/backup/patch/27338041/26925311/files/rdbms/admin/dbmsrman.sql"
Applying sub-patch '27338041' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/dbmsrman.sql" because it is the same as
the file in incoming patch "/backup/patch/27338041/27338041/files/rdbms/admin/dbmsrman.sql"

Patching component oracle.sqlplus.rsf, 12.1.0.2.0...
Composite patch 27338041 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-04-25_19-03-55PM_1.log

OPatch succeeded.
[oracle@testpc 27338041]$



[oracle@testpc 27338041]$ datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Wed Apr 25 19:12:31 2018
Copyright (c) 2012, 2016, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_41499_2018_04_25_19_12_31/sqlpatch_invocation.log

Connecting to database...OK
Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
  ID 180417 in the binary registry and not installed in any PDB

Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED 1UATDB 2UATDB 3UATDB 4UAT
    Nothing to roll back
    The following patches will be applied:
      27338041 (DATABASE PATCH SET UPDATE 12.1.0.2.180417)

Installing patches...
Installing patches...
Patch installation complete.  Total patches installed: 10

Validating logfiles...
Patch 27338041 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_CDBROOT_2018Apr25_19_13_22.log (no errors)
Patch 27338041 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_PDBSEED_2018Apr25_19_14_37.log (no errors)
Patch 27338041 apply (pdb 1UAT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_1UATDB _2018Apr25_19_14_37.log (no errors)
Patch 27338041 apply (pdb 2UAT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_2UATDB _2018Apr25_19_14_37.log (no errors)
Patch 27338041 apply (pdb 3UAT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_3UATDB _2018Apr25_19_14_37.log (no errors)
Patch 27338041 apply (pdb 4UAT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_4UAT_2018Apr25_19_15_56.log (no errors)
SQL Patching tool complete on Wed Apr 25 19:18:14 2018

Wednesday, April 18, 2018

Relocate MGMTDB database from one Diskgroup to other Diskgroup


Execute the below command as root user:
/u01/app/12.1.0/grid/bin/crsctl stop res ora.crf -init
/u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=0 -init

Execute the below command as Grid User:
/u01/app/12.1.0/grid/bin/srvctl stop mgmtdb
Create a CDB for the MGMTDB using DBCA
/u01/app/12.1.0/grid/bin/dbca -silent -deleteDatabase -sourceDB -MGMTDB
$/u01/app/12.1.0/grid/bin/dbca -silent -createDatabase -sid -MGMTDB -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -gdbName _mgmtdb -storageType ASM -diskGroupName +SASDATA1 -datafileJarLocation /u01/app/12.1.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck

Create a PDB within the MGMTDB using DBCA.

 Execute to find Cluster Name:
-bash-4.1$ cemutlo -n
NOTE: The CLUSTER_NAME needs to have any hyphens (“-”) replaced with underscores (“_”)

$/u01/app/12.1.0/grid/bin/dbca -silent -createPluggableDatabase -sourceDB -MGMTDB -pdbName -createPDBFrom RMANBACKUP -PDBBackUpfile /u01/app/12.1.0/grid/assistants/dbca/templates/mgmtseed_pdb.dfb -PDBMetadataFile /u01/app/12.1.0/grid/assistants/dbca/templates/mgmtseed_pdb.xml -createAsClone true

 Confirm the node on which MGMTDB is running by executing.
srvctl status MGMTDB

 Execute below command from the Node on which MGMTDB is running
mgmtca

 Execute the below command as root user:
crsctl modify res ora.crf -attr ENABLED=1 -init
crsctl start res ora.crf -init