Passo a passo para aplicação do Release Update 12.2.0.1.170718

O Release Update 12.2.0.1.170718 é o Patch 25811364 (arquivo p25811364_122010_Linux-x86-64.zip).

Este é o primeiro RU (Release Update). Não é pouca coisa, veja que é necessário STARTUP UPGRADE, como era com PatchSet. Mas veja no lsinventory (último comando) que são poucos Bugs (para o Oracle).

Este abaixo é o procedimento para aplicação em Single Instance, e sem Grid Infrastructure.

Como sempre, baixe o último OPatch (arquivo p6880880_122010_Linux-x86-64.zip).

[oracle@nerv01 ~]$ unzip -q p6880880_122010_Linux-x86-64.zip
[oracle@nerv01 ~]$ rm -rf $ORACLE_HOME/OPatch.BACKUP
[oracle@nerv01 ~]$ mv $ORACLE_HOME/OPatch/ $ORACLE_HOME/OPatch.BACKUP
[oracle@nerv01 ~]$ mv /home/oracle/OPatch $ORACLE_HOME
[oracle@nerv01 ~]$ unzip -q p25811364_122010_Linux-x86-64.zip
[oracle@nerv01 ~]$ cd 25811364/
[oracle@nerv01 25811364]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2017-08-28_16-18-15PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   25811364

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.2.0.1/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '25811364' to OH '/u01/app/oracle/product/12.2.0.1/db_1'

Patching component oracle.javavm.server, 12.2.0.1.0...

Patching component oracle.javavm.server.core, 12.2.0.1.0...

Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...

Patching component oracle.rdbms, 12.2.0.1.0...
Patch 25811364 successfully applied.
Log file location: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2017-08-28_16-18-15PM_1.log

OPatch succeeded.
[oracle@nerv01 25811364]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 28-AUG-2017 16:24:31

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

Starting /u01/app/oracle/product/12.2.0.1/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/nerv01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nerv01.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nerv01.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                28-AUG-2017 16:24:37
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/nerv01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nerv01.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@nerv01 25811364]$ rlwrap sqlplus / AS SYSDBA

SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 28 16:24:44 2017

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

Connected to an idle instance.

16:26:44 SYS@ORCL> STARTUP UPGRADE;
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  8794848 bytes
Variable Size             603983136 bytes
Database Buffers         1526726656 bytes
Redo Buffers                7979008 bytes
Database mounted.
Database opened.
16:27:26 SYS@ORCL> ALTER PLUGGABLE DATABASE ALL OPEN UPGRADE;

Pluggable database altered.

Elapsed: 00:00:03.87
16:27:53 SYS@ORCL> EXIT;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@nerv01 25811364]$ cd $ORACLE_HOME/OPatch
[oracle@nerv01 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Mon Aug 28 16:28:10 2017
Copyright (c) 2012, 2017, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_24255_2017_08_28_16_28_10/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:
Patch 25811364 (OJVM RELEASE UPDATE: 12.2.0.1.170718 (25811364)):
  Installed in the binary registry only
Bundle series DBBP:
  ID 170620 in the binary registry and ID 170620 in PDB CDB$ROOT, ID 170620 in PDB PDB$SEED, ID 170620 in PDB PROD

Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PROD
    Nothing to roll back
    The following patches will be applied:
      25811364 (OJVM RELEASE UPDATE: 12.2.0.1.170718 (25811364))

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

Validating logfiles...
Patch 25811364 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25811364/21188920/25811364_apply_ORCL_CDBROOT_2017Aug28_16_29_24.log (no errors)
Patch 25811364 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25811364/21188920/25811364_apply_ORCL_PDBSEED_2017Aug28_16_29_24.log (no errors)
Patch 25811364 apply (pdb PROD): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25811364/21188920/25811364_apply_ORCL_PROD_2017Aug28_16_29_25.log (no errors)
SQL Patching tool complete on Mon Aug 28 16:29:26 2017
[oracle@nerv01 OPatch]$ rlwrap sqlplus / AS SYSDBA

SQL*Plus: Release 12.2.0.1.0 Production on Mon Aug 28 16:29:37 2017

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


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

16:29:37 SYS@ORCL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
16:30:12 SYS@ORCL> STARTUP
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  8794848 bytes
Variable Size             603983136 bytes
Database Buffers         1526726656 bytes
Redo Buffers                7979008 bytes
Database mounted.
Database opened.
16:30:53 SYS@ORCL> ALTER PLUGGABLE DATABASE ALL OPEN;

Pluggable database altered.

Elapsed: 00:00:00.51
16:32:01 SYS@ORCL> EXIT;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@nerv01 OPatch]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.2.0.1/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2017-08-28_16-32-11PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-08-28_16-32-11PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: nerv01.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

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


Interim patches (2) :

Patch  25811364     : applied on Mon Aug 28 16:19:41 BRT 2017
Unique Patch ID:  21188920
Patch description:  "OJVM RELEASE UPDATE: 12.2.0.1.170718 (25811364)"
   Created on 8 Jul 2017, 06:21:50 hrs PST8PDT
   Bugs fixed:
     25811105, 25890046, 26023042

Patch  25983138     : applied on Sun Jul 09 10:07:28 BRT 2017
Unique Patch ID:  21358214
Patch description:  "DATABASE BUNDLE PATCH: 12.2.0.1.170620 (25983138)"
   Created on 18 Jun 2017, 23:01:52 hrs PST8PDT
   Bugs fixed:
     23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
     25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
     25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
     25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
     24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
     24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
     25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
     25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017



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

OPatch succeeded.
[oracle@nerv01 OPatch]$

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *