Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 3)

Por Deiby Gómez Robles , Yenugula Venkata RaviKumar (OCM) e David Siqueira
Postado en março 2014

Indice:

1. Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 1)
2. Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 2)
3. Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 3)

Introdução: Nas duas partes anteriores deste artigo sobre implementação de segurança em um ambiente "Oracle Exadata Database Machine" foi demonstrado a maneira de como se cria segurança a nivel de ASM (Parte 1) e a nível de Base de Dados (Parte 2) para satisfazer todos os requisitos das organizações e acompanhar o ciclo de vida dos dados. Netsa ultima parte do artigo demonstraremos como remover a configuração de segurança tanto a nivel de ASM como a nivel de Base de Dados, assim o artigo não só o ajudará a implementar a segurança como também lhe auxiliará na remoção desta segurança, tornando o artigo completo que pode ser utilizado pra provas e estudos. "Oracle Exadata Database Machine" a cada dia ganha mais popularidade nos paises Latino Americanos, não somente pelos baixos tempos oferecidos ao processar grandes quantidades de dados, a compressão fornecida pelo  "HybridColumnarCompression", mas sim porque fornecem muitos recursos que facilitam a administração dos servidores de bases de dados e armazenamento, no entanto, por existir muitos servidores ( 22 servidores em um  "Full Rack", levando em consideração que Oracle ExadataDatabase Machine é uma solução escalavel") l a segurança é um problema emergente que pode ser comparado com o problema de segurança quando um número de banco de dados de usuários é muito grande. Sabemos que para gerenciar privilégios de usuários existemas roles (papéis), que nada mais é do que um grupo de usuários, pois bem, a segurança no  Exadata viria a ser uma analogia, onde as roles poderiam ser os clusteres de ASM e os usuários podem ser as bases de dados, onde você pode restringir os acessos aos  "Grid Disk" agrupando as bases de dados pelo mesmo uso do clúster de ASM (Granularidade Grossa) ou você pode restringir o acesso aos "Grid Disk" para cada uma das bases de dados (Granularidade Fina).

Removendo a Segurança a Nível de ASM e a Nivel de Banco de Dados

1. Baixar a instância de ASM e de Banco de Dados:

[oracle@exadb01  ~]$ . oraenv
ORACLE_SID  = [xdbvm] ?+ASM
The Oracle base remains  unchanged with value /u01/app/oracle
[oracle@exadb01 ~]$ ps -ef |  greppmon
oracle    3441      1  0 08:55 ?        00:00:00 asm_pmon_+ASM
oracle    3704      1  0 08:55 ?        00:00:00 ora_pmon_xdbvm
oracle    4374   3392  0 09:17 pts/2    00:00:00 greppmon
[oracle@exadb01 ~]$ srvctl  stop database -d xdbvm
[oracle@exadb01 ~]$
[oracle@exadb01 ~]$ ps -ef |  greppmon
oracle    3441      1  0 08:55 ?        00:00:00 asm_pmon_+ASM
oracle    4455   3392  0 09:21 pts/2    00:00:00 greppmon
[oracle@exadb01 ~]$ srvctl  stop diskgroup -g DATA
[oracle@exadb01 ~]$ srvctl  stop diskgroup -g RECO
[oracle@exadb01 ~]$ srvctl  stop asm
[oracle@exadb01 ~]$ ps -ef |  greppmon
oracle    4529   3392  0 09:22 pts/2    00:00:00 greppmon
[oracle@exadb01 ~]$



2. Modificar o "Grid Disk" da "Exadata Cell Cell01":

CellCLI> alter griddisk  DATA_CD_disk01_cell01,DATA_CD_disk02_cell01,DATA_CD_disk03_cell01,
DATA_CD_disk04_cell01,DATA_CD_disk05_cell01,DATA_CD_disk06_cell01,
DATA_CD_disk07_cell01,DATA_CD_disk08_cell01,DATA_CD_disk09_cell01,
DATA_CD_disk10_cell01,DATA_CD_disk11_cell01,DATA_CD_disk12_cell01,
RECO_CD_disk01_cell01,RECO_CD_disk02_cell01,RECO_CD_disk03_cell01,
RECO_CD_disk04_cell01,RECO_CD_disk05_cell01,RECO_CD_disk06_cell01,
RECO_CD_disk07_cell01,RECO_CD_disk08_cell01,RECO_CD_disk09_cell01,
RECO_CD_disk10_cell01,RECO_CD_disk11_cell01,RECO_CD_disk12_cell01  availableTo='+ASM'

GridDisk  DATA_CD_disk01_cell01 successfully altered
GridDisk  DATA_CD_disk02_cell01 successfully altered
GridDisk  DATA_CD_disk03_cell01 successfully altered
GridDisk  DATA_CD_disk04_cell01 successfully altered
GridDisk  DATA_CD_disk05_cell01 successfully altered
GridDisk  DATA_CD_disk06_cell01 successfully altered
GridDisk  DATA_CD_disk07_cell01 successfully altered
GridDisk  DATA_CD_disk08_cell01 successfully altered
GridDisk  DATA_CD_disk09_cell01 successfully altered
GridDisk  DATA_CD_disk10_cell01 successfully altered
GridDisk  DATA_CD_disk11_cell01 successfully altered
GridDisk  DATA_CD_disk12_cell01 successfully altered
GridDisk  RECO_CD_disk01_cell01 successfully altered
GridDisk  RECO_CD_disk02_cell01 successfully altered
GridDisk  RECO_CD_disk03_cell01 successfully altered
GridDisk  RECO_CD_disk04_cell01 successfully altered
GridDisk  RECO_CD_disk05_cell01 successfully altered
GridDisk  RECO_CD_disk06_cell01 successfully altered
GridDisk  RECO_CD_disk07_cell01 successfully altered
GridDisk  RECO_CD_disk08_cell01 successfully altered
GridDisk  RECO_CD_disk09_cell01 successfully altered
GridDisk  RECO_CD_disk10_cell01 successfully altered
GridDisk  RECO_CD_disk11_cell01 successfully altered
GridDisk  RECO_CD_disk12_cell01 successfully altered



3. Verificar os atributos "availableTo" de cada "Grid Disk" na "Exadata Cell Cell01":

CellCLI> list griddisk  attributes name, availableTo
         DATA_CD_disk01_cell01   +ASM
         DATA_CD_disk02_cell01   +ASM
         DATA_CD_disk03_cell01   +ASM
         DATA_CD_disk04_cell01   +ASM
         DATA_CD_disk05_cell01   +ASM
         DATA_CD_disk06_cell01   +ASM
         DATA_CD_disk07_cell01   +ASM
         DATA_CD_disk08_cell01   +ASM
         DATA_CD_disk09_cell01   +ASM
         DATA_CD_disk10_cell01   +ASM
         DATA_CD_disk11_cell01   +ASM
         DATA_CD_disk12_cell01   +ASM
         RECO_CD_disk01_cell01   +ASM
         RECO_CD_disk02_cell01   +ASM
         RECO_CD_disk03_cell01   +ASM
         RECO_CD_disk04_cell01   +ASM
         RECO_CD_disk05_cell01   +ASM
         RECO_CD_disk06_cell01   +ASM
         RECO_CD_disk07_cell01   +ASM
         RECO_CD_disk08_cell01   +ASM
         RECO_CD_disk09_cell01   +ASM
         RECO_CD_disk10_cell01   +ASM
         RECO_CD_disk11_cell01   +ASM
         RECO_CD_disk12_cell01   +ASM



4. Verificar o atributo "availableTo" de cada "Grid Disk" na "Exadata Cell Cell02":

CellCLI> list griddisk  attributes name, availableTo
         DATA_CD_disk01_cell02   +ASM,xdbvm
         DATA_CD_disk02_cell02   +ASM,xdbvm
         DATA_CD_disk03_cell02   +ASM,xdbvm
         DATA_CD_disk04_cell02   +ASM,xdbvm
         DATA_CD_disk05_cell02   +ASM,xdbvm
         DATA_CD_disk06_cell02   +ASM,xdbvm
         DATA_CD_disk07_cell02   +ASM,xdbvm
         DATA_CD_disk08_cell02   +ASM,xdbvm
         DATA_CD_disk09_cell02   +ASM,xdbvm
         DATA_CD_disk10_cell02   +ASM,xdbvm
         DATA_CD_disk11_cell02   +ASM,xdbvm
         DATA_CD_disk12_cell02   +ASM,xdbvm
         RECO_CD_disk01_cell02   +ASM,xdbvm
         RECO_CD_disk02_cell02   +ASM,xdbvm
         RECO_CD_disk03_cell02   +ASM,xdbvm
         RECO_CD_disk04_cell02   +ASM,xdbvm
         RECO_CD_disk05_cell02   +ASM,xdbvm
         RECO_CD_disk06_cell02   +ASM,xdbvm
         RECO_CD_disk07_cell02   +ASM,xdbvm
         RECO_CD_disk08_cell02   +ASM,xdbvm
         RECO_CD_disk09_cell02   +ASM,xdbvm
         RECO_CD_disk10_cell02   +ASM,xdbvm
         RECO_CD_disk11_cell02   +ASM,xdbvm
         RECO_CD_disk12_cell02   +ASM,xdbvm



5. Modificar o "Grid Disk" na "Exadata Cell Cell01":

CellCLI> alter griddisk  DATA_CD_disk01_cell02,DATA_CD_disk02_cell02,DATA_CD_disk03_cell02,
DATA_CD_disk04_cell02,DATA_CD_disk05_cell02,DATA_CD_disk06_cell02,
DATA_CD_disk07_cell02,DATA_CD_disk08_cell02,DATA_CD_disk09_cell02,
DATA_CD_disk10_cell02,DATA_CD_disk11_cell02,DATA_CD_disk12_cell02,
RECO_CD_disk01_cell02,RECO_CD_disk02_cell02,RECO_CD_disk03_cell02,
RECO_CD_disk04_cell02,RECO_CD_disk05_cell02,RECO_CD_disk06_cell02,
RECO_CD_disk07_cell02,RECO_CD_disk08_cell02,RECO_CD_disk09_cell02,
RECO_CD_disk10_cell02,RECO_CD_disk11_cell02,RECO_CD_disk12_cell02  availableTo='+ASM'

GridDisk  DATA_CD_disk01_cell02 successfully altered
GridDisk  DATA_CD_disk02_cell02 successfully altered
GridDisk  DATA_CD_disk03_cell02 successfully altered
GridDisk  DATA_CD_disk04_cell02 successfully altered
GridDisk  DATA_CD_disk05_cell02 successfully altered
GridDisk  DATA_CD_disk06_cell02 successfully altered
GridDisk  DATA_CD_disk07_cell02 successfully altered
GridDisk  DATA_CD_disk08_cell02 successfully altered
GridDisk  DATA_CD_disk09_cell02 successfully altered
GridDisk  DATA_CD_disk10_cell02 successfully altered
GridDisk  DATA_CD_disk11_cell02 successfully altered
GridDisk  DATA_CD_disk12_cell02 successfully altered
GridDisk  RECO_CD_disk01_cell02 successfully altered
GridDisk  RECO_CD_disk02_cell02 successfully altered
GridDisk  RECO_CD_disk03_cell02 successfully altered
GridDisk RECO_CD_disk04_cell02  successfully altered
GridDisk  RECO_CD_disk05_cell02 successfully altered
GridDisk  RECO_CD_disk06_cell02 successfully altered
GridDisk  RECO_CD_disk07_cell02 successfully altered
GridDisk  RECO_CD_disk08_cell02 successfully altered
GridDisk RECO_CD_disk09_cell02  successfully altered
GridDisk  RECO_CD_disk10_cell02 successfully altered
GridDisk  RECO_CD_disk11_cell02 successfully altered
GridDisk  RECO_CD_disk12_cell02 successfully altered

CellCLI> list griddisk  attributes name, availableTo
         DATA_CD_disk01_cell02   +ASM
         DATA_CD_disk02_cell02   +ASM
         DATA_CD_disk03_cell02   +ASM
         DATA_CD_disk04_cell02   +ASM
         DATA_CD_disk05_cell02   +ASM
         DATA_CD_disk06_cell02   +ASM
         DATA_CD_disk07_cell02   +ASM
         DATA_CD_disk08_cell02   +ASM
         DATA_CD_disk09_cell02   +ASM
         DATA_CD_disk10_cell02   +ASM
         DATA_CD_disk11_cell02   +ASM
         DATA_CD_disk12_cell02   +ASM
         RECO_CD_disk01_cell02   +ASM
         RECO_CD_disk02_cell02   +ASM
         RECO_CD_disk03_cell02   +ASM
         RECO_CD_disk04_cell02   +ASM
         RECO_CD_disk05_cell02   +ASM
         RECO_CD_disk06_cell02   +ASM
         RECO_CD_disk07_cell02   +ASM
         RECO_CD_disk08_cell02   +ASM
         RECO_CD_disk09_cell02   +ASM
         RECO_CD_disk10_cell02   +ASM
         RECO_CD_disk11_cell02   +ASM
         RECO_CD_disk12_cell02   +ASM



6. Efetuar "Login" no "Exadata Cell Cell01" e remover as chaves registradas para as bases de dados e para os clusteres de ASM :

CellCLI> assign key for  xdbvm=''
Key for xdbvm successfully  dropped

CellCLI> alter griddisk  all availableTo=''
GridDisk  DATA_CD_disk01_cell01 successfully altered
GridDisk  DATA_CD_disk02_cell01 successfully altered
GridDisk DATA_CD_disk03_cell01  successfully altered
GridDisk  DATA_CD_disk04_cell01 successfully altered
GridDisk  DATA_CD_disk05_cell01 successfully altered
GridDisk  DATA_CD_disk06_cell01 successfully altered
GridDisk  DATA_CD_disk07_cell01 successfully altered
GridDisk DATA_CD_disk08_cell01  successfully altered
GridDisk  DATA_CD_disk09_cell01 successfully altered
GridDisk  DATA_CD_disk10_cell01 successfully altered
GridDisk  DATA_CD_disk11_cell01 successfully altered
GridDisk  DATA_CD_disk12_cell01 successfully altered
GridDisk RECO_CD_disk01_cell01  successfully altered
GridDisk  RECO_CD_disk02_cell01 successfully altered
GridDisk  RECO_CD_disk03_cell01 successfully altered
GridDisk  RECO_CD_disk04_cell01 successfully altered
GridDisk  RECO_CD_disk05_cell01 successfully altered
GridDisk  RECO_CD_disk06_cell01 successfully altered
GridDisk  RECO_CD_disk07_cell01 successfully altered
GridDisk  RECO_CD_disk08_cell01 successfully altered
GridDisk  RECO_CD_disk09_cell01 successfully altered
GridDisk  RECO_CD_disk10_cell01 successfully altered
GridDisk  RECO_CD_disk11_cell01 successfully altered
GridDisk  RECO_CD_disk12_cell01 successfully altered

CellCLI> list griddisk  attributes name, availableTo
         DATA_CD_disk01_cell01
         DATA_CD_disk02_cell01
         DATA_CD_disk03_cell01
         DATA_CD_disk04_cell01
         DATA_CD_disk05_cell01
         DATA_CD_disk06_cell01
         DATA_CD_disk07_cell01
         DATA_CD_disk08_cell01
         DATA_CD_disk09_cell01
         DATA_CD_disk10_cell01
         DATA_CD_disk11_cell01
         DATA_CD_disk12_cell01
         RECO_CD_disk01_cell01
         RECO_CD_disk02_cell01
         RECO_CD_disk03_cell01
         RECO_CD_disk04_cell01
         RECO_CD_disk05_cell01
         RECO_CD_disk06_cell01
         RECO_CD_disk07_cell01
         RECO_CD_disk08_cell01
         RECO_CD_disk09_cell01
         RECO_CD_disk10_cell01
         RECO_CD_disk11_cell01
         RECO_CD_disk12_cell01



7. Modificar os "Grid Disk" na "Exadata Cell Cell02":

CellCLI> alter griddisk  DATA_CD_disk01_cell01,DATA_CD_disk02_cell01,DATA_CD_disk03_cell01,
DATA_CD_disk04_cell01,DATA_CD_disk05_cell01,DATA_CD_disk06_cell01,
DATA_CD_disk07_cell01,DATA_CD_disk08_cell01,DATA_CD_disk09_cell01,
DATA_CD_disk10_cell01,DATA_CD_disk11_cell01,DATA_CD_disk12_cell01,
RECO_CD_disk01_cell01,RECO_CD_disk02_cell01,RECO_CD_disk03_cell01,
RECO_CD_disk04_cell01,RECO_CD_disk05_cell01,RECO_CD_disk06_cell01,
RECO_CD_disk07_cell01,RECO_CD_disk08_cell01,RECO_CD_disk09_cell01,
RECO_CD_disk10_cell01,RECO_CD_disk11_cell01,RECO_CD_disk12_cell01 
availableTo=''

GridDisk  DATA_CD_disk01_cell01 successfully altered
GridDisk  DATA_CD_disk02_cell01 successfully altered
GridDisk  DATA_CD_disk03_cell01 successfully altered
GridDisk  DATA_CD_disk04_cell01 successfully altered
GridDisk  DATA_CD_disk05_cell01 successfully altered
GridDisk  DATA_CD_disk06_cell01 successfully altered
GridDisk  DATA_CD_disk07_cell01 successfully altered
GridDisk  DATA_CD_disk08_cell01 successfully altered
GridDisk  DATA_CD_disk09_cell01 successfully altered
GridDisk  DATA_CD_disk10_cell01 successfully altered
GridDisk  DATA_CD_disk11_cell01 successfully altered
GridDisk  DATA_CD_disk12_cell01 successfully altered
GridDisk  RECO_CD_disk01_cell01 successfully altered
GridDisk  RECO_CD_disk02_cell01 successfully altered
GridDisk  RECO_CD_disk03_cell01 successfully altered
GridDisk  RECO_CD_disk04_cell01 successfully altered
GridDisk  RECO_CD_disk05_cell01 successfully altered
GridDisk  RECO_CD_disk06_cell01 successfully altered
GridDisk  RECO_CD_disk07_cell01 successfully altered
GridDisk  RECO_CD_disk08_cell01 successfully altered
GridDisk  RECO_CD_disk09_cell01 successfully altered
GridDisk  RECO_CD_disk10_cell01 successfully altered
GridDisk  RECO_CD_disk11_cell01 successfully altered
GridDisk  RECO_CD_disk12_cell01 successfully altered

CellCLI> list griddisk  attributes name, availableTo
         DATA_CD_disk01_cell01
         DATA_CD_disk02_cell01
         DATA_CD_disk03_cell01
         DATA_CD_disk04_cell01
         DATA_CD_disk05_cell01
         DATA_CD_disk06_cell01
         DATA_CD_disk07_cell01
         DATA_CD_disk08_cell01
         DATA_CD_disk09_cell01
         DATA_CD_disk10_cell01
         DATA_CD_disk11_cell01
         DATA_CD_disk12_cell01
         RECO_CD_disk01_cell01
         RECO_CD_disk02_cell01
         RECO_CD_disk03_cell01
         RECO_CD_disk04_cell01
         RECO_CD_disk05_cell01
         RECO_CD_disk06_cell01
         RECO_CD_disk07_cell01
         RECO_CD_disk08_cell01
         RECO_CD_disk09_cell01
         RECO_CD_disk10_cell01
         RECO_CD_disk11_cell01
         RECO_CD_disk12_cell01

CellCLI> assign key for  +ASM=''
Key for +ASM successfully  dropped

CellCLI> list key
CellCLI>



8. Efetuar  "Login" na "Exadata Cell Cell02" e remover as chaves registradas para as bases de dados e para os clusteres de ASM:

CellCLI> assign key for  xdbvm=''
Key for xdbvm successfully  dropped

CellCLI> alter griddisk  all availableTo=''
GridDisk  DATA_CD_disk01_cell02 successfully altered
GridDisk  DATA_CD_disk02_cell02 successfully altered
GridDisk  DATA_CD_disk03_cell02 successfully altered
GridDisk  DATA_CD_disk04_cell02 successfully altered
GridDisk  DATA_CD_disk05_cell02 successfully altered
GridDisk  DATA_CD_disk06_cell02 successfully altered
GridDisk  DATA_CD_disk07_cell02 successfully altered
GridDisk  DATA_CD_disk08_cell02 successfully altered
GridDisk  DATA_CD_disk09_cell02 successfully altered
GridDisk  DATA_CD_disk10_cell02 successfully altered
GridDisk  DATA_CD_disk11_cell02 successfully altered
GridDisk  DATA_CD_disk12_cell02 successfully altered
GridDisk  RECO_CD_disk01_cell02 successfully altered
GridDisk  RECO_CD_disk02_cell02 successfully altered
GridDisk  RECO_CD_disk03_cell02 successfully altered
GridDisk  RECO_CD_disk04_cell02 successfully altered
GridDisk  RECO_CD_disk05_cell02 successfully altered
GridDisk  RECO_CD_disk06_cell02 successfully altered
GridDisk  RECO_CD_disk07_cell02 successfully altered
GridDisk  RECO_CD_disk08_cell02 successfully altered
GridDisk  RECO_CD_disk09_cell02 successfully altered
GridDisk  RECO_CD_disk10_cell02 successfully altered
GridDisk  RECO_CD_disk11_cell02 successfully altered
GridDisk  RECO_CD_disk12_cell02 successfully altered

CellCLI> alter griddisk  DATA_CD_disk01_cell02,DATA_CD_disk02_cell02,DATA_CD_disk03_cell02,
DATA_CD_disk04_cell02,DATA_CD_disk05_cell02,DATA_CD_disk06_cell02,
DATA_CD_disk07_cell02,DATA_CD_disk08_cell02,DATA_CD_disk09_cell02,
DATA_CD_disk10_cell02,DATA_CD_disk11_cell02,DATA_CD_disk12_cell02,
RECO_CD_disk01_cell02,RECO_CD_disk02_cell02,RECO_CD_disk03_cell02,
RECO_CD_disk04_cell02,RECO_CD_disk05_cell02,RECO_CD_disk06_cell02,
RECO_CD_disk07_cell02,RECO_CD_disk08_cell02,RECO_CD_disk09_cell02,
RECO_CD_disk10_cell02,RECO_CD_disk11_cell02,RECO_CD_disk12_cell02 
availableTo=''

GridDisk DATA_CD_disk01_cell02  successfully altered
GridDisk  DATA_CD_disk02_cell02 successfully altered
GridDisk  DATA_CD_disk03_cell02 successfully altered
GridDisk  DATA_CD_disk04_cell02 successfully altered
GridDisk  DATA_CD_disk05_cell02 successfully altered
GridDisk DATA_CD_disk06_cell02  successfully altered
GridDisk  DATA_CD_disk07_cell02 successfully altered
GridDisk  DATA_CD_disk08_cell02 successfully altered
GridDisk  DATA_CD_disk09_cell02 successfully altered
GridDisk  DATA_CD_disk10_cell02 successfully altered
GridDisk DATA_CD_disk11_cell02  successfully altered
GridDisk  DATA_CD_disk12_cell02 successfully altered
GridDisk  RECO_CD_disk01_cell02 successfully altered
GridDisk  RECO_CD_disk02_cell02 successfully altered
GridDisk  RECO_CD_disk03_cell02 successfully altered
GridDisk RECO_CD_disk04_cell02  successfully altered
GridDisk  RECO_CD_disk05_cell02 successfully altered
GridDisk  RECO_CD_disk06_cell02 successfully altered
GridDisk  RECO_CD_disk07_cell02 successfully altered
GridDisk  RECO_CD_disk08_cell02 successfully altered
GridDisk  RECO_CD_disk09_cell02 successfully altered
GridDisk  RECO_CD_disk10_cell02 successfully altered
GridDisk  RECO_CD_disk11_cell02 successfully altered
GridDisk  RECO_CD_disk12_cell02 successfully altered

CellCLI> list griddisk  attributes name, availableTo
         DATA_CD_disk01_cell02
         DATA_CD_disk02_cell02
         DATA_CD_disk03_cell02
         DATA_CD_disk04_cell02
         DATA_CD_disk05_cell02
         DATA_CD_disk06_cell02
         DATA_CD_disk07_cell02
         DATA_CD_disk08_cell02
         DATA_CD_disk09_cell02
         DATA_CD_disk10_cell02
         DATA_CD_disk11_cell02
         DATA_CD_disk12_cell02
         RECO_CD_disk01_cell02
         RECO_CD_disk02_cell02
         RECO_CD_disk03_cell02
         RECO_CD_disk04_cell02
         RECO_CD_disk05_cell02
         RECO_CD_disk06_cell02
         RECO_CD_disk07_cell02
         RECO_CD_disk08_cell02
         RECO_CD_disk09_cell02
         RECO_CD_disk10_cell02
         RECO_CD_disk11_cell02
         RECO_CD_disk12_cell02

CellCLI> assign key for +ASM=''
Key for +ASM successfully  dropped

CellCLI> list key
CellCLI>



9. Remover o arquivo "cellkey.ora" tanto no diretório "/etc/oracle/cell/network-config" como no"$ORACLE_HOME/admin/<SID>/pfile", isto é para remover a configuração para os clusteres de ASM e apra a base de dados respectivamente.

[oracle@exadb01 pfile]$ pwd
/u01/app/oracle/admin/xdbvm/pfile
[oracle@exadb01 pfile]$ ls  -lrth
total 8.0K
-rw-r----- 1 oracle oinstall  1.8K Oct  7 12:19 init.ora.972013122932
-rw-r----- 1 oracle  oinstall   48 Dec  3 08:42 cellkey.ora
[oracle@exadb01 pfile]$ rm  -rfcellkey.ora

oracle@exadb01 pfile]$ cd  /etc/oracle/cell/network-config
[oracle@exadb01  network-config]$ ls -lrth
total 16K
-rw-r--r-- 1 oracle  oinstall  44 Aug  8 05:17 cellip.ora
-rw-r--r-- 1 oracle oinstall  263 Aug 21 14:19 cellinit.ora.bak
-rw-r--r-- 1 oracle  oinstall  29 Aug 21 14:19 cellinit.ora
-rw-r----- 1 oracle  oinstall  60 Dec  3 05:38 cellkey.ora
[oracle@exadb01  network-config]$ rm -rfcellkey.ora



