To perform this upgrade, you will need the following Oracle packages:<\/p>\n
- \n
- Oracle and Grid Installer: p10404530_112030_Linux-x86-64 (1,2,3 files only)<\/li>\n
- Patch for update bug fix: p9413827_112010_Linux-x86-64 (if the source version is the 11.2.0.1)<\/li>\n
- Latest Patch Set update<\/li>\n<\/ul>\n
This tutorial is divided into 7 stages macros:<\/strong><\/span><\/p>\n
- \n
- Transfer the installation files to the server and unzip them.<\/strong><\/span><\/a><\/li>\n
- Apply patch 9413827.<\/strong><\/span><\/a><\/li>\n
- Install the dependency package cvuqdisk.<\/strong><\/span><\/a><\/li>\n
- Install and upgrade Oracle Grid to the latest version.<\/strong><\/span><\/a><\/li>\n
- Install and upgrade Oracle Database to the latest version.<\/strong><\/span><\/a><\/li>\n
- Apply the latest Patch Set Update in Oracle Database and Grid.<\/strong><\/span><\/a><\/li>\n<\/ol>\n
So, let’s start:<\/p>\n
<\/a>1 – Transfer the installation files to the server and unzip them.<\/h1>\n
First part, we will transfer the files to a server where they have available. If you do not have them, download these files from Metalink.<\/p>\n
[root@patchserver ~]# scp -r p10404530_112030_Linux-x86-64\/ patches\/ root@10.20.1.2:\/u01\/oracle_install\r\nroot@10.20.1.2's password:\r\np10404530_112030_Linux-x86-64_1of7.zip 100% 1296MB 21.2MB\/s 01:01\r\np10404530_112030_Linux-x86-64_2of7.zip 100% 1089MB 21.8MB\/s 00:50\r\np10404530_112030_Linux-x86-64_3of7.zip 100% 934MB 21.2MB\/s 00:44\r\np9413827_112010_Linux-x86-64.zip 100% 285MB 21.9MB\/s 00:13\r\n[root@patchserver oracle_install]#<\/pre>\n
Then, let’s log into RAC node 1 where we transfered the files and check:<\/p>\n
[root@oraclebdsrv01 ~]# ls -laR \/u01\/oracle_install\/\r\n\/u01\/oracle_install\/:\r\ntotal 16\r\ndrwxr-xr-x 4 root root 4096 Jun 14 16:46 .\r\ndrwxr-xr-x 5 root oinstall 4096 Jun 14 16:41 ..\r\ndrwxr-xr-x 2 root root 4096 Jun 14 16:45 p10404530_112030_Linux-x86-64\r\ndrwxrwxr-x 2 root root 4096 Jun 14 16:47 patches\r\n\r\n\/u01\/oracle_install\/p10404530_112030_Linux-x86-64:\r\ntotal 3401636\r\ndrwxr-xr-x 2 root root 4096 Jun 14 16:45 .\r\ndrwxr-xr-x 4 root root 4096 Jun 14 16:46 ..\r\n-rw-r--r-- 1 root root 1358454646 Jun 14 16:43 p10404530_112030_Linux-x86-64_1of7.zip\r\n-rw-r--r-- 1 root root 1142195302 Jun 14 16:44 p10404530_112030_Linux-x86-64_2of7.zip\r\n-rw-r--r-- 1 root root 979195792 Jun 14 16:46 p10404530_112030_Linux-x86-64_3of7.zip\r\n\r\n\/u01\/oracle_install\/patches:\r\ntotal 747360\r\ndrwxrwxr-x 2 root root 4096 Jun 14 16:47 .\r\ndrwxr-xr-x 4 root root 4096 Jun 14 16:46 ..\r\n-rw-r--r-- 1 root root 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
Now unzip the files as the oracle user:<\/p>\n
[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/\r\n[oracle@oraclebdsrv01 p10404530_112030_Linux-x86-64]$ ls -la\r\ntotal 3401636\r\ndrwxr-xr-x 2 oracle oinstall 4096 Jun 14 16:45 .\r\ndrwxr-xr-x 5 oracle oinstall 4096 Jun 14 17:13 ..\r\n-rw-r--r-- 1 oracle oinstall 1358454646 Jun 14 16:43 p10404530_112030_Linux-x86-64_1of7.zip\r\n-rw-r--r-- 1 oracle oinstall 1142195302 Jun 14 16:44 p10404530_112030_Linux-x86-64_2of7.zip\r\n-rw-r--r-- 1 oracle oinstall 979195792 Jun 14 16:46 p10404530_112030_Linux-x86-64_3of7.zip\r\n[oracle@oraclebdsrv01 p10404530_112030_Linux-x86-64]$ unzip \"*.zip\"\r\nArchive: p10404530_112030_Linux-x86-64_1of7.zip\r\n creating: database\/\r\n .....\r\n\r\nArchive: p10404530_112030_Linux-x86-64_2of7.zip\r\n creating: database\/stage\/Components\/oracle.ctx\/\r\n .....\r\n\r\nArchive: p10404530_112030_Linux-x86-64_3of7.zip\r\n creating: grid\/\r\n .....\r\n\r\n3 archives were successfully processed.\r\n[oracle@oraclebdsrv01 p10404530_112030_Linux-x86-64]$<\/pre>\n
The first part was easy.<\/p>\n
<\/a>2 – Unzip the files.<\/h1>\n
The second part will be a patch to fix the update for this database version. If skipped, you would face the following message during the installation of Grid in step 3:<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea95be1eb56.png\")
<\/p>\nAttention to this step, READ the README.txt file inside the patch folder.
\nIn my case, the installation folder of the Oracle Home is not shared across the intances. So, I used the option “Configuration B” specified in the manual.<\/p>\nYou must run the whole steps below a node of your RAC at a time. So, perform all the steps in a node, then another, successively.<\/p>\n
We will divide this part into 10 sub-steps:<\/p>\n
### 1 Make sure the opatch is set up to the ORACLE_HOME and GRID_HOME.<\/h4>\n
As oracle, run:
\n% opatch lsinventory -detail -oh <rdbms_home><\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ echo $DB_HOME\r\n\/u01\/app\/oracle\/product\/11.1.0\/db_1\r\n[oracle@oraclebdsrv01 ~]$ opatch lsinventory -detail -oh $DB_HOME\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation. All rights reserved.\r\n\r\nOracle Home : \/u01\/app\/oracle\/product\/11.1.0\/db_1\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n from : \/etc\/oraInst.loc\r\nOPatch version : 11.1.0.6.6\r\nOUI version : 11.2.0.1.0\r\nOUI location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/oui\r\nLog file location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/opatch2013-06-20_15-26-49PM.log\r\n\r\nPatch history file: \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nLsinventory Output file location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory2013-06-20_15-26-49PM.txt\r\n\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (1):\r\n\r\nOracle Database 11g 11.2.0.1.0\r\nThere are 1 products installed in this Oracle Home.\r\n\r\nInstalled Products (134):\r\n\r\nAgent Required Support Files 10.2.0.4.2\r\nAssistant Common Files 11.2.0.1.0\r\nBali Share 1.1.18.0.0\r\nBuildtools Common Files 11.2.0.1.0\r\nCharacter Set Migration Utility 11.2.0.1.0\r\nCluster Verification Utility Common Files 11.2.0.1.0\r\nDatabase Configuration and Upgrade Assistants 11.2.0.1.0\r\nDatabase SQL Scripts 11.2.0.1.0\r\nDatabase Workspace Manager 11.2.0.1.0\r\nDeinstallation Tool 11.2.0.1.0\r\nEnterprise Edition Options 11.2.0.1.0\r\nEnterprise Manager Agent 10.2.0.4.2\r\nEnterprise Manager Agent Core Files 10.2.0.4.2\r\nEnterprise Manager Common Core Files 10.2.0.4.2\r\nEnterprise Manager Common Files 10.2.0.4.2\r\nEnterprise Manager Database Plugin -- Agent Support 11.2.0.1.0\r\nEnterprise Manager Database Plugin -- Repository Support 11.2.0.1.0\r\nEnterprise Manager Grid Control Core Files 10.2.0.4.2\r\nEnterprise Manager Minimal Integration 11.2.0.1.0\r\nEnterprise Manager plugin Common Files 11.2.0.1.0\r\nEnterprise Manager Repository Core Files 10.2.0.4.2\r\nExadata Storage Server 11.2.0.1.0\r\nExpat libraries 2.0.1.0.1\r\nGeneric Connectivity Common Files 11.2.0.1.0\r\nHAS Common Files 11.2.0.1.0\r\nHAS Files for DB 11.2.0.1.0\r\nInstallation Common Files 11.2.0.1.0\r\nInstallation Plugin Files 11.2.0.1.0\r\nInstaller SDK Component 11.2.0.1.0\r\nJAccelerator (COMPANION) 11.2.0.1.0\r\nLDAP Required Support Files 11.2.0.1.0\r\nOLAP SQL Scripts 11.2.0.1.0\r\nOracle 11g Warehouse Builder Required Files 11.2.0.1.0\r\nOracle Advanced Security 11.2.0.1.0\r\nOracle Application Express 11.2.0.1.0\r\nOracle Call Interface (OCI) 11.2.0.1.0\r\nOracle Clusterware RDBMS Files 11.2.0.1.0\r\nOracle Code Editor 1.2.1.0.0I\r\nOracle Configuration Manager 10.3.1.1.0\r\nOracle Configuration Manager Deconfiguration 10.3.1.0.0\r\nOracle Containers for Java 11.2.0.1.0\r\nOracle Core Required Support Files 11.2.0.1.0\r\nOracle Data Mining RDBMS Files 11.2.0.1.0\r\nOracle Database 11g 11.2.0.1.0\r\nOracle Database 11g 11.2.0.1.0\r\nOracle Database 11g Multimedia Files 11.2.0.1.0\r\nOracle Database Deconfiguration 11.2.0.1.0\r\nOracle Database Gateway for ODBC 11.2.0.1.0\r\nOracle Database User Interface 2.2.13.0.0\r\nOracle Database Utilities 11.2.0.1.0\r\nOracle Database Vault J2EE Application 11.2.0.1.0\r\nOracle Database Vault option 11.2.0.1.0\r\nOracle DBCA Deconfiguration 11.2.0.1.0\r\nOracle Display Fonts 9.0.2.0.0\r\nOracle Enterprise Manager Console DB 11.2.0.1.0\r\nOracle Extended Windowing Toolkit 3.4.47.0.0\r\nOracle Globalization Support 11.2.0.1.0\r\nOracle Globalization Support 11.2.0.1.0\r\nOracle Help For Java 4.2.9.0.0\r\nOracle Help for the Web 2.0.14.0.0\r\nOracle Ice Browser 5.2.3.6.0\r\nOracle Internet Directory Client 11.2.0.1.0\r\nOracle Java Client 11.2.0.1.0\r\nOracle JDBC Server Support Package 11.2.0.1.0\r\nOracle JDBC\/OCI Instant Client 11.2.0.1.0\r\nOracle JDBC\/THIN Interfaces 11.2.0.1.0\r\nOracle JFC Extended Windowing Toolkit 4.2.36.0.0\r\nOracle JVM 11.2.0.1.0\r\nOracle Label Security 11.2.0.1.0\r\nOracle LDAP administration 11.2.0.1.0\r\nOracle Locale Builder 11.2.0.1.0\r\nOracle Message Gateway Common Files 11.2.0.1.0\r\nOracle Multimedia 11.2.0.1.0\r\nOracle Multimedia Annotator 11.2.0.1.0\r\nOracle Multimedia Client Option 11.2.0.1.0\r\nOracle Multimedia Java Advanced Imaging 11.2.0.1.0\r\nOracle Multimedia Locator 11.2.0.1.0\r\nOracle Multimedia Locator RDBMS Files 11.2.0.1.0\r\nOracle Net 11.2.0.1.0\r\nOracle Net Listener 11.2.0.1.0\r\nOracle Net Required Support Files 11.2.0.1.0\r\nOracle Net Services 11.2.0.1.0\r\nOracle Netca Client 11.2.0.1.0\r\nOracle Notification Service 11.2.0.0.0\r\nOracle Notification Service (eONS) 11.2.0.1.0\r\nOracle ODBC Driver 11.2.0.1.0\r\nOracle ODBC Driverfor Instant Client 11.2.0.1.0\r\nOracle OLAP 11.2.0.1.0\r\nOracle OLAP API 11.2.0.1.0\r\nOracle OLAP RDBMS Files 11.2.0.1.0\r\nOracle One-Off Patch Installer 11.2.0.0.2\r\nOracle Partitioning 11.2.0.1.0\r\nOracle Programmer 11.2.0.1.0\r\nOracle Quality of Service Management (Client) 11.2.0.1.0\r\nOracle RAC Deconfiguration 11.2.0.1.0\r\nOracle RAC Required Support Files-HAS 11.2.0.1.0\r\nOracle Real Application Testing 11.2.0.1.0\r\nOracle Recovery Manager 11.2.0.1.0\r\nOracle Security Developer Tools 11.2.0.1.0\r\nOracle Spatial 11.2.0.1.0\r\nOracle SQL Developer 11.2.0.1.0\r\nOracle Starter Database 11.2.0.1.0\r\nOracle Text 11.2.0.1.0\r\nOracle Text Required Support Files 11.2.0.1.0\r\nOracle UIX 2.2.24.5.0\r\nOracle Universal Connection Pool 11.2.0.1.0\r\nOracle Universal Installer 11.2.0.1.0\r\nOracle Wallet Manager 11.2.0.1.0\r\nOracle XML Development Kit 11.2.0.1.0\r\nOracle XML Query 11.2.0.1.0\r\nParser Generator Required Support Files 11.2.0.1.0\r\nPerl Interpreter 5.10.0.0.1\r\nPerl Modules 5.10.0.0.1\r\nPL\/SQL 11.2.0.1.0\r\nPL\/SQL Embedded Gateway 11.2.0.1.0\r\nPlatform Required Support Files 11.2.0.1.0\r\nPrecompiler Common Files 11.2.0.1.0\r\nPrecompiler Required Support Files 11.2.0.1.0\r\nProvisioning Advisor Framework 10.2.0.4.2\r\nRDBMS Required Support Files 11.2.0.1.0\r\nRDBMS Required Support Files for Instant Client 11.2.0.1.0\r\nregexp 2.1.9.0.0\r\nRequired Support Files 11.2.0.1.0\r\nSample Schema Data 11.2.0.1.0\r\nSecure Socket Layer 11.2.0.1.0\r\nSQL*Plus 11.2.0.1.0\r\nSQL*Plus Files for Instant Client 11.2.0.1.0\r\nSQL*Plus Required Support Files 11.2.0.1.0\r\nSQLJ Runtime 11.2.0.1.0\r\nSSL Required Support Files for InstantClient 11.2.0.1.0\r\nSun JDK 1.5.0.17.0\r\nXDK Required Support Files 11.2.0.1.0\r\nXML Parser for Java 11.2.0.1.0\r\nXML Parser for Oracle JVM 11.2.0.1.0\r\nThere are 134 products installed in this Oracle Home.\r\n\r\nThere are no Interim patches installed in this Oracle Home.\r\n\r\nRac system comprising of multiple nodes\r\n Local node = oraclebdsrv01\r\n Remote node = oraclebdsrv02\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nOPatch succeeded.\r\n[oracle@oraclebdsrv01 ~]$<\/pre>\n
As grid, run:
\n% opatch lsinventory -detail -oh <crs_home><\/p>\n[root@oraclebdsrv01 ~]# su - grid\r\n[grid@oraclebdsrv01 ~]$ echo $GRID_HOME\r\n\/u01\/app\/11.2.0\/grid\r\n[grid@oraclebdsrv01 ~]$ opatch lsinventory -detail -oh $GRID_HOME\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation. All rights reserved.\r\n\r\nOracle Home : \/u01\/app\/11.2.0\/grid\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n from : \/etc\/oraInst.loc\r\nOPatch version : 11.1.0.6.6\r\nOUI version : 11.2.0.1.0\r\nOUI location : \/u01\/app\/11.2.0\/grid\/oui\r\nLog file location : \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch2013-06-20_15-27-03PM.log\r\n\r\nPatch history file: \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nLsinventory Output file location : \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/lsinv\/lsinventory2013-06-20_15-27-03PM.txt\r\n\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (1):\r\n\r\nOracle Grid Infrastructure 11.2.0.1.0\r\nThere are 1 products installed in this Oracle Home.\r\n\r\nInstalled Products (87):\r\n\r\nAgent Required Support Files 10.2.0.4.2\r\nAssistant Common Files 11.2.0.1.0\r\nAutomatic Storage Management Assistant 11.2.0.1.0\r\nBali Share 1.1.18.0.0\r\nBuildtools Common Files 11.2.0.1.0\r\nCharacter Set Migration Utility 11.2.0.1.0\r\nCluster Ready Services Files 11.2.0.1.0\r\nCluster Verification Utility Common Files 11.2.0.1.0\r\nCluster Verification Utility Files 11.2.0.1.0\r\nDatabase SQL Scripts 11.2.0.1.0\r\nDeinstallation Tool 11.2.0.1.0\r\nEnterprise Manager Common Core Files 10.2.0.4.2\r\nEnterprise Manager Common Files 10.2.0.4.2\r\nEnterprise Manager Minimal Integration 11.2.0.1.0\r\nEnterprise Manager plugin Common Files 11.2.0.1.0\r\nExpat libraries 2.0.1.0.1\r\nHAS Common Files 11.2.0.1.0\r\nHAS Files for DB 11.2.0.1.0\r\nInstallation Common Files 11.2.0.1.0\r\nInstallation Plugin Files 11.2.0.1.0\r\nInstaller SDK Component 11.2.0.1.0\r\nLDAP Required Support Files 11.2.0.1.0\r\nOLAP SQL Scripts 11.2.0.1.0\r\nOracle Clusterware RDBMS Files 11.2.0.1.0\r\nOracle Configuration Manager Deconfiguration 10.3.1.0.0\r\nOracle Containers for Java 11.2.0.1.0\r\nOracle Core Required Support Files 11.2.0.1.0\r\nOracle Database 11g 11.2.0.1.0\r\nOracle Database 11g Multimedia Files 11.2.0.1.0\r\nOracle Database Deconfiguration 11.2.0.1.0\r\nOracle Database User Interface 2.2.13.0.0\r\nOracle Database Utilities 11.2.0.1.0\r\nOracle DBCA Deconfiguration 11.2.0.1.0\r\nOracle Extended Windowing Toolkit 3.4.47.0.0\r\nOracle Globalization Support 11.2.0.1.0\r\nOracle Globalization Support 11.2.0.1.0\r\nOracle Grid Infrastructure 11.2.0.1.0\r\nOracle Help For Java 4.2.9.0.0\r\nOracle Ice Browser 5.2.3.6.0\r\nOracle Internet Directory Client 11.2.0.1.0\r\nOracle Java Client 11.2.0.1.0\r\nOracle JDBC\/OCI Instant Client 11.2.0.1.0\r\nOracle JDBC\/THIN Interfaces 11.2.0.1.0\r\nOracle JFC Extended Windowing Toolkit 4.2.36.0.0\r\nOracle JVM 11.2.0.1.0\r\nOracle LDAP administration 11.2.0.1.0\r\nOracle Locale Builder 11.2.0.1.0\r\nOracle Multimedia 11.2.0.1.0\r\nOracle Multimedia Client Option 11.2.0.1.0\r\nOracle Multimedia Java Advanced Imaging 11.2.0.1.0\r\nOracle Multimedia Locator 11.2.0.1.0\r\nOracle Multimedia Locator RDBMS Files 11.2.0.1.0\r\nOracle Net 11.2.0.1.0\r\nOracle Net Listener 11.2.0.1.0\r\nOracle Net Required Support Files 11.2.0.1.0\r\nOracle Netca Client 11.2.0.1.0\r\nOracle Notification Service 11.2.0.0.0\r\nOracle Notification Service (eONS) 11.2.0.1.0\r\nOracle One-Off Patch Installer 11.2.0.0.2\r\nOracle Quality of Service Management (Client) 11.2.0.1.0\r\nOracle Quality of Service Management (Server) 11.2.0.1.0\r\nOracle RAC Deconfiguration 11.2.0.1.0\r\nOracle RAC Required Support Files-HAS 11.2.0.1.0\r\nOracle Recovery Manager 11.2.0.1.0\r\nOracle Security Developer Tools 11.2.0.1.0\r\nOracle Text Required Support Files 11.2.0.1.0\r\nOracle Universal Installer 11.2.0.1.0\r\nOracle Wallet Manager 11.2.0.1.0\r\nParser Generator Required Support Files 11.2.0.1.0\r\nPerl Interpreter 5.10.0.0.1\r\nPerl Modules 5.10.0.0.1\r\nPL\/SQL 11.2.0.1.0\r\nPL\/SQL Embedded Gateway 11.2.0.1.0\r\nPlatform Required Support Files 11.2.0.1.0\r\nPrecompiler Required Support Files 11.2.0.1.0\r\nRDBMS Required Support Files 11.2.0.1.0\r\nRDBMS Required Support Files for Instant Client 11.2.0.1.0\r\nRequired Support Files 11.2.0.1.0\r\nSecure Socket Layer 11.2.0.1.0\r\nSQL*Plus 11.2.0.1.0\r\nSQL*Plus Files for Instant Client 11.2.0.1.0\r\nSQL*Plus Required Support Files 11.2.0.1.0\r\nSSL Required Support Files for InstantClient 11.2.0.1.0\r\nSun JDK 1.5.0.17.0\r\nUniversal Storage Manager Files 11.2.0.1.0\r\nXDK Required Support Files 11.2.0.1.0\r\nXML Parser for Java 11.2.0.1.0\r\nThere are 87 products installed in this Oracle Home.\r\n\r\nThere are no Interim patches installed in this Oracle Home.\r\n\r\nRac system comprising of multiple nodes\r\n Local node = oraclebdsrv01\r\n Remote node = oraclebdsrv02\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nOPatch succeeded.\r\n[grid@oraclebdsrv01 ~]$<\/pre>\n
### 2 Unzip the files.<\/h4>\n
As oracle, run:
\n% unzip p9413827_11201_LINUX.X64.zip<\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/patches\r\n[oracle@oraclebdsrv01 patches]$ ls -la\r\ntotal 747360\r\ndrwxrwxr-x 2 oracle oinstall 4096 Jun 14 16:47 .\r\ndrwxr-xr-x 5 oracle oinstall 4096 Jun 14 17:13 ..\r\n-rw-r--r-- 1 oracle oinstall 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip\r\n[oracle@oraclebdsrv01 patches]$ unzip p9413827_112010_Linux-x86-64.zip\r\nArchive: p9413827_112010_Linux-x86-64.zip\r\n creating: 9413827\/\r\n .....\r\n[oracle@oraclebdsrv01 patches]$<\/pre>\n
### 3 Stop the “oracle_home” service.<\/h4>\n
As oracle, run:
\n% srvctl stop home -o <rdbms_home> -s -n <node_name>#<\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ srvctl stop home -o $DB_HOME -s \/u01\/oracle_install\/patches\/status.file -n oraclebdsrv01\r\n[oracle@oraclebdsrv01 ~]$<\/pre>\n
### 4 Unprotect the blocked installation files.<\/h4>\n
As root, run:
\n# <crs_home>\/crs\/install\/rootcrs.pl -unlock<\/p>\nATTENTION: If you have many audit files, this step will take much! So, delete them before!<\/p>\n
In my case, I never knew I had so many and my command “rootcrs.pl -unlock” got stuck. I opened another parallel session to solve the problem.<\/p>\n
[root@oraclebdsrv01 ~]# ls -1 \/u01\/app\/oracle\/admin\/SGF\/adump\/ | wc -l\r\n127153\r\n[root@oraclebdsrv01 ~]# ls -1 \/u01\/app\/11.2.0\/grid\/rdbms\/audit\/ | wc -l\r\n3175278<\/pre>\n
One of the fastest ways to delete files using rsync is, as can be seen in: http:\/\/linuxnote.net\/jianingy\/en\/linux\/a-fast-way-to-remove-huge-number-of-files.html<\/a><\/p>\n
[grid@oraclebdsrv01 ~]# find \/u01\/app\/11.2.0\/grid\/rdbms\/audit\/ ! -name \"*.aud\"\r\n\/u01\/app\/11.2.0\/grid\/rdbms\/audit\/\r\n[grid@oraclebdsrv01 ~]$ mkdir \/tmp\/empty\r\n[grid@oraclebdsrv01 ~]$ rsync -a --delete \/tmp\/empty\/ \/u01\/app\/11.2.0\/grid\/rdbms\/audit\/<\/pre>\n
Running the script:<\/p>\n
[root@oraclebdsrv01 ~]# \/u01\/app\/11.2.0\/grid\/crs\/install\/rootcrs.pl -unlock\r\n2013-06-21 10:17:54: Parsing the host name\r\n2013-06-21 10:17:54: Checking for super user privileges\r\n2013-06-21 10:17:54: User has super user privileges\r\nUsing configuration parameter file: crs\/install\/crsconfig_params\r\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.crsd' on 'oraclebdsrv01'\r\nCRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.OCR_VOTE.dg' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.registry.acfs' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.ARCHIVE.dg' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.DATA1.dg' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2672: Attempting to start 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.registry.acfs' on 'oraclebdsrv01' succeeded\r\nCRS-2676: Start of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.OCR_VOTE.dg' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.ARCHIVE.dg' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.DATA1.dg' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.eons' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.ons' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.ons' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.net1.network' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.net1.network' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.eons' on 'oraclebdsrv01' succeeded\r\nCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01' has completed\r\nCRS-2677: Stop of 'ora.crsd' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.drivers.acfs' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.gpnpd' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.ctssd' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.evmd' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.mdnsd' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.cssdmonitor' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.evmd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.mdnsd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.gpnpd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.drivers.acfs' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.ctssd' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.cssd' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.cssd' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.diskmon' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.gipcd' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.gipcd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.diskmon' on 'oraclebdsrv01' succeeded\r\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01' has completed\r\nCRS-4133: Oracle High Availability Services has been stopped.\r\nSuccessfully unlock \/u01\/app\/11.2.0\/grid\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
### 5 Save the current settings of the database home.<\/h4>\n
As oracle, run:
\n% custom\/server\/9413827\/custom\/scripts\/prepatch.sh -dbhome <rdbms_home><\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/patches\/9413827\/\r\n[oracle@oraclebdsrv01 9413827]$ custom\/server\/9413827\/custom\/scripts\/prepatch.sh -dbhome $DB_HOME\r\ncustom\/server\/9413827\/custom\/scripts\/prepatch.sh completed successfully.\r\n[oracle@oraclebdsrv01 9413827]$<\/pre>\n
### 6 Let’s apply the patch on CRS and after on RDBMS.<\/h4>\n
As grid, run:
\n% opatch napply -local -oh <crs_home> -id 9413827<\/p>\n[root@oraclebdsrv01 ~]# su - grid\r\n[grid@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/patches\/\r\n[grid@oraclebdsrv01 patches]$ ls -la\r\ntotal 747368\r\ndrwxrwxr-x 3 oracle oinstall 4096 Jun 21 10:14 .\r\ndrwxr-xr-x 5 oracle oinstall 4096 Jun 14 17:13 ..\r\ndrwxr-xr-x 5 oracle oinstall 4096 Oct 25 2010 9413827\r\n-rw-r--r-- 1 oracle oinstall 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip\r\n-rw-r--r-- 1 oracle oinstall 7 Jun 21 10:14 status.file\r\n[grid@oraclebdsrv01 patches]$ echo $GRID_HOME\r\n\/u01\/app\/11.2.0\/grid\r\n[grid@oraclebdsrv01 patches]$ opatch napply -local -oh $GRID_HOME -id 9413827\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation. All rights reserved.\r\n\r\nUTIL session\r\n\r\nOracle Home : \/u01\/app\/11.2.0\/grid\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n from : \/etc\/oraInst.loc\r\nOPatch version : 11.1.0.6.6\r\nOUI version : 11.2.0.1.0\r\nOUI location : \/u01\/app\/11.2.0\/grid\/oui\r\nLog file location : \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch2013-06-21_13-17-02PM.log\r\n\r\nPatch history file: \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nInvoking utility \"napply\"\r\nChecking conflict among patches...\r\nChecking if Oracle Home has components required by patches...\r\nChecking conflicts against Oracle Home...\r\nOPatch continues with these patches: 9413827\r\n\r\nDo you want to proceed? [y|n]\r\ny\r\nUser Responded with: Y\r\n\r\nRunning prerequisite checks...\r\n\r\nYou selected -local option, hence OPatch will patch the local system only.\r\n\r\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\r\n(Oracle Home = '\/u01\/app\/11.2.0\/grid')\r\n\r\nIs the local system ready for patching? [y|n]\r\ny\r\nUser Responded with: Y\r\nBacking up files affected by the patch 'NApply' for restore. This might take a while...\r\n\r\nApplying patch 9413827...\r\n\r\nApplySession applying interim patch '9413827' to OH '\/u01\/app\/11.2.0\/grid'\r\nBacking up files affected by the patch '9413827' for rollback. This might take a while...\r\n\r\nPatching component oracle.crs, 11.2.0.1.0...\r\nCopying file to \"\/u01\/app\/11.2.0\/grid\/bin\/appagent.bin\"\r\n.....\r\nCopying file to \"\/u01\/app\/11.2.0\/grid\/srvm\/mesg\/sclsus.msg\"\r\nApplySession adding interim patch '9413827' to inventory\r\n\r\nVerifying the update...\r\nInventory check OK: Patch ID 9413827 is registered in Oracle Home inventory with proper meta-data.\r\nFiles check OK: Files from Patch ID 9413827 are present in Oracle Home.\r\n\r\nThe local system has been patched and can be restarted.\r\n\r\nUtilSession: N-Apply done.\r\n\r\nOPatch succeeded.\r\n[grid@oraclebdsrv01 patches]$<\/pre>\n
As oracle, run:
\n% opatch napply custom\/server\/ -local -oh <rdbms_home> -id 9413827<\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/patches\/\r\n[oracle@oraclebdsrv01 patches]$ ls -la\r\ntotal 747368\r\ndrwxrwxr-x 3 oracle oinstall 4096 Jun 21 10:14 .\r\ndrwxr-xr-x 5 oracle oinstall 4096 Jun 14 17:13 ..\r\ndrwxr-xr-x 5 oracle oinstall 4096 Oct 25 2010 9413827\r\n-rw-r--r-- 1 oracle oinstall 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip\r\n-rw-r--r-- 1 oracle oinstall 7 Jun 21 10:14 status.file\r\n[oracle@oraclebdsrv01 patches]$ echo $DB_HOME\r\n\/u01\/app\/oracle\/product\/11.1.0\/db_1\r\n[oracle@oraclebdsrv01 patches]$ opatch napply 9413827\/custom\/server\/ -local -oh $DB_HOME -id 9413827\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation. All rights reserved.\r\n\r\nUTIL session\r\n\r\nOracle Home : \/u01\/app\/oracle\/product\/11.1.0\/db_1\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n from : \/etc\/oraInst.loc\r\nOPatch version : 11.1.0.6.6\r\nOUI version : 11.2.0.1.0\r\nOUI location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/oui\r\nLog file location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/opatch2013-06-21_13-55-07PM.log\r\n\r\nPatch history file: \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nInvoking utility \"napply\"\r\nChecking conflict among patches...\r\nChecking if Oracle Home has components required by patches...\r\nChecking conflicts against Oracle Home...\r\nOPatch continues with these patches: 9413827\r\n\r\nDo you want to proceed? [y|n]\r\ny\r\nUser Responded with: Y\r\n\r\nRunning prerequisite checks...\r\n\r\nYou selected -local option, hence OPatch will patch the local system only.\r\n\r\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\r\n(Oracle Home = '\/u01\/app\/oracle\/product\/11.1.0\/db_1')\r\n\r\nIs the local system ready for patching? [y|n]\r\ny\r\nUser Responded with: Y\r\nBacking up files affected by the patch 'NApply' for restore. This might take a while...\r\n\r\nApplying patch 9413827...\r\n\r\nApplySession applying interim patch '9413827' to OH '\/u01\/app\/oracle\/product\/11.1.0\/db_1'\r\nBacking up files affected by the patch '9413827' for rollback. This might take a while...\r\n\r\nPatching component oracle.rdbms, 11.2.0.1.0...\r\nCopying file to \"\/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/cluvfy\"\r\n.....\r\nCopying file to \"\/u01\/app\/oracle\/product\/11.1.0\/db_1\/srvm\/mesg\/sclsus.msg\"\r\nApplySession adding interim patch '9413827' to inventory\r\n\r\nVerifying the update...\r\nInventory check OK: Patch ID 9413827 is registered in Oracle Home inventory with proper meta-data.\r\nFiles check OK: Files from Patch ID 9413827 are present in Oracle Home.\r\nRunning make for target install\r\nRunning make for target install\r\n\r\nThe local system has been patched and can be restarted.\r\n\r\nUtilSession: N-Apply done.\r\n\r\nOPatch succeeded.\r\n[oracle@oraclebdsrv01 patches]$<\/pre>\n
### 7 Some configuration settings need to be done.<\/h4>\n
As root, run:
\n# chmod +w <crs_home>\/log\/\/agent
\n# chmod +w <crs_home>\/log\/\/agent\/crsd<\/p>\n[root@oraclebdsrv01 ~]# chmod +w \/u01\/app\/11.2.0\/grid\/log\/oraclebdsrv01\/agent\/\r\n[root@oraclebdsrv01 ~]# chmod +w \/u01\/app\/11.2.0\/grid\/log\/oraclebdsrv01\/agent\/crsd\/\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
As oracle, run:
\n% custom\/server\/9413827\/custom\/scripts\/postpatch.sh -dbhome <rdbms_home><\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/patches\/9413827\/\r\n[oracle@oraclebdsrv01 9413827]$ echo $DB_HOME\r\n\/u01\/app\/oracle\/product\/11.1.0\/db_1\r\n[oracle@oraclebdsrv01 9413827]$ custom\/server\/9413827\/custom\/scripts\/postpatch.sh -dbhome $DB_HOME\r\nReading \/u01\/app\/oracle\/product\/11.1.0\/db_1\/install\/params.ora..\r\nReading \/u01\/app\/oracle\/product\/11.1.0\/db_1\/install\/params.ora..\r\nParsing file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/racgwrap\r\nParsing file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvctl\r\nParsing file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvconfig\r\nParsing file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/cluvfy\r\nVerifying file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/racgwrap\r\nVerifying file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvctl\r\nVerifying file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvconfig\r\nVerifying file \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/cluvfy\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/racgwrap\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvctl\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvconfig\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/cluvfy\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/racgmain\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/racgeut\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/diskmon.bin\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/lsnodes\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/osdbagrp\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/rawutl\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/srvm\/admin\/ractrans\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/srvm\/admin\/getcrshome\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/gnsd\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/crsdiag.pl\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libhasgen11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libclsra11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libdbcfg11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libocr11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libocrb11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libocrutl11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libuini11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/librdjni11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libgns11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libgnsjni11.so\r\nReapplying file permissions on \/u01\/app\/oracle\/product\/11.1.0\/db_1\/lib\/libagfw11.so\r\n[oracle@oraclebdsrv01 9413827]$<\/pre>\n
### 8 We must restore the security permissions of the application directories.<\/h4>\n
As root, run:
\n# <crs_home>\/crs\/install\/rootcrs.pl -patch
\n# <db_home>\/bin\/srvctl start home -o <db_home> -s -n<\/p>\n[root@oraclebdsrv01 ~]# \/u01\/app\/11.2.0\/grid\/crs\/install\/rootcrs.pl -patch\r\n2013-06-21 14:05:58: Parsing the host name\r\n2013-06-21 14:05:58: Checking for super user privileges\r\n2013-06-21 14:05:58: User has super user privileges\r\nUsing configuration parameter file: \/u01\/app\/11.2.0\/grid\/crs\/install\/crsconfig_params\r\nCRS-4123: Oracle High Availability Services has been started.\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
[root@oraclebdsrv01 ~]# \/u01\/app\/oracle\/product\/11.1.0\/db_1\/bin\/srvctl start home -o \/u01\/app\/oracle\/product\/11.1.0\/db_1 -s \/u01\/oracle_install\/patches\/status.file -n oraclebdsrv01\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
### 9 Checking opatch.<\/h4>\n
Finally, we will check if the patch is installed and cataloged.<\/p>\n
As oracle, run:
\n% opatch lsinventory -detail -oh <rdbms_home><\/p>\n[root@oraclebdsrv01 ~]# su - oracle\r\n[oracle@oraclebdsrv01 ~]$ opatch lsinventory -oh $DB_HOME\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation. All rights reserved.\r\n\r\nOracle Home : \/u01\/app\/oracle\/product\/11.1.0\/db_1\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n from : \/etc\/oraInst.loc\r\nOPatch version : 11.1.0.6.6\r\nOUI version : 11.2.0.1.0\r\nOUI location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/oui\r\nLog file location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/opatch2013-07-20_10-21-28AM.log\r\n\r\nPatch history file: \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nLsinventory Output file location : \/u01\/app\/oracle\/product\/11.1.0\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory2013-07-20_10-21-28AM.txt\r\n\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (1):\r\n\r\nOracle Database 11g 11.2.0.1.0\r\nThere are 1 products installed in this Oracle Home.\r\n\r\nInterim patches (1) :\r\n\r\nPatch 9413827 : applied on Fri Jun 21 13:55:34 BRT 2013\r\nUnique Patch ID: 13136265\r\n Created on 25 Oct 2010, 07:07:02 hrs PST8PDT\r\n Bugs fixed:\r\n 9262748, 9343627, 9655006, 9783609, 9413827, 9778840\r\n\r\nRac system comprising of multiple nodes\r\nRac system comprising of multiple nodes\r\n Local node = oraclebdsrv01\r\n Remote node = oraclebdsrv02\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nOPatch succeeded.\r\n[oracle@oraclebdsrv01 ~]$<\/pre>\n
As grid, run:
\n% opatch lsinventory -detail -oh <crs_home><\/p>\n[root@oraclebdsrv01 ~]# su - grid\r\n[grid@oraclebdsrv01 ~]$ opatch lsinventory -oh $GRID_HOME\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation. All rights reserved.\r\n\r\nOracle Home : \/u01\/app\/11.2.0\/grid\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n from : \/etc\/oraInst.loc\r\nOPatch version : 11.1.0.6.6\r\nOUI version : 11.2.0.1.0\r\nOUI location : \/u01\/app\/11.2.0\/grid\/oui\r\nLog file location : \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch2013-07-20_10-19-44AM.log\r\n\r\nPatch history file: \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nLsinventory Output file location : \/u01\/app\/11.2.0\/grid\/cfgtoollogs\/opatch\/lsinv\/lsinventory2013-07-20_10-19-44AM.txt\r\n\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (1):\r\n\r\nOracle Grid Infrastructure 11.2.0.1.0\r\nThere are 1 products installed in this Oracle Home.\r\n\r\nInterim patches (1) :\r\n\r\nPatch 9413827 : applied on Fri Jun 21 13:18:07 BRT 2013\r\nUnique Patch ID: 13136265\r\n Created on 25 Oct 2010, 07:07:18 hrs PST8PDT\r\n Bugs fixed:\r\n 9262748, 9343627, 9655006, 9783609, 9413827, 9262722, 9778840\r\n\r\nRac system comprising of multiple nodes\r\n Local node = oraclebdsrv01\r\n Remote node = oraclebdsrv02\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nOPatch succeeded.\r\n[grid@oraclebdsrv01 ~]$<\/pre>\n
### 10 Repeat on other servers.<\/h4>\n
Now repeat the previous steps in the next RAC node.<\/p>\n
[root@oraclebdsrv02 ~]# mkdir -p \/u01\/oracle_install\/patches\/\r\n[root@oraclebdsrv02 ~]# chown -R oracle:oinstall \/u01\/oracle_install<\/pre>\n
[oracle@oraclebdsrv01 ~]$ scp \/u01\/oracle_install\/patches\/p9413827_112010_Linux-x86-64.zip oracle@oraclebdsrv02:\/u01\/oracle_install\/patches\/\r\np9413827_112010_Linux-x86-64.zip 100% 285MB 35.6MB\/s 00:08\r\n[oracle@oraclebdsrv01 ~]$<\/pre>\n
<\/a>3 – Install the dependency package cvuqdisk.<\/h1>\n
Updating the grid brings a new package as a dependency: cvuqdisk. Luckily for us, this package is available in the Oracle installation zip.<\/p>\n
There is another way to apply this package which is directly by the graphic interface on the screen of dependency check, where Oracle will generate a script in “\/tmp\/” to run as root. However, I still prefer the manual approach:<\/p>\n
[root@oraclebdsrv01 ~]# find \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/ -name \"*.rpm\"\r\n\/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/stage\/cvu\/cv\/remenv\/cvuqdisk-1.0.9-1.rpm\r\n\/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/rpm\/cvuqdisk-1.0.9-1.rpm\r\n[root@oraclebdsrv01 ~]# yum --disablerepo=\"*\" --nogpgcheck install \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/rpm\/cvuqdisk-1.0.9-1.rpm\r\nLoaded plugins: rhnplugin, security\r\nThis system is not registered with RHN.\r\nRHN support will be disabled.\r\nSetting up Install Process\r\nExamining \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/rpm\/cvuqdisk-1.0.9-1.rpm: cvuqdisk-1.0.9-1.x86_64\r\nMarking \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/rpm\/cvuqdisk-1.0.9-1.rpm as an update to cvuqdisk-1.0.7-1.x86_64\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package cvuqdisk.x86_64 0:1.0.9-1 set to be updated\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n=====================================================================================================================================================================================================\r\n Package Arch Version Repository Size\r\n=====================================================================================================================================================================================================\r\nUpdating:\r\n cvuqdisk x86_64 1.0.9-1 \/cvuqdisk-1.0.9-1 11 k\r\n\r\nTransaction Summary\r\n=====================================================================================================================================================================================================\r\nInstall 0 Package(s)\r\nUpgrade 1 Package(s)\r\n\r\nTotal size: 11 k\r\nIs this ok [y\/N]: y\r\nDownloading Packages:\r\nRunning rpm_check_debug\r\nRunning Transaction Test\r\nFinished Transaction Test\r\nTransaction Test Succeeded\r\nRunning Transaction\r\n Updating : cvuqdisk 1\/2\r\n Cleanup : cvuqdisk 2\/2\r\n\r\nUpdated:\r\n cvuqdisk.x86_64 0:1.0.9-1\r\n\r\nComplete!\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
Now on the other node:<\/p>\n
[root@oraclebdsrv01 ~]#\r\n[root@oraclebdsrv01 ~]# scp \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/rpm\/cvuqdisk-1.0.9-1.rpm root@oraclebdsrv02:\/tmp\/\r\nroot@oraclebdsrv02's password:\r\ncvuqdisk-1.0.9-1.rpm 100% 8551 8.4KB\/s 00:00\r\n[root@oraclebdsrv01 ~]# ssh oraclebdsrv02\r\nroot@oraclebdsrv02's password:\r\nLast login: Thu Jun 20 14:54:08 2013 from 10.20.1.2\r\n[root@oraclebdsrv02 ~]# yum --disablerepo=\"*\" --nogpgcheck install \/tmp\/cvuqdisk-1.0.9-1.rpm\r\nLoaded plugins: rhnplugin, security\r\nThis system is not registered with RHN.\r\nRHN support will be disabled.\r\nSetting up Install Process\r\nExamining \/tmp\/cvuqdisk-1.0.9-1.rpm: cvuqdisk-1.0.9-1.x86_64\r\nMarking \/tmp\/cvuqdisk-1.0.9-1.rpm as an update to cvuqdisk-1.0.7-1.x86_64\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package cvuqdisk.x86_64 0:1.0.9-1 set to be updated\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n=====================================================================================================================================================================================================\r\n Package Arch Version Repository Size\r\n=====================================================================================================================================================================================================\r\nUpdating:\r\n cvuqdisk x86_64 1.0.9-1 \/cvuqdisk-1.0.9-1 11 k\r\n\r\nTransaction Summary\r\n=====================================================================================================================================================================================================\r\nInstall 0 Package(s)\r\nUpgrade 1 Package(s)\r\n\r\nTotal size: 11 k\r\nIs this ok [y\/N]: y\r\nDownloading Packages:\r\nRunning rpm_check_debug\r\nRunning Transaction Test\r\nFinished Transaction Test\r\nTransaction Test Succeeded\r\nRunning Transaction\r\n Updating : cvuqdisk 1\/2\r\n Cleanup : cvuqdisk 2\/2\r\n\r\nUpdated:\r\n cvuqdisk.x86_64 0:1.0.9-1\r\n\r\nComplete!\r\n[root@oraclebdsrv02 ~]#<\/pre>\n
<\/a>4 – Install and upgrade Oracle Grid to the latest version.<\/h1>\n
We are now ready to call the Grid installer. Starting with version 11.2.0.3, Oracle does not update existing homes, it creates separate homes.<\/p>\n
First, let’s just create the folders where will be located the new CRS_HOME:<\/p>\n
As root, execute on each node:<\/p>\n
[root@oraclebdsrv01 ~]# mkdir -p \/u01\/app\/11.2.3\/grid\/\r\n[root@oraclebdsrv01 ~]# chown grid:oinstall \/u01\/app\/11.2.3\/grid\/\r\n[root@oraclebdsrv01 ~]#\r\n\r\n[root@oraclebdsrv02 ~]# mkdir -p \/u01\/app\/11.2.3\/grid\/\r\n[root@oraclebdsrv02 ~]# chown grid:oinstall \/u01\/app\/11.2.3\/grid\/\r\n[root@oraclebdsrv02 ~]#<\/pre>\n
Calling the installer. As grid, run:<\/p>\n
[grid@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/grid\/\r\n[grid@oraclebdsrv01 grid]$ .\/runInstaller\r\nStarting Oracle Universal Installer...\r\n\r\nChecking Temp space: must be greater than 120 MB. Actual 356122 MB Passed\r\nChecking swap space: must be greater than 150 MB. Actual 95997 MB Passed\r\nChecking monitor: must be configured to display at least 256 colors. Actual 65536 Passed\r\nPreparing to launch Oracle Universal Installer from \/tmp\/OraInstall2013-06-20_02-59-13PM. Please wait ...\r\n[grid@oraclebdsrv01 grid]$<\/pre>\n
The screen below will appear. Choose the option “Skip software updates”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea95f329ab0.png\")
<\/p>\nOn the next screen, choose “Upgrade Oracle Grid Infrastructure”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96089ff94.png\")
<\/p>\nSelect the desired languages.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96163b87e.png\")
<\/p>\nAll nodes in your cluster should be selected.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96248a20b.png\")
<\/p>\nAssociate the corresponding OS groups.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea962f67c77.png\")
<\/p>\nAt this point, you should choose a different directory for your upgrade and installation. In my case, I use the standard “11.2.3”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea963a8e54b.png\")
<\/p>\nOn the next screen, a summary appears. Check the data and click “Install”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea965405c14.png\")
<\/p>\nWhen the upgrade is complete, it will request you to run the following script as root. Do one at a time on both nodes, starting at the node where the installation was called.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea9663a5cb5.png\")
<\/p>\nAs root, run in the first node:<\/p>\n
[root@oraclebdsrv01 ~]# \/u01\/app\/11.2.3\/grid\/rootupgrade.sh\r\nPerforming root user operation for Oracle 11g\r\n\r\nThe following environment variables are set as:\r\n ORACLE_OWNER= oracle\r\n ORACLE_HOME= \/u01\/app\/11.2.3\/grid\r\n\r\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]:\r\nThe contents of \"dbhome\" have not changed. No need to overwrite.\r\nThe file \"oraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)\r\n[n]: y\r\n Copying oraenv to \/usr\/local\/bin ...\r\nThe file \"coraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)\r\n[n]: y\r\n Copying coraenv to \/usr\/local\/bin ...\r\n\r\nEntries will be added to the \/etc\/oratab file as needed by\r\nDatabase Configuration Assistant when a database is created\r\nFinished running generic part of root script.\r\nNow product-specific root actions will be performed.\r\nUsing configuration parameter file: \/u01\/app\/11.2.3\/grid\/crs\/install\/crsconfig_params\r\nCreating trace directory\r\n\r\nASM upgrade has started on first node.\r\n\r\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.crsd' on 'oraclebdsrv01'\r\nCRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.ossdb.db' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2672: Attempting to start 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.scan2.vip' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.scan3.vip' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.scan2.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2672: Attempting to start 'ora.scan2.vip' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.scan3.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2672: Attempting to start 'ora.scan3.vip' on 'oraclebdsrv02'\r\nCRS-2676: Start of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2676: Start of 'ora.scan2.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02'\r\nCRS-2676: Start of 'ora.scan3.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02'\r\nCRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02' succeeded\r\nCRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.ossdb.db' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.ARCHIVE.dg' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.DATA.dg' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.ARCHIVE.dg' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.DATA.dg' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.ons' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.eons' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.ons' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.net1.network' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.net1.network' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.eons' on 'oraclebdsrv01' succeeded\r\nCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01' has completed\r\nCRS-2677: Stop of 'ora.crsd' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.ctssd' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.evmd' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.mdnsd' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.cssdmonitor' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.evmd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.mdnsd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.ctssd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.cssd' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.cssd' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.gpnpd' on 'oraclebdsrv01'\r\nCRS-2673: Attempting to stop 'ora.diskmon' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.gpnpd' on 'oraclebdsrv01' succeeded\r\nCRS-2673: Attempting to stop 'ora.gipcd' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.gipcd' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.diskmon' on 'oraclebdsrv01' succeeded\r\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01' has completed\r\nCRS-4133: Oracle High Availability Services has been stopped.\r\nOLR initialization - successful\r\nReplacing Clusterware entries in inittab\r\nclscfg: EXISTING configuration version 5 detected.\r\nclscfg: version 5 is 11g Release 2.\r\nSuccessfully accumulated necessary OCR keys.\r\nCreating OCR keys for user 'root', privgrp 'root'..\r\nOperation successful.\r\nConfigure Oracle Grid Infrastructure for a Cluster ... succeeded\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
As root, run in the second (and last) node:<\/p>\n
[root@oraclebdsrv02 ~]# \/u01\/app\/11.2.3\/grid\/rootupgrade.sh\r\nPerforming root user operation for Oracle 11g\r\n\r\nThe following environment variables are set as:\r\n ORACLE_OWNER= oracle\r\n ORACLE_HOME= \/u01\/app\/11.2.3\/grid\r\n\r\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]:\r\nThe contents of \"dbhome\" have not changed. No need to overwrite.\r\nThe file \"oraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)\r\n[n]: y\r\n Copying oraenv to \/usr\/local\/bin ...\r\nThe file \"coraenv\" already exists in \/usr\/local\/bin. Overwrite it? (y\/n)\r\n[n]: y\r\n Copying coraenv to \/usr\/local\/bin ...\r\n\r\nEntries will be added to the \/etc\/oratab file as needed by\r\nDatabase Configuration Assistant when a database is created\r\nFinished running generic part of root script.\r\nNow product-specific root actions will be performed.\r\nUsing configuration parameter file: \/u01\/app\/11.2.3\/grid\/crs\/install\/crsconfig_params\r\nCreating trace directory\r\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.crsd' on 'oraclebdsrv02'\r\nCRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.ossdb.db' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.oraclebdsrv02.vip' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.oraclebdsrv02.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2672: Attempting to start 'ora.oraclebdsrv02.vip' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.scan2.vip' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.scan3.vip' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.scan2.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2672: Attempting to start 'ora.scan2.vip' on 'oraclebdsrv01'\r\nCRS-2677: Stop of 'ora.scan3.vip' on 'oraclebdsrv02' succeeded\r\nCRS-2672: Attempting to start 'ora.scan3.vip' on 'oraclebdsrv01'\r\nCRS-2676: Start of 'ora.oraclebdsrv02.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2676: Start of 'ora.scan2.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01'\r\nCRS-2676: Start of 'ora.scan3.vip' on 'oraclebdsrv01' succeeded\r\nCRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01'\r\nCRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01' succeeded\r\nCRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01' succeeded\r\nCRS-2677: Stop of 'ora.ossdb.db' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.ARCHIVE.dg' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.DATA.dg' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.ARCHIVE.dg' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.DATA.dg' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.asm' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.eons' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.ons' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.ons' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.net1.network' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.net1.network' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.eons' on 'oraclebdsrv02' succeeded\r\nCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv02' has completed\r\nCRS-2677: Stop of 'ora.crsd' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.ctssd' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.evmd' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.mdnsd' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.cssdmonitor' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.evmd' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.mdnsd' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.asm' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.ctssd' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.cssd' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.cssd' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.gpnpd' on 'oraclebdsrv02'\r\nCRS-2673: Attempting to stop 'ora.diskmon' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.gpnpd' on 'oraclebdsrv02' succeeded\r\nCRS-2673: Attempting to stop 'ora.gipcd' on 'oraclebdsrv02'\r\nCRS-2677: Stop of 'ora.gipcd' on 'oraclebdsrv02' succeeded\r\nCRS-2677: Stop of 'ora.diskmon' on 'oraclebdsrv02' succeeded\r\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv02' has completed\r\nCRS-4133: Oracle High Availability Services has been stopped.\r\nOLR initialization - successful\r\nReplacing Clusterware entries in inittab\r\nclscfg: EXISTING configuration version 5 detected.\r\nclscfg: version 5 is 11g Release 2.\r\nSuccessfully accumulated necessary OCR keys.\r\nCreating OCR keys for user 'root', privgrp 'root'..\r\nOperation successful.\r\nStarted to upgrade the Oracle Clusterware. This operation may take a few minutes.\r\nStarted to upgrade the CSS.\r\nStarted to upgrade the CRS.\r\nThe CRS was successfully upgraded.\r\nOracle Clusterware operating version was successfully set to 11.2.0.3.0\r\n\r\nASM upgrade has finished on last node.\r\n\r\nConfigure Oracle Grid Infrastructure for a Cluster ... succeeded\r\n[root@oraclebdsrv02 ~]#<\/pre>\n
Nice. Press OK on the screen prompting you to run the scripts. The upgrade was successful.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea967a911f6.png\")
<\/p>\nFinally, upgrade .bash_profile for all users with the variable pointing to the new GRID HOME. Do not confuse with the ORACLE HOME.<\/p>\n
To check if your grid is already running in the new version, run the following commands as grid:<\/p>\n
[grid@oraclebdsrv01 ~]$ crsctl query crs releaseversion\r\nOracle High Availability Services release version on the local node is [11.2.0.3.0]\r\n[grid@oraclebdsrv01 ~]$ crsctl query crs activeversion\r\nOracle Clusterware active version on the cluster is [11.2.0.3.0]<\/pre>\n
<\/a>5 – Install and upgrade Oracle Database to the latest version.<\/h1>\n
Now that we have the Grid in version 11.2.0.3, the next step is to install the database on a new home and then invoke the DBUA to upgrade it.<\/p>\n
As oracle, run:<\/p>\n
[oracle@oraclebdsrv01 ~]$ cd \/u01\/oracle_install\/p10404530_112030_Linux-x86-64\/database\/\r\n[oracle@oraclebdsrv01 database]$ .\/runInstaller\r\nStarting Oracle Universal Installer...\r\n\r\nChecking Temp space: must be greater than 120 MB. Actual 25835 MB Passed\r\nChecking swap space: must be greater than 150 MB. Actual 32724 MB Passed\r\nChecking monitor: must be configured to display at least 256 colors. Actual 65536 Passed\r\nPreparing to launch Oracle Universal Installer from \/tmp\/OraInstall2013-07-17_12-07-58PM. Please wait ...\r\n[oracle@oraclebdsrv01 database]$<\/pre>\n
On the screen that appears, fill in the data as desired. In my case, I’m not interested in receiving updates via MOS.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea968e3fd82.png\")
<\/p>\nWhen presenting the alert, confirm.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea969ac191d.png\")
<\/p>\nNow select the option “Skip software updates”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96a548cb0.png\")
<\/p>\nAt that moment, just pick the option “Install database software only”. We will upgrade it in another step.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96b1675da.png\")
<\/p>\nCheck the “Oracle Real Application Clusters” and select all nodes of your cluster.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96be15f6f.png\")
<\/p>\nNow select the desired language.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96c8e6f8f.png\")
<\/p>\nChoose the same edition as your original database, according to your license.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96d2c729c.png\")
<\/p>\nAt this time, the destination folder will be different from where the current Oracle Database is running. I use the standard “11.2.3”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96ddce0ce.png\")
<\/p>\nCheck the corresponding OS groups.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96ed5141c.png\")
<\/p>\nWait for the verification requirements. If all goes well, nothing will be missing.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96fa3309d.png\")
<\/p>\nWait for the summary and click “Install”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea970caebfb.png\")
<\/p>\nThe installation will proceed.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea971e01a1c.png\")
<\/p>\nAfter installation, you are prompted to run the script as the root user. Execute on all nodes, one at a time.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea9723c7ced.png\")
<\/p>\nAs root, run on all nodes:<\/p>\n
[root@oraclebdsrv01 ~]# \/u01\/app\/oracle\/product\/11.2.3\/dbhome_1\/root.sh\r\nPerforming root user operation for Oracle 11g\r\n\r\nThe following environment variables are set as:\r\n ORACLE_OWNER= oracle\r\n ORACLE_HOME= \/u01\/app\/oracle\/product\/11.2.3\/dbhome_1\r\n\r\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]:\r\nThe contents of \"dbhome\" have not changed. No need to overwrite.\r\nThe contents of \"oraenv\" have not changed. No need to overwrite.\r\nThe contents of \"coraenv\" have not changed. No need to overwrite.\r\n\r\nEntries will be added to the \/etc\/oratab file as needed by\r\nDatabase Configuration Assistant when a database is created\r\nFinished running generic part of root script.\r\nNow product-specific root actions will be performed.\r\nFinished product-specific root actions.\r\n[root@oraclebdsrv01 ~]#<\/pre>\n
Finally, the success installation screen is displayed.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea9736c007e.png\")
<\/p>\nNice. Now, upgrade .bash_profile for all users with the variable pointing to the new HOME of ORACLE. Do not confuse with the GRID HOME.<\/p>\n
Next, let’s run the DBUA to migrate the database to the new home.<\/p>\n
As oracle, run:<\/p>\n
[oracle@oraclebdsrv01 ~]$ \/u01\/app\/oracle\/product\/11.2.3\/dbhome_1\/bin\/dbua<\/pre>\n
The database upgrade screen will appear.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97501b078.png\")
<\/p>\nSelect the database you want to update.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea975bee350.png\")
<\/p>\nWait for verification.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea976263bc4.png\")
<\/p>\nA screen will appear with the necessary recommendations to be made. Execute them before proceeding.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea977af343c.png\")
<\/p>\nDuring the upgrade, Oracle recommends some checks to be performed. Below are some examples to help solve them:<\/p>\n
-- List and recompile invalid objects:\r\nselect * from dba_objects where status<>'VALID';\r\nEXEC UTL_RECOMP.recomp_serial();\r\nEXEC UTL_RECOMP.recomp_parallel(4);\r\n\r\n-- Check if there are refreshes of MVIEW ongoing:\r\nselect currmvowner, currmvname from v$mvrefresh;\r\n\r\n-- Check if there are items in the trash:\r\nselect * from dba_recyclebin;\r\nPURGE DBA_RECYCLEBIN;\r\n\r\n-- Check for objects dependent to the system-related package DBMS_LDAP:\r\nselect * from dba_dependencies where referenced_name='DBMS_LDAP';\r\n\r\n-- Check if the parameter 'event' or '_trace_event' are not default and save list of current parameters:\r\nselect * from v$parameter where name in ('event','_trace_event');\r\ncreate pfile=\/tmp\/pfile.bkp.txt from spfile;\r\n\r\n-- Redo system tables statistics:\r\nexec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; \r\nexec DBMS_STATS.GATHER_DICTIONARY_STATS;<\/pre>\nOn the next screen, I do not recommend disabling the archives so you will be able to safe return if necessary.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea978f58903.png\")
<\/p>\nWhen the warning appears, proceed with the installation.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea979c6a784.png\")
<\/p>\nChoose ARCHIVE area, if not already specified.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97a976f48.png\")
<\/p>\nUncheck the option to configure the Enterprise Manager. It is better to run it later manually.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97b55b956.png\")
<\/p>\nCheck the report and click “Finish”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97c558d6c.png\")
<\/p>\nThe upgrade will start.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97d260a06.png\")
<\/p>\nAt the end, click OK. It is advisable to check the generated log files for “ORA-” messages.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97e01535e.png\")
<\/p>\nThe update will show a final report.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97f491330.png\")
<\/p>\nFinally, do not forget to copy the tnsnames.ora file, as well as any “.ora” configuration files that is relevant, from the old home to the new.<\/p>\n
<\/a>6 – Apply the latest Patch Set Update in Oracle Database and Grid.<\/h1>\n
Up to this point, the updating process is done, but it is always good to have all correction patches installed. So, read the article to apply the latest PSU here<\/a>!<\/p>\n
Do not forget to delete the installation files to save space!<\/p>\n
<\/p>\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n
- Apply patch 9413827.<\/strong><\/span><\/a><\/li>\n
- Transfer the installation files to the server and unzip them.<\/strong><\/span><\/a><\/li>\n
