Como atualizar Oracle Grid 11g para 11.2.0.3

This post is also available in: English

Nesse artigo iremos efetuar o upgrade de um banco de dados Oracle RAC executando na versão 11.2.0.1 para a versão 11.2.0.3.
As etapas para um upgrade vindo da versão 11.2.0.2 são bem parecidos, só alterando os pacotes e patches dependentes.
O nosso banco RAC está executando em um Red Hat. Segue as especificações:

  • S.O: Red Hat Enterprise Linux Server release 5.8 (Tikanga) – x86_64
  • Kernel: 2.6.18-308.16.1.el5
  • VMWare: VMware ESXi 5.0
  • Oracle 11.2.0.3
  • Oracle homes individuais e discos compartilhados para o RAC via VMFS

Para realizar esse upgrade, serão necessários os seguintes pacotes do Oracle:

  • Instalador do Oracle e Grid: p10404530_112030_Linux-x86-64 (apenas os arquivos 1,2,3)
  • Patch para correção de bug da atualização: p9413827_112010_Linux-x86-64 (se a versão de origem for a 11.2.0.1)
  • Último patch set update

Esse tutorial está dividido em 7 etapas macros. Serão elas:

  1. Transferir arquivos de instalação para o servidor e descompactá-los.
  2. Aplicar patch de correção 9413827.
  3. Instalar o pacote cvuqdisk de dependência.
  4. Instalar e atualizar o Oracle Grid para a última versão.
  5. Instalar e atualizar o Oracle Database para a última versão.
  6. Aplicar o último Patch Set Update no Oracle Grid e Database.

Então vamos começar:

1 - Transferir arquivos de instalação para o servidor e descompactá-los.

Primeira parte, vamos transferir os arquivos de um servidor onde temos eles disponíveis. Caso não os tenha, faça download destes arquivos pelo Metalink.

[root@patchserver ~]# scp -r p10404530_112030_Linux-x86-64/ patches/ root@10.20.1.2:/u01/oracle_install
root@10.20.1.2's password:
p10404530_112030_Linux-x86-64_1of7.zip             100% 1296MB  21.2MB/s   01:01
p10404530_112030_Linux-x86-64_2of7.zip             100% 1089MB  21.8MB/s   00:50
p10404530_112030_Linux-x86-64_3of7.zip             100%  934MB  21.2MB/s   00:44
p9413827_112010_Linux-x86-64.zip                   100%  285MB  21.9MB/s   00:13
[root@patchserver oracle_install]#

Em seguida, vamos logar no nó 1 do servidor do RAC para onde os transferimos e verificar:

[root@oraclebdsrv01 ~]# ls -laR /u01/oracle_install/
/u01/oracle_install/:
total 16
drwxr-xr-x 4 root root     4096 Jun 14 16:46 .
drwxr-xr-x 5 root oinstall 4096 Jun 14 16:41 ..
drwxr-xr-x 2 root root     4096 Jun 14 16:45 p10404530_112030_Linux-x86-64
drwxrwxr-x 2 root root     4096 Jun 14 16:47 patches

/u01/oracle_install/p10404530_112030_Linux-x86-64:
total 3401636
drwxr-xr-x 2 root root       4096 Jun 14 16:45 .
drwxr-xr-x 4 root root       4096 Jun 14 16:46 ..
-rw-r--r-- 1 root root 1358454646 Jun 14 16:43 p10404530_112030_Linux-x86-64_1of7.zip
-rw-r--r-- 1 root root 1142195302 Jun 14 16:44 p10404530_112030_Linux-x86-64_2of7.zip
-rw-r--r-- 1 root root  979195792 Jun 14 16:46 p10404530_112030_Linux-x86-64_3of7.zip

/u01/oracle_install/patches:
total 747360
drwxrwxr-x 2 root root      4096 Jun 14 16:47 .
drwxr-xr-x 4 root root      4096 Jun 14 16:46 ..
-rw-r--r-- 1 root root 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip
[root@oraclebdsrv01 ~]#

Agora descompacte os arquivos com o usuário oracle:

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ cd /u01/oracle_install/p10404530_112030_Linux-x86-64/
[oracle@oraclebdsrv01 p10404530_112030_Linux-x86-64]$ ls -la
total 3401636
drwxr-xr-x 2 oracle oinstall       4096 Jun 14 16:45 .
drwxr-xr-x 5 oracle oinstall       4096 Jun 14 17:13 ..
-rw-r--r-- 1 oracle oinstall 1358454646 Jun 14 16:43 p10404530_112030_Linux-x86-64_1of7.zip
-rw-r--r-- 1 oracle oinstall 1142195302 Jun 14 16:44 p10404530_112030_Linux-x86-64_2of7.zip
-rw-r--r-- 1 oracle oinstall  979195792 Jun 14 16:46 p10404530_112030_Linux-x86-64_3of7.zip
[oracle@oraclebdsrv01 p10404530_112030_Linux-x86-64]$ unzip "*.zip"
Archive:  p10404530_112030_Linux-x86-64_1of7.zip
   creating: database/
   .....

Archive:  p10404530_112030_Linux-x86-64_2of7.zip
   creating: database/stage/Components/oracle.ctx/
   .....

Archive:  p10404530_112030_Linux-x86-64_3of7.zip
   creating: grid/
   .....

3 archives were successfully processed.
[oracle@oraclebdsrv01 p10404530_112030_Linux-x86-64]$

A primeira parte foi fácil.

2 - Aplicar patch de correção 9413827.

A segunda parte será a aplicação do patch de correção da atualização para esta versão de banco. Se a pulássemos, nos depararíamos com a seguinte mensagem durante a instalação do Grid na etapa 3:

Atenção, para esta etapa, LEIA ATENTAMENTE o arquivo README.txt do patch.
No meu caso, a pasta de instalação do Oracle Home não é compartilhada entre as intâncias. Portanto, deverei utilizar a opção "Configuration B" especificada no manual.

É necessário executar o passo abaixo inteiro em um nó do seu RAC por vez. Ou seja, executar todas as etapas em um nó, depois em outro, sucessivamente.

Dividiremos essa parte em 10 subetapas:

### 1 Verifique se o opatch está configurado para o ORACLE_HOME e GRID_HOME.