10. Iniciar a instancia de banco de dados e de ASM:

[oracle@exadb01 ~]$ . oraenv
ORACLE_SID = [+ASM] ? +ASM
The Oracle base remains  unchanged with value /u01/app/oracle
[oracle@exadb01 ~]$ ps -ef |  greppmon
oracle    4603   3392  0 09:31 pts/2    00:00:00 greppmon
[oracle@exadb01 ~]$ srvctl  start asm
[oracle@exadb01 ~]$ srvctl  start diskgroup -g DATA
[oracle@exadb01 ~]$ srvctl  start diskgroup -g RECO
[oracle@exadb01 ~]$ srvctl  start database -d xdbvm
[oracle@exadb01 ~]$ ps -ef |  greppmon
oracle    4688      1  0 09:31 ?        00:00:00 asm_pmon_+ASM
oracle    4962      1  0 09:32 ?        00:00:00 ora_pmon_xdbvm
oracle    5240   3392  0 09:33 pts/2    00:00:00 greppmon



11. Efetuar "Login" na base de dado e revisar o status da base:

[oracle@exadb01 ~]$ . oraenv
ORACLE_SID = [+ASM] ?xdbvm
The Oracle base remains  unchanged with value /u01/app/oracle
[oracle@exadb01 ~]$ sqlplus  /nolog

