« Oracle 11gr2 : Problemas con ASM y Cluster Synchronization ServiceOracle 11gr1 : Índices INVISIBLES (INVISIBLE INDEX) »

Oracle 11gr2 : Aplicando nuestro primer PSU ABRIL 2010



Oracle lanzó el día de ayer , 13 de Abril su CPU correspondiente a Abril 2010 , en el vienen los típicos CPU, pero viene una cosa en especial que es un PSU para Oracle 11gr2

La información la puedes ver AQUÍ





En este CPU , viene para la 11gr2 (11.2.0.1) un CPU y un PSU , los 2 arreglan los mismos inconvenientes y esto viene consignado en cada uno de los README








Antes de comenzar con la instalación , debemos cerciorarnos que en nuestra variable de medio ambiente PATH ,tenemos acceso a los utilitarios make , ar , ld y nm

Por ejemplo, una forma de buscarlo es con el comando which

[oracle@oracle11g 9352237]$ which make
/usr/bin/make



Si es encontrado significa que está en el PATH

Además se debe colocar en el PATH la ruta donde se encuentra el OPATCH, para ello ejecutamos el siguiente comando

export PATH=$PATH:$ORACLE_HOME/OPatch



Se debe verificar la versión del OPatch, tiene que ser 11.2.0.1.0 o superior

Primero se debe verificar la versión que estemos utilizando

[oracle@oracle11g parches_11_2_1_0]$ opatch version
Invoking OPatch 11.1.0.6.6

OPatch Version: 11.1.0.6.6

OPatch succeeded.



Como no es la correspondiente , debemos bajarla desde Metalink , en la siguiente URL

Parche 6880880

E instalarla

[oracle@oracle11g parches_11_2_1_0]$ unzip p6880880_112000_LINUX.zip
Archive: p6880880_112000_LINUX.zip
creating: OPatch/
creating: OPatch/docs/
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
creating: OPatch/jlib/
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/jlib/opatchactions.jar
inflating: OPatch/jlib/opatchext.jar
inflating: OPatch/jlib/opatchfmw.jar
creating: OPatch/crs/
inflating: OPatch/crs/auto_patch.pl
inflating: OPatch/crs/crsconfig_lib.pm
inflating: OPatch/crs/crsdelete.pm
inflating: OPatch/crs/crspatch.pm
creating: OPatch/crs/log/
extracting: OPatch/crs/log/dummy
inflating: OPatch/crs/oracss.pm
inflating: OPatch/crs/patch112.pl
inflating: OPatch/crs/s_crsconfig_defs
inflating: OPatch/crs/s_crsconfig_lib.pm
creating: OPatch/fmw/
inflating: OPatch/fmw/application.py
inflating: OPatch/fmw/init_def.py
inflating: OPatch/fmw/main_driver.py
inflating: OPatch/fmw/node_manager.py
inflating: OPatch/fmw/prereq.py
inflating: OPatch/fmw/start_stop.py
creating: OPatch/opatchprereqs/
creating: OPatch/opatchprereqs/opatch/
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
creating: OPatch/opatchprereqs/oui/
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
inflating: OPatch/opatch.pl
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/README.txt
creating: OPatch/ocm/
creating: OPatch/ocm/bin/
inflating: OPatch/ocm/bin/emocmrsp
inflating: OPatch/ocm/ocm_platforms.txt
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/emocmclnt-14.jar
inflating: OPatch/ocm/lib/emocmutl.jar
inflating: OPatch/ocm/lib/osdt_core3.jar
inflating: OPatch/ocm/lib/osdt_jce.jar
extracting: OPatch/ocm/ocm.zip




Eliminamos la anterior versión

Copiamos la que descomprimimos y verificamos la versión actual de nuestro OPatch

[oracle@oracle11g parches_11_2_1_0]$ rm -rf $ORACLE_HOME/OPatch
[oracle@oracle11g parches_11_2_1_0]$ cp -R OPatch $ORACLE_HOME/.
[oracle@oracle11g parches_11_2_1_0]$
[oracle@oracle11g parches_11_2_1_0]$
[oracle@oracle11g parches_11_2_1_0]$ cd $ORACLE_HOME/OPatch
[oracle@oracle11g OPatch]$ ./opatch version
Invoking OPatch 11.2.0.1.2

OPatch Version: 11.2.0.1.2