Como oracle, execute:
% opatch lsinventory -detail -oh <rdbms_home>

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ echo $DB_HOME
/u01/app/oracle/product/11.1.0/db_1
[oracle@oraclebdsrv01 ~]$ opatch lsinventory -detail -oh $DB_HOME
Invoking OPatch 11.1.0.6.6

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

Oracle Home       : /u01/app/oracle/product/11.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.1.0/db_1/oui
Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2013-06-20_15-26-49PM.log

Patch history file: /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-06-20_15-26-49PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.

Installed Products (134):

Agent Required Support Files                                         10.2.0.4.2
Assistant Common Files                                               11.2.0.1.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.1.0
Character Set Migration Utility                                      11.2.0.1.0
Cluster Verification Utility Common Files                            11.2.0.1.0
Database Configuration and Upgrade Assistants                        11.2.0.1.0
Database SQL Scripts                                                 11.2.0.1.0
Database Workspace Manager                                           11.2.0.1.0
Deinstallation Tool                                                  11.2.0.1.0
Enterprise Edition Options                                           11.2.0.1.0
Enterprise Manager Agent                                             10.2.0.4.2
Enterprise Manager Agent Core Files                                  10.2.0.4.2
Enterprise Manager Common Core Files                                 10.2.0.4.2
Enterprise Manager Common Files                                      10.2.0.4.2
Enterprise Manager Database Plugin -- Agent Support                  11.2.0.1.0
Enterprise Manager Database Plugin -- Repository Support             11.2.0.1.0
Enterprise Manager Grid Control Core Files                           10.2.0.4.2
Enterprise Manager Minimal Integration                               11.2.0.1.0
Enterprise Manager plugin Common Files                               11.2.0.1.0
Enterprise Manager Repository Core Files                             10.2.0.4.2
Exadata Storage Server                                               11.2.0.1.0
Expat libraries                                                       2.0.1.0.1
Generic Connectivity Common Files                                    11.2.0.1.0
HAS Common Files                                                     11.2.0.1.0
HAS Files for DB                                                     11.2.0.1.0
Installation Common Files                                            11.2.0.1.0
Installation Plugin Files                                            11.2.0.1.0
Installer SDK Component                                              11.2.0.1.0
JAccelerator (COMPANION)                                             11.2.0.1.0
LDAP Required Support Files                                          11.2.0.1.0
OLAP SQL Scripts                                                     11.2.0.1.0
Oracle 11g Warehouse Builder Required Files                          11.2.0.1.0
Oracle Advanced Security                                             11.2.0.1.0
Oracle Application Express                                           11.2.0.1.0
Oracle Call Interface (OCI)                                          11.2.0.1.0
Oracle Clusterware RDBMS Files                                       11.2.0.1.0
Oracle Code Editor                                                   1.2.1.0.0I
Oracle Configuration Manager                                         10.3.1.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           11.2.0.1.0
Oracle Core Required Support Files                                   11.2.0.1.0
Oracle Data Mining RDBMS Files                                       11.2.0.1.0
Oracle Database 11g                                                  11.2.0.1.0
Oracle Database 11g                                                  11.2.0.1.0
Oracle Database 11g Multimedia Files                                 11.2.0.1.0
Oracle Database Deconfiguration                                      11.2.0.1.0
Oracle Database Gateway for ODBC                                     11.2.0.1.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            11.2.0.1.0
Oracle Database Vault J2EE Application                               11.2.0.1.0
Oracle Database Vault option                                         11.2.0.1.0
Oracle DBCA Deconfiguration                                          11.2.0.1.0
Oracle Display Fonts                                                  9.0.2.0.0
Oracle Enterprise Manager Console DB                                 11.2.0.1.0
Oracle Extended Windowing Toolkit                                    3.4.47.0.0
Oracle Globalization Support                                         11.2.0.1.0
Oracle Globalization Support                                         11.2.0.1.0
Oracle Help For Java                                                  4.2.9.0.0
Oracle Help for the  Web                                             2.0.14.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle Internet Directory Client                                     11.2.0.1.0
Oracle Java Client                                                   11.2.0.1.0
Oracle JDBC Server Support Package                                   11.2.0.1.0
Oracle JDBC/OCI Instant Client                                       11.2.0.1.0
Oracle JDBC/THIN Interfaces                                          11.2.0.1.0
Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0
Oracle JVM                                                           11.2.0.1.0
Oracle Label Security                                                11.2.0.1.0
Oracle LDAP administration                                           11.2.0.1.0
Oracle Locale Builder                                                11.2.0.1.0
Oracle Message Gateway Common Files                                  11.2.0.1.0
Oracle Multimedia                                                    11.2.0.1.0
Oracle Multimedia Annotator                                          11.2.0.1.0
Oracle Multimedia Client Option                                      11.2.0.1.0
Oracle Multimedia Java Advanced Imaging                              11.2.0.1.0
Oracle Multimedia Locator                                            11.2.0.1.0
Oracle Multimedia Locator RDBMS Files                                11.2.0.1.0
Oracle Net                                                           11.2.0.1.0
Oracle Net Listener                                                  11.2.0.1.0
Oracle Net Required Support Files                                    11.2.0.1.0
Oracle Net Services                                                  11.2.0.1.0
Oracle Netca Client                                                  11.2.0.1.0
Oracle Notification Service                                          11.2.0.0.0
Oracle Notification Service (eONS)                                   11.2.0.1.0
Oracle ODBC Driver                                                   11.2.0.1.0
Oracle ODBC Driverfor Instant Client                                 11.2.0.1.0
Oracle OLAP                                                          11.2.0.1.0
Oracle OLAP API                                                      11.2.0.1.0
Oracle OLAP RDBMS Files                                              11.2.0.1.0
Oracle One-Off Patch Installer                                       11.2.0.0.2
Oracle Partitioning                                                  11.2.0.1.0
Oracle Programmer                                                    11.2.0.1.0
Oracle Quality of Service Management (Client)                        11.2.0.1.0
Oracle RAC Deconfiguration                                           11.2.0.1.0
Oracle RAC Required Support Files-HAS                                11.2.0.1.0
Oracle Real Application Testing                                      11.2.0.1.0
Oracle Recovery Manager                                              11.2.0.1.0
Oracle Security Developer Tools                                      11.2.0.1.0
Oracle Spatial                                                       11.2.0.1.0
Oracle SQL Developer                                                 11.2.0.1.0
Oracle Starter Database                                              11.2.0.1.0
Oracle Text                                                          11.2.0.1.0
Oracle Text Required Support Files                                   11.2.0.1.0
Oracle UIX                                                           2.2.24.5.0
Oracle Universal Connection Pool                                     11.2.0.1.0
Oracle Universal Installer                                           11.2.0.1.0
Oracle Wallet Manager                                                11.2.0.1.0
Oracle XML Development Kit                                           11.2.0.1.0
Oracle XML Query                                                     11.2.0.1.0
Parser Generator Required Support Files                              11.2.0.1.0
Perl Interpreter                                                     5.10.0.0.1
Perl Modules                                                         5.10.0.0.1
PL/SQL                                                               11.2.0.1.0
PL/SQL Embedded Gateway                                              11.2.0.1.0
Platform Required Support Files                                      11.2.0.1.0
Precompiler Common Files                                             11.2.0.1.0
Precompiler Required Support Files                                   11.2.0.1.0
Provisioning Advisor Framework                                       10.2.0.4.2
RDBMS Required Support Files                                         11.2.0.1.0
RDBMS Required Support Files for Instant Client                      11.2.0.1.0
regexp                                                                2.1.9.0.0
Required Support Files                                               11.2.0.1.0
Sample Schema Data                                                   11.2.0.1.0
Secure Socket Layer                                                  11.2.0.1.0
SQL*Plus                                                             11.2.0.1.0
SQL*Plus Files for Instant Client                                    11.2.0.1.0
SQL*Plus Required Support Files                                      11.2.0.1.0
SQLJ Runtime                                                         11.2.0.1.0
SSL Required Support Files for InstantClient                         11.2.0.1.0
Sun JDK                                                              1.5.0.17.0
XDK Required Support Files                                           11.2.0.1.0
XML Parser for Java                                                  11.2.0.1.0
XML Parser for Oracle JVM                                            11.2.0.1.0
There are 134 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
  Local node = oraclebdsrv01
  Remote node = oraclebdsrv02

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@oraclebdsrv01 ~]$

