This is my experience with the Patch 12311357 – 11.2.0.2.2 Patch Set Update Standalone grid infrastructure.
In my precedent post, article I have shown how to apply the Patch 12311357 in RAC environment.
1- Backup the database:
First of all, it-s recommended to backup your database with RMAN.
2- Update the Opatch version;
Make sure you have updated the Opatch with the latest version.
You can find the latest version in MOS document ID: 6880880
As grid user:
as grid user: -bash-3.2$ opatch version Invoking OPatch 11.2.0.1.1 OPatch Version: 11.2.0.1.1 OPatch succeeded. -bash-3.2$ ---Save copy of Old opatch version -bash-3.2$ su - Password: [root@srv05 grid]# cp -R /opt/11.2.0/grid/OPatch/ /opt/11.2.0/grid/OPatch.OLD/ The Opatch zip file name is: p6880880_112000_Linux-x86-64.zip [root@srv05 grid]# pwd /opt/11.2.0/grid [root@srv05 grid]# rm -rf OPatch [root@srv05 grid]# cp -R /opt/Linux_x86_64_11202/opatch/OPatch/ . [root@srv05 grid]# chown -R grid:oinstall /opt/11.2.0/grid/OPatch as grid user: -bash-3.2$ opatch version Invoking OPatch 11.2.0.1.5 OPatch Version: 11.2.0.1.5 OPatch succeeded. -bash-3.2$
3- OCM Configuration:
As grid user: -bash-3.2$ id uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),506(asmdba),507(asmoper) -bash-3.2$ -bash-3.2$ cd /home/grid/ => from a directory where grid user has write privilege. -bash-3.2$ /opt/11.2.0/grid/OPatch/ocm/bin/emocmrsp OCM Installation Response Generator 10.3.4.0.0 - Production Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved. 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 The OCM configuration response file (ocm.rsp) was successfully created. Validate the Oracle Inventury:
4- Validation of Oracle Inventory
Before beginning patch application, check the consistency of inventory information for GI home and the database home to be patched. Run the following command as respective Oracle home owner to check the consistency.
-bash-3.2$ /opt/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/11.2.0/grid Invoking OPatch 11.2.0.1.5 Oracle Interim Patch Installer version 11.2.0.1.5 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /opt/11.2.0/grid Central Inventory : /a01/app/oraInventory/ from : /etc/oraInst.loc OPatch version : 11.2.0.1.5 OUI version : 11.2.0.2.0 OUI location : /opt/11.2.0/grid/oui Log file location : /opt/11.2.0/grid/cfgtoollogs/opatch/opatch2011-07-10_23-40-19PM.log Patch history file: /opt/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt Lsinventory Output file location : /opt/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2011-07-10_23-40-19PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Grid Infrastructure 11.2.0.2.0 There are 1 products installed in this Oracle Home. Installed Products (88): Agent Required Support Files 10.2.0.4.3 Assistant Common Files 11.2.0.2.0 Automatic Storage Management Assistant 11.2.0.2.0 Bali Share 1.1.18.0.0 Buildtools Common Files 11.2.0.2.0 Character Set Migration Utility 11.2.0.2.0 Cluster Ready Services Files 11.2.0.2.0 Cluster Verification Utility Common Files 11.2.0.2.0 Cluster Verification Utility Files 11.2.0.2.0 Database SQL Scripts 11.2.0.2.0 Deinstallation Tool 11.2.0.2.0 Enterprise Manager Common Core Files 10.2.0.4.3 Enterprise Manager Common Files 10.2.0.4.3 Enterprise Manager plugin Common Files 11.2.0.2.0 Expat libraries 2.0.1.0.1 HAS Common Files 11.2.0.2.0 HAS Files for DB 11.2.0.2.0 Installation Common Files 11.2.0.2.0 Installation Plugin Files 11.2.0.2.0 Installer SDK Component 11.2.0.2.0 LDAP Required Support Files 11.2.0.2.0 OLAP SQL Scripts 11.2.0.2.0 Oracle Clusterware RDBMS Files 11.2.0.2.0 Oracle Configuration Manager Deconfiguration 10.3.1.0.0 Oracle Containers for Java 11.2.0.2.0 Oracle Core Required Support Files 11.2.0.2.0 Oracle Database 11g 11.2.0.2.0 Oracle Database 11g Multimedia Files 11.2.0.2.0 Oracle Database Deconfiguration 11.2.0.2.0 Oracle Database User Interface 2.2.13.0.0 Oracle Database Utilities 11.2.0.2.0 Oracle DBCA Deconfiguration 11.2.0.2.0 Oracle Extended Windowing Toolkit 3.4.47.0.0 Oracle Globalization Support 11.2.0.2.0 Oracle Globalization Support 11.2.0.2.0 Oracle Grid Infrastructure 11.2.0.2.0 Oracle Help For Java 4.2.9.0.0 Oracle Ice Browser 5.2.3.6.0 Oracle Internet Directory Client 11.2.0.2.0 Oracle Java Client 11.2.0.2.0 Oracle JDBC/OCI Instant Client 11.2.0.2.0 Oracle JDBC/THIN Interfaces 11.2.0.2.0 Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 Oracle JVM 11.2.0.2.0 Oracle LDAP administration 11.2.0.2.0 Oracle Locale Builder 11.2.0.2.0 Oracle Multimedia 11.2.0.2.0 Oracle Multimedia Client Option 11.2.0.2.0 Oracle Multimedia Java Advanced Imaging 11.2.0.2.0 Oracle Multimedia Locator 11.2.0.2.0 Oracle Multimedia Locator RDBMS Files 11.2.0.2.0 Oracle Net 11.2.0.2.0 Oracle Net Listener 11.2.0.2.0 Oracle Net Required Support Files 11.2.0.2.0 Oracle Netca Client 11.2.0.2.0 Oracle Notification Service 11.2.0.2.0 Oracle Notification Service (eONS) 11.2.0.2.0 Oracle One-Off Patch Installer 11.2.0.0.2 Oracle Quality of Service Management (Client) 11.2.0.2.0 Oracle Quality of Service Management (Server) 11.2.0.2.0 Oracle RAC Deconfiguration 11.2.0.2.0 Oracle RAC Required Support Files-HAS 11.2.0.2.0 Oracle Recovery Manager 11.2.0.2.0 Oracle Security Developer Tools 11.2.0.2.0 Oracle Text Required Support Files 11.2.0.2.0 Oracle Universal Installer 11.2.0.2.0 Oracle USM Deconfiguration 11.2.0.2.0 Oracle Wallet Manager 11.2.0.2.0 Parser Generator Required Support Files 11.2.0.2.0 Perl Interpreter 5.10.0.0.1 Perl Modules 5.10.0.0.1 PL/SQL 11.2.0.2.0 PL/SQL Embedded Gateway 11.2.0.2.0 Platform Required Support Files 11.2.0.2.0 Precompiler Required Support Files 11.2.0.2.0 RDBMS Required Support Files 11.2.0.2.0 RDBMS Required Support Files for Instant Client 11.2.0.2.0 RDBMS Required Support Files Runtime 11.2.0.2.0 Required Support Files 11.2.0.2.0 Secure Socket Layer 11.2.0.2.0 SQL*Plus 11.2.0.2.0 SQL*Plus Files for Instant Client 11.2.0.2.0 SQL*Plus Required Support Files 11.2.0.2.0 SSL Required Support Files for InstantClient 11.2.0.2.0 Sun JDK 1.5.0.24.08 Universal Storage Manager Files 11.2.0.2.0 XDK Required Support Files 11.2.0.2.0 XML Parser for Java 11.2.0.2.0 There are 88 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. -bash-3.2$
5- Patch Grid home:
You can have the following issue if you try this command:
as a root user:
issue:
[root@srv05 patches]# /opt/11.2.0/grid/OPatch/opatch auto /opt/Linux_x86_64_11202/patches/ -oh /opt/11.2.0/grid Executing /usr/bin/perl /opt/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /opt/Linux_x86_64_11202 -patchn patches -oh /opt/11.2.0/grid -paramfile /opt/11.2.0/grid/crs/install/crsconfig_params opatch auto log file location is /opt/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-07-11_00-33-41.log Detected Oracle Restart install Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params OPatch is bundled with OCM, Enter the absolute OCM response file path: /home/grid/ocm.rsp The opatch minimum version check for patch /opt/Linux_x86_64_11202/patches/12311357 failed for /opt/11.2.0/grid The opatch minimum version check for patch /opt/Linux_x86_64_11202/patches/11724916 failed for /opt/11.2.0/grid Opatch version check failed for oracle home /opt/11.2.0/grid Opatch version check failed update the opatch version for the failed homes and retry
To fix the issue:
-rw-r--r-- 1 grid oinstall 621 Jul 10 23:25 ocm.rsp -bash-3.2$ chmod 666 * -bash-3.2$ ls -rl total 4 -rw-rw-rw- 1 grid oinstall 621 Jul 10 23:25 ocm.rsp
Now, run again the same command to patch the grid infrastructure home:
As a root user:
[root@srv05 ~]# /opt/11.2.0/grid/OPatch/opatch auto /opt/Linux_x86_64_11202/patches/ -oh /opt/11.2.0/grid Executing /usr/bin/perl /opt/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /opt/Linux_x86_64_11202 -patchn patches -oh /opt/11.2.0/grid -paramfile /opt/11.2.0/grid/crs/install/crsconfig_params opatch auto log file location is /opt/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-07-11_00-40-17.log Detected Oracle Restart install Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params OPatch is bundled with OCM, Enter the absolute OCM response file path: /home/grid/ocm.rsp Successfully unlock /opt/11.2.0/grid patch /opt/Linux_x86_64_11202/patches/12311357 apply successful for home /opt/11.2.0/grid patch /opt/Linux_x86_64_11202/patches/11724916 apply successful for home /opt/11.2.0/grid ACFS-9300: ADVM/ACFS distribution files found. ACFS-9312: Existing ADVM/ACFS installation detected. ACFS-9314: Removing previous ADVM/ACFS installation. ACFS-9315: Previous ADVM/ACFS components successfully removed. ACFS-9307: Installing requested ADVM/ACFS software. ACFS-9308: Loading installed ADVM/ACFS drivers. ACFS-9321: Creating udev for ADVM/ACFS. ACFS-9323: Creating module dependencies - this may take some time. ACFS-9327: Verifying ADVM/ACFS devices. ACFS-9309: ADVM/ACFS installation correctness verified. CRS-4123: Oracle High Availability Services has been started. [root@srv05 ~]#
6- Patch Oracle database home:
Make a copy of the OPatch directory.
As oracle user:
-bash-3.2$ echo $ORACLE_HOME /opt/app/oracle/product/11.2.0/db_1 -bash-3.2$ cd /opt/app/oracle/product/11.2.0/db_1/OPatch/ -bash-3.2$ ls -rtl total 80 -rw-r--r-- 1 oracle oinstall 2590 Dec 14 2009 opatch.pl -rw-r--r-- 1 oracle oinstall 23695 Dec 14 2009 emdpatch.pl -rwxr-xr-x 1 oracle oinstall 22150 Feb 14 2010 opatch drwxr-xr-x 4 oracle oinstall 4096 Jun 26 12:46 opatchprereqs drwxr-xr-x 2 oracle oinstall 4096 Jun 26 12:46 ocm drwxr-xr-x 2 oracle oinstall 4096 Jun 26 12:46 jlib drwxr-xr-x 2 oracle oinstall 4096 Jun 26 12:46 fmw drwxr-xr-x 2 oracle oinstall 4096 Jun 26 12:46 docs drwxr-xr-x 3 oracle oinstall 4096 Jun 26 12:46 crs -rw-r--r-- 1 oracle oinstall 49 Jun 26 12:46 opatch.ini -bash-3.2$ cd .. -bash-3.2$ cp -R ./OPatch/ ./OPatch.OLD AS Oracle user: -bash-3.2$ opatch version Invoking OPatch 11.2.0.1.5 OPatch Version: 11.2.0.1.5 OPatch succeeded. -bash-3.2$
Create the Oracle configuration file:
As root user:
[root@srv05 db_1]# /opt/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp OCM Installation Response Generator 10.3.4.0.0 - Production Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved. 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 The OCM configuration response file (ocm.rsp) was successfully created. [root@srv05 db_1]#
As Oracle user:
-bash-3.2$ /opt/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory -detail -oh /opt/app/oracle/product/11.2.0/db_1 Invoking OPatch 11.2.0.1.5 Oracle Interim Patch Installer version 11.2.0.1.5 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /opt/app/oracle/product/11.2.0/db_1 Central Inventory : /a01/app/oraInventory/ from : /etc/oraInst.loc OPatch version : 11.2.0.1.5 OUI version : 11.2.0.2.0 OUI location : /opt/app/oracle/product/11.2.0/db_1/oui Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatc h2011-07-11_00-52-53AM.log Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatc h_history.txt Lsinventory Output file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollo gs/opatch/lsinv/lsinventory2011-07-11_00-52-53AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.2.0 There are 1 products installed in this Oracle Home. Installed Products (136): Agent Required Support Files 10.2.0.4.3 Assistant Common Files 11.2.0.2.0 Bali Share 1.1.18.0.0 Buildtools Common Files 11.2.0.2.0 Character Set Migration Utility 11.2.0.2.0 Cluster Verification Utility Common Files 11.2.0.2.0 Database Configuration and Upgrade Assistants 11.2.0.2.0 Database SQL Scripts 11.2.0.2.0 Database Workspace Manager 11.2.0.2.0 Deinstallation Tool 11.2.0.2.0 Enterprise Edition Options 11.2.0.2.0 Enterprise Manager Agent 10.2.0.4.3 Enterprise Manager Agent Core Files 10.2.0.4.3 Enterprise Manager Common Core Files 10.2.0.4.3 Enterprise Manager Common Files 10.2.0.4.3 Enterprise Manager Database Plugin -- Agent Support 11.2.0.2.0 Enterprise Manager Database Plugin -- Repository Support 11.2.0.2.0 Enterprise Manager Grid Control Core Files 10.2.0.4.3 Enterprise Manager plugin Common Files 11.2.0.2.0 Enterprise Manager Repository Core Files 10.2.0.4.3 Exadata Storage Server 11.2.0.1.0 Expat libraries 2.0.1.0.1 Generic Connectivity Common Files 11.2.0.2.0 HAS Common Files 11.2.0.2.0 HAS Files for DB 11.2.0.2.0 Installation Common Files 11.2.0.2.0 Installation Plugin Files 11.2.0.2.0 Installer SDK Component 11.2.0.2.0 JAccelerator (COMPANION) 11.2.0.2.0 LDAP Required Support Files 11.2.0.2.0 OLAP SQL Scripts 11.2.0.2.0 Oracle 11g Warehouse Builder Required Files 11.2.0.2.0 Oracle Advanced Security 11.2.0.2.0 Oracle Application Express 11.2.0.2.0 Oracle Call Interface (OCI) 11.2.0.2.0 Oracle Clusterware RDBMS Files 11.2.0.2.0 Oracle Code Editor 1.2.1.0.0I Oracle Configuration Manager 10.3.3.1.1 Oracle Configuration Manager Client 10.3.2.1.0 Oracle Configuration Manager Deconfiguration 10.3.1.0.0 Oracle Containers for Java 11.2.0.2.0 Oracle Core Required Support Files 11.2.0.2.0 Oracle Data Mining RDBMS Files 11.2.0.2.0 Oracle Database 11g 11.2.0.2.0 Oracle Database 11g 11.2.0.2.0 Oracle Database 11g Multimedia Files 11.2.0.2.0 Oracle Database Deconfiguration 11.2.0.2.0 Oracle Database Gateway for ODBC 11.2.0.2.0 Oracle Database User Interface 2.2.13.0.0 Oracle Database Utilities 11.2.0.2.0 Oracle Database Vault J2EE Application 11.2.0.2.0 Oracle Database Vault option 11.2.0.2.0 Oracle DBCA Deconfiguration 11.2.0.2.0 Oracle Display Fonts 9.0.2.0.0 Oracle Enterprise Manager Console DB 11.2.0.2.0 Oracle Extended Windowing Toolkit 3.4.47.0.0 Oracle Globalization Support 11.2.0.2.0 Oracle Globalization Support 11.2.0.2.0 Oracle Help For Java 4.2.9.0.0 Oracle Help for the Web 2.0.14.0.0 Oracle Ice Browser 5.2.3.6.0 Oracle Internet Directory Client 11.2.0.2.0 Oracle Java Client 11.2.0.2.0 Oracle JDBC Server Support Package 11.2.0.2.0 Oracle JDBC/OCI Instant Client 11.2.0.2.0 Oracle JDBC/THIN Interfaces 11.2.0.2.0 Oracle JFC Extended Windowing Toolkit 4.2.36.0.0 Oracle JVM 11.2.0.2.0 Oracle Label Security 11.2.0.2.0 Oracle LDAP administration 11.2.0.2.0 Oracle Locale Builder 11.2.0.2.0 Oracle Message Gateway Common Files 11.2.0.2.0 Oracle Multimedia 11.2.0.2.0 Oracle Multimedia Annotator 11.2.0.2.0 Oracle Multimedia Client Option 11.2.0.2.0 Oracle Multimedia Java Advanced Imaging 11.2.0.2.0 Oracle Multimedia Locator 11.2.0.2.0 Oracle Multimedia Locator RDBMS Files 11.2.0.2.0 Oracle Net 11.2.0.2.0 Oracle Net Listener 11.2.0.2.0 Oracle Net Required Support Files 11.2.0.2.0 Oracle Net Services 11.2.0.2.0 Oracle Netca Client 11.2.0.2.0 Oracle Notification Service 11.2.0.2.0 Oracle Notification Service (eONS) 11.2.0.2.0 Oracle ODBC Driver 11.2.0.2.0 Oracle ODBC Driverfor Instant Client 11.2.0.2.0 Oracle OLAP 11.2.0.2.0 Oracle OLAP API 11.2.0.2.0 Oracle OLAP RDBMS Files 11.2.0.2.0 Oracle One-Off Patch Installer 11.2.0.0.2 Oracle Partitioning 11.2.0.2.0 Oracle Programmer 11.2.0.2.0 Oracle Quality of Service Management (Client) 11.2.0.2.0 Oracle RAC Deconfiguration 11.2.0.2.0 Oracle RAC Required Support Files-HAS 11.2.0.2.0 Oracle Real Application Testing 11.2.0.2.0 Oracle Recovery Manager 11.2.0.2.0 Oracle Security Developer Tools 11.2.0.2.0 Oracle Spatial 11.2.0.2.0 Oracle SQL Developer 11.2.0.2.0 Oracle Starter Database 11.2.0.2.0 Oracle Text 11.2.0.2.0 Oracle Text Required Support Files 11.2.0.2.0 Oracle UIX 2.2.24.6.0 Oracle Universal Connection Pool 11.2.0.2.0 Oracle Universal Installer 11.2.0.2.0 Oracle USM Deconfiguration 11.2.0.2.0 Oracle Wallet Manager 11.2.0.2.0 Oracle XML Development Kit 11.2.0.2.0 Oracle XML Query 11.2.0.2.0 Parser Generator Required Support Files 11.2.0.2.0 Perl Interpreter 5.10.0.0.1 Perl Modules 5.10.0.0.1 PL/SQL 11.2.0.2.0 PL/SQL Embedded Gateway 11.2.0.2.0 Platform Required Support Files 11.2.0.2.0 Precompiler Common Files 11.2.0.2.0 Precompiler Required Support Files 11.2.0.2.0 Provisioning Advisor Framework 10.2.0.4.3 RDBMS Required Support Files 11.2.0.2.0 RDBMS Required Support Files for Instant Client 11.2.0.2.0 RDBMS Required Support Files Runtime 11.2.0.2.0 regexp 2.1.9.0.0 Required Support Files 11.2.0.2.0 Sample Schema Data 11.2.0.2.0 Secure Socket Layer 11.2.0.2.0 SQL*Plus 11.2.0.2.0 SQL*Plus Files for Instant Client 11.2.0.2.0 SQL*Plus Required Support Files 11.2.0.2.0 SQLJ Runtime 11.2.0.2.0 SSL Required Support Files for InstantClient 11.2.0.2.0 Sun JDK 1.5.0.24.08 XDK Required Support Files 11.2.0.2.0 XML Parser for Java 11.2.0.2.0 XML Parser for Oracle JVM 11.2.0.2.0 There are 136 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. -bash-3.2$
Make sure the database instance is down;
-bash-3.2$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon Jul 11 00:55:02 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance. SYS@db02 AS SYSDBA> SYS@db02 AS SYSDBA> exit Disconnected -bash-3.2$
You may face the following error, when you try to patch the Oracle database home
As Oracle user:
-bash-3.2$ opatch napply -oh /opt/app/oracle/product/11.2.0/db_1 -local /opt/Linux_x86_64_11202/patches/12311357 Invoking OPatch 11.2.0.1.5 Oracle Interim Patch Installer version 11.2.0.1.5 Copyright (c) 2010, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /opt/app/oracle/product/11.2.0/db_1 Central Inventory : /opt/Linux_x86_64_11202/orainventorylogs_20110711/oraInventory/ from : /etc/oraInst.loc OPatch version : 11.2.0.1.5 OUI version : 11.2.0.2.0 OUI location : /opt/app/oracle/product/11.2.0/db_1/oui Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-07-11_02-08-35AM.log Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt Invoking utility "napply" Checking conflict among patches... Checking if Oracle Home has components required by patches... UtilSession failed: Patch 12311357 requires component(s) that are not installed in OracleHome. These not-installed components are oracle.crs:11.2.0.2.0, oracle.usm:11.2.0.2.0, OPatch failed with error code 73 -bash-3.2$
To fix the issue, you should run the following command:
AS Oracle user:
-bash-3.2$ /opt/Linux_x86_64_11202/patches/12311357/custom/scripts/prepatch.sh -dbhome /opt/app/oracle/product/11.2.0/db_1
./prepatch.sh completed successfully.
-bash-3.2$
As oracle user:
-bash-3.2$ opatch napply -oh /opt/app/oracle/product/11.2.0/db_1 -local /opt/Linux_x86_64_11202/patches/12311357/custom/server/12311357/
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswar.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswcs.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswd.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswdk.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswe.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswel.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswf.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswhu.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswi.msb"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/has/mesg/clswiw.msb"
....
....
Copying file to "/opt/app/oracle/product/11.2.0/db_1/oui/jlib/srvmasm.jar"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/oui/lib/linux/libsrvm11.so"
ApplySession adding interim patch '12311357' to inventory
Verifying the update...
Inventory check OK: Patch ID 12311357 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 12311357 are present in Oracle Home.
Running make for target install_srvm
Running make for target install
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
-bash-3.2$
-bash-3.2$ opatch napply -oh /opt/app/oracle/product/11.2.0/db_1 -local /opt/Linux_x86_64_11202/patches/11724916/
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/Linux_x86_64_11202/orainventorylogs_20110711/oraInventory/
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/app/oracle/product/11.2.0/db_1/oui
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-07-11_20-50-24PM.log
Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches: 11724916
Do you want to proceed? [y|n]
y
User Responded with: Y
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
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/app/oracle/product/11.2.0/db_1')
Is the local system ready for patching? [y|n]
y
.....
.....
Updating archive file "/opt/app/oracle/product/11.2.0/db_1/lib/libzt11.a" with "lib/libzt11.a/nzdacval.o"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/lib/libnnz11.so"
Patching component oracle.rdbms.dv, 11.2.0.2.0...
Copying file to "/opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catmacd.sql"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catmacpatch.sql"
Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...
Copying file to "/opt/app/oracle/product/11.2.0/db_1/rdbms/admin/c1101000.sql"
Copying file to "/opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catupstr.sql"
ApplySession adding interim patch '11724916' to inventory
Verifying the update...
Inventory check OK: Patch ID 11724916 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 11724916 are present in Oracle Home.
Running make for target client_sharedlib
Running make for target client_sharedlib
Running make for target ioracle
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
-bash-3.2$
as oracle user:
-bash-3.2$ /opt/Linux_x86_64_11202/patches/12311357/custom/scripts/postpatch.sh -dbhome /opt/app/oracle/product/11.2.0/db_1
Reading /opt/app/oracle/product/11.2.0/db_1/install/params.ora..
Reading /opt/app/oracle/product/11.2.0/db_1/install/params.ora..
Parsing file /opt/app/oracle/product/11.2.0/db_1/bin/racgwrap
Parsing file /opt/app/oracle/product/11.2.0/db_1/bin/srvctl
Parsing file /opt/app/oracle/product/11.2.0/db_1/bin/srvconfig
Parsing file /opt/app/oracle/product/11.2.0/db_1/bin/cluvfy
Verifying file /opt/app/oracle/product/11.2.0/db_1/bin/racgwrap
Verifying file /opt/app/oracle/product/11.2.0/db_1/bin/srvctl
Verifying file /opt/app/oracle/product/11.2.0/db_1/bin/srvconfig
Verifying file /opt/app/oracle/product/11.2.0/db_1/bin/cluvfy
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/racgwrap
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/srvctl
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/srvconfig
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/cluvfy
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/diskmon.bin
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/lsnodes
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/osdbagrp
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/rawutl
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/gnsd
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/bin/crsdiag.pl
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libhasgen11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libclsra11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libocr11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libocrb11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libocrutl11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libuini11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/librdjni11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libgns11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libgnsjni11.so
Reapplying file permissions on /opt/app/oracle/product/11.2.0/db_1/lib/libagfw11.so
-bash-3.2$
AS Oracle user:
-bash-3.2$ opatch lsinventory -detail -oh $ORACLE_HOME
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/Linux_x86_64_11202/orainventorylogs_20110711/oraInventory/
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/app/oracle/product/11.2.0/db_1/oui
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-07-11_20-56-40PM.log
Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-07-11_20-56-40PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.2.0
There are 1 products installed in this Oracle Home.
................
racle ODBC Driver 11.2.0.2.0
Oracle ODBC Driverfor Instant Client 11.2.0.2.0
Oracle OLAP 11.2.0.2.0
Oracle OLAP API 11.2.0.2.0
Oracle OLAP RDBMS Files 11.2.0.2.0
Oracle One-Off Patch Installer 11.2.0.0.2
Oracle Partitioning 11.2.0.2.0
Oracle Programmer 11.2.0.2.0
Oracle Quality of Service Management (Client) 11.2.0.2.0
Oracle RAC Deconfiguration 11.2.0.2.0
Oracle RAC Required Support Files-HAS 11.2.0.2.0
..............
There are 136 products installed in this Oracle Home.
Interim patches (2) :
Patch 11724916 : applied on Mon Jul 11 20:51:30 CEST 2011
Unique Patch ID: 13762085
Created on 1 Apr 2011, 07:09:05 hrs PST8PDT
Bugs fixed:
10151017, 10158965, 11724916, 10190642, 10129643, 10018789, 9744252
10248523, 9956713, 10356513, 9715581, 9770451, 10170431, 10425676
10222719, 9591812, 10127360, 10094201, 11069199, 10245086, 10205230
10052141, 11818335, 11830776, 11830777, 9905049, 11830778, 10077191
10358019, 10219576, 10264680, 10209232, 10102506, 11067567, 9881076
10040531, 10218814, 9788588, 9735237, 10230571, 10079168, 10228151
10013431, 10217802, 10238786, 10052956, 11699057, 10080579, 10332111
10227288, 10329146, 10332589, 10110863, 10073683, 10019218, 10229719
10373381, 11724984, 9539440, 10411618, 10022980, 10187168, 6523037
9724970, 10084145, 10157402, 9651350, 10299224
Files Touched:
/kgl2.o --> ORACLE_HOME/lib/libgeneric11.a
/kgh.o --> ORACLE_HOME/lib/libgeneric11.a
/kgx.o --> ORACLE_HOME/lib/libgeneric11.a
/kgl.o --> ORACLE_HOME/lib/libgeneric11.a
oraus.msb --> ORACLE_HOME/rdbms/mesg/oraus.msb
oraus.msg --> ORACLE_HOME/rdbms/mesg/oraus.msg
ins_net_client.mk --> ORACLE_HOME/network/lib/client_sharedlib
/kfc.o --> ORACLE_HOME/lib/libserver11.a
/kfcl.o --> ORACLE_HOME/lib/libserver11.a
/kfd.o --> ORACLE_HOME/lib/libserver11.a
/kfds.o --> ORACLE_HOME/lib/libserver11.a
/kff.o --> ORACLE_HOME/lib/libserver11.a
/kffm.o --> ORACLE_HOME/lib/libserver11.a
/kfgb.o --> ORACLE_HOME/lib/libserver11.a
/ksvt.o --> ORACLE_HOME/lib/libserver11.a
/kfdp.o --> ORACLE_HOME/lib/libserver11.a
/kspt.o --> ORACLE_HOME/lib/libserver11.a
/qks3t.o --> ORACLE_HOME/lib/libserver11.a
.....
6- Mutex Patch:
You may face the following issue:
As a grid user:
-bash-3.2$ opatch napply -oh /opt/11.2.0/grid -local 12431716 Invoking OPatch 11.2.0.1.5 Oracle Interim Patch Installer version 11.2.0.1.5 Copyright (c) 2010, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /opt/11.2.0/grid Central Inventory : /opt/Linux_x86_64_11202/orainventorylogs_20110711/oraInventory/ from : /etc/oraInst.loc OPatch version : 11.2.0.1.5 OUI version : 11.2.0.2.0 OUI location : /opt/11.2.0/grid/oui Log file location : /opt/11.2.0/grid/cfgtoollogs/opatch/opatch2011-07-11_21-20-28PM.log Patch history file: /opt/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt Invoking utility "napply" Checking conflict among patches... Checking if Oracle Home has components required by patches... Checking conflicts against Oracle Home... OPatch continues with these patches: 12431716 Do you want to proceed? [y|n] y User Responded with: Y Running prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following executables are active : /opt/11.2.0/grid/lib/libclntsh.so.11.1 UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. OPatch failed with error code 73 -bash-3.2$ lsof | grep libclntsh.so.11.1 ohasd.bin 14589 grid mem REG 253,2 52371741 9966192 /opt/11.2.0/grid/lib/libclntsh.so.11.1 scriptage 14630 grid mem REG 253,2 52371741 9966192 /opt/11.2.0/grid/lib/libclntsh.so.11.1 -bash-3.2$
To fix the issue, you need to stop Oracle Restart.
-bash-3.2$ crsctl stop has CRS-4133: Oracle High Availability Services has been stopped. -bash-3.2$
As a grid user:
-bash-3.2$ opatch napply -oh /opt/11.2.0/grid -local 12431716 Invoking OPatch 11.2.0.1.5 Oracle Interim Patch Installer version 11.2.0.1.5 Copyright (c) 2010, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /opt/11.2.0/grid Central Inventory : /opt/Linux_x86_64_11202/orainventorylogs_20110711/oraInventory/ from : /etc/oraInst.loc OPatch version : 11.2.0.1.5 OUI version : 11.2.0.2.0 OUI location : /opt/11.2.0/grid/oui Log file location : /opt/11.2.0/grid/cfgtoollogs/opatch/opatch2011-07-11_21-24-09PM.log Patch history file: /opt/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt Invoking utility "napply" Checking conflict among patches... Checking if Oracle Home has components required by patches... Checking conflicts against Oracle Home... OPatch continues with these patches: 12431716 Do you want to proceed? [y|n] y .... .... Backing up files affected by the patch 'NApply' for restore. This might take a while... Applying patch 12431716... ApplySession applying interim patch '12431716' to OH '/opt/11.2.0/grid' Backing up files affected by the patch '12431716' for rollback. This might take a while... Patching component oracle.rdbms, 11.2.0.2.0... Patching component oracle.rdbms.rsf, 11.2.0.2.0... Updating archive file "/opt/11.2.0/grid/lib/libgeneric11.a" with "lib/libgeneric11.a/kgx.o" ApplySession adding interim patch '12431716' to inventory Verifying the update... Inventory check OK: Patch ID 12431716 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 12431716 are present in Oracle Home. Running make for target ioracle Running make for target irenamedg Running make for target client_sharedlib The local system has been patched and can be restarted. UtilSession: N-Apply done. OPatch succeeded. -bash-3.2$
Now mutex patch for database home:
As oracle user:
-bash-3.2$ opatch napply -oh $ORACLE_HOME -local /opt/Linux_x86_64_11202/mutex/12431716/
Invoking OPatch 11.2.0.1.5
Oracle Interim Patch Installer version 11.2.0.1.5
Copyright (c) 2010, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /opt/app/oracle/product/11.2.0/db_1
Central Inventory : /opt/Linux_x86_64_11202/orainventorylogs_20110711/oraInventory/
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.5
OUI version : 11.2.0.2.0
OUI location : /opt/app/oracle/product/11.2.0/db_1/oui
Log file location : /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2011-07-11_21-26-53PM.log
Patch history file: /opt/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Unable to lock Central Inventory. OPatch will attempt to re-lock.
Do you want to proceed? [y|n]
y
User Responded with: Y
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
You selected -local option, hence OPatch will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/app/oracle/product/11.2.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...
Applying patch 12431716...
ApplySession applying interim patch '12431716' to OH '/opt/app/oracle/product/11.2.0/db_1'
Backing up files affected by the patch '12431716' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.2.0...
Patching component oracle.rdbms.rsf, 11.2.0.2.0...
Updating archive file "/opt/app/oracle/product/11.2.0/db_1/lib/libgeneric11.a" with "lib/libgeneric11.a/kgx.o"
ApplySession adding interim patch '12431716' to inventory
Verifying the update...
Inventory check OK: Patch ID 12431716 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 12431716 are present in Oracle Home.
Running make for target ioracle
Running make for target irenamedg
Running make for target client_sharedlib
The local system has been patched and can be restarted.
UtilSession: N-Apply done.
OPatch succeeded.
-bash-3.2$
AS a root user:
[root@srv05 ~]# /opt/11.2.0/grid/crs/install/roothas.pl -patch
Using configuration parameter file: /opt/11.2.0/grid/crs/install/crsconfig_params
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@srv05 ~]#
AS Oracle user:
-bash-3.2$ cd $ORACLE_HOME/rdbms/admin
-bash-3.2$ sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Jul 11 21:35:10 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
@ > connect / as sysdba
Connected to an idle instance.
SYS@db02 AS SYSDBA> startup
ORACLE instance started.
Total System Global Area 1.4965E+10 bytes
Fixed Size 2241040 bytes
Variable Size 1040190960 bytes
Database Buffers 1.3892E+10 bytes
Redo Buffers 31297536 bytes
Database mounted.
Database opened.
SYS@db02 AS SYSDBA> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Generating apply and rollback scripts...
Check the following file for errors:
/opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_db02_GENERATE_2011Jul11_21_36_04.log
Apply script: /opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catbundle_PSU_db02_APPLY.sql
Rollback script: /opt/app/oracle/product/11.2.0/db_1/rdbms/admin/catbundle_PSU_db02_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
SYS@db02 AS SYSDBA> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SYS@db02 AS SYSDBA> SELECT '/opt/app/oracle/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;
SYS@db02 AS SYSDBA> SPOOL &spool_file
SYS@db02 AS SYSDBA> exec dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SYS@db02 AS SYSDBA> PROMPT Skipping Oracle Database Vault because it is not installed or versions mismatch...
Skipping Oracle Database Vault because it is not installed or versions mismatch...
SYS@db02 AS SYSDBA> ALTER SESSION SET current_schema = SYS;
Session altered.
SYS@db02 AS SYSDBA> PROMPT Updating registry...
Updating registry...
SYS@db02 AS SYSDBA> 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 '11.2.0.2',
9 2,
10 'PSU',
11 'PSU 11.2.0.2.2');
1 row created.
SYS@db02 AS SYSDBA> COMMIT;
Commit complete.
SYS@db02 AS SYSDBA> SPOOL off
SYS@db02 AS SYSDBA> SET echo off
Check the following log file for errors:
/opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_db02_APPLY_2011Jul11_21_36_06.log
SYS@db02 AS SYSDBA>
7- Test:
Assure that the important resources are ONLINE:
As grid user: -bash-3.2$ crsctl status resource NAME=crs_dbconsole TYPE=local_resource TARGET=OFFLINE STATE=OFFLINE NAME=dbcagent TYPE=local_resource TARGET=OFFLINE STATE=OFFLINE NAME=ora.LISTENER.lsnr TYPE=ora.listener.type TARGET=ONLINE STATE=ONLINE on srv05 NAME=ora.LISTENER_OAM.lsnr TYPE=ora.listener.type TARGET=ONLINE STATE=ONLINE on srv05 NAME=ora.db02.db TYPE=ora.database.type TARGET=ONLINE STATE=ONLINE on srv05 NAME=ora.cssd TYPE=ora.cssd.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.diskmon TYPE=ora.diskmon.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.evmd TYPE=ora.evm.type TARGET=ONLINE STATE=ONLINE on srv05 NAME=ora.ons TYPE=ora.ons.type TARGET=OFFLINE STATE=OFFLINE -bash-3.2$ -bash-3.2$ crsctl start resource crs_dbconsole CRS-2672: Attempting to start 'crs_dbconsole' on 'srv05' CRS-2676: Start of 'crs_dbconsole' on 'srv05' succeeded -bash-3.2$
As a root user, reboot the server to check:
init 6
Check with grid user if the resources are ONLINE after server reboot;
As a grid user:
-bash-3.2$ crsctl status resource NAME=crs_dbconsole TYPE=local_resource TARGET=ONLINE STATE=ONLINE on srv05 NAME=dbcagent TYPE=local_resource TARGET=OFFLINE STATE=OFFLINE NAME=ora.LISTENER.lsnr TYPE=ora.listener.type TARGET=ONLINE STATE=ONLINE on srv05 NAME=ora.LISTENER_OAM.lsnr TYPE=ora.listener.type TARGET=ONLINE STATE=ONLINE on srv05 NAME=ora.db02.db TYPE=ora.database.type TARGET=ONLINE STATE=OFFLINE NAME=ora.cssd TYPE=ora.cssd.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.diskmon TYPE=ora.diskmon.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.evmd TYPE=ora.evm.type TARGET=ONLINE STATE=INTERMEDIATE on srv05 NAME=ora.ons TYPE=ora.ons.type TARGET=OFFLINE STATE=OFFLINE -bash-3.2$
Hope it helps,
Wissem
Blog's RSS Feed
Loading ...
Just the scripts I posted above
Any reason not to use auto patch for both CRS and RAC homes with one command? Or use opatch auto for RAC home as root user instead of taking multiple steps as oracle user?