miércoles, 15 de julio de 2009

Primer PSU ya está disponible, instalémoslo!

Para complementar el Post anterior, les aviso que ya está disponible desde ayer el primer Patch Set Update, lo pueden encontrar en Metalink (My Oracle Support) como el Patch 8576156 - DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009). En este Post les indico cómo instalarlo, acompañenme en esta aventura.



Este Patch Set Update está disponible para las siguientes plataformas:
  • Sun Solaris SPARC (64-bit) / 21M
  • Linux x86 / 11M
  • Linux x86-64 / 16M
  • HP-UX PA-RISC(64-bit) / 18M
  • HP-UX Itanium / 30M
  • IBM AIX on POWER Systems (64-bit) /13M

Aproveché a descargar la versión para Linux x86 y al revisar los requisitos encontré el primer problema: debo tener el OPatch 10.2.0.4.7 o superior y en mi instalación tenía la versión 10.2.0.4.2. Esto me obligó a descargar la última versión, disponible como el Patch 6880880.


Con esto ya está superado el problema:

[oracle@urania ~]$ opatch version
Invoking OPatch 10.2.0.4.7

OPatch Version: 10.2.0.4.7

OPatch succeeded.

Todo listo para instalar el PSU, pero primero verificamos que no entre en conflicto con algún one-off patch previamente instalado.

[oracle@urania ~]$ cd 8576156
[oracle@urania 8576156]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir .
Invoking OPatch 10.2.0.4.7

Oracle Interim Patch Installer version 10.2.0.4.7
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/10.2.0/db_4
Central Inventory : /u01/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.7
OUI version       : 10.2.0.4.0
OUI location      : /u01/app/oracle/product/10.2.0/db_4/oui
Log file location : /u01/app/oracle/product/10.2.0/db_4/cfgtoollogs/opatch/opatch2009-07-15_12-41-59PM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_4/cfgtoollogs/opatch/opatch_history.txt

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Ahora bajamos la base de datos y aplicamos el PSU.

[oracle@urania 8576156]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jul 15 12:37:56 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@test> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@test> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@urania 8576156]$ opatch apply
Invoking OPatch 10.2.0.4.7

Oracle Interim Patch Installer version 10.2.0.4.7
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/10.2.0/db_4
Central Inventory : /u01/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.7
OUI version       : 10.2.0.4.0
OUI location      : /u01/app/oracle/product/10.2.0/db_4/oui
Log file location : /u01/app/oracle/product/10.2.0/db_4/cfgtoollogs/opatch/opatch2009-07-15_12-44-45PM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_4/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '8576156' to OH '/u01/app/oracle/product/10.2.0/db_4'

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/10.2.0/db_4')


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 '8576156' for restore. This might take a while...
Backing up files affected by the patch '8576156' for rollback. This might take a while...
Execution of 'sh /home/oracle/8576156/custom/scripts/pre -apply 8576156 ':


Return Code = 0

Patching component oracle.rdbms.rsf, 10.2.0.4.0...
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libgeneric10.a"  with "lib/libgeneric10.a/qcodfdef.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libgeneric10.a"  with "lib/libgeneric10.a/qcdo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libgeneric10.a"  with "lib/libgeneric10.a/qcdo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libgeneric10.a"  with "lib/libgeneric10.a/kghs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libgeneric10.a"  with "lib/libgeneric10.a/kgcc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libgeneric10.a"  with "lib/libgeneric10.a/kgh.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libcommon10.a"  with "lib/libcommon10.a/kd4.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libcommon10.a"  with "lib/libcommon10.a/kdb4.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libcommon10.a"  with "lib/libcommon10.a/kdr4.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libcommon10.a"  with "lib/libcommon10.a/kdr9ir24.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libcommon10.a"  with "lib/libcommon10.a/ttcpip.o"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataManager.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataReports.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaFileManager.class"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/lib/env_rdbms.mk"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/lib/rfsd.o"