Como grid, execute:
% opatch lsinventory -detail -oh <crs_home>

[root@oraclebdsrv01 ~]# su - grid
[grid@oraclebdsrv01 ~]$ echo $GRID_HOME
/u01/app/11.2.0/grid
[grid@oraclebdsrv01 ~]$ opatch lsinventory -detail -oh $GRID_HOME
Invoking OPatch 11.1.0.6.6

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

Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/11.2.0/grid/oui
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-06-20_15-27-03PM.log

Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-06-20_15-27-03PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.1.0
There are 1 products installed in this Oracle Home.

Installed Products (87):

Agent Required Support Files                                         10.2.0.4.2
Assistant Common Files                                               11.2.0.1.0
Automatic Storage Management Assistant                               11.2.0.1.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.1.0
Character Set Migration Utility                                      11.2.0.1.0
Cluster Ready Services Files                                         11.2.0.1.0
Cluster Verification Utility Common Files                            11.2.0.1.0
Cluster Verification Utility Files                                   11.2.0.1.0
Database SQL Scripts                                                 11.2.0.1.0
Deinstallation Tool                                                  11.2.0.1.0
Enterprise Manager Common Core Files                                 10.2.0.4.2
Enterprise Manager Common Files                                      10.2.0.4.2
Enterprise Manager Minimal Integration                               11.2.0.1.0
Enterprise Manager plugin Common Files                               11.2.0.1.0
Expat libraries                                                       2.0.1.0.1
HAS Common Files                                                     11.2.0.1.0
HAS Files for DB                                                     11.2.0.1.0
Installation Common Files                                            11.2.0.1.0
Installation Plugin Files                                            11.2.0.1.0
Installer SDK Component                                              11.2.0.1.0
LDAP Required Support Files                                          11.2.0.1.0
OLAP SQL Scripts                                                     11.2.0.1.0
Oracle Clusterware RDBMS Files                                       11.2.0.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           11.2.0.1.0
Oracle Core Required Support Files                                   11.2.0.1.0
Oracle Database 11g                                                  11.2.0.1.0
Oracle Database 11g Multimedia Files                                 11.2.0.1.0
Oracle Database Deconfiguration                                      11.2.0.1.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            11.2.0.1.0
Oracle DBCA Deconfiguration                                          11.2.0.1.0
Oracle Extended Windowing Toolkit                                    3.4.47.0.0
Oracle Globalization Support                                         11.2.0.1.0
Oracle Globalization Support                                         11.2.0.1.0
Oracle Grid Infrastructure                                           11.2.0.1.0
Oracle Help For Java                                                  4.2.9.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle Internet Directory Client                                     11.2.0.1.0
Oracle Java Client                                                   11.2.0.1.0
Oracle JDBC/OCI Instant Client                                       11.2.0.1.0
Oracle JDBC/THIN Interfaces                                          11.2.0.1.0
Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0
Oracle JVM                                                           11.2.0.1.0
Oracle LDAP administration                                           11.2.0.1.0
Oracle Locale Builder                                                11.2.0.1.0
Oracle Multimedia                                                    11.2.0.1.0
Oracle Multimedia Client Option                                      11.2.0.1.0
Oracle Multimedia Java Advanced Imaging                              11.2.0.1.0
Oracle Multimedia Locator                                            11.2.0.1.0
Oracle Multimedia Locator RDBMS Files                                11.2.0.1.0
Oracle Net                                                           11.2.0.1.0
Oracle Net Listener                                                  11.2.0.1.0
Oracle Net Required Support Files                                    11.2.0.1.0
Oracle Netca Client                                                  11.2.0.1.0
Oracle Notification Service                                          11.2.0.0.0
Oracle Notification Service (eONS)                                   11.2.0.1.0
Oracle One-Off Patch Installer                                       11.2.0.0.2
Oracle Quality of Service Management (Client)                        11.2.0.1.0
Oracle Quality of Service Management (Server)                        11.2.0.1.0
Oracle RAC Deconfiguration                                           11.2.0.1.0
Oracle RAC Required Support Files-HAS                                11.2.0.1.0
Oracle Recovery Manager                                              11.2.0.1.0
Oracle Security Developer Tools                                      11.2.0.1.0
Oracle Text Required Support Files                                   11.2.0.1.0
Oracle Universal Installer                                           11.2.0.1.0
Oracle Wallet Manager                                                11.2.0.1.0
Parser Generator Required Support Files                              11.2.0.1.0
Perl Interpreter                                                     5.10.0.0.1
Perl Modules                                                         5.10.0.0.1
PL/SQL                                                               11.2.0.1.0
PL/SQL Embedded Gateway                                              11.2.0.1.0
Platform Required Support Files                                      11.2.0.1.0
Precompiler Required Support Files                                   11.2.0.1.0
RDBMS Required Support Files                                         11.2.0.1.0
RDBMS Required Support Files for Instant Client                      11.2.0.1.0
Required Support Files                                               11.2.0.1.0
Secure Socket Layer                                                  11.2.0.1.0
SQL*Plus                                                             11.2.0.1.0
SQL*Plus Files for Instant Client                                    11.2.0.1.0
SQL*Plus Required Support Files                                      11.2.0.1.0
SSL Required Support Files for InstantClient                         11.2.0.1.0
Sun JDK                                                              1.5.0.17.0
Universal Storage Manager Files                                      11.2.0.1.0
XDK Required Support Files                                           11.2.0.1.0
XML Parser for Java                                                  11.2.0.1.0
There are 87 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
  Local node = oraclebdsrv01
  Remote node = oraclebdsrv02

