sexta-feira, 27 de fevereiro de 2015

Atualizando seu Oracle RAC 11.2.0.2 para 11.2.0.3 com aumento de Filesystem - PARTE III


Olá pessoal, como estão todos? Espero que bem, há muito tempo não falo com vocês, mas voltei para terminar aquele artigo sobre atualização do Oracle RAC, espero que apreciem o trabalho em conjunto com o meu amigo Thiago Silva. Divirtam-se!!!

ATUALIZANDO BINÁRIOS


Demorei para escrever essa ultima parte do artigo, é que esses últimos meses estava super corridor, mas vamos para o que interessa terminar essa Terceira e última parte do artigo. Antes de iniciar a atualização do Oracle, vamos aplicar o bundle patch no binário do Oracle 11.2.0.2 com utilitário OPacth.

[oracle@ora-rac01 binarios]$ srvctl stop database -d dath
[oracle@ora-rac01 binarios]$ srvctl status database -d dath
A instância dath1 não está em execução no nó ora-rac01
A instância dath2 não está em execução no nó ora-rac02
  [root@ora-rac02 binarios]# ls
16459322  16619893  bundle.xml p16742320_112020_Linux-x86-64.zip  README.html README.txt
[root@ora-rac02 binarios]# opatch auto -oh /u01/app/oracle/product/11.2.0.2/db_1 -olderver
Executing /u01/app/11.2.0.2/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.2/db_1/OPatch/crs/patch11202.pl -patchdir / -patchn binarios -oh /u01/app/oracle/product/11.2.0.2/db_1 -paramfile /u01/app/11.2.0.2/grid/crs/install/crsconfig_params
INC is /binarios/16459322/files/crs/install /u01/app/11.2.0.2/grid/crs/install /u01/app/11.2.0.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0.2/grid/perl/lib/5.10.0 /u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0 /u01/app/11.2.0.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0.2/grid/perl/lib/5.10.0 /u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/11.2.0.2/grid/perl/lib/site_perl/5.10.0 /u01/app/11.2.0.2/grid/perl/lib/site_perl . 
opatch auto log file location is /u01/app/oracle/product/11.2.0.2/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2014-06-30_01-25-21.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/app/11.2.0.2/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/app/11.2.0.2/grid/OPatch/ocm/bin/ocm.rsp
patch //binarios/16459322/custom/server/16459322  apply successful for home  /u01/app/oracle/product/11.2.0.2/db_1
patch //binarios/16619893  apply successful for home  /u01/app/oracle/product/11.2.0.2/db_1
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_DATH_APPLY_2014Jun30_01_44_15.log

O Bundle patch deverá ser aplicado em todos os nó do Rac, após aplicar o patch no último nó, executei o script catbundle.sql no meu último nó do Rac, conforme saída acima. Após a aplicação do Bundle Patch, fiz um backup via RMAN também.
[oracle@ora-rac01 ~]$ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Mar 9 15:03:42 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DATH (DBID=3788767579)
RMAN> run {
2> allocate channel d1 type disk;
3> backup database tag 'BEFORE_UPGRADE';
4> backup current controlfile tag 'BK_CF_BEFORE_UPGRADE';
5> release channel d1;
6> }
using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=55 instance=dath2 device type=DISK
Starting backup at 09/03/2014 15:04:47
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/dath/datafile/system.256.841354699
input datafile file number=00002 name=+DATA/dath/datafile/sysaux.257.841354701
input datafile file number=00005 name=+DATA/dath/datafile/example.264.841354867
input datafile file number=00003 name=+DATA/dath/datafile/undotbs1.258.841354703
input datafile file number=00006 name=+DATA/dath/datafile/undotbs2.265.841355319
input datafile file number=00004 name=+DATA/dath/datafile/users.259.841354705
channel d1: starting piece 1 at 09/03/2014 15:04:47
channel d1: finished piece 1 at 09/03/2014 15:05:02
piece handle=+RECO/dath/backupset/2014_03_09/nnndf0_before_upgrade_0.292.841763087 tag=BEFORE_UPGRADE comment=NONE
channel d1: backup set complete, elapsed time: 00:00:15
Finished backup at 09/03/2014 15:05:02
Starting backup at 09/03/2014 15:05:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
including current control file in backup set
channel d1: starting piece 1 at 09/03/2014 15:05:04
channel d1: finished piece 1 at 09/03/2014 15:05:05
piece handle=+RECO/dath/backupset/2014_03_09/ncnnf0_bk_cf_before_upgrade_0.295.841763105 tag=BK_CF_BEFORE_UPGRADE comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 09/03/2014 15:05:05
Starting Control File and SPFILE Autobackup at 09/03/2014 15:05:05
piece handle=+RECO/dath/autobackup/2014_03_09/s_841763105.296.841763105 comment=NONE
Finished Control File and SPFILE Autobackup at 09/03/2014 15:05:06
released channel: d1
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
5 B F A DISK 04/03/2014 22:19:09 1 1 YES BKP_FULL
10 B F A DISK 09/03/2014 15:04:58 1 1 NO BEFORE_UPGRADE
RMAN>
Agora vamos para instalação do Oracle 11.2.0.3, antes de iniciar  criei o diretório de destino dos binários da release 11.2.0.3/db_1.
[root@ora-rac01 /]# mkdir –p /u01/app/oracle/product/11.2.0.3/db_1
[root@ora-rac01 /]# chown –R oracle:oinstall 11.2.0.3/db_1