Patching component oracle.rdbms.util, 10.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 10.2.0.4.0...
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtdefr.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtbpp.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtdmsu.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtbstr.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtsum.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtsms.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtjob.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtaqds.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtlmc.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtlmd.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtlsby.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/prvtbcap.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/dbmssum.sql"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/e1001000.sql"

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kupp.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kwqn.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ctc.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qccpu                  b.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kkxe.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kkxs.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kzvdv                  e.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/sldbg                  .o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdg.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kkz.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/updex                  e.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qerhj                  .o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ain.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qerlx                  t.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qkexr                  .o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/atb.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qol.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kksc.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qke.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kzrt.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/opipr                  s.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdl.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kxto.                  o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kaf.o                  "
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kaf9i                  r2.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kd9ir
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kd9ir2t.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdb9ir2o.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdblc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kds.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdst.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdst00.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdst01.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdst10.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdst11.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qertb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/nsoqbc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/vop.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kksl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/evar2v.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbz.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbw.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbv.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbk.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfafo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfcfg.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfipc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfmon.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfmon1.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfra.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrdb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrla.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrld.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrpa.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrpd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrst.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfrxpt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfsicd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfsl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfsx.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/rfupg.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knld.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kdt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ktu.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/koklm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kokeg.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvi.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvrda.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvu.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvx.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvxb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvxp.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvxr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvxs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knaha.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knahf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knahs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knals.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knasp.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knlc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knlcf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knlci.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ktuq.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krfr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krff.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kct.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kccr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kck.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcp.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcra.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcrf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcrfr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcrlc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcrp.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcrr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcv.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krfg.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krfw.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krsc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krsf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krsl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krsm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksct.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kspt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/tbsdrv.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/dbsdrv.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfgb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfk.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfk0.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kqf.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjfc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjfd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjfm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksp.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kslt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kji.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjbr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfcb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfcl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kfrb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kwqmn.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksu.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksq.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ktc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbz.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbw.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbv.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbk.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcbb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjbl.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksxp.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjdd.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjdr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjb.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kjbm.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcrfw.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kcs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/krvg.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/knld.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/prsc.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/prsg.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/prssz.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kzrt.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kpolon.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kxfx.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ktss.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/qertqo.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/kxfq.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libserver10.a"  with "lib/libserver10.a/ksws.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/rdbms/lib/libperfsrv10.a"  with "rdbms/lib/libperfsrv10.a/qcodfdef_PERF.o"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/cpu/view_recompile/recompile_precheck_jan2008cpu.sql"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/cpu/view_recompile/view_recompile_jan2008cpu.sql"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/psu/10.2.0.4.1/catpsu.sql"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/psu/10.2.0.4.1/catpsu_rollback.sql"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/bundledata_PSU.xml"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/catbundle.sql"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/lib/jox.o"

Patching component oracle.javavm.server, 10.2.0.4.0...
Copying file to "/u01/app/oracle/product/10.2.0/db_4/lib/libjox10.so"

Patching component oracle.sysman.repository.core, 10.2.0.4.0a...
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsg.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsgID.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/rsrcmgr/RsrcmgrMonController.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/MemoryController.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SessionDetailsController.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SitemapController.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/sesn/SessionDetails.class"

Patching component oracle.sysman.console.db, 10.2.0.4.0...
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_healthgif.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_healthgif$__jsp_StaticText.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_health.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_4/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_health$__jsp_StaticText.class"

Patching component oracle.ovm, 10.2.0.4.0...
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmctrg.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmadmb.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmadms.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmasrtb.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmltb.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmutlb.plb"
Copying file to "/u01/app/oracle/product/10.2.0/db_4/rdbms/admin/owmutls.plb"

Patching component oracle.network.rsf, 10.2.0.4.0...
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/lib/libn10.a"  with "lib/libn10.a/nacom.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/network/lib/libnlsnr10.a"  with "network/lib/libnlsnr10.a/nsglgr.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/network/lib/libnlsnr10.a"  with "network/lib/libnlsnr10.a/nsglro.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/network/lib/libnlsnr10.a"  with "network/lib/libnlsnr10.a/nsgcs.o"
Updating archive file "/u01/app/oracle/product/10.2.0/db_4/network/lib/libnlsnr10.a"  with "network/lib/libnlsnr10.a/nsglsn.o"

Patching component oracle.network.listener, 10.2.0.4.0...
Running make for target iextjob
Running make for target iextjobo
Running make for target client_sharedlib
Running make for target idgmgrl
Running make for target ioracle
Running make for target client_sharedlib
Running make for target itnslsnr
ApplySession adding interim patch '8576156' to inventory

Verifying the update...
Inventory check OK: Patch ID 8576156 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8576156 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/8576156/custom/scripts/post -apply 8576156 ':


Return Code = 0

The local system has been patched and can be restarted.