--------------------------------------------------------------------------------

OPatch succeeded.
[grid@oraclebdsrv01 ~]$

### 2 Descompacte os arquivos.

Como oracle, execute:
% unzip p9413827_11201_LINUX.X64.zip

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ cd /u01/oracle_install/patches
[oracle@oraclebdsrv01 patches]$ ls -la
total 747360
drwxrwxr-x 2 oracle oinstall      4096 Jun 14 16:47 .
drwxr-xr-x 5 oracle oinstall      4096 Jun 14 17:13 ..
-rw-r--r-- 1 oracle oinstall 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip
[oracle@oraclebdsrv01 patches]$ unzip p9413827_112010_Linux-x86-64.zip
Archive:  p9413827_112010_Linux-x86-64.zip
   creating: 9413827/
   .....
[oracle@oraclebdsrv01 patches]$

### 3 Pare a home executando na máquina.

Como oracle, execute:
% srvctl stop home -o <rdbms_home> -s -n <node_name>#

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ srvctl stop home -o $DB_HOME -s /u01/oracle_install/patches/status.file -n oraclebdsrv01
[oracle@oraclebdsrv01 ~]$

### 4 Desproteger os arquivos bloqueados da instalação.

Como root, execute:
# <crs_home>/crs/install/rootcrs.pl -unlock

ATENÇÂO: Se você tiver muitos arquivos de audit, essa etapa vai demorar muito! Portanto, apague-os antes!!

No meu caso, eu não sabia que tinha tantos e o meu comando "rootcrs.pl -unlock" ficou travado. Abri uma outra sessão paralela para resolver o problema.

[root@oraclebdsrv01 ~]# ls -1 /u01/app/oracle/admin/SGF/adump/ | wc -l
127153
[root@oraclebdsrv01 ~]# ls -1 /u01/app/11.2.0/grid/rdbms/audit/ | wc -l
3175278

Um dos meios mais rápidos de apagar arquivos é utilizando rsync, como pode ser visto em: http://linuxnote.net/jianingy/en/linux/a-fast-way-to-remove-huge-number-of-files.html

[grid@oraclebdsrv01 ~]# find /u01/app/11.2.0/grid/rdbms/audit/ ! -name "*.aud"
/u01/app/11.2.0/grid/rdbms/audit/
[grid@oraclebdsrv01 ~]$ mkdir /tmp/empty
[grid@oraclebdsrv01 ~]$ rsync -a --delete /tmp/empty/ /u01/app/11.2.0/grid/rdbms/audit/

Executando o script:

