Check your OPatch Versión
[oracle@server1 16902043]$ /u01/app/oracle/product/11.2.0/db_ee_2/OPatch/opatch version OPatch Version: 11.2.0.3.4 [oracle@server1 16902043]$ $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_ee_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_ee_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-10-27_10-09-47AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 16902043 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. 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 This node is part of an Oracle Real Application Cluster. Remote nodes: 'server2' Local node: 'server1' Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/db_ee_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '16902043' to OH '/u01/app/oracle/product/11.2.0/db_ee_1' ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.ldap.rsf, 11.2.0.3.0... Patching component oracle.ldap.rsf.ic, 11.2.0.3.0... Patching component oracle.owb.rsf, 11.2.0.3.0... Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.rsf, 11.2.0.3.0... Patching component oracle.sysman.console.db, 11.2.0.3.0... Verifying the update... Patching in rolling mode. The node 'server2' will be patched next. Please shutdown Oracle instances running out of this ORACLE_HOME on 'server2'. (Oracle Home = '/u01/app/oracle/product/11.2.0/db_ee_1') Is the node ready for patching? [y|n] y User Responded with: Y Updating nodes 'server2' Apply-related files are: FP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_files.txt" DP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_dirs.txt" MP = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/make_cmds.txt" RC = "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/remote_cmds.txt" Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_files.txt" with actual path. Propagating files to remote nodes... Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/copy_dirs.txt" with actual path. Propagating directories to remote nodes... Instantiating the file "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/11.2.0/db_ee_1/.patch_storage/NApply/2013-10-27_10-09-47AM/rac/make_cmds.txt" with actual path. Running command on remote node 'server2': cd /u01/app/oracle/product/11.2.0/db_ee_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk irenamedg ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'server2': cd /u01/app/oracle/product/11.2.0/db_ee_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'server2': cd /u01/app/oracle/product/11.2.0/db_ee_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 Running command on remote node 'server2': cd /u01/app/oracle/product/11.2.0/db_ee_1/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_ee_1 || echo REMOTE_MAKE_FAILED::>&2 RC file not exist. There are no commands to be run on the remote nodes. The node 'server2' has been patched. You can restart Oracle instances on it. Composite patch 16902043 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/db_ee_1/cfgtoollogs/opatch/opatch2013-10-27_10-09-47AM_1.log OPatch succeeded.If you have done all above without any error you need upgrade you database itself. To do this load the catbundle.sql in your database.
[oracle@server1 db_ee_1]$ cd $ORACLE_HOME/rdbms/admin [oracle@server1 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 27 10:52:49 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @catbundle psu apply
Check the Logfile ($ORACLE_HOME/cfgtoollogs/catbundle/catbundle_PSU_DB11EE_APPLY_.log for any erros.
If you have also a RMAN catalog running remember to update it also.
As always, comments are welcome.
No hay comentarios:
Publicar un comentario