Oracle Technology Network
Artículos
Rendimiento y Disponibilidad de Base de datos
Artículos
Rendimiento y Disponibilidad de Base de datos
Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 3)
Por Deiby Gómez Robles e Yenugula Venkata RaviKumar (OCM)
Publicado en Marzo 2014
Indice:
- Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 1)
- Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 2)
- Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 3)
Introducción: En las dos partes anteriores de este artículo sobre implementación de seguridad en un ambiente de "Oracle Exadata Database Machine" se ha demostrado la manera en la que se crea la seguridad a nivel de ASM (Parte 1) y a nivel de base de datos (Parte 2) para satisfacer los diferentes requerimientos de la organización y acompañar en todo el ciclo de vida de los datos. En esta última parte del articulo se demostrará como eliminar la configuración de seguridad tanto a nivel de ASM como a nivel de Base de Datos, de esta manera no solo el articulo en sus tres partes le ayudará a implementar la seguridad en su organización sino también al demostrar el procedimiento de eliminación de la seguridad le provee un articulo completo que puede ser utilizado para fines de pruebas o para fines educativos. "Oracle Exadata Database Machine" día con día está ganando popularidad en los países de Latinoamérica, no solo por los bajos tiempos que utiliza para procesar grandes cantidades de Datos, la taza de compresión que provee "Hybrid Columnar Compression", sino porque provee muchas características que facilitan la administración de los servidores de base de datos y de almacenamiento, sin embargo, al existir muchos servidores ( 22 servidores en un "Full Rack", y tomando en cuenta que "Oracle Exadata Database Machine es una solución escalable") la seguridad es un problema emergente que bien puede compararse con el problema de seguridad cuando en una base de datos el número de usuarios es muy grande. Se sabe que para manejar los privilegios de los usuarios más fácilmente existen los roles, qué no es más que un grupo de usuarios, pues bien, la seguridad en Exadata vendría a ser una analogía, donde los roles podrían ser los clústeres de ASM y los usuarios podrían ser las bases de datos, se puede restringir el acceso a los "Grid Disk" agrupando las bases de datos por el uso de un mismo clúster de ASM (Granularidad Gruesa) o bien puede restringir el acceso a los "Grid Disk" por cada una de las bases de datos (Granularidad fina).
Eliminando la seguridad a nivel de ASM y a nivel de Base de Datos
- Bajar la instancia de ASM y de Base de Datos:
- Modificar el "Grid Disk" desde el "Exadata Cell Cell01":
- Revisar el atributo "availableTo" de cada "Grid Disk" en el "Exadata Cell Cell01":
- Revisar el atributo "availableTo" de cada "Grid Disk" en el "Exadata Cell Cell02":
- Modificar el "Grid Disk" desde el "Exadata Cell Cell01":
- Realizar "Login" en el "Exadata Cell Cell01" y eliminar las llaves asignadas a las bases de datos y a los clústeres de ASM:
- Modificar los "Grid Disk" desde el "Exadata Cell Cell02":
- Realizar "Login" en el "Exadata Cell Cell02" y eliminar las llaves asignadas a las bases de datos y a los clústeres de ASM:
- Eliminar el archivo "cellkey.ora" tanto en el directorio "/etc/oracle/cell/network-config" como en el "$ORACLE_HOME/admin/<SID>/pfile", esto es para remover la configuración para los clústeres de ASM y para la base de datos respectivamente.
- Iniciar la instancia de base de datos y de ASM:
- Realizar "Login" en la base de datos y revisar el estado de la misma:
[oracle@exadb01 ~]$ . oraenv ORACLE_SID = [xdbvm] ? +ASM The Oracle base remains unchanged with value /u01/app/oracle [oracle@exadb01 ~]$ ps -ef | grep pmon 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 grep pmon [oracle@exadb01 ~]$ srvctl stop database -d xdbvm [oracle@exadb01 ~]$ [oracle@exadb01 ~]$ ps -ef | grep pmon oracle 3441 1 0 08:55 ? 00:00:00 asm_pmon_+ASM oracle 4455 3392 0 09:21 pts/2 00:00:00 grep pmon [oracle@exadb01 ~]$ srvctl stop diskgroup -g DATA [oracle@exadb01 ~]$ srvctl stop diskgroup -g RECO [oracle@exadb01 ~]$ srvctl stop asm [oracle@exadb01 ~]$ ps -ef | grep pmon oracle 4529 3392 0 09:22 pts/2 00:00:00 grep pmon [oracle@exadb01 ~]$
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
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 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
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
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
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>
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>
[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 -rf cellkey.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 -rf cellkey.ora
[oracle@exadb01 ~]$ . oraenv ORACLE_SID = [+ASM] ? +ASM The Oracle base remains unchanged with value /u01/app/oracle [oracle@exadb01 ~]$ ps -ef | grep pmon oracle 4603 3392 0 09:31 pts/2 00:00:00 grep pmon [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 | grep pmon 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 grep pmon
[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.
Printer ViewContáctenos
- Ventas en EE. UU.: +1.800.633.0738
- Reciba una llamada de Oracle
- Contactos globales
- Directorio de soporte