[root@oraclebdsrv01 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
2013-06-21 10:17:54: Parsing the host name
2013-06-21 10:17:54: Checking for super user privileges
2013-06-21 10:17:54: User has super user privileges
Using configuration parameter file: crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.crsd' on 'oraclebdsrv01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.OCR_VOTE.dg' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.ARCHIVE.dg' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01' succeeded
CRS-2672: Attempting to start 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.registry.acfs' on 'oraclebdsrv01' succeeded
CRS-2676: Start of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.OCR_VOTE.dg' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.ARCHIVE.dg' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.DATA1.dg' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.eons' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.ons' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.ons' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.net1.network' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.eons' on 'oraclebdsrv01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01' has completed
CRS-2677: Stop of 'ora.crsd' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.evmd' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.cssdmonitor' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.drivers.acfs' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.cssd' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.gipcd' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.gipcd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'oraclebdsrv01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/11.2.0/grid
[root@oraclebdsrv01 ~]#

### 5 Salve as configurações atuais da home do banco de dados.

Como oracle, execute:
% custom/server/9413827/custom/scripts/prepatch.sh -dbhome <rdbms_home>

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ cd /u01/oracle_install/patches/9413827/
[oracle@oraclebdsrv01 9413827]$ custom/server/9413827/custom/scripts/prepatch.sh -dbhome $DB_HOME
custom/server/9413827/custom/scripts/prepatch.sh completed successfully.
[oracle@oraclebdsrv01 9413827]$

### 6 Vamos aplicar o patch do CRS e após do RDBMS.

Como grid, execute:
% opatch napply -local -oh <crs_home> -id 9413827

[root@oraclebdsrv01 ~]# su - grid
[grid@oraclebdsrv01 ~]$ cd /u01/oracle_install/patches/
[grid@oraclebdsrv01 patches]$ ls -la
total 747368
drwxrwxr-x 3 oracle oinstall      4096 Jun 21 10:14 .
drwxr-xr-x 5 oracle oinstall      4096 Jun 14 17:13 ..
drwxr-xr-x 5 oracle oinstall      4096 Oct 25  2010 9413827
-rw-r--r-- 1 oracle oinstall 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall         7 Jun 21 10:14 status.file
[grid@oraclebdsrv01 patches]$ echo $GRID_HOME
/u01/app/11.2.0/grid
[grid@oraclebdsrv01 patches]$ opatch napply -local -oh $GRID_HOME -id 9413827
Invoking OPatch 11.1.0.6.6

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

UTIL session

Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/11.2.0/grid/oui
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-06-21_13-17-02PM.log

Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches:   9413827

Do you want to proceed? [y|n]
y
User Responded with: Y

Running prerequisite checks...

You selected -local option, hence OPatch will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/11.2.0/grid')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...

Applying patch 9413827...

ApplySession applying interim patch '9413827' to OH '/u01/app/11.2.0/grid'
Backing up files affected by the patch '9413827' for rollback. This might take a while...

Patching component oracle.crs, 11.2.0.1.0...
Copying file to "/u01/app/11.2.0/grid/bin/appagent.bin"
.....
Copying file to "/u01/app/11.2.0/grid/srvm/mesg/sclsus.msg"
ApplySession adding interim patch '9413827' to inventory

Verifying the update...
Inventory check OK: Patch ID 9413827 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9413827 are present in Oracle Home.

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.
[grid@oraclebdsrv01 patches]$

Como oracle, execute:
% opatch napply custom/server/ -local -oh <rdbms_home> -id 9413827

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ cd /u01/oracle_install/patches/
[oracle@oraclebdsrv01 patches]$ ls -la
total 747368
drwxrwxr-x 3 oracle oinstall      4096 Jun 21 10:14 .
drwxr-xr-x 5 oracle oinstall      4096 Jun 14 17:13 ..
drwxr-xr-x 5 oracle oinstall      4096 Oct 25  2010 9413827
-rw-r--r-- 1 oracle oinstall 298972922 Jun 14 16:47 p9413827_112010_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall         7 Jun 21 10:14 status.file
[oracle@oraclebdsrv01 patches]$ echo $DB_HOME
/u01/app/oracle/product/11.1.0/db_1
[oracle@oraclebdsrv01 patches]$ opatch napply 9413827/custom/server/ -local -oh $DB_HOME -id 9413827
Invoking OPatch 11.1.0.6.6

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

UTIL session

Oracle Home       : /u01/app/oracle/product/11.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.1.0/db_1/oui
Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2013-06-21_13-55-07PM.log

Patch history file: /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches:   9413827

Do you want to proceed? [y|n]
y
User Responded with: Y

Running prerequisite checks...

You selected -local option, hence OPatch will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.1.0/db_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...

Applying patch 9413827...

ApplySession applying interim patch '9413827' to OH '/u01/app/oracle/product/11.1.0/db_1'
Backing up files affected by the patch '9413827' for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
Copying file to "/u01/app/oracle/product/11.1.0/db_1/bin/cluvfy"
.....
Copying file to "/u01/app/oracle/product/11.1.0/db_1/srvm/mesg/sclsus.msg"
ApplySession adding interim patch '9413827' to inventory

Verifying the update...
Inventory check OK: Patch ID 9413827 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9413827 are present in Oracle Home.
Running make for target install
Running make for target install

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.
[oracle@oraclebdsrv01 patches]$

### 7 Alguns ajustes de configurações precisam ser feitos.

Como root, execute:
# chmod +w <crs_home>/log//agent
# chmod +w <crs_home>/log//agent/crsd

[root@oraclebdsrv01 ~]# chmod +w /u01/app/11.2.0/grid/log/oraclebdsrv01/agent/
[root@oraclebdsrv01 ~]# chmod +w /u01/app/11.2.0/grid/log/oraclebdsrv01/agent/crsd/
[root@oraclebdsrv01 ~]#

Como oracle, execute:
% custom/server/9413827/custom/scripts/postpatch.sh -dbhome <rdbms_home>

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ cd /u01/oracle_install/patches/9413827/
[oracle@oraclebdsrv01 9413827]$ echo $DB_HOME
/u01/app/oracle/product/11.1.0/db_1
[oracle@oraclebdsrv01 9413827]$ custom/server/9413827/custom/scripts/postpatch.sh -dbhome $DB_HOME
Reading /u01/app/oracle/product/11.1.0/db_1/install/params.ora..
Reading /u01/app/oracle/product/11.1.0/db_1/install/params.ora..
Parsing file /u01/app/oracle/product/11.1.0/db_1/bin/racgwrap
Parsing file /u01/app/oracle/product/11.1.0/db_1/bin/srvctl
Parsing file /u01/app/oracle/product/11.1.0/db_1/bin/srvconfig
Parsing file /u01/app/oracle/product/11.1.0/db_1/bin/cluvfy
Verifying file /u01/app/oracle/product/11.1.0/db_1/bin/racgwrap
Verifying file /u01/app/oracle/product/11.1.0/db_1/bin/srvctl
Verifying file /u01/app/oracle/product/11.1.0/db_1/bin/srvconfig
Verifying file /u01/app/oracle/product/11.1.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/racgwrap
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/racgmain
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/racgeut
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/gnsd
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/bin/crsdiag.pl
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libhasgen11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libclsra11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libdbcfg11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libocr11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libocrb11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libocrutl11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libuini11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/librdjni11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libgns11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libgnsjni11.so
Reapplying file permissions on /u01/app/oracle/product/11.1.0/db_1/lib/libagfw11.so
[oracle@oraclebdsrv01 9413827]$

### 8 Precisamos restaurar as permissões de segurança dos diretórios da aplicação.

Como root, execute:
# <crs_home>/crs/install/rootcrs.pl -patch
# <db_home>/bin/srvctl start home -o <db_home> -s -n

[root@oraclebdsrv01 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch
2013-06-21 14:05:58: Parsing the host name
2013-06-21 14:05:58: Checking for super user privileges
2013-06-21 14:05:58: User has super user privileges
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4123: Oracle High Availability Services has been started.
[root@oraclebdsrv01 ~]#
[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
[root@oraclebdsrv01 ~]#

### 9 Checagem opatch.

Por último, faremos uma chacagem para ver se o patch está instalado e catalogado.

Como oracle, execute:
% opatch lsinventory -detail -oh <rdbms_home>

[root@oraclebdsrv01 ~]# su - oracle
[oracle@oraclebdsrv01 ~]$ opatch lsinventory -oh $DB_HOME
Invoking OPatch 11.1.0.6.6

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

Oracle Home       : /u01/app/oracle/product/11.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.1.0/db_1/oui
Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2013-07-20_10-21-28AM.log

Patch history file: /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-07-20_10-21-28AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  9413827      : applied on Fri Jun 21 13:55:34 BRT 2013
Unique Patch ID:  13136265
   Created on 25 Oct 2010, 07:07:02 hrs PST8PDT
   Bugs fixed:
     9262748, 9343627, 9655006, 9783609, 9413827, 9778840

Rac system comprising of multiple nodes
Rac system comprising of multiple nodes
  Local node = oraclebdsrv01
  Remote node = oraclebdsrv02

--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@oraclebdsrv01 ~]$

Como grid, execute:
% opatch lsinventory -detail -oh <crs_home>

[root@oraclebdsrv01 ~]# su - grid
[grid@oraclebdsrv01 ~]$ opatch lsinventory -oh $GRID_HOME
Invoking OPatch 11.1.0.6.6

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

Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/11.2.0/grid/oui
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-07-20_10-19-44AM.log

Patch history file: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-07-20_10-19-44AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  9413827      : applied on Fri Jun 21 13:18:07 BRT 2013
Unique Patch ID:  13136265
   Created on 25 Oct 2010, 07:07:18 hrs PST8PDT
   Bugs fixed:
     9262748, 9343627, 9655006, 9783609, 9413827, 9262722, 9778840

Rac system comprising of multiple nodes
  Local node = oraclebdsrv01
  Remote node = oraclebdsrv02

--------------------------------------------------------------------------------

OPatch succeeded.
[grid@oraclebdsrv01 ~]$

### 10 Repetir nos outros servidores.

Agora repita as etapas anteriores no próximo nó do RAC.

[root@oraclebdsrv02 ~]# mkdir -p /u01/oracle_install/patches/
[root@oraclebdsrv02 ~]# chown -R oracle:oinstall /u01/oracle_install
[oracle@oraclebdsrv01 ~]$ scp /u01/oracle_install/patches/p9413827_112010_Linux-x86-64.zip oracle@oraclebdsrv02:/u01/oracle_install/patches/
p9413827_112010_Linux-x86-64.zip                                                                                                                                    100%  285MB  35.6MB/s   00:08
[oracle@oraclebdsrv01 ~]$

3 - Instalar o pacote cvuqdisk de dependência.

A atualização do grid traz como dependência um novo pacote cvuqdisk. Para a nossa sorte, este pacote é disponibilizado no próprio zip da instalação do Oracle.

Existe outra forma de aplicar este pacote que é diretamente pela parte gráfica na tela de dependências, onde o Oracle irá gerar um script na "/tmp/" para ser executado como root. No entanto, eu ainda prefiro a abordagem manual:

[root@oraclebdsrv01 ~]# find /u01/oracle_install/p10404530_112030_Linux-x86-64/grid/ -name "*.rpm"
/u01/oracle_install/p10404530_112030_Linux-x86-64/grid/stage/cvu/cv/remenv/cvuqdisk-1.0.9-1.rpm
/u01/oracle_install/p10404530_112030_Linux-x86-64/grid/rpm/cvuqdisk-1.0.9-1.rpm
[root@oraclebdsrv01 ~]# yum --disablerepo="*" --nogpgcheck install /u01/oracle_install/p10404530_112030_Linux-x86-64/grid/rpm/cvuqdisk-1.0.9-1.rpm
Loaded plugins: rhnplugin, security
This system is not registered with RHN.
RHN support will be disabled.
Setting up Install Process
Examining /u01/oracle_install/p10404530_112030_Linux-x86-64/grid/rpm/cvuqdisk-1.0.9-1.rpm: cvuqdisk-1.0.9-1.x86_64
Marking /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
Resolving Dependencies
--> Running transaction check
---> Package cvuqdisk.x86_64 0:1.0.9-1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================
 Package                                       Arch                                        Version                                      Repository                                              Size
=====================================================================================================================================================================================================
Updating:
 cvuqdisk                                      x86_64                                      1.0.9-1                                      /cvuqdisk-1.0.9-1                                       11 k

Transaction Summary
=====================================================================================================================================================================================================
Install       0 Package(s)
Upgrade       1 Package(s)

Total size: 11 k
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating       : cvuqdisk                                                                                                                                                                      1/2
  Cleanup        : cvuqdisk                                                                                                                                                                      2/2

Updated:
  cvuqdisk.x86_64 0:1.0.9-1

Complete!
[root@oraclebdsrv01 ~]#

Agora no outro nó:

[root@oraclebdsrv01 ~]#
[root@oraclebdsrv01 ~]# scp /u01/oracle_install/p10404530_112030_Linux-x86-64/grid/rpm/cvuqdisk-1.0.9-1.rpm root@oraclebdsrv02:/tmp/
root@oraclebdsrv02's password:
cvuqdisk-1.0.9-1.rpm                                                                                                                                               100% 8551     8.4KB/s   00:00
[root@oraclebdsrv01 ~]# ssh oraclebdsrv02
root@oraclebdsrv02's password:
Last login: Thu Jun 20 14:54:08 2013 from 10.20.1.2
[root@oraclebdsrv02 ~]# yum --disablerepo="*" --nogpgcheck install /tmp/cvuqdisk-1.0.9-1.rpm
Loaded plugins: rhnplugin, security
This system is not registered with RHN.
RHN support will be disabled.
Setting up Install Process
Examining /tmp/cvuqdisk-1.0.9-1.rpm: cvuqdisk-1.0.9-1.x86_64
Marking /tmp/cvuqdisk-1.0.9-1.rpm as an update to cvuqdisk-1.0.7-1.x86_64
Resolving Dependencies
--> Running transaction check
---> Package cvuqdisk.x86_64 0:1.0.9-1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================
 Package                                       Arch                                        Version                                      Repository                                              Size
=====================================================================================================================================================================================================
Updating:
 cvuqdisk                                      x86_64                                      1.0.9-1                                      /cvuqdisk-1.0.9-1                                       11 k

Transaction Summary
=====================================================================================================================================================================================================
Install       0 Package(s)
Upgrade       1 Package(s)

Total size: 11 k
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating       : cvuqdisk                                                                                                                                                                      1/2
  Cleanup        : cvuqdisk                                                                                                                                                                      2/2

Updated:
  cvuqdisk.x86_64 0:1.0.9-1

Complete!
[root@oraclebdsrv02 ~]#

4 - Instalar e atualizar o Oracle Grid para a última versão.

Estamos já prontos para chamar o instalador do Grid. A partir da versão 11.2.0.3, o Oracle não atualiza as homes existentes, ele cria homes separadas.

Antes, vamos então apenas criar as pastas onde ficará localizado o novo CRS_HOME:

Como root, execute em cada nó:

[root@oraclebdsrv01 ~]# mkdir -p /u01/app/11.2.3/grid/
[root@oraclebdsrv01 ~]# chown grid:oinstall /u01/app/11.2.3/grid/
[root@oraclebdsrv01 ~]#

[root@oraclebdsrv02 ~]# mkdir -p /u01/app/11.2.3/grid/
[root@oraclebdsrv02 ~]# chown grid:oinstall /u01/app/11.2.3/grid/
[root@oraclebdsrv02 ~]#

Chamando o instalador. Como grid, execute:

[grid@oraclebdsrv01 ~]$ cd /u01/oracle_install/p10404530_112030_Linux-x86-64/grid/
[grid@oraclebdsrv01 grid]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 356122 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 95997 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 65536    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-06-20_02-59-13PM. Please wait ...
[grid@oraclebdsrv01 grid]$

A tela abaixo surgirá. Escolha a opção "Skip software updates".

Na tela seguinte, escolha a opção "Upgrade Oracle Grid Infrastructure".

Selecione os idiomas desejados.

Todos os nós de seu cluster deverão estar selecionados.

Associe os grupos de SO correspondentes.

Nesse momento, você deverá escolher um diretório diferente para o seu upgrade e instalação. No meu caso, eu utilizo o padrão "11.2.3".

Na tela seguinte, aparecerá um resumo. Confira os dados e clique "Install".

Quando o upgrade finalizar, ele pedirá para executar o script abaixo como root. Execute um de cada vez em ambos os nós, começando pelo nó onde a instalação foi chamada.

Como root, execute no primeiro nó:

[root@oraclebdsrv01 ~]# /u01/app/11.2.3/grid/rootupgrade.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/11.2.3/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.3/grid/crs/install/crsconfig_params
Creating trace directory

ASM upgrade has started on first node.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.crsd' on 'oraclebdsrv01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.ossdb.db' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv01' succeeded
CRS-2672: Attempting to start 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.scan2.vip' on 'oraclebdsrv01' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.scan3.vip' on 'oraclebdsrv01' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'oraclebdsrv02'
CRS-2676: Start of 'ora.oraclebdsrv01.vip' on 'oraclebdsrv02' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'oraclebdsrv02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02'
CRS-2676: Start of 'ora.scan3.vip' on 'oraclebdsrv02' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.ossdb.db' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.ARCHIVE.dg' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.ARCHIVE.dg' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.eons' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.ons' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.net1.network' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.eons' on 'oraclebdsrv01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv01' has completed
CRS-2677: Stop of 'ora.crsd' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.evmd' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.cssdmonitor' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.asm' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.cssd' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oraclebdsrv01'
CRS-2673: Attempting to stop 'ora.diskmon' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.gpnpd' on 'oraclebdsrv01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.gipcd' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'oraclebdsrv01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@oraclebdsrv01 ~]#

Como root, execute no segundo (e último) nó:

[root@oraclebdsrv02 ~]# /u01/app/11.2.3/grid/rootupgrade.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/11.2.3/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.3/grid/crs/install/crsconfig_params
Creating trace directory
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.crsd' on 'oraclebdsrv02'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.ossdb.db' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.oraclebdsrv02.vip' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.oraclebdsrv02.vip' on 'oraclebdsrv02' succeeded
CRS-2672: Attempting to start 'ora.oraclebdsrv02.vip' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.scan2.vip' on 'oraclebdsrv02' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'oraclebdsrv01'
CRS-2677: Stop of 'ora.scan3.vip' on 'oraclebdsrv02' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'oraclebdsrv01'
CRS-2676: Start of 'ora.oraclebdsrv02.vip' on 'oraclebdsrv01' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'oraclebdsrv01' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01'
CRS-2676: Start of 'ora.scan3.vip' on 'oraclebdsrv01' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'oraclebdsrv01' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'oraclebdsrv01' succeeded
CRS-2677: Stop of 'ora.ossdb.db' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.ARCHIVE.dg' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.ARCHIVE.dg' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.asm' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.eons' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.ons' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.ons' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.net1.network' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.eons' on 'oraclebdsrv02' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oraclebdsrv02' has completed
CRS-2677: Stop of 'ora.crsd' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.evmd' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.asm' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.cssdmonitor' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.asm' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.cssd' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oraclebdsrv02'
CRS-2673: Attempting to stop 'ora.diskmon' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.gpnpd' on 'oraclebdsrv02' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oraclebdsrv02'
CRS-2677: Stop of 'ora.gipcd' on 'oraclebdsrv02' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'oraclebdsrv02' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oraclebdsrv02' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Started to upgrade the Oracle Clusterware. This operation may take a few minutes.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Oracle Clusterware operating version was successfully set to 11.2.0.3.0

ASM upgrade has finished on last node.

Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@oraclebdsrv02 ~]#