SQL*Plus: Release 11.2.0.3.0  Production on Tue Dec 3 09:33:31 2013

Copyright (c) 1982, 2011,  Oracle.  All rights reserved.

SQL> connect  sys/welcome1@xdbvm as sysdba
Connected.

SQL> select  open_mode,database_role from v$database;

OPEN_MODE            DATABASE_ROLE
-------------------  ----------------
READ WRITE           PRIMARY

Deiby Gómez es un DBA con experiencia en Oracle Exadata Database Machine y Soluciones de Alta Disponibilidad. Frecuentemente da conferencias en distintos eventos de Oracle en Guatemala tales como "Oracle Technology Network Tour", "Java Day", "Primer Simposio de Oracle" y en varias Universidades de su país de residencia (Guatemala). Deiby es el primer Oracle ACE de Guatemala. Deiby es "Oracle RAC 11g and Grid Infraestructure Administrator" y "Exadata Database Machine X3 Administrator". Constantemente publica artículos en su blog www.oraclefromguatemala.com.gt.

Yenugula Venkata RaviKumar es un DBA con más de 13 años de experiencia, especializado en ambientes de Alta Disponibilidad de Bases de Datos (RAC, Data Guard, Golden Gate, entre otras),  afinación del rendimiento para Bases de Datos, Migraciones y Respaldos, Oracle Exadata X2 y X3, experto en Sistemas operativos como AIX, HP-UX y Linux . Ha participado como conferencista en varios eventos Oracle en la India donde actualmente reside. Obtuvo el título de Oracle Certified Master 10g en el año 2009.Constantemente publica artículos en su blog http://yvrk1973.blogspot.in.

David Siqueira DBA desde 2001, atuante no mercado de São Paulo Brasil, trabalhou nas principais consultorias sempre buscando melhorar conhecimentos e agregar valor aos ambientes por onde passou, é OCP 10 e 11g, OCE SQL Expert, OCE RAC 10g, OCE Exadata Essentials e foi nomeado Oracle ACE em Dezembro de 2011. Atua com ambientes de Alta Disponibilidade Oracel RAC 11g, Exadata X2-2 e Administração de Banco de Dados em Geral. Também possui conhecimentos em sistemas operacionais Oracle VM server e Oracle Businnes Intelligence.