OPatch succeeded.

Hasta ahora todo va bien, pero falta un paso final, necesario para que el Scheduler funcione adecuadamente.

[oracle@urania 8576156]$ su root
Password:
[root@urania 8576156]# sh psu_root.sh
[root@urania 8576156]# exit

Proceso concluído, pero no hemos terminado, falta hacer la post instalación. Empezamos por ejecutar catbundle.sql, no olvidar revisar los logs para verificar que no hubieron errores.

[oracle@urania 8576156]$ cd $ORACLE_HOME/rdbms/admin
[oracle@urania admin]$ sqlplus / as sysdba
SYS@test> startup
SYS@test> @catbundle.sql psu apply
. . .
. . .
. . .
SYS@test> ALTER SESSION SET current_schema = SYS;

Session altered.

SYS@test> PROMPT Updating registry...
Updating registry...
SYS@test> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '10.2.0.4',
  9     1,
 10     'PSU',
 11     'PSU 10.2.0.4.1');

1 row created.

SYS@test> COMMIT;

Commit complete.

SYS@test> SPOOL off
SYS@test> SET echo off
Check the following log file for errors:
/u01/app/oracle/product/10.2.0/db_4/cfgtoollogs/catbundle/catbundle_PSU_TEST_APPLY_2009Jul15_13_13_44.log

SYS@test> exit

El paso final es recompilar las vistas de la base de datos, ojo que puede tomar bastantes minutos. Primero verificamos cuántos objetos se compilarán y luego ejecutamos la compilación en sí.

[oracle@urania admin]$ cd $ORACLE_HOME/cpu/view_recompile
[oracle@urania view_recompile]$ sqlplus / as sysdba
SYS@test> @recompile_precheck_jan2008cpu.sql

Running precheck.sql...


Number of views to be recompiled :2081
-----------------------------------------------------------------------

Number of objects to be recompiled :4171
Please follow the README.txt instructions for running viewrecomp.sql

PL/SQL procedure successfully completed.

SYS@test> exit

[oracle@urania ~]$ cd $ORACLE_HOME/cpu/view_recompile
[oracle@urania view_recompile]$ sqlplus / as sysdba
SYS@test> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@test> startup upgrade
ORACLE instance started.

Total System Global Area  247463936 bytes
Fixed Size                  1266848 bytes
Variable Size              96471904 bytes
Database Buffers          146800640 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.
SYS@test> @view_recompile_jan2008cpu.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

1 row created.

Commit complete.

No. of Invalid Objects is :1595
Please refer to README.html to for instructions on validating these objects

PL/SQL procedure successfully completed.

Logfile for the current viewrecomp.sql session is : vcomp_TEST_15Jul2009_13_23_16.log
SYS@test> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@test> startup
ORACLE instance started.

Total System Global Area  247463936 bytes
Fixed Size                  1266848 bytes
Variable Size             109054816 bytes
Database Buffers          134217728 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.
SYS@test> exit

Algunos objetos quedaron descompilados por lo que debemos ejecutar utlrp.sql para compilarlos.

[oracle@urania ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@urania admin]$ sqlplus / as sysdba
SYS@test> @utlrp.sql

TIMESTAMP
----------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2009-07-15 13:29:22

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
----------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2009-07-15 13:31:06


PL/SQL procedure successfully completed.

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0


PL/SQL procedure successfully completed.

De ser necesario habría que recompilar manualmente los objetos que hubiesen quedado descompilados. Con esto se ha concluído satisfactoriamente la instalación del primer PSU, contamos ahora con Oracle 10.2.0.4.1.

SYS@test> select version, comments from registry$history;

VERSION              COMMENTS
-------------------- --------------------
10.2.0.4             PSU 10.2.0.4.1

Si bien les he mostrado los pasos a seguir, esto no debe ser considerado un reemplazo del procedimiento formal indicado en el archivo Readme.html que acompaña a este PSU, hay procedimientos especiales para RAC por ejemplo, así que a ir leyendo la documentación y haciendo las pruebas del caso para que finalmente lo apliquen en sus ambientes de producción, suerte!

Post Relacionados:

¿Te pareció interesante este artículo?, ¿te quedaron algunas dudas?, ¿quieres sugerirme un tema a tratar?, pues déjame tus comentarios o envíame un email y para que NO te pierdas ningún Post, suscríbete por email ahora mismo!

7 comentarios, agrega el tuyo!