Pronto. Aperte OK na tela solicitando a instalação dos scripts. O upgrade foi realizado com sucesso.

Por fim, atualize .bash_profile de todos os usuarios com a variável apontando para a HOME nova do GRID. Não confundir com a HOME do ORACLE.

Para verificar se seu grid já está executando na nova versão, rode os comandos abaixo como grid:

[grid@oraclebdsrv01 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.3.0]
[grid@oraclebdsrv01 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]

5 - Instalar e atualizar o Oracle Database para a última versão.

Agora que já estamos com o Grid na versão 11.2.0.3, a próxima etapa consiste em instalar a database em uma nova home e depois invocar o DBUA para atualizá-la.

Como oracle, execute:

[oracle@oraclebdsrv01 ~]$ cd /u01/oracle_install/p10404530_112030_Linux-x86-64/database/
[oracle@oraclebdsrv01 database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 25835 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 32724 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 65536    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-17_12-07-58PM. Please wait ...
[oracle@oraclebdsrv01 database]$

Na tela que surgir, preencha os dados conforme desejado. No meu caso, eu não estou interessado em receber updates via MOS.

Ao apresentar o alerta, confirme.

Selecione agora a opção "Skip software updates".

Nesse momento, escolheremos apenas a opção "Install database software only". Faremos o upgrade em outra etapa.

Marque a opção "Oracle Real Application Clusters" e selecione todos os nós do seu cluster.

Escolha agora o idioma desejado.

Escolha a mesma edição que do seu banco de dados original, conforme a sua licença.

Neste momento, a pasta de destino será diferente da onde o Oracle Database atual está executando. Eu utilizo o padrão "11.2.3".

Marque os grupos do SO correspondentes.

Aguarde a verificação de requisítos. Se tudo der certo, nada faltará.

Aguarde a apresentação do resumo e clique "Install".

A instalação seguirá.

Ao fim da instalação, será solicitado a execução do script com o usuário root. Execute em todos os nós, um por vez.

Como root, execute em todos os nós:

[root@oraclebdsrv01 ~]# /u01/app/oracle/product/11.2.3/dbhome_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.3/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@oraclebdsrv01 ~]#

Por fim, a instalação exibirá a tela de sucesso.

Pronto. Por fim, atualize .bash_profile de todos os usuarios com a variável apontando para a HOME nova do ORACLE. Não confundir com a HOME do GRID.

Agora vamos executar o DBUA para migrar o banco para a nova home.

Como oracle, execute:

[oracle@oraclebdsrv01 ~]$ /u01/app/oracle/product/11.2.3/dbhome_1/bin/dbua

A tela de upgrade do banco aparecerá.

Selecione o banco que deseja atualizar.

Aguarde a verificação.

Será exibida uma tela com as recomendações necessárias a serem feitas. Execute-as antes de prosseguir.

Durante a atualização, a Oracle recomenda que sejam algumas checagens. Abaixo estão alguns exemplos para ajudar a solucioná-los:

-- Listar e recompilar objetos inválidos:
select * from dba_objects where status<>'VALID';
EXEC UTL_RECOMP.recomp_serial();
EXEC UTL_RECOMP.recomp_parallel(4);

-- Verificar se existem refreshes de MVIEW em andamento:
select currmvowner, currmvname from v$mvrefresh;

-- Verificar se existem itens na lixeira:
select * from dba_recyclebin;
PURGE DBA_RECYCLEBIN;

-- Verificar se existem objetos além dos de sistema relacionados a package DBMS_LDAP:
select * from dba_dependencies where referenced_name='DBMS_LDAP';

-- Verificar se os parametros 'event' ou '_trace_event' estão não default e salvar listar de parâmetros atuais:
select * from v$parameter where name in ('event','_trace_event');
create pfile=/tmp/pfile.bkp.txt from spfile;

-- Refazer estatísticas das tabelas de sistema:
exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; 
exec DBMS_STATS.GATHER_DICTIONARY_STATS;

Na tela seguinte, recomendo não desativar os archives para possibilitar uma volta segura caso necessário.

Ao aparecer o alerta, prossiga com a instalação.

Escolha a área de ARCHIVE, se já não estiver especificada.

Desmarque a opção de configurar o Enterprise Manager. É aconselhável executar manualmente depois.

Verifique o relatório e clique "Finish".

O upgrade inicializará.

Ao término com sucesso, clique Ok. É aconselhável verificar os arquivos de log gerados por mensagens "ORA-".

A atualização apresentará um relatório final.

Para finalizar, não esqueça de copiar o arquivo tnsnames.ora, assim como qualquer arquivo de configuração ".ora" que seja relevante, da home antiga para a nova.

6 - Aplicar o último Patch Set Update no Oracle Grid e Database.

Até aqui já estaria fechada a sua atualização, mas sempre é bom ter todas as versões de correções instaladas. Portanto, dê uma lida no artigos para aplicar o último PSU aqui!

Não esqueça de apagar os arquivos de instalação para economizar espaço!

 

Gostou? Não deixe de comentar ou deixar um 👍!

2 comentários

  1. Parabéns pelo blog.
    Rodrigo,

    Uma dúvida,em caso de rollback,seria incluir o ORACLE_HOME antigo no .bash_profile e subir o cluster,correto?
    Entendo que o ORACLE_HOME antigo não sofre nenhuma alteração.

    Obrigado.

    Pedro - DBA Oracle

    1. Oi Pedro,
      Obrigado pelo comentário.
      Mais ou menos. Para voltar a versão apenas do software do Oracle Database, você iria precisar atualizar o .bash_profile, reapontar pra home antiga no oratab e ainda recriar o apontamento do CRS parando o banco atual, removendo e criando novamente. Ex::

      srvctl stop database -d ORCL
      srvctl remove database -d ORCL
      srvctl add database -d ORCL -o $DB_HOME -p '+DATA1/ORCL/PARAMETERFILE/spfile.ora' -s open
      srvctl add instance -d ORCL -i ORCL1 -n orclbddrjs001
      srvctl add instance -d ORCL -i ORCL2 -n orclbddrjs002
      srvctl start database -d ORCL -o mount

      Como você provavelmente também já vai ter executado o DBUA e o catálogo da instância foi atualizado, será necessário voltar o backup para o último momento antes da atualização. Eu normalmente crio um "restore point" usando flashback pra facilitar nesta tarefa.

      Já para retornar a versão do software do Oracle Grid, a tarefa seria muito mais complexa uma vez que todos os registros do Grid foram atualizados.

      Abraços,
      Rodrigo

Deixe um comentário

Seu e-mail não será publicado.