Instalace Patch 21150806 - Combo of OJVM Component 12.1.0.1.4 DB PSU + DB PSU 12.1.0.1.8 (Jul2015) — Databázový administrátor

Hned na začátku podotýkám, že jsem instaloval pouze Patch 20831107 – Database Patch Set Update 12.1.0.1.8 (Jul2015)

12.1.0.1 Base Release – Availability and Known Issues (Doc ID 1565082.1)

Zatím není na windows. Dostupný pro tyto platformy.

Kontrola opatch

[oracle@dbserver backup]$ which opatch
/usr/bin/which: no opatch in (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/app/oracle/product/12.1.0/dbhome_1/bin)
[oracle@dbserver backup]$ export PATH=$PATH:$ORACLE_HOME/OPatch
[oracle@dbserver backup]$ which opatch
/u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch

[oracle@dbserver backup]$ opatch version
OPatch Version: 12.1.0.1.0
OPatch succeeded.

Kontrola konfliktů

[oracle@dbserver 20831107]$ pwd
/storage/backup/21150806/20831107
[oracle@dbserver 20831107]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

PREREQ session

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.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-08_08-06-00AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Zastaveni databáze a listeneru

[oracle@dbserver 20831107]$ sqlplus / as sysdba
SQL> shutdown immediate
[oracle@dbserver 20831107]$ lsnrctl stop
The command completed successfully

Analýze patche

Patch 21150806 – Combo of OJVM Component 12.1.0.1.4 DB PSU + DB PSU 12.1.0.1.8 (Jul2015)
- Patch 20831107 – Database Patch Set Update 12.1.0.1.8 (Jul2015)
  - Document 2005667.1 Patch Set Update and Critical Patch Update July 2015 Availability Document
  - Document 854428.1 Patch Set Updates for Oracle Products
  - Document 2006081.1 Oracle Database Patch Set Update 12.1.0.1.8 Known Issu
- Patch 21068523 – Oracle JavaVM Component 12.1.0.1.4 Database PSU (Jul2015)

Aplikuji pouze PSU

[oracle@dbserver 20831107]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, 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.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-08_08-27-23AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-10-08_08-27-23AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.

Měl jsem tam jednu chybu a řešení je zde. MISSING COMMAND :FUSER

