Oracle RAC 12cR2 - NERV
Oracle RAC 12cR2 Em Red Hat Eoterprise Lioux 7a4 Iociui CDB Arclitecture Ricardo Portilo Prooi ricardo@oervioformatcaacomabr Esta obra está iiceociada sob a iiceoça Creatve Commoos AtribuiçooSӹemDerivados oa0 Brasiia Para ver uma cópia desta iiceoça, visite ltp://creatvecommoosaorg/iiceoses/bySod/oa0/br/a
Comandos no Treinamento Comando com o usuário root: # ls -lh Comando com um usuário oracle: ls -lh Adicionar texto a um arquivo: vi initORCL.ora . db cache size 500M . Comando no Oracle: SQL SELECT STATUS FROM V INSTANCE; Algo deve ser alterado de acordo com sua máquina: Hostoame: nerv01aiocaidomaio Quando algo dá errado propositalmente: O que aconteceu? Coloque todas as senhas (root, oracle, SYS, SYSTEM) como Nerv2018. 2
rlwrap # wget -latest-7.noarch.rpm # yum -y install epel-release-latest-7.noarch.rpm # yum -y install rlwrap rlwrap rlwrap rlwrap rlwrap sqlplus / AS SYSDBA rman TARGET / lsnrctl dgmgrl SYS/Nerv2018@ORCL 3
Por que usar o RAC? Dispooibiiidade Escaiabiiidade Custo Totai de Propriedade (TCO) 4 4
Por que não usar o RAC? Custo de Equipameotos Custo de Liceoças Custo de Coolecimeoto Compiexidade Escaiabiiidade 5 5
Arquitetura 6 6
Oracle RAC x Single Instance 1 Database x N Iostaoces Backgrouod Processes daemoos OCR Votog Disk 7 7
Evolução Oracle RAC Oracle 6.0.35: VAX / VMӹ Oracle 7: PCM Oracle 8i: Cacle Fusioo I Oracle 9i: Cacle Fusioo II, Oracie Ciuster Maoagemeot ӹervices Oracle 10gR1: Oracie Ciuster Maoagemeot ӹervices Ciuster Ready ӹervices (CRӹ) AӹM S Automatc ӹtorage maoagemeot FAN S Fast Appiicatoo Notfcatoo Iotegraçoo com Database ӹervices AWR, ADDM, AӹH, ӹcleduier, Eoterprise Maoager Oracle 10gR2: CRӹ Oracie Ciusterwarea New Features iociuem: ciuvfy, asmcmda Oracle 11gR1: Apeoas 7 New Featuresa Oracle 11gR2: CRӹ Grid Iofrastrucutrea o2 New Featuresa Oracle 12cR1: oo New Featuresa Oracle 12cR2: o2 New Featuresa 8 8
RAC 11gR1 New Features Eolaoced Oracie RAC Mooitoriog aod Diagoostcs io Eoterprise Maoager Eolaoced Oracie Reai Appiicatoo Ciusters Coofguratoo Assistaots OCI Ruotme Coooectoo Load Baiaociog Paraiiei Executoo for Oracie Reai Appiicatoo Ciusters ӹupport for Distributed Traosactoos io ao Oracie RAC Eoviroomeot Eolaoced Oracie RAC ӹwitclover ӹupport for Logicai ӹtaodby Databases Eolaoced Oracie RAC Mooitoriog aod Diagoostcs io Eoterprise Maoager 9 9
RAC 11gR2 New Features – Parte 1 Coofguratoo Assistaots ӹupport New Oracie RAC Features Enhanced Cluster Verifcaton Utlity Integraton of Cluster Verifcaton Utlity and Oracle Universal Installer Cluster Time Service Oracie Ciuster Registry (OCR) Eolaocemeots Grid Piug aod Piay (GPoP) Oracle Restart Policy-Based Cluster and Capacity Management Improved Ciusterware Resource Modeiiog Role-Separated Management Ageot Deveiopmeot Framework Zero Downtme Patching for Oracle Clusterware and Oracle RAC Eoterprise MaoagerSBased Ciusterware Resource Maoagemeot Eoterprise Maoager Provisiooiog for Oracie Ciusterware aod Oracie Reai Appiicatoo Ciusters Eoterprise Maoager ӹupport for Grid Piug aod Piay Eoterprise Maoager ӹupport for Oracie Restart Coofguratoo Assistaot ӹupport for Removiog Oracie RAC Iostaiiatoos 10 10
RAC 11gR2 New Features – Parte 2 Oracie Uoiversai Iostaiier ӹupport for Removiog Oracie RAC Iostaiiatoos Improved Deiostaiiatoo ӹupport Witl Oracie Uoiversai Iostaiier Dowogradiog Database Coofgured Witl DBCootroi Oracie Restart Iotegratoo witl Oracie Uoiversai Iostaiier Out-of-Place Oracle Clusterware Upgrade OUI ӹupport for OutSofSPiace Oracie Ciusterware Upgrade ӹerver Cootroi (ӹRVCTL) Eolaocemeots ӹerver Cootroi (ӹRVCTL) Eolaocemeots to ӹupport Grid Piug aod Piay ӹRVCTL ӹupport for ӹiogieSIostaoce Database io a Ciuster Uoiversai Coooectoo Pooi (UCP) Iotegratoo witl Oracie Data Guard UCP Iotegratoo Witl Oracie Reai Appiicatoo Ciusters Uoiversai Coooectoo Pooi (UCP) for JDBC Java API for Oracie RAC FAN Higl Avaiiabiiity Eveots EMCA ӹupports New Oracie RAC Coofguratoo for Eoterprise Maoager Giobai Oracie RAC AӹH Report ADDM Backwards Compatbiiity 11 11
RAC 12cR1 New Features – Parte 1 Oracle Flex Cluster ӹRVCTL ӹupport for Oracie Fiex Ciuster Impiemeotatoos Policy-Based Cluster Management and Administraton WlatSIf Commaod Evaiuatoo Shared Grid Naming Service (GNS) Ooiioe Resource Atribute Modifcatoo Grid Infrastructure Script Automaton for Installaton and Upgrade Muitpurpose Ciuster Iostaiiatoo ӹupport ӹupport for IPv6 Based IP Addresses for Oracie RAC Ciieot Coooectvity Message Forwardiog oo Oracie RAC ӹlarded Queues for Performaoce aod ӹcaiabiiity Oracie Grid Iofrastructure Roiiiog Migratoo for OoeSOf Patcles 12 12
RAC 12cR1 New Features – Parte 2 Oracle Flex ASM Oracie AӹM ӹlared Password Fiie io a Disk Group Oracie AӹM Rebaiaoce Eolaocemeots Oracie AӹM Disk Resyoc Eolaocemeots Oracie AӹM clowo, clgrp, clmod aod Opeo Fiies ӹupport Oracie AӹM ӹupport ALTER DIӹKGROUP REPLACE UӹER Oracie AӹM Fiie Access Cootroi oo Wiodows Oracle ASM Disk Scrubbing Oracie Ciuster Registry Backup io AӹM Disk Group ӹupport Eoterprise Maoager ӹupport for Oracie AӹM Features Oracie ACFӹ ӹupport for Aii Oracie Database Fiies Oracie ACFӹ aod Higliy Avaiiabie NFӹ Oracie ACFӹ ӹoapslots Eolaocemeots Oracie ACFӹ Repiicatoo Iotegratoo witl Oracie ACFӹ ӹecurity aod Eocryptoo Oracie ACFӹ ӹecurity aod Eocryptoo Features Oracie ACFӹ Fiie Tags for Grid Homes Oracie ACFӹ PiugSio APIs Oracie ACFӹ Repiicatoo aod Taggiog oo AIX Oracie ACFӹ Repiicatoo aod Taggiog oo ӹoiaris Oracie Audit Vauit ӹupport for Oracie ACFӹ ӹecurity aod Eocryptoo Eoterprise Maoager ӹupport for Oracie ACFӹ New Features 13 13
RAC 12cR2 New Features – Parte 1 Oracle Flex ASM Disk Group Quota Management Prioritzed Rebalancing Exteodiog Oracie Reai Appiicatoo Ciusters (Oracie RAC) Coofguratoo ӹupport I/O ӹerver Ciuster Resource Actvity Log Ciuster Verifcatoo Utiity S ӹecood Geoeratoo Commaod Lioe Output ӹwitcl ӹervice Eolaocemeot VM Maoager Ageot for GI ӹlared Grid Namiog ӹervice Higl Avaiiabiiity Oracie Ciusterware Resource Groups Reasooed WlatSIf Commaod Evaiuatoo (WlySIf) Server Weight-Based Node Evicton Load-Aware Resource Placement Oracie Ciusterware Appiicatoo Ciusters Oracie Grid Iofrastructure Iostaiiatoo ӹupport for Appiicatoo Ciuster Iostaiiatoo Type 14 14
RAC 12cR2 New Features – Parte 2 Oracie Automatc ӹtorage Maoagemeot Ciuster Fiie ӹystem (Oracie ACFӹ) ӹoapslot Eolaocemeots Oracle ACFS System Defragger 4K ӹectors aod Metadata Eolaocemeots for Oracie ACFӹ Oracie ACFӹ Metadata Coiiectoo Eolaocemeots Oracie ACFӹ PiugSios for Fiie Cooteot Oracie ACFӹ Loopback Device Oracie ACFӹ API Access for ӹoapslots, Fiie Tags, PiugSio Metrics Oracle ACFS Compression Enhancements Oracie ӹoapslotSBased Repiicatoo Eolaocemeots Oracie ACFӹ AutoSResize Eolaocemeots Oracie ACFӹ ӹparse Fiies Eolaocemeots Oracie ACFӹ Metadata Acceieratoo Oracie ACFӹ NAӹ Maximum Avaiiabiiity eXteosioos Rapid Home Provisiooiog ӹupport for IPv6 Based IP Addresses for tle Oracie Ciuster Iotercoooect Oracle Real Applicaton Clusters (Oracle RAC) Reader Nodes Service-Oriented Bufer Cache Access Optmizaton 15 15
Flex ASM 16 16
Flex Cluster 17 17
Lab 1.1: Instalação RHEL 7 18
Lab 1.2: Instalação RHEL 7 19
Lab 1.3: Instalação RHEL 7 20
Lab 1.4: Instalação RHEL 7 21
Lab 1.5: Instalação RHEL 7 22
Lab 1.6: Instalação RHEL 7 23
Lab 1.7: Instalação RHEL 7 24
Lab 1.8: Instalação RHEL 7 25
Lab 1.9: Instalação RHEL 7 26
Lab 1.10: Instalação RHEL 7 27
Lab 1.11: Instalação RHEL 7 28
Lab 1.12: Instalação RHEL 7 29
Lab 1.13: Instalação RHEL 7 30
Lab 1.14: Instalação RHEL 7 31
Lab 1.15: Instalação RHEL 7 32
Lab 1.16: Instalação RHEL 7 33
Lab 1.17: Instalação RHEL 7 34
Lab 1.18: Instalação RHEL 7 35
Lab 1.19: Instalação RHEL 7 36
Lab 1.20: Instalação RHEL 7 37
Lab 1.21: Instalação RHEL 7 38
Lab 1.22: Instalação RHEL 7 39
Lab 1.23: Instalação RHEL 7 40
Lab 1.24: Instalação RHEL 7 41
Lab 1.25: Instalação RHEL 7 42
Lab 1.26: Instalação RHEL 7 43
Lab 1.27: Instalação RHEL 7 44
Lab 1.28: Instalação RHEL 7 45
Lab 1.29: Instalação RHEL 7 46
Lab 1.30: Instalação RHEL 7 47
Lab 1.31: Instalação RHEL 7 48
Lab 1.32: Instalação RHEL 7 49
Lab 1.33: Instalação RHEL 7 50
Lab 1.34: Instalação RHEL 7 51
Lab 1.35: Instalação RHEL 7 52
Lab 1.36: Instalação RHEL 7 53
Lab 1.37: Instalação RHEL 7 54
Lab 1.38: Instalação RHEL 7 55
Lab 1.39: Instalação RHEL 7 56
Lab 1.40: Instalação RHEL 7 57
Lab 1.41: Instalação RHEL 7 58
Lab 1.42: Instalação RHEL 7 59
Lab 1.43: Instalação RHEL 7 60
Lab 1.44: Instalação RHEL 7 61
Lab 1.45: Instalação RHEL 7 62
Lab 1.46: Instalação RHEL 7 63
Lab 1.47: Instalação RHEL 7 64
Lab 1.48: Instalação RHEL 7 65
Lab 1.49: Instalação RHEL 7 66
Lab 1.50: Instalação RHEL 7 67
Lab 2.1: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, atualize o sistema operacional e execute a instalação dos pré-requisitos. # subscription-manager register --username ricardo@nervinformatica.com.br --password MinhaSenha --auto-attach # subscription-manager subscribe --auto # yum -y update # yum -y install bc binutils compat-libcap1 glibc glibc.i686 glibc-devel glibcdevel.i686 ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc libstdc .i686 libstdc -devel libstdc -devel.i686 libxcb libxcb.i686 libX11 libX11.i686 libXau libXau.i686 libXi libXi.i686 libXtst libXtst.i686 make net-tools nfs-utils smartmontools sysstat gcc gcc-c # yum -y install unzip wget iscsi-initiator-utils java-1.8.0-openjdk screen # yum -y install tuned # tuned-adm profile throughput-performance # yum -y install kernel-3.10.0-514.16.1.el7.x86 64 # yum -y install -latest-7.noarch.rpm # yum -y update # yum -y install rlwrap Nas máquinas nerv01 e nerv02, altere a seguinte linha no arquivo /etc/fstab. . tmpfs /dev/shm tmpfs defaults,size 2g 0 0 . 68 68
Lab 2.2: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, adicione as linhas abaixo ao final do arquivo /etc/sysctl.conf. . # Oracle RAC 12cR2 net.ipv4.ip forward 0 net.ipv4.conf.default.accept source route 0 kernel.sysrq 0 kernel.core uses pid 1 net.ipv4.tcp syncookies 1 kernel.msgmnb 65536 kernel.msgmax 65536 fs.file-max 6815744 kernel.sem 250 32000 100 128 kernel.shmmni 4096 kernel.shmall 4294967296 kernel.shmmax 4398046511104 kernel.panic on oops 1 net.core.rmem default 262144 net.core.rmem max 4194304 net.core.wmem default 262144 net.core.wmem max 1048576 net.ipv4.conf.all.rp filter 2 net.ipv4.conf.default.rp filter 2 fs.aio-max-nr 1048576 net.ipv4.ip local port range 9000 65500 . 69
Lab 2.3: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, adicione as linhas abaixo ao final do arquivo /etc/security/ limits.conf. . # Oracle oracle oracle oracle oracle oracle oracle oracle oracle . RAC 12cR2 soft nofile hard nofile soft nproc hard nproc soft stack hard stack hard memlock soft memlock 1024 65536 16384 16384 10240 32768 134217728 134217728 70 70
Lab 2.4: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, remova o DNS 8.8.8.8 da placa de rede eth0. # nmtui 71 71
Lab 2.5: Confguração RHEL 7 72 72
Lab 2.6: Confguração RHEL 7 73 73
Lab 2.7: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, ACRESCENTAR AO FINAL do arquivo /etc/hosts: # Public 192.168.15.101 nerv01.localdomain nerv01 192.168.15.102 nerv02.localdomain nerv02 # Private 192.168.1.101 nerv01-priv.localdomain nerv01-priv 192.168.1.102 nerv02-priv.localdomain nerv02-priv # Virtual 192.168.15.111 nerv01-vip.localdomain nerv01-vip 192.168.15.112 nerv02-vip.localdomain nerv02-vip 74 74
Lab 2.8: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, executar os comandos abaixo. # # # # # # # # # # groupadd oinstall groupadd dba groupadd oper groupadd asmadmin groupadd asmdba groupadd asmoper usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle mkdir -p /u01/app/12.2.0.1/grid chown -R oracle:oinstall /u01 chmod -R 775 /u01 Nas máquinas nerv01 e nerv02, adicione a linha abaixo ao fnal do arquivo /etc/sysconfg/network. . NOZEROCONF YES . 75 75
Lab 2.9: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, desabilite o frewall, o avahi e o chronyd. # systemctl disable firewalld # systemctl disable avahi-daemon # systemctl enable chronyd Nas máquinas nerv01 e nerv02, altere as seguintes linhas no arquivo /etc/chrony.conf. . # server 0.rhel.pool.ntp.org # server 1.rhel.pool.ntp.org # server 2.rhel.pool.ntp.org # server 3.rhel.pool.ntp.org server 192.168.15.2 iburst . iburst iburst iburst iburst Nas máquinas nerv01 e nerv02, altere o SELinux para o modo permissive. # vi /etc/selinux/config . SELINUX permissive . Reinicie as máquinas nerv01 e nerv02 para validar todas as confgurações. # reboot 76 76
Lab 2.10: Confguração RHEL 7 Nas máquinas nerv01 e nerv02, verifque se o Kernel utlizado é o kernel-3.10.0514.16.1.el7.x86 64. # uname -a Nas máquinas nerv01 e nerv02, se o Kernel não estver correto, altere para o kernel-3.10.0514.16.1.el7.x86 64. # # # # # # awk -F\' ' 1 "menuentry " {print 2}' /etc/grub2.cfg grub2-set-default 2 grub2-mkconfig -o /boot/grub2/grub.cfg cat /boot/grub2/grubenv grep saved reboot uname -a 77 77
Lab 2.11: Confguração RHEL 7 Nas máquinas nerv01 e nerv02 , com o usuário oracle, ACRESCENTAR NO FINAL do arquivo /home/oracle/.bash profile as linhas abaixo. export TMP /tmp export TMPDIR TMP export ORACLE HOSTNAME nerv01.localdomain export ORACLE UNQNAME ORCL export ORACLE BASE /u01/app/oracle export ORACLE HOME ORACLE BASE/product/12.2.0.1/db 1 export GRID HOME /u01/app/12.2.0.1/grid export CRS HOME GRID HOME export ORACLE SID ORCL1 export ORACLE TERM xterm export PATH /usr/sbin: PATH export PATH ORACLE HOME/bin: PATH export LD LIBRARY PATH ORACLE HOME/lib:/lib:/usr/lib export CLASSPATH ORACLE HOME/JRE: ORACLE HOME/jlib: ORACLE HOME/rdbms/jlib if [ USER "oracle" ]; then if [ SHELL "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi 78 78
Opções de Shared Storage 79 79
Lab 3.1: Confguração Discos Nas máquinas nerv01 e nerv02, atve o pacote iSCSI Initator. # systemctl enable iscsid # systemctl start iscsid Nas máquinas nerv01 e nerv02, verifque os Discos exportados no Storage. # iscsiadm -m discovery -t sendtargets -p 192.168.15.201 -l Nas máquinas nerv01 e nerv02 verifque se os discos foram confgurados localmente. # fdisk -l grep sd Na máquina nerv01, partcione os novos discos. # fdisk /dev/sdb n enter p enter 1 enter enter enter w enter . 80 80
Lab 3.2: Confguração Discos Na máquina nerv01, confgure o disco com o AFD (ASM Filter Driver). # # # # cp linuxx64 12201 grid home.zip /u01/app/12.2.0.1/grid/ cd /u01/app/12.2.0.1/grid/ unzip -q linuxx64 12201 grid home.zip rm linuxx64 12201 grid home.zip su export ORACLE HOME GRID HOME ORACLE HOME/bin/asmcmd afd label CONFIG01 /dev/sdb1 --init ORACLE HOME/bin/asmcmd afd lslbl /dev/sdb1 chown oracle:asmadmin /dev/sdb1 Na máquina nerv02, confgure o disco com o AFD (ASM Filter Driver). # partprobe /dev/sdb # chown oracle:asmadmin /dev/sdb1 81 81
Lab 4.1: Instalação Grid Infrastructure Na máquina nerv01, com o usuário root, instale o Cluster Verifcaton Utlity. # yum -y install m Copie o Cluster Verifcaton Utlity para a máquina nerv02, e instale-o com o usuário root. [root@nerv01 ]# scp m nerv02:/root/ [root@nerv02 ]# yum -y install /root/cvuqdisk-1.0.10-1.rpm Na máquina nerv01, com o usuário oracle, inicie a instalação do Grid Infrastructure. cd /home/oracle unzip -q p25078431 122010 Linux-x86-64.zip cd /u01/app/12.2.0.1/grid/ ./gridSetup.sh -applyOneOffs /home/oracle/25078431/ 82
Lab 4.2: Instalação Grid Infrastructure 83
Lab 4.3: Instalação Grid Infrastructure 84
Lab 4.4: Instalação Grid Infrastructure 85
Lab 4.5: Instalação Grid Infrastructure 86
Lab 4.6: Instalação Grid Infrastructure 87
Lab 4.7: Instalação Grid Infrastructure 88
Lab 4.8: Instalação Grid Infrastructure 89 89
Lab 4.9: Instalação Grid Infrastructure 90 90
Lab 4.10: Instalação Grid Infrastructure 91 91
Lab 4.11: Instalação Grid Infrastructure 92
Lab 4.12: Instalação Grid Infrastructure 93
Lab 4.13: Instalação Grid Infrastructure 94
Lab 4.14: Instalação Grid Infrastructure 95
Lab 4.15: Instalação Grid Infrastructure 96
Lab 4.16: Instalação Grid Infrastructure 97
Lab 4.17: Instalação Grid Infrastructure 98
Lab 4.18: Instalação Grid Infrastructure 99
Lab 4.19: Instalação Grid Infrastructure 100
Lab 4.20: Instalação Grid Infrastructure 101
Lab 4.21: Instalação Grid Infrastructure 102
Lab 4.22: Instalação Grid Infrastructure 103
Lab 4.23: Instalação Grid Infrastructure 104
Lab 4.24: Instalação Grid Infrastructure 105
Lab 4.25: Instalação Grid Infrastructure nerv01: # /u01/app/oraInventory/orainstRoot.sh # /u01/app/12.2.0.1/grid/root.sh . Enter the full pathname of the local bin directory: [/usr/local/bin]: ENTER . . oraenv ORACLE SID [ ASM1] ? ASM1 ENTER rlwrap sqlplus / AS SYSASM SQL ALTER SYSTEM SET " USE PLATFORM HASH FUNCTION" FALSE SCOPE SPFILE SID '*'; # /u01/app/12.2.0.1/grid/bin/crsctl stop has # /u01/app/12.2.0.1/grid/bin/crsctl start has # Espere aparecer uma mensagem como a abaixo. # tail -f g # 2018-03-23 13:12:05.348 [CRSD(14968)]CRS-2772: Server 'nerv01' has been assigned to pool 'Free' nerv02: # /u01/app/oraInventory/orainstRoot.sh # /u01/app/12.2.0.1/grid/root.sh . Enter the full pathname of the local bin directory: [/usr/local/bin]: ENTER . 106
Lab 4.26: Instalação Grid Infrastructure 107
Lab 4.27: Instalação Grid Infrastructure nerv01: . oraenv ASM1 srvctl stop cha srvctl stop qosmserver srvctl disable qosmserver srvctl stop mgmtdb srvctl disable mgmtdb srvctl stop mgmtlsnr srvctl disable mgmtlsnr srvctl stop cvu srvctl disable cvu crsctl stop res ora.crf -init rlwrap sqlplus / AS SYSASM SQL ALTER SYSTEM SET " ASM ALLOW SMALL MEMORY TARGET" TRUE SCOPE SPFILE SID '*'; SQL ALTER SYSTEM SET MEMORY TARGET 700 SCOPE SPFILE SID '*'; SQL ALTER SYSTEM SET MEMORY MAX TARGET 700M SCOPE SPFILE SID '*'; SQL ALTER SYSTEM SET " DISABLE HIGHRES TICKS" TRUE SCOPE SPFILE SID '*'; # /u01/app/12.2.0.1/grid/bin/crsctl delete res ora.crf -init # /u01/app/12.2.0.1/grid/bin/tfactl uninstall # /u01/app/12.2.0.1/grid/bin/crsctl stop has # /u01/app/12.2.0.1/grid/bin/crsctl start has nerv02: . oraenv ASM2 crsctl stop res ora.crf -init # /u01/app/12.2.0.1/grid/bin/crsctl # /u01/app/12.2.0.1/grid/bin/tfactl # /u01/app/12.2.0.1/grid/bin/crsctl # /u01/app/12.2.0.1/grid/bin/crsctl delete res ora.crf -init uninstall stop has start has 108
Lab 5.1: Instalação Oracle Database Sofware Na máquina nerv02, com o usuário oracle, crie o diretório para o Oracle Database. mkdir -p /u01/app/oracle/product/12.2.0.1/db 1 Na máquina nerv01, com o usuário oracle, descompacte e execute o instalador do Oracle Database Sofware. mkdir -p /u01/app/oracle/product/12.2.0.1/db 1 cd /home/oracle unzip -q linuxx64 12201 database.zip cd /home/oracle/database ./runInstaller 109
Lab 5.2: Instalação Oracle Database Sofware 110
Lab 5.3: Instalação Oracle Database Sofware 111
Lab 5.4: Instalação Oracle Database Sofware 112
Lab 5.5: Instalação Oracle Database Sofware 113
Lab 5.6: Instalação Oracle Database Sofware 114
Lab 5.7: Instalação Oracle Database Sofware 115
Lab 5.8: Instalação Oracle Database Sofware 116
Lab 5.9: Instalação Oracle Database Sofware 117
Lab 5.10: Instalação Oracle Database Sofware 118
Lab 5.11: Instalação Oracle Database Sofware # /u01/app/oracle/product/12.2.0.1/db 1/root.sh . Enter the full pathname of the local bin directory: [/usr/local/bin]: ENTER . # 119
Lab 5.12: Instalação Oracle Database Sofware 120
Lab 6.1: Criação Banco de Dados Nas máquinas nerv01 e nerv02, verifque os Discos exportados no Storage. # iscsiadm -m discovery -t sendtargets -p 192.168.15.201 -l Nas máquinas nerv01 e nerv02 verifque se os discos foram confgurados localmente. # fdisk -l grep sd Na máquina nerv01, partcione os novos discos. # fdisk /dev/sdc n enter p enter 1 enter enter enter w enter . 121 121
Lab 6.2: Criação Banco de Dados Na máquina nerv01, crie os novos Discos no ASM Filter Driver. # # # # # # # # # # export export su asmcmd asmcmd asmcmd asmcmd asmcmd asmcmd asmcmd asmcmd asmcmd exit ORACLE HOME GRID HOME ORACLE SID ASM1 afd lslbl afd label afd label afd label afd label afd label afd label afd label afd lslbl DATA01 /dev/sd?1 # Disco de 20GB FRA01 /dev/sd?1 # Disco de 10GB VD01 /dev/sd?1 # Disco de 1GB VD02 /dev/sd?1 # Disco de 1GB VD03 /dev/sd?1 # Disco de 1GB OCR01 /dev/sd?1 # Disco de 2GB OCR02 /dev/sd?1 # Disco de 2GB Na máquina nerv02, detecte os discos do ASM Filter Driver. # # export export su asmcmd asmcmd ORACLE HOME GRID HOME ORACLE SID ASM2 afd scan afd lslbl 122 122
Lab 6.3: Criação Banco de Dados Na máquina nerv01, crie os novos Disk Groups. rlwrap sqlplus / AS SYSASM SQL CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK 'AFD:DATA01' ATTRIBUTE 'compatible.asm' '12.2', 'compatible.rdbms' '12.2', 'au size' '8M'; SQL CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK 'AFD:FRA01' ATTRIBUTE 'compatible.asm' '12.2', 'compatible.rdbms' '12.2', 'au size' '8M'; SQL CREATE DISKGROUP VD NORMAL REDUNDANCY DISK 'AFD:VD01','AFD:VD02','AFD:VD03' ATTRIBUTE 'compatible.asm' '12.2', 'compatible.rdbms' '12.2', 'au size' '1M'; SQL CREATE DISKGROUP OCR NORMAL REDUNDANCY DISK 'AFD:OCR01','AFD:OCR02' ATTRIBUTE 'compatible.asm' '12.2', 'compatible.rdbms' '12.2', 'au size' '1M'; SQL SELECT GROUP NUMBER, NAME, STRIPE, REDUNDANCY FROM V ASM TEMPLATE ORDER BY GROUP NUMBER, NAME; srvctl srvctl srvctl srvctl srvctl srvctl srvctl srvctl enable diskgroup -g DATA -n nerv02 start diskgroup -g DATA -n nerv02 enable diskgroup -g FRA -n nerv02 start diskgroup -g FRA -n nerv02 enable diskgroup -g VD -n nerv02 start diskgroup -g VD -n nerv02 enable diskgroup -g OCR -n nerv02 start diskgroup -g OCR -n nerv02 123 123
ASM Stripping: Fine x Coarse 124 124
Lab 6.4: Criação Banco de Dados Execute o DBCA para criar o banco de dados. source /home/oracle/.bash profile dbca 125 125
Lab 6.5: Criação Banco de Dados 126 126
Lab 6.6: Criação Banco de Dados 127 127
Lab 6.7: Criação Banco de Dados 128 128
Lab 6.8: Criação Banco de Dados 129 129
Lab 6.9: Criação Banco de Dados 130 130
Lab 6.10: Criação Banco de Dados 131 131
Lab 6.11: Criação Banco de Dados 132 132
Lab 6.12: Criação Banco de Dados 133 133
Lab 6.14: Criação Banco de Dados 134 134
Lab 6.15: Criação Banco de Dados 135 135
Lab 6.16: Criação Banco de Dados 136 136
Lab 6.17: Criação Banco de Dados 137 137
Lab 6.18: Criação Banco de Dados 138 138
Lab 6.19: Criação Banco de Dados 139 139
Lab 6.20: Criação Banco de Dados Se tver o erro acima, execute na máquina nerv01 os comandos abaixo após o término do dbca: . oraenv ORACLE SID [ ORCL1] ? ORCL1 ENTER rlwrap sqlplus / AS SYSDBA SQL ALTER SYSTEM SET " USE PLATFORM HASH FUNCTION" FALSE SCOPE SPFILE SID '*'; srvctl stop database -db ORCL srvctl start database -db ORCL 140
Lab 6.21: Criação Banco de Dados 141 141
RAC Database Background Process ACMӹ: Atomic Cootroifie to Memory ӹervice GTX0Sj: Giobai Traosactoo Process LMON: Giobai Eoqueue ӹervice Mooitor LMD: Giobai Eoqueue ӹervice Daemoo LMӹ: Giobai Cacle ӹervice Process LCK0: Iostaoce Eoqueue Process RMӹo: Oracie RAC Maoagemeot Processes RӹMN: Remote ӹiave Mooitor PFILE / SPFILE (1x) ALTER SYSTEM SID ’*’; ALTER SYSTEM . SID ’ORCL1’; DATAFILEs (1x) CONTROL FILEs (1x) Online REDO LOG Threads (x Nodes) ALTER DATABASE ADD LOGFILE THREAD 1 SIZE 1G; ALTER DATABASE ADD LOGFILE THREAD 2 SIZE 1G; UNDO TABLESPACE (x Nodes) 142 142
Lab 6.21: Criação Banco de Dados Na máquina nerv01, para efetuar logon na Instance ASM1, use o SQLPlus. export ORACLE SID ASM1 sqlplus / as SYSDBA Por que não funcionou? Verifque os discos existentes, e espaço disponível. SQL SELECT NAME, TOTAL MB, FREE MB FROM V ASM DISK; SQL SELECT NAME, TOTAL MB, FREE MB FROM V ASM DISKGROUP; asmcmd -p ASMCMD [ ] lsdg Pelo asmcmd, copie um DATAFILE do ASM para o /home/oracle de uma máquina do RAC. Na instância do banco, crie uma TABLESPACE. SQL CREATE TABLESPACE TESTE; SQL ALTER TABLESPACE TESTE ADD DATAFILE; SQL ALTER TABLESPACE TESTE ADD DATAFILE ‘ DATA’; Verifque o novo DATAFILE criado, e os já existentes. SQL SELECT FILE NAME, BYTES, MAXBYTES, AUTOEXTENSIBLE, INCREMENT BY FROM DBA DATA FILES; 143 143
CDB Architecture 144
Deprecaton of Non-CDB Architecture Documentação 12cR1: Documentação 12cR2: 145
12cR2 CDB New Features ӹubset ӹtaodby Data Guard Broker PDB Migratoo or Faiiover CrossSPiatorm Import of a Piuggabie Database ioto a Muitteoaot Cootaioer Database I/O Rate Limits for PDBs Heat Map aod Automatc Data Optmizatoo ӹupport for CDBs PDB Claracter ӹet PDB Refresl Hiots io CONTAINERӹ Query Paraiiei PDB Creatoo Ciause PDB Arclive Fiies (apdb Fiies) Defauit Tabiespace Ciause Ciooiog a PDB Near Zero Dowotme PDB Reiocatoo Logicai ӹtaodby Database to ӹupport CDBs witl PDBs witl Difereot Claracter ӹets LogMioer to ӹupport CDBs witl PDBs witl Difereot Claracter ӹets ӹupport for PDBs witl Difereot Claracter ӹets, Time Zooe Fiie Versioos, aod Database Time Zooes io a CDB Memory Resource Maoagemeot PerSProcess PGA Limits Performaoce Profies aod Maodatory PDB Profies CDBSLevei PDB Lockdowo 146
12cR2 CDB New Features Appiicatoo Root Proxy PDB Forwardiog Coooectoos to A New Address Based oo ӹervice ӹerviceSLevei ACLs for TCP Protocoi Fiaslback Piuggabie Database Upgradiog a CDB Witl Ooe or More PDBs io a ӹiogie Operatoo ӹupport for Tlousaods of Piuggabie Databases for Eacl Muitteoaot Cootaioer Database Piuggabie Database Lockdowo Profies Eolaocemeots Piuggabie Database Operatog ӹystem Credeotais Oracie Eoterprise Maoager Database Express (EM Express) Resource Maoager ӹupport EM Express: ӹimpiifyiog Coofguratoo for Muitteoaot Tlrougl ӹiogie Port Access EM Express: Performaoce Hub Eolaocemeots Automatc Workioad Repository (AWR) ӹupport for a Piuggabie Database (PDB) ӹeiectve PDB Upgrades AWR PDB AUTOFLUӹH ENABLED Ioitaiizatoo Parameter ENABLE AUTOMATIC MAINTENANCE PDB Ioitaiizatoo Parameter AUTOTAӹK MAX ACTIVE PDBӹ Ioitaiizatoo Parameter Giobai aod ӹlared Coooectoo Pooi for Oracie Cioud aod Muitteoaot Oracie Databases Prioritzed Rebaiaociog Oracie Database Vauit Commoo Reaims aod Commaod Ruies for Oracie Muitteoaot 147
Opton Multtenant 148
Multtenant - EE 149
Singletenant - SE2 150
Esse banco utliza CDB Arquitecture? 151
Que Containers / PDBs este banco tem? 152
Em que Container estou conectado? 153
Como conectar em um PDB? SET CONTAINER 154
Como conectar em um PDB? lsnrctl status . Services Summary. Service "5397376af7702ac5e0536a00a8c0505d" has 1 instance(s). Instance "ORCL", status READY, has 1 handler(s) for this service. Service "ORCL" has 1 instance(s). Instance "ORCL", status READY, has 1 handler(s) for this service. Service "ORCLXDB" has 1 instance(s). Instance "ORCL", status READY, has 1 handler(s) for this service. Service "prod" has 1 instance(s). Instance "ORCL", status READY, has 1 handler(s) for this service. The command completed successfully 155
Como conectar em um PDB? tnsnames.ora cat ORACLE HOME/network/admin/tnsnames.ora . ORCL (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST nerv06.localdomain)(PORT 1521)) (CONNECT DATA (SERVER DEDICATED) (SERVICE NAME ORCL) ) ) PROD (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST nerv06.localdomain)(PORT 1521)) (CONNECT DATA (SERVER DEDICATED) (SERVICE NAME PROD) ) ) . 156
Como conectar em um PDB? tnsnames.ora 157
Como conectar em um PDB? Easy Connect 158
E agora, qual o nome da Instância? E do Banco? 159
E agora, qual o nome da Instância? E do Banco? 160
CDB e PDBs: STARTUP 161
CDB e PDBs: STARTUP Execute o SAVE STATE para o PDB PROD nos dois Nodes no RAC. 162
Alert Log 163
DATAFILEs 164
DATAFILEs 165
DATAFILEs 166
Dicionário de Dados 167
VIEWs 168
VIEWs 169
Parâmetros 170
Parâmetros 171
TABLESPACEs 172
USERs 173
USERs 174
USERs 175
USERs 176
SELECT em outros Containers 177
Criando (Clonando) um PDB 178
Criando (Clonando) um PDB 179
Criando (Clonando) um PDB 180
Criando (Clonando) um PDB 181
Criando (Clonando) um PDB 182
Unplug / Plug 183
Unplug / Plug 184
DROP 185
Backup CDB e PDBs RMAN BACKUP DATABASE; RMAN BACKUP DATAFILE 1; RMAN BACKUP DATAFILE 1,3; CDB RMAN BACKUP DATABASE ROOT; RMAN BACKUP TABLESPACE SYSTEM; RMAN BACKUP TABLESPACE SYSTEM,SYSAUX; PDBs RMAN BACKUP PLUGGABLE DATABASE DEV1; RMAN BACKUP PLUGGABLE DATABASE DEV1,DEV2; RMAN BACKUP TABLESPACE DEV1:SYSTEM; 186
Restore / Recover CDB e PDBs RMAN RMAN RMAN RMAN CDB RMAN RMAN RMAN RMAN PDBs RMAN RMAN RMAN RMAN RESTORE RECOVE
Oracle RAC 12cR2 Em Red Hat Eoterprise Lioux 7a4 Iociui CDB Arclitecture. 2 Comandos no Treinamento Comando com o usuário root: # ls -lh Comando com um usuário oracle: ls -lh . # yum -y install epel-release-latest-7.noarch.rpm # yum -y install rlwrap rlwrap sqlplus / AS SYSDBA
1.12 Overview of Managing Oracle RAC Environments 1-36 1.12.1 About Designing and Deploying Oracle RAC Environments 1-37 1.12.2 About Administrative Tools for Oracle RAC Environments 1-37 1.12.3 About Monitoring Oracle RAC Environments 1-39 1.12.4 About Evaluating Performance in Oracle RAC Environments 1-40 2 Administering Storage in Oracle RAC
2.4 Installing Oracle RAC and Oracle RAC One Node Databases 2-3 2.4.1 Installing Oracle RAC and Oracle RAC One Node Database Software 2-4 2.5 Simplified Upgrade of TIMESTAMP WITH TIME ZONE Data 2-5 2.6 Overview of Installation Directories for Oracle RAC 2-6 2.6.1 Overview of Oracle Base Directories 2-6 2.6.2 Overview of Oracle Home Directories 2-7
Oracle 19c : de-support of Oracle RAC in SE2 Introduction Oracle Real Application Clusters (Oracle RAC) is the only solution to build an active – active cluster using shared storage for your Oracle database. Up to Oracle 18c Oracle RAC is available as a feature within
Oracle Database using Oracle Real Application Clusters (Oracle RAC) and Oracle Resource Management provided the first consolidation platform optimized for Oracle Database and is the MAA best practice for Oracle Database 11g. Oracle RAC enables multiple Oracle databases to be easily consolidated onto a single Oracle RAC cluster.
Apr 12, 2018 · RAC AGENDA – MAY 2018 . 1. Welcome, RAC Introductions and RAC Procedure - RAC Chair . 2. Approval of Agenda and Minutes - RAC Chair . 3. Wildlife Board Meeting Update INFORMATIONAL - RAC Chair . 4. Reg
Safety Precautions Operating Instructions Installation Instructions Care and Cleaning RAC-WK0511CMU RAC-WK0611CRU RAC-WK0811ESCWU RAC-WK1011ESCWU RAC-WK1211ESCWU RAC-WK1511ESCRU RAC-WK1821ESCRU Warning notices: Before using this product, please read this manual carefully and keep it for future reference. The design and specifications are subject to
Cliente de un Oracle Database 12cR2 hacia un tópico Cliente en Apache Kafka. Los pasos de la implementación fueron divididos en las siguientes 4 secciones: Instalación de Apache Kafka Oracle GoldenGate 12c en Oracle Database 12cR2 Oracle GoldenGate for Big Data Validación de Streaming de Datos I. Instalación de Apache Kafka
Artificial Intelligence and its application in healthcare could be another great leap, like population-wide vaccination or IVF, but as this report sets out, it must be handled with care. For me, the key theme that leaps from almost every page of this report is the tension between the tech mantra, ‘move fast and break things’ and principle enshrined in the Hippocratic Oath, ‘First, do no .
