Aplicar Parche Oracle Oracle Linux Opatch
Descargamos el parche del sitio del sitio oficial de Oracle
ejemplo parche numero 14283239
Este Patch corrige el Bug
Bugs Fixed by This Patch
---------------------------------
The following are the bugs fixed by this patch:
14283239: HIGH CPU FOR SQL REQUESTS WITH SYSAUTH$ INVOLVED
Copiamos el parche en el directorio ---> /home/oracle/14283239
Setear correctamente las variables de entorno
ORACLE_SID
ORACLE_BASE
ORACLE_HOME
verificamos la version de opatch, si es necesario se actualiza
opatch list
$ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
Bajamos la BD
Conectado a:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL> shutdown immediate;
Base de datos cerrada.
Base de datos desmontada.
Instancia ORACLE cerrada.
SQL>
Instalar el parche
$ORACLE_HOME/OPatch/opatch apply ./14283239
Installer de Parche Temporal de Oracle versión 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. Todos los Derechos Reservados.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/14283239_Jun_23_2017_14_36_16/apply2017-06-23_14-36-16PM_1.log
Applying interim patch '14283239' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Cierre las instancias Oracle que se estén ejecutando fuera de este ORACLE_HOME en el sistema local.
(Directorio Raíz de Oracle = '/u01/app/oracle/product/11.2.0/dbhome_1')
¿Está el sistema local listo para aplicarle un parche? [y|n]
y
User Responded with: Y
Backing up files...
Aplicando parche a componente oracle.rdbms, 11.2.0.4.0...
Verifying the update...
Patch 14283239 successfully applied
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/14283239_Jun_23_2017_14_36_16/apply2017-06-23_14-36-16PM_1.log
OPatch succeeded.
Verificamos que el parche quede bien instalado
$ORACLE_HOME/OPatch/opatch lsinventory
Installer de Parche Temporal de Oracle versión 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. Todos los Derechos Reservados.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-06-23_14-48-33PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-06-23_14-48-33PM.txt
--------------------------------------------------------------------------------
Productos de nivel superior instalados (1):
Oracle Database 11g 11.2.0.4.0
Hay 1 productos instalados en este directorio raíz de Oracle.
Parches temporales (1) :
Patch 14283239 : applied on Fri Jun 23 14:37:18 COT 2017
Unique Patch ID: 18393452
Created on 8 Jan 2015, 11:54:15 hrs PST8PDT
Bugs fixed:
14283239
--------------------------------------------------------------------------------
OPatch succeeded.
Subinmos la BD
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 23 15:03:14 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 7566139392 bytes
Fixed Size 2267992 bytes
Variable Size 1660945576 bytes
Database Buffers 5888802816 bytes
Redo Buffers 14123008 bytes
Base de datos montada.
Base de datos abierta.
SQL>