[oracle@dbserver 20831107]$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, 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.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-08_08-27-33AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769486 20299016 20831107

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 '19769486' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.cman, 12.1.0.1.0 ] , [ oracle.oraolap, 12.1.0.1.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.1.0...
Patching component oracle.ldap.rsf, 12.1.0.1.0...
Patching component oracle.precomp.common, 12.1.0.1.0...
Patching component oracle.ovm, 12.1.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.1.0...
Patching component oracle.rdbms.deconfig, 12.1.0.1.0...
Patching component oracle.xdk, 12.1.0.1.0...
Patching component oracle.rdbms.util, 12.1.0.1.0...
Patching component oracle.rdbms, 12.1.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...
Patching component oracle.nlsrtl.rsf, 12.1.0.1.0...
Patching component oracle.xdk.parser.java, 12.1.0.1.0...
Patching component oracle.rdbms.rsf, 12.1.0.1.0...
Patching component oracle.xdk.rsf, 12.1.0.1.0...
Patching component oracle.rdbms.rman, 12.1.0.1.0...
Patching component oracle.precomp.lang, 12.1.0.1.0...
Patching component oracle.ordim.client, 12.1.0.1.0...
Patching component oracle.ordim.jai, 12.1.0.1.0...
Patching component oracle.rsf, 12.1.0.1.0...

Verifying the update...
applying sub-patch '20299016' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.nlsrtl.rsf, 12.1.0.1.0...
Patching component oracle.xdk.parser.java, 12.1.0.1.0...
Patching component oracle.xdk.rsf, 12.1.0.1.0...
Patching component oracle.rdbms.rsf, 12.1.0.1.0...
Patching component oracle.xdk, 12.1.0.1.0...
Patching component oracle.rdbms, 12.1.0.1.0...

Verifying the update...
Applying sub-patch '20831107' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.oraolap.dbscripts, 12.1.0.1.0...
Patching component oracle.rdbms, 12.1.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...

Verifying the update...
Composite patch 20831107 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-08_08-27-33AM_1.log

OPatch succeeded.

Loading Modified SQL Files into the Database

[oracle@dbserver 20831107]$ lsnrctl start

SQL> startup
SQL> exit
[oracle@dbserver OPatch]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/OPatch

[oracle@dbserver OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Thu Oct 8 08:32:38 2015
Copyright (c) 2014, Oracle. All rights reserved.

Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
Currently installed C Patches: 19769486,20299016,20831107
Adding patches to installation queue and performing prereq checks...
Installation queue:
 Nothing to roll back
 The following patches will be applied: 19769486,20299016,20831107
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...
Patch 19769486 apply: SUCCESS
 logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/19769486/19769486_apply_ORCL_2015Oct08_08_32_51.log (no errors)
 catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_orcl_GENERATE_2015Oct08_08_33_37.log (no errors)
 catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_orcl_APPLY_2015Oct08_08_33_37.log (no errors)
Patch 20299016 apply: SUCCESS
 logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/20299016/20299016_apply_ORCL_2015Oct08_08_33_36.log (no errors)
 catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_orcl_GENERATE_2015Oct08_08_33_37.log (no errors)
 catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_orcl_APPLY_2015Oct08_08_33_37.log (no errors)
Patch 20831107 apply: SUCCESS
 logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/20831107/20831107_apply_ORCL_2015Oct08_08_33_37.log (no errors)
 catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_orcl_GENERATE_2015Oct08_08_33_37.log (no errors)
 catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_orcl_APPLY_2015Oct08_08_33_37.log (no errors)
SQL Patching tool complete on Thu Oct 8 08:33:37 2015

Kontrola

[oracle@dbserver OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, 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.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2015-10-08_08-34-23AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-10-08_08-34-23AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 20831107 : applied on Thu Oct 08 08:27:53 CEST 2015
Unique Patch ID: 18888731
Patch description: "Database Patch Set Update : 12.1.0.1.8 (20831107)"
 Created on 19 Jun 2015, 08:27:14 hrs PST8PDT
Sub-patch 20299016; "Database Patch Set Update : 12.1.0.1.7 (20299016)"
Sub-patch 19769486; "Database Patch Set Update : 12.1.0.1.6 (19769486)"
 Bugs fixed:
 16406802, 16576250, 17605522, 16433745, 18439152, 16465158, 16523150
 18002100, 17830435, 16101465, 17316776, 16660558, 17797837, 16433540
 16462834, 16924879, 16842274, 16663465, 16465149, 18603606, 14010183
 16705020, 17912217, 14664684, 15921906, 17817656, 17040764, 17478145
 17039360, 19358317, 16991789, 17777061, 18148383, 16485876, 16787973
 17405549, 16433869, 18641419, 16715647, 17467075, 13771513, 16911800
 16456371, 18420490, 16712618, 17216406, 16825779, 19297295, 16921340
 17797453, 16443657, 16994576, 16479182, 17441661, 17465741, 16993424
 16788832, 16888264, 17437634, 14237793, 16910001, 16838328, 16689109
 17298973, 18126350, 16795944, 19554106, 19458377, 16512817, 16762985
 17596344, 17516005, 16524968, 16757934, 18641461, 16946613, 16978185
 16495802, 16543323, 19309466, 17171530, 16935643, 17308691, 17571945
 16782193, 17226980, 18641451, 17982838, 16855202, 16683859, 16619979
 17888553, 16173738, 17364702, 16837842, 17005047, 16772060, 20657441
 16710753, 14197853, 17205719, 17848854, 16459685, 17860549, 17976046
 17750832, 16347904, 17359546, 17080436, 17898041, 18155703, 18078926
 16007562, 16410570, 17551812, 17390431, 16856570, 16613964, 16802693
 19556045, 16061921, 18355572, 16551086, 17954431, 16668226, 17217040
 17600719, 17184677, 16527374, 20074391, 16228604, 16042673, 14576755
 17393683, 19006849, 17174582, 18393024, 17210416, 17000176, 18121501
 18348157, 16697600, 17436936, 17034172, 17762296, 16450169, 17019974
 17974104, 17898730, 18423374, 15994107, 15914210, 17289787, 16191248
 15986012, 16679874, 16570023, 17442449, 15905421, 15996344, 19866250
 16475788, 17489214, 17572525, 20296213, 16263492, 14595800, 15931910
 17608025, 17659488, 17753428, 19699191, 17391312, 17027533, 17311728
 20424899, 17753514, 18096714, 17897716, 16681689, 17478811, 16320173
 18554871, 16178562, 21273804, 16864562, 16362358, 16855292, 16039096
 17026503, 20299016, 18093615, 17324822, 18513099, 16872333, 16864359
 16698577, 17806676, 17867137, 20328279, 16850996, 16901482, 17182200
 17892268, 17257820, 16603924, 16930325, 16212405, 19248799, 16849982
 15987992, 16457621, 17443671, 16473934, 16913149, 18308576, 17158214
 18856947, 18889652, 16707927, 16275522, 14355775, 18099539, 16816103
 16912439, 16584684, 16517900, 16851772, 16859937, 16919176, 17349104
 16741246, 17537657, 16972213, 17552800, 18522516, 17341326, 17346196
 16928832, 20558005, 16087650, 16585173, 19049453, 17735933, 16796277
 16675739, 17273253, 13521413, 18061914, 17981677, 16822629, 16372203
 16845022, 8352043, 17174391, 17810688, 16977973, 16634384, 16672859
 16392068, 16863422, 18244962, 17037526, 17491753, 16682595, 16575931
 17260090, 18973907, 17490498, 17088068, 17330580, 19915271, 16195633
 16936008, 16181570, 17762256, 17721717, 16733884, 17534365, 18436307
 17983206, 16793174, 18092561, 17922172, 19121550, 17716565, 17446849
 16964686, 16617325, 17761775, 17461374, 16721594, 17179261, 18262334
 17610418, 18292893, 16902138, 17042658, 16483559, 15953721, 18229326
 16986421, 17305959, 16874123, 16769019, 17006570, 17032726, 16070351
 19197175, 16371304, 16964279, 16864864, 17249820, 19692901, 17446564
 17343514, 17325413, 17421502, 16170787, 17462687, 17362796, 17439871
 16730813, 20331945, 17883081, 17579911, 12911115, 18082092, 16347068
 17946998, 16313881, 16227068, 17997255, 17394724, 17443596, 16836849
 16969016, 14852021, 17716305, 17051636, 17244462, 19289642, 17767676
 17786278, 18189497, 17572720, 17082983, 16444683, 16621274, 16524071
 16709437, 14123213, 14506328, 16943711, 17710315, 13866822, 16503473
 16590848, 16784143, 16057129, 18031528, 16619249, 16589507, 16674666
 13782826, 19769486, 16790307, 16675710, 17828499, 16864048, 16694728
 16910734, 17614134, 17263661, 16448848, 17050888, 16286774, 20128874
 17280117, 18362376, 16427054, 16992075, 17016479, 16784167, 16663303
 16674842, 17468141, 18436647, 16186165, 14536110, 16946990, 17570606
 17235750, 16703112, 16784901, 17068536, 16929165
--------------------------------------------------------------------------------
OPatch succeeded.

Kontrola přes DBMS_QOPATCH

set heading off long 50000 pages 9999 lines 180 trims on tab off
select xmltransform(dbms_qopatch.get_opatch_count, dbms_qopatch.get_opatch_xslt) from dual;
select xmltransform(dbms_qopatch.get_opatch_list, dbms_qopatch.get_opatch_xslt) from dual;
select xmltransform(dbms_qopatch.get_pending_activity, dbms_qopatch.get_opatch_xslt) from dual;

set serverout on
exec dbms_qopatch.get_sqlpatch_status;

Output
Patch Id : 19769486
 Action : APPLY
 Action Time : 08-OCT-2015 08:33:37
 Description : bundle:PSU
 Logfile : /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/19769486/19769486_apply_ORCL_2015Oct08_08_32_51.log
 Status : SUCCESS

Patch Id : 20299016
 Action : APPLY
 Action Time : 08-OCT-2015 08:33:37
 Description : bundle:PSU
 Logfile : /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/20299016/20299016_apply_ORCL_2015Oct08_08_33_36.log
 Status : SUCCESS

Patch Id : 20831107
 Action : APPLY
 Action Time : 08-OCT-2015 08:33:37
 Description : bundle:PSU
 Logfile : /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/20831107/20831107_apply_ORCL_2015Oct08_08_33_37.log
 Status : SUCCESS

PL/SQL procedure successfully completed.

Kontrola přes dba_registry

SQL> column comments format a30
column action_time format a30
select comments, action_time from dba_registry_history where bundle_series like '%PSU' order by action_time;SQL> SQL> SQL>

COMMENTS ACTION_TIME
------------------------------ ------------------------------
Patchset 12.1.0.0.0 24-MAY-13 01.20.05.485655 PM
Patchset 12.1.0.0.0 03-OCT-15 09.31.26.228268 AM
PSU 12.1.0.1.8 08-OCT-15 08.33.36.702856 AM
PSU 12.1.0.1.8 08-OCT-15 08.33.37.116284 AM
PSU 12.1.0.1.8 08-OCT-15 08.33.37.503493 AM

ORACLE DBA

Tomáš Solař Consulting

Školení a kurzy

Publikace

Instalace Patch 21150806 – Combo of OJVM Component 12.1.0.1.4 DB PSU + DB PSU 12.1.0.1.8 (Jul2015)

Tomáš Solař – databázový administrátor Health check zdarma
DBA for reference Nezapomeňte patchovat Monitorování databáze Kontakt

Kontrola opatch

Kontrola konfliktů

Zastaveni databáze a listeneru

Analýze patche

Aplikuji pouze PSU

Loading Modified SQL Files into the Database

Kontrola

Kontrola přes DBMS_QOPATCH

Kontrola přes dba_registry

Komentáře

Kontakt

Zanechte mi telefon nebo e-mail a spojíme se!

databázový administrátor, konzultant a školitel

Tomáš Solař

Instalace Patch 21150806 – Combo of OJVM Component 12.1.0.1.4 DB PSU + DB PSU 12.1.0.1.8 (Jul2015)

Tomáš Solař – databázový administrátor Health check zdarma DBA for reference Nezapomeňte patchovat Monitorování databáze Kontakt

Kontrola opatch

Kontrola konfliktů

Zastaveni databáze a listeneru

Analýze patche

Aplikuji pouze PSU

Loading Modified SQL Files into the Database

Kontrola

Kontrola přes DBMS_QOPATCH

Kontrola přes dba_registry

Komentáře

Kontakt

Zanechte mi telefon nebo e-mail a spojíme se!

databázový administrátor, konzultant a školitel

Tomáš Solař

Tomáš Solař – databázový administrátor Health check zdarma
DBA for reference Nezapomeňte patchovat Monitorování databáze Kontakt