Para realizar esse upgrade, ser\u00e3o necess\u00e1rios os seguintes pacotes do Oracle:<\/p>\n
- \n
- Instalador do Oracle e Grid: p10404530_112030_Linux-x86-64 (apenas os arquivos 1,2,3)<\/li>\n
- Patch para corre\u00e7\u00e3o de bug da atualiza\u00e7\u00e3o: p9413827_112010_Linux-x86-64 (se a vers\u00e3o de origem for a 11.2.0.1)<\/li>\n
- \u00daltimo patch set update<\/li>\n<\/ul>\n
Esse tutorial est\u00e1 dividido em 7 etapas macros. Ser\u00e3o elas:<\/strong><\/span><\/p>\n
- \n
- Transferir arquivos de instala\u00e7\u00e3o para o servidor e descompact\u00e1-los.<\/strong><\/span><\/a><\/li>\n
- Aplicar patch de corre\u00e7\u00e3o 9413827.<\/strong><\/span><\/a><\/li>\n
- Instalar o pacote cvuqdisk de depend\u00eancia.<\/strong><\/span><\/a><\/li>\n
- Instalar e atualizar o Oracle Grid para a \u00faltima vers\u00e3o.<\/strong><\/span><\/a><\/li>\n
- Instalar e atualizar o Oracle Database para a \u00faltima vers\u00e3o.<\/strong><\/span><\/a><\/li>\n
- Aplicar o \u00faltimo Patch Set Update no Oracle Grid e Database.<\/strong><\/span><\/a><\/li>\n<\/ol>\n
Ent\u00e3o vamos come\u00e7ar:<\/p>\n
1 – Transferir arquivos de instala\u00e7\u00e3o para o servidor e descompact\u00e1-los.<\/a><\/h1>\n
Primeira parte, vamos transferir os arquivos de um servidor onde temos eles dispon\u00edveis. Caso n\u00e3o os tenha, fa\u00e7a download destes arquivos pelo 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
Em seguida, vamos logar no n\u00f3 1 do servidor do RAC para onde os transferimos e verificar:<\/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
Agora descompacte os arquivos com o usu\u00e1rio oracle:<\/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
A primeira parte foi f\u00e1cil.<\/p>\n
2 – Aplicar patch de corre\u00e7\u00e3o 9413827.<\/a><\/h1>\n
A segunda parte ser\u00e1 a aplica\u00e7\u00e3o do patch de corre\u00e7\u00e3o da atualiza\u00e7\u00e3o para esta vers\u00e3o de banco. Se a pul\u00e1ssemos, nos deparar\u00edamos com a seguinte mensagem durante a instala\u00e7\u00e3o do Grid na etapa 3:<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea95be1eb56.png\")
<\/p>\nAten\u00e7\u00e3o, para esta etapa, LEIA ATENTAMENTE o arquivo README.txt do patch.
\nNo meu caso, a pasta de instala\u00e7\u00e3o do Oracle Home n\u00e3o \u00e9 compartilhada entre as int\u00e2ncias. Portanto, deverei utilizar a op\u00e7\u00e3o “Configuration B” especificada no manual.<\/p>\n\u00c9 necess\u00e1rio executar o passo abaixo inteiro em um n\u00f3 do seu RAC por vez. Ou seja, executar todas as etapas em um n\u00f3, depois em outro, sucessivamente.<\/p>\n
Dividiremos essa parte em 10 subetapas:<\/p>\n
### 1 Verifique se o opatch est\u00e1 configurado para o ORACLE_HOME e GRID_HOME.<\/h4>\n
Como oracle, execute:
\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
Como grid, execute:
\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 Descompacte os arquivos.<\/h4>\n
Como oracle, execute:
\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 Pare a home executando na m\u00e1quina.<\/h4>\n
Como oracle, execute:
\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 Desproteger os arquivos bloqueados da instala\u00e7\u00e3o.<\/h4>\n
Como root, execute:
\n# <crs_home>\/crs\/install\/rootcrs.pl -unlock<\/p>\nATEN\u00c7\u00c2O: Se voc\u00ea tiver muitos arquivos de audit, essa etapa vai demorar muito! Portanto, apague-os antes!!<\/p>\n
No meu caso, eu n\u00e3o sabia que tinha tantos e o meu comando “rootcrs.pl -unlock” ficou travado. Abri uma outra sess\u00e3o paralela para resolver o problema.<\/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
Um dos meios mais r\u00e1pidos de apagar arquivos \u00e9 utilizando rsync, como pode ser visto em: 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
Executando o 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 Salve as configura\u00e7\u00f5es atuais da home do banco de dados.<\/h4>\n
Como oracle, execute:
\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 Vamos aplicar o patch do CRS e ap\u00f3s do RDBMS.<\/h4>\n
Como grid, execute:
\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
Como oracle, execute:
\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 Alguns ajustes de configura\u00e7\u00f5es precisam ser feitos.<\/h4>\n
Como root, execute:
\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
Como oracle, execute:
\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 Precisamos restaurar as permiss\u00f5es de seguran\u00e7a dos diret\u00f3rios da aplica\u00e7\u00e3o.<\/h4>\n
Como root, execute:
\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 Checagem opatch.<\/h4>\n
Por \u00faltimo, faremos uma chacagem para ver se o patch est\u00e1 instalado e catalogado.<\/p>\n
Como oracle, execute:
\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
Como grid, execute:
\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 Repetir nos outros servidores.<\/h4>\n
Agora repita as etapas anteriores no pr\u00f3ximo n\u00f3 do RAC.<\/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
3 – Instalar o pacote cvuqdisk de depend\u00eancia.<\/a><\/h1>\n
A atualiza\u00e7\u00e3o do grid traz como depend\u00eancia um novo pacote cvuqdisk. Para a nossa sorte, este pacote \u00e9 disponibilizado no pr\u00f3prio zip da instala\u00e7\u00e3o do Oracle.<\/p>\n
Existe outra forma de aplicar este pacote que \u00e9 diretamente pela parte gr\u00e1fica na tela de depend\u00eancias, onde o Oracle ir\u00e1 gerar um script na “\/tmp\/” para ser executado como root. No entanto, eu ainda prefiro a abordagem manual:<\/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
Agora no outro n\u00f3:<\/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
4 – Instalar e atualizar o Oracle Grid para a \u00faltima vers\u00e3o.<\/a><\/h1>\n
Estamos j\u00e1 prontos para chamar o instalador do Grid. A partir da vers\u00e3o 11.2.0.3, o Oracle n\u00e3o atualiza as homes existentes, ele cria homes separadas.<\/p>\n
Antes, vamos ent\u00e3o apenas criar as pastas onde ficar\u00e1 localizado o novo CRS_HOME:<\/p>\n
Como root, execute em cada n\u00f3:<\/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
Chamando o instalador. Como grid, execute:<\/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
A tela abaixo surgir\u00e1. Escolha a op\u00e7\u00e3o “Skip software updates”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea95f329ab0.png\")
<\/p>\nNa tela seguinte, escolha a op\u00e7\u00e3o “Upgrade Oracle Grid Infrastructure”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96089ff94.png\")
<\/p>\nSelecione os idiomas desejados.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96163b87e.png\")
<\/p>\nTodos os n\u00f3s de seu cluster dever\u00e3o estar selecionados.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96248a20b.png\")
<\/p>\nAssocie os grupos de SO correspondentes.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea962f67c77.png\")
<\/p>\nNesse momento, voc\u00ea dever\u00e1 escolher um diret\u00f3rio diferente para o seu upgrade e instala\u00e7\u00e3o. No meu caso, eu utilizo o padr\u00e3o “11.2.3”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea963a8e54b.png\")
<\/p>\nNa tela seguinte, aparecer\u00e1 um resumo. Confira os dados e clique “Install”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea965405c14.png\")
<\/p>\nQuando o upgrade finalizar, ele pedir\u00e1 para executar o script abaixo como root. Execute um de cada vez em ambos os n\u00f3s, come\u00e7ando pelo n\u00f3 onde a instala\u00e7\u00e3o foi chamada.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea9663a5cb5.png\")
<\/p>\nComo root, execute no primeiro n\u00f3:<\/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
Como root, execute no segundo (e \u00faltimo) n\u00f3:<\/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
Pronto. Aperte OK na tela solicitando a instala\u00e7\u00e3o dos scripts. O upgrade foi realizado com sucesso.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea967a911f6.png\")
<\/p>\nPor fim, atualize .bash_profile de todos os usuarios com a vari\u00e1vel apontando para a HOME nova do GRID. N\u00e3o confundir com a HOME do ORACLE.<\/p>\n
Para verificar se seu grid j\u00e1 est\u00e1 executando na nova vers\u00e3o, rode os comandos abaixo como 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
5 – Instalar e atualizar o Oracle Database para a \u00faltima vers\u00e3o.<\/a><\/h1>\n
Agora que j\u00e1 estamos com o Grid na vers\u00e3o 11.2.0.3, a pr\u00f3xima etapa consiste em instalar a database em uma nova home e depois invocar o DBUA para atualiz\u00e1-la.<\/p>\n
Como oracle, execute:<\/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
Na tela que surgir, preencha os dados conforme desejado. No meu caso, eu n\u00e3o estou interessado em receber updates via MOS.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea968e3fd82.png\")
<\/p>\nAo apresentar o alerta, confirme.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea969ac191d.png\")
<\/p>\nSelecione agora a op\u00e7\u00e3o “Skip software updates”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96a548cb0.png\")
<\/p>\nNesse momento, escolheremos apenas a op\u00e7\u00e3o “Install database software only”. Faremos o upgrade em outra etapa.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96b1675da.png\")
<\/p>\nMarque a op\u00e7\u00e3o “Oracle Real Application Clusters” e selecione todos os n\u00f3s do seu cluster.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96be15f6f.png\")
<\/p>\nEscolha agora o idioma desejado.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96c8e6f8f.png\")
<\/p>\nEscolha a mesma edi\u00e7\u00e3o que do seu banco de dados original, conforme a sua licen\u00e7a.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96d2c729c.png\")
<\/p>\nNeste momento, a pasta de destino ser\u00e1 diferente da onde o Oracle Database atual est\u00e1 executando. Eu utilizo o padr\u00e3o “11.2.3”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96ddce0ce.png\")
<\/p>\nMarque os grupos do SO correspondentes.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96ed5141c.png\")
<\/p>\nAguarde a verifica\u00e7\u00e3o de requis\u00edtos. Se tudo der certo, nada faltar\u00e1.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea96fa3309d.png\")
<\/p>\nAguarde a apresenta\u00e7\u00e3o do resumo e clique “Install”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea970caebfb.png\")
<\/p>\nA instala\u00e7\u00e3o seguir\u00e1.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea971e01a1c.png\")
<\/p>\nAo fim da instala\u00e7\u00e3o, ser\u00e1 solicitado a execu\u00e7\u00e3o do script com o usu\u00e1rio root. Execute em todos os n\u00f3s, um por vez.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea9723c7ced.png\")
<\/p>\nComo root, execute em todos os n\u00f3s:<\/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
Por fim, a instala\u00e7\u00e3o exibir\u00e1 a tela de sucesso.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea9736c007e.png\")
<\/p>\nPronto. Por fim, atualize .bash_profile de todos os usuarios com a vari\u00e1vel apontando para a HOME nova do ORACLE. N\u00e3o confundir com a HOME do GRID.<\/p>\n
Agora vamos executar o DBUA para migrar o banco para a nova home.<\/p>\n
Como oracle, execute:<\/p>\n
[oracle@oraclebdsrv01 ~]$ \/u01\/app\/oracle\/product\/11.2.3\/dbhome_1\/bin\/dbua<\/pre>\n
A tela de upgrade do banco aparecer\u00e1.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97501b078.png\")
<\/p>\nSelecione o banco que deseja atualizar.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea975bee350.png\")
<\/p>\nAguarde a verifica\u00e7\u00e3o.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea976263bc4.png\")
<\/p>\nSer\u00e1 exibida uma tela com as recomenda\u00e7\u00f5es necess\u00e1rias a serem feitas. Execute-as antes de prosseguir.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea977af343c.png\")
<\/p>\nDurante a atualiza\u00e7\u00e3o, a Oracle recomenda que sejam algumas checagens. Abaixo est\u00e3o alguns exemplos para ajudar a solucion\u00e1-los:<\/p>\n
-- Listar e recompilar objetos inv\u00e1lidos:\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-- Verificar se existem refreshes de MVIEW em andamento:\r\nselect currmvowner, currmvname from v$mvrefresh;\r\n\r\n-- Verificar se existem itens na lixeira:\r\nselect * from dba_recyclebin;\r\nPURGE DBA_RECYCLEBIN;\r\n\r\n-- Verificar se existem objetos al\u00e9m dos de sistema relacionados a package DBMS_LDAP:\r\nselect * from dba_dependencies where referenced_name='DBMS_LDAP';\r\n\r\n-- Verificar se os parametros 'event' ou '_trace_event' est\u00e3o n\u00e3o default e salvar listar de par\u00e2metros atuais:\r\nselect * from v$parameter where name in ('event','_trace_event');\r\ncreate pfile=\/tmp\/pfile.bkp.txt from spfile;\r\n\r\n-- Refazer estat\u00edsticas das tabelas de sistema:\r\nexec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; \r\nexec DBMS_STATS.GATHER_DICTIONARY_STATS;<\/pre>\nNa tela seguinte, recomendo n\u00e3o desativar os archives para possibilitar uma volta segura caso necess\u00e1rio.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea978f58903.png\")
<\/p>\nAo aparecer o alerta, prossiga com a instala\u00e7\u00e3o.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea979c6a784.png\")
<\/p>\nEscolha a \u00e1rea de ARCHIVE, se j\u00e1 n\u00e3o estiver especificada.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97a976f48.png\")
<\/p>\nDesmarque a op\u00e7\u00e3o de configurar o Enterprise Manager. \u00c9 aconselh\u00e1vel executar manualmente depois.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97b55b956.png\")
<\/p>\nVerifique o relat\u00f3rio e clique “Finish”.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97c558d6c.png\")
<\/p>\nO upgrade inicializar\u00e1.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97d260a06.png\")
<\/p>\nAo t\u00e9rmino com sucesso, clique Ok. \u00c9 aconselh\u00e1vel verificar os arquivos de log gerados por mensagens “ORA-“.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97e01535e.png\")
<\/p>\nA atualiza\u00e7\u00e3o apresentar\u00e1 um relat\u00f3rio final.<\/p>\n
![\"\"](\"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/07\/img_51ea97f491330.png\")
<\/p>\nPara finalizar, n\u00e3o esque\u00e7a de copiar o arquivo tnsnames.ora, assim como qualquer arquivo de configura\u00e7\u00e3o “.ora” que seja relevante, da home antiga para a nova.<\/p>\n
6 – Aplicar o \u00faltimo Patch Set Update no Oracle Grid e Database.<\/a><\/h1>\n
At\u00e9 aqui j\u00e1 estaria fechada a sua atualiza\u00e7\u00e3o, mas sempre \u00e9 bom ter todas as vers\u00f5es de corre\u00e7\u00f5es instaladas. Portanto, d\u00ea uma lida no artigos para aplicar o \u00faltimo PSU aqui<\/a>!<\/p>\n
N\u00e3o esque\u00e7a de apagar os arquivos de instala\u00e7\u00e3o para economizar espa\u00e7o!<\/p>\n
<\/p>\nGostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n
- Aplicar patch de corre\u00e7\u00e3o 9413827.<\/strong><\/span><\/a><\/li>\n
- Transferir arquivos de instala\u00e7\u00e3o para o servidor e descompact\u00e1-los.<\/strong><\/span><\/a><\/li>\n