Em seguida alterei o meu bash_profile para carregar o novo caminho da variável ORACLE_HOME, depois descompactei os binário do Oracle e iniciei o instalador.

[oracle@ora-rac01 ~]$ source dath.env
[oracle@ora-rac01 ~]$ echo $ORACLE_BASE
/u01/app/oracle
[oracle@ora-rac01 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.3/db_1
[oracle@ora-rac01 binarios]$ ls -lthor
total 2,4G
-rwxr-xr-x 1 oracle 1,3G Mar 9 15:10 p10404530_112030_Linux-x86-64_1of7.zip
-rwxr-xr-x 1 oracle 1,1G Mar 9 15:11 p10404530_112030_Linux-x86-64_2of7.zip
[oracle@ora-rac01 binarios]$ unzip p10404530_112030_Linux-x86-64_1of7.zip
[oracle@ora-rac01 binarios]$ unzip p10404530_112030_Linux-x86-64_2of7.zip
[oracle@ora-rac01 binarios]$ ls -lthor
total 2,4G
drwxr-xr-x 8 oracle 4,0K Set 22 2011 database
-rwxr-xr-x 1 oracle 1,3G Mar 9 15:10 p10404530_112030_Linux-x86-64_1of7.zip
-rwxr-xr-x 1 oracle 1,1G Mar 9 15:11 p10404530_112030_Linux-x86-64_2of7.zip
[oracle@ora-rac01 binarios]$ cd database/
[oracle@ora-rac01 database]$ ls
doc install readme.html response rpm runInstaller sshsetup stage welcome.html
[oracle@ora-rac01 database]$ ./runInstaller










root@ora-rac01 ~]# cd /u01/app/oracle/product/11.2.0.3/db_1/
[root@ora-rac01 db_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.0.3/db_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@ora-rac01 db_1]#

[root@ora-rac02 ~]# cd /u01/app/oracle/product/11.2.0.3/db_1/
[root@ora-rac02 db_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.0.3/db_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.

Como vocês mesmo visualizaram, instalei somente o software de banco de dados e não iniciei ainda o upgrade do banco. No próximo passo vou executar o upgrade do banco de dados manualmente, ou seja efetuaremos via script.
 [oracle@ora-rac01 dbs]$ ls
hc_dath1.dat  hc_DBUA0.dat  initdath1.ora  init.ora  orapwdath1  snapcf_dath1.f
[oracle@ora-rac01 dbs]$ cp orapwdath1 /u01/app/oracle/product/11.2.0.3/db_1/dbs/
[oracle@ora-rac01 dbs]$ cd /u01/app/oracle/product/11.2.0.3/db_1/dbs/
[oracle@ora-rac01 dbs]$ ls
init.ora  orapwdath1
[oracle@ora-rac01 dbs]$

[oracle@ora-rac01 dbs]$ cd /u01/app/oracle/product/11.2.0.2/db_1/network/admin/
[oracle@ora-rac01 admin]$ ls
samples  shrept.lst  tnsnames.ora
[oracle@ora-rac01 admin]$ cp tnsnames.ora /u01/app/oracle/product/11.2.0.3/db_1/network/admin/
[oracle@ora-rac01 admin]$ cd /u01/app/oracle/product/11.2.0.3/db_1/network/admin/
[oracle@ora-rac01 admin]$ ls
samples  shrept.lst  tnsnames.ora
[oracle@ora-rac01 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DATH =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ora-rac-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dath)
    )
  )


