Aplikace PSU/CPU January 2014

Máte pochyby, zda externí DBA je pro Vás to pravé?

PRVNÍ MĚSÍC VZDÁLENÉ ADMINISTRACE ZDARMA. Čtěte více. Ověřte si, že daná spolupráce funguje.

Získáni patche

Patch Set Update and Critical Patch Update January 2014 Availability Document (Doc ID 1594621.1)
Patch 17552800: DATABASE PATCH SET UPDATE 12.1.0.1.2

Příprava prostředí

[oel64:oracle:orcl12c]$ ls -ltr
total 111564
-rw-r--r--. 1 oracle oinstall 69580299 Mar 27 07:11 p17552800_121010_Linux-x86-64.zip
[oel64:oracle:orcl12c]$ unzip p17552800_121010_Linux-x86-64.zip
[oel64:oracle:orcl12c]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Mar 27 07:16:35 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
[oel64:oracle:orcl12c]$ lsnrctl stop

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 27-MAR-2014 07:20:04

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[oel64:oracle:orcl12c]$ pwd
/home/oracle/17552800
[oel64:oracle:orcl12c]$ ls -ltr
total 84
-rw-r--r--. 1 oracle oinstall 21 Jan 3 12:21 README.txt
drwxr-xr-x. 3 oracle oinstall 4096 Jan 3 12:21 etc
drwxr-xr-x. 7 oracle oinstall 4096 Jan 3 12:21 files
-rw-rw-r--. 1 oracle oinstall 70222 Jan 14 10:32 README.html

Aplikace patche

[oel64:oracle:orcl12c]$ 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/17552800_Mar_27_2014_07_24_29/apply2014-03-27_07-24-29AM_1.log

Applying interim patch '17552800' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Verifying environment and performing prerequisite checks...
Patch 17552800: Optional component(s) missing : [ oracle.network.cman, 12.1.0.1.0 ]
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...

Patching component oracle.network.rsf, 12.1.0.1.0...

Patching component oracle.rdbms, 12.1.0.1.0...

Patching component oracle.rdbms.rsf, 12.1.0.1.0...

Patching component oracle.ldap.rsf, 12.1.0.1.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.1.0...

Patching component oracle.rdbms.util, 12.1.0.1.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...

Patching component oracle.rdbms.rman, 12.1.0.1.0...

Verifying the update...
Patch 17552800 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17552800_Mar_27_2014_07_24_29/apply2014-03-27_07-24-29AM_1.log

OPatch succeeded.

POST patch steps

[oel64:oracle:orcl12c]$ sqlplus / as sysdba
SQL> startup
..
Database mounted.
Database opened.
[oel64:oracle:orcl12c]$ lsnrctl start
...
Services Summary...
Service "orcl12c" has 1 instance(s).
 Instance "orcl12c", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oel64:oracle:orcl12c]$ cd $ORACLE_HOME/OPatch
[oel64:oracle:orcl12c]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Thu Mar 27 07:30:38 2014
Copyright (c) 2013, Oracle. All rights reserved.

Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
Currently installed C Patches: 17552800
Nothing to roll back
The following patches will be applied: 17552800
Adding patches to installation queue...
Installing patches...
Validating logfiles...
Patch 17552800 apply: SUCCESS
 logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17552800/17552800_apply_ORCL12C_orcl12c_2014Mar27_07_30_51.log (no errors)
 catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL12C_orcl12c_GENERATE_2014Mar27_07_30_52.log (no errors)
 catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL12C_orcl12c_APPLY_2014Mar27_07_30_54.log (no errors)
SQL Patching tool complete on Thu Mar 27 07:31:04 2014

Kontrola

OPATCH

[oel64:oracle:orcl12c]$ 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/opatch2014-03-27_07-32-38AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-27_07-32-38AM.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 17552800 : applied on Thu Mar 27 07:28:00 CET 2014
Unique Patch ID: 16974186
Patch description: "Database Patch Set Update : 12.1.0.1.2 (17552800)"
 Created on 3 Jan 2014, 03:21:20 hrs PST8PDT
 Bugs fixed:
 17034172, 16694728, 17439871, 16320173, 17082983, 16313881, 16715647
 17362796, 16450169, 16392068, 16977973, 14197853, 16712618, 17552800
 17922172, 17441661, 16524071, 16856570, 16410570, 16372203, 16849982
 16837842, 16459685, 16802693, 16978185, 16845022, 16195633, 14536110
 17579911, 16787973, 16850996, 17311728, 16838328, 16178562, 17244462
 16503473, 16935643, 14355775, 16362358, 16994576, 16928832, 16864359
 17080436, 16679874, 16788832, 16585173, 15986012, 14852021, 16191248
 17174391, 17249820, 16946990, 16589507, 16173738, 16874123, 16784143
 17343514, 17346196, 17324822, 16495802, 16859937, 16590848, 17068536
 16910001, 16527374, 16730813, 16663303, 16186165, 16675739, 16457621
 16170787, 16524968, 17032726, 16543323, 17005047, 17981677, 17442449
 16795944, 16668226, 16070351, 16698577, 17088068, 16621274, 17330580
 16888264, 16448848, 16863422, 16465158, 16634384, 17443671, 16816103
 16910734, 16911800, 16517900, 16825779, 17019974, 16707927, 16347904
 17263661, 17273253, 16902138, 17179261, 16465149, 17184677, 16689109
 16705020, 16864864, 16682595, 16972213, 16946613, 16721594, 16964279
 16855292, 17205719, 17026503, 16964686, 16674842, 16757934, 16864562
 15996344, 16842274, 17000176, 16769019, 17572525, 16485876, 16709437
 17289787, 16919176, 17217040, 16796277, 16462834, 16617325, 17308691
 16921340, 16784167, 16733884, 16483559, 16057129, 16822629, 16286774
 16660558, 17596344, 17570606, 16674666, 16697600, 16993424, 16772060
 16991789, 16790307, 16275522, 16603924, 16427054, 16227068, 16784901
 13521413, 16836849, 16007562, 16663465, 16551086, 17027533, 16675710
 16406802, 17465741, 17171530, 16523150, 16212405, 16741246, 16930325, 16443657
--------------------------------------------------------------------------------
OPatch succeeded.

dba_registry_sqlpatch

SQL> select PATCH_ID, STATUS, ACTION_TIME from dba_registry_sqlpatch;

PATCH_ID STATUS ACTION_TIME
---------- ---------- -------------------------------
 17552800 SUCCESS 27-MAR-14 07.31.03.985225 AM

dba_registry_history

SQL> select ACTION_TIME, VERSION, COMMENTS from dba_registry_history;

ACTION_TIME
---------------------------------------------------------------------------
VERSION
------------------------------
COMMENTS
--------------------------------------------------------------------------------
24-MAY-13 01.20.05.485655 PM
12.1.0.1
Patchset 12.1.0.0.0

05-NOV-13 02.15.02.596287 PM
12.1.0.1
Patchset 12.1.0.0.0

27-MAR-14 07.31.03.822438 AM
12.1.0.1
PSU 12.1.0.1.2

ORACLE DBA

Tomáš Solař Consulting

Školení a kurzy

Publikace

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

Získáni patche

Příprava prostředí

Aplikace patche

POST patch steps

Kontrola

OPATCH

dba_registry_sqlpatch

dba_registry_history

Komentáře

Kontakt

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

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

Tomáš Solař

Aplikace PSU/CPU January 2014

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

Získáni patche

Příprava prostředí

Aplikace patche

POST patch steps

Kontrola

OPATCH

dba_registry_sqlpatch

dba_registry_history

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