OPatch succeeded.
[oracle@oracle11g OPatch]$




Después de lo anterior , podemos verificar que no haya problemas y/o conflictos con parches existentes, para ello ejecutamos el comando

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352237



OBS : Esto se debe hacer en la ruta donde se encuentra la carpeta del PSU

[oracle@oracle11g parches_11_2_1_0]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./9352237
Invoking OPatch 11.2.0.1.2

Installer de Parche Temporal de Oracle versión 11.2.0.1.2
Copyright (c) 2010, Oracle Corporation. Todos los Derechos Reservados.

PREREQ session

Directorio Raíz de Oracle : /u01/app/oracle/product/11.2.0/dbhome_1
Inventario Central: /u01/app/oracle/oraInventory
de : /etc/oraInst.loc
Versión de OPatch : 11.2.0.1.2
Versión de OUI : 11.2.0.1.0
Ubicación de OUI : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Ubicación de Archivo Log : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2010-04-13_13-32-28PM.log

Patch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.



Para instalar el PSU se debe bajar la instancia y bajar el listener

Estando dentro de la carpeta del PSU , se ejecuta opatch apply

cd 9352237
opatch apply



Invoking OPatch 11.2.0.1.2

Oracle Interim Patch Installer version 11.2.0.1.2
Copyright (c) 2010, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.2
OUI version : 11.2.0.1.0
OUI location : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2010-04-13_14-34-26PM.log

Patch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '9352237' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '9352237' for restore. This might take a while...
Backing up files affected by the patch '9352237' for rollback. This might take a while...
Execution of 'sh /home/oracle/parches_11_2_1_0/9352237/custom/scripts/pre -apply 9352237 ':

Return Code = 0

Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libpls11.a" with "lib/libpls11.a/phd.o"
....
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libcommon11.a" with "lib/libcommon11.a/kdzc.o"
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/libdbtools11.a" with "rdbms/lib/libdbtools11.a/krmq.o"

Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtamgt.plb"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlu112i.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlu112x.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catexp.sql"

Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kcc.o"
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kdt.o"
....
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libasmclnt11.a" with "lib/libasmclnt11.a/kgfn.o"
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libasmclnt11.a" with "lib/libasmclnt11.a/kgfo.o"

Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ktd.o"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/jox.o"
...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/psu/11.2.0.1.1/catpsu_rollback.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/bundledata_PSU.xml"

Patching component oracle.oraolap, 11.2.0.1.0...
Updating archive file "/u01/app/oracle/product/11.2.0/dbhome_1/lib/liboraolap11.a" with "lib/liboraolap11.a/xscarrot.o"

Patching component oracle.rdbms.deconfig, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libasmclnt11.so"

Patching component oracle.javavm.server, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/javavm/install/jvm_exp.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/javavm/install/initjvm.sql"
Copying file to "/u01/app/oracle/product/11.2.0/dbhome_1/javavm/install/jvmursc.sql"
Running make for target client_sharedlib
Running make for target irman
Running make for target ikfod
Running make for target irenamedg
Running make for target idgmgrl
Running make for target imkpatch
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '9352237' to inventory

Verifying the update...
Inventory check OK: Patch ID 9352237 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9352237 are present in Oracle Home.

--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Patch Set Update Installation (PSU Deinstallation) **
** is not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this PSU, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************

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

Execution of 'sh /home/oracle/parches_11_2_1_0/9352237/custom/scripts/post -apply 9352237 ':

Return Code = 0

The local system has been patched and can be restarted.

OPatch succeeded.



Una vez instalado el parche , se debe ejecutar lo siguiente

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT



Y cualquier error , se debe verificar en

$ORACLE_HOME/cfgtoollogs/catbundle/catbundle_PSU_ORCL11G2_APPLY_2010Apr13_15_11_49.log



Y como punto final vemos el catálogo de parchado , según el OPatch

opatch lsinventory



Y la nueva versión del motor

SQL> col comments format a20
SQL> r
1* select version , comments from registry$history

VERSION COMMENTS
------------------------------ --------------------
11.2.0.1 PSU 11.2.0.1.1



Y ya.. tenemos instalado nuestro primer PSU para Oracle11gr2

Espero que les sirva

by Ligarius
14.04.10. 15:13:25. 1548 words, 8195 views. Categories: Base de datos, Instalación, Oracle11gR2 ,