Anónimo dijo...

Enhorabuena por tu blog, si quieres puedes apuntarte al directorio web/blog www.cincolinks.com podrás promocionar tu web, con tu ficha y tus votaciones y valoraciones, con un método de intercambio de visitas llamado 5links! con el que tu blog será visitado tanto como visites a los demás y que harán que tu blog se de a conocer por toda la red. Pásate ;)

Creo que no hay muchos blogs de las características y temática del tuyo en este directorio, me gustaría mucho que participaras.


Saludos, espero verte por www.cincolinks.com.

Luis dijo...

Hola Enrique, primero agradecerte por compartir tu experencia sobre este tema. Tengo algunas consultas, estoy instalando un Oracle 10g al cual se le aplico el Patch 10.2.0.4. Luego actualize el PSU que haces mención en esta pagina. Y despues he creado la BD. Mi pregunta es si en esta BD que he creado es necesario aplicar la parte de "post instalación" que haces mención o que es necesario tomar en cuenta para la BD que he creado. Mi otra consulta se refiere a que si dispongo de una nueva instalación del Sw del Motor de Oracle (10.2.0.4) y para poder aplicar la ultima versión de PSU, es necesario aplicarlos los anteriores. Gracias. Saludos

Enrique Orbegozo dijo...

Hola Luis, si la base de datos la creaste despues de aplicar el PSU y fue creada de forma personalizada (sin usar las plantillas) entonces no tendrías que seguir los pasos de post instalación. Si usaste alguna de las plantillas que se basa en una base de datos pre-armada entonces sí porque estas han sido creadas antes de la aparición del PSU. Sobre lo segundo, el PSU lo puedes aplicar en cualquier momento, pero si tenias algunos one-off patches previamente instalados es posible que exista algún conflicto, que tendrías que resolver primero, quizas solicitando un merge patch, como tuve que hacer hace poco al aplicar el PSU1 sobre 11.1.0.7. Ah! dicho sea de paso ya está disponible el PSU2 para 10.2.0.4.
Saludos y gracias por participar.

Luis dijo...

Gracias Enrique por tu pronta respuesta. Probe en otro servidor instalar el 10gr2, luego el Patch 10.2.0.4 y finalmente el PSU (Enero 2010). Se creo la BD a traves del DBCA en forma customizada. Al realizar la consulta a la registry$history no retorno ningún registro, asi que tuve que aplicar los pasos posteriores. Al finalizar consulte nuevamente el registry$history y me aparecio lo sgte:
VERSION COMMENTS
10.2.0.4 PSU 10.2.0.4.3
view recompilation

Me imagino que esto ya me indica que el PSU se aplico correctamente.

Consulta: El aplicar este PSU (Enero 2010) se puede decir que dicha BD no necesita algun otro patch hasta la publicación del proximo PSU.

Saludos

Enrique Orbegozo dijo...

Luis, la documentación que acompaña a los PSU indica explícitamente que no es necesario seguir los pasos de post instalación para una base de datos nueva, salvo que haya sido creada a partir de una "sample database". Al consultar sobre registry$history no encontraste filas debido a que no hubo que parchar nada en la base de datos (no se ejecutó catbundle.sql), pues esta ya había sido creada con los ajustes del caso. No creo que al aplicar el PSU hayas dañado tu instalación pero no lo recomendaría. Finalmente, los PSU son solo un subconjunto de los patches existentes, así que si en tu instalación se presentan otros problemas es posible que requieras aplicar patches adicionales.
Saludos!

Juan dijo...

Hola Enrique, gracias por postear este tema que me ha ayudado a entender mucho acerca del PSU. quisiera preguntarte acerca del merge patch in unix ya que estoy aplicando un PSU y en el log de los prerequisitos tengo el siguiente mensaje "Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :" y me lista una cierta cantidad de parches.
Estaba pensando hacer rollback a los parches listados y aplicar el PSU. ¿Tu crees que funcione?. Por otro lado a que se refiere parches superset. Te agradeceria mucho tu ayuda
Juan

Enrique Orbegozo dijo...

Hola Juan, solo deben preocuparte los patches que aparecen como conflict, para ellos debes solicitar a Oracle Support que te proporcione un merge patch; los patches que aparecen como subset pueden ser ignorados debido a que se trata de una advertencia de que el patch que estas intentando aplicar ya los incluye.
Saludos!