SQL> show parameter spfile

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile     string +DATA/dath/spfiledath.ora
SQL> create pfile='/home/oracle/initdath1.ora' from spfile;

File created.

SQL>

#*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/dath/controlfile/current.261.850748285','+DATA/dath/controlfile/current.260.850748285'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='dath'
*.db_recovery_file_dest_size=4227858432
*.db_recovery_file_dest='+RECO'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dathXDB)'
#dath1.instance_number=1
#dath2.instance_number=2
*.nls_language='BRAZILIAN PORTUGUESE'
*.nls_territory='BRAZIL'
*.open_cursors=300
*.pga_aggregate_target=104857600
*.processes=200
*.remote_listener='ora-rac-scan:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=225
*.sga_target=524288000
#dath2.thread=2
#dath1.thread=1
#dath2.undo_tablespace='UNDOTBS2'


[oracle@ora-rac01 ~]$ srvctl stop database -d dath -o immediate

[grid@ora-rac01 ~]$ cd $ORACLE_HOME/bin
[grid@ora-rac01 bin]$ pwd
/u01/app/11.2.0.3/grid/bin
[grid@ora-rac01 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11.2.0.3/db_1/bin/oracle
[grid@ora-rac01 bin]$ cd /u01/app/oracle/product/11.2.0.3/db_1/bin/
[grid@ora-rac01 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 232399431 Sep 21 02:54 oracle
[grid@ora-rac01 bin]$


SQL> startup upgrade pfile='/home/oracle/initdath1.ora'
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size     2235208 bytes
Variable Size   272630968 bytes
Database Buffers   788529152 bytes
Redo Buffers     5541888 bytes
Database mounted.
Database opened.
SQL>

old   2:    IF '&&mig_file' = '1102000' THEN
new   2:    IF '1102000' = '1102000' THEN

PL/SQL procedure successfully completed.

SQL> drop version_script;   -- no longer needed
  2
SQL> SELECT :utl_name FROM DUAL;




1 row selected.

SQL> @@&utl_file
SQL> Rem
SQL> Rem $Header: catupshd.sql 12-jul-2007.07:16:44 rburns Exp $
SQL> Rem
SQL> Rem catupshd.sql
SQL> Rem
SQL> Rem Copyright (c) 2007, Oracle. All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      catupshd.sql - CATalog UPgrade SHutDown
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      This script shuts down the database at the conclusion of
SQL> Rem      upgrades that do not run utlmmig.sql, which also does a shutdown.
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      Invoked from catupend.sql
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    rburns      07/12/07 - final upgrade shutdown
SQL> Rem    rburns      07/12/07 - Created
SQL> Rem
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC>   The above sql script is the final step of the upgrade. Please
DOC>   review any errors in the spool log file. If there are any errors in
DOC>   the spool file, consult the Oracle Database Upgrade Guide for
DOC>   troubleshooting recommendations.
DOC>
DOC>   Next restart for normal operation, and then run utlrp.sql to
DOC>   recompile any invalid application objects.
DOC>
DOC>   If the source database had an older time zone version prior to
DOC>   upgrade, then please run the DBMS_DST package.  DBMS_DST will upgrade
DOC>   TIMESTAMP WITH TIME ZONE data to use the latest time zone file shipped
DOC>   with Oracle.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL>
SQL> Rem Set errorlogging off
SQL> SET ERRORLOGGING OFF;
SQL>
SQL> REM END OF CATUPGRD.SQL
SQL>
SQL> REM bug 12337546 - Exit current sqlplus session at end of catupgrd.sql.
SQL> REM                This forces user to start a new sqlplus session in order
SQL> REM                to connect to the upgraded db.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options



SQL> @?/rdbms/admin/utlu112s.sql
.
Oracle Database 11.2 Post-Upgrade Status Tool 09-21-2014 05:09:33
.
Component Current      Version Elapsed Time
Name Status     Number HH:MM:SS
.
Oracle Server
.   VALID      11.2.0.3.0  00:24:19
JServer JAVA Virtual Machine
.   VALID      11.2.0.3.0  00:04:53
Oracle Real Application Clusters
.   VALID      11.2.0.3.0  00:00:01
Oracle Workspace Manager
.   VALID      11.2.0.3.0  00:00:46
OLAP Analytic Workspace
.   VALID      11.2.0.3.0  00:00:26
OLAP Catalog
.   VALID      11.2.0.3.0  00:01:07
Oracle OLAP API
.   VALID      11.2.0.3.0  00:00:34
Oracle Enterprise Manager
.   VALID      11.2.0.3.0  00:04:04
Oracle XDK
.   VALID      11.2.0.3.0  00:01:11
Oracle Text
.   VALID      11.2.0.3.0  00:00:46
Oracle XML Database
.   VALID      11.2.0.3.0  00:04:04
Oracle Database Java Packages
.   VALID      11.2.0.3.0  00:00:27
Oracle Multimedia
.   VALID      11.2.0.3.0  00:04:54
Spatial
.   VALID      11.2.0.3.0  00:03:06
Oracle Expression Filter
.   VALID      11.2.0.3.0  00:00:14
Oracle Rules Manager
.   VALID      11.2.0.3.0  00:00:11
Oracle Application Express
.   VALID     3.2.1.00.12
Gathering Statistics
. 00:02:55
Total Upgrade Time: 00:54:09

PL/SQL procedure successfully completed.

SQL>



SQL> @?/rdbms/admin/catuppst.sql

Generating apply and rollback scripts...
Check the following file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_DATH_GENERATE_2014Sep21_05_11_35.log
Apply script: /u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catbundle_PSU_DATH_APPLY.sql
Rollback script: /u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catbundle_PSU_DATH_ROLLBACK.sql

PL/SQL procedure successfully completed.

Executing script file...




SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/u01/app/oracle/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;




SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

SQL> ALTER SESSION SET current_schema = SYS;

Session altered.

SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '11.2.0.3',
  9     0,
 10     'PSU',
 11     'Patchset 11.2.0.2.0');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_DATH_APPLY_2014Sep21_05_11_37.log
SQL>



SQL> spool upgrade3.log
SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2014-09-21 05:14:47

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>   number should decrease with time.
DOC>     SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>   should increase with time.
DOC>     SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>     SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>     SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#


PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2014-09-21 05:34:14

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
  0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
  0


Function created.


PL/SQL procedure successfully completed.


Function dropped.


PL/SQL procedure successfully completed.

SQL> SQL>


[oracle@ora-rac01 ~]$ srvctl remove database -d dath
Remover o banco de dados dath? (y/[n]) y
[oracle@ora-rac01 ~]$

SQL> show parameter spfile

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile     string
SQL> create spfile='+DATA/DATH/spfiledath.ora' from pfile='/home/oracle/initdath1.ora';

File created.

[oracle@ora-rac01 dbs]$ srvctl add database -d dath -o $ORACLE_HOME -y AUTOMATIC -a "DATA,RECO"
[oracle@ora-rac01 dbs]$ srvctl add instance -d dath -i dath1 -n ora-rac01
[oracle@ora-rac01 dbs]$ srvctl add instance -d dath -i dath2 -n ora-rac02
[oracle@ora-rac01 ~]$ srvctl start database -d dath -o open
[oracle@ora-rac01 ~]$ srvctl status database -d dath
A instância dath1 está em execução no nó ora-rac01
A instância dath2 está em execução no nó ora-rac02

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select instance_name, status from gv$instance;

INSTANCE_NAME STATUS
---------------- ------------
dath1 OPEN
dath2 OPEN

Bem é isso, finalizamos nossa atualização do ambiente de Cluster Oracle RAC 11gR2, saimos da release 11.2.0.2 para 11.2.0.3, espero que tenham apreciado esse laboratório e que ele seja util para todos vocês, obrigado mais uma vez pela paciencia.
Por Thiago Silva.
 
PessoALL, espero que tenham gostado, divirtam-se experimentando essa atualização em seus laboratórios, obrigado ao meu amigo Thiago pela honra de aceitar escrever em meu espaço, espero que seja util. SUCESSO SEMPRE!!!




.