Srs, o que acham que pode estar acontecendo??
Em 11 de junho de 2014 21:39, Orfeu Lima <orfeu.l...@gmail.com> escreveu: > Vitor, quando faço um multipath -ll eles aparecem normalmente. > Esse é o ponto da questão. > Fiz um teste e coloquei esse mesmo servidor em um ambiente de homologação > que é semelhante a esse, a diferença é que são apenas 2 nós. > O asm listou normalmente os discos. > > [root@sbsb198 ~]# /etc/init.d/oracleasm scandisks > Scanning the system for Oracle ASMLib disks: [ OK ] > [root@sbsb198 ~]# /etc/init.d/oracleasm listdisks > [root@sbsb198 ~]# > > > [root@sbsb198 ~]# multipath -ll > sdb: checker msg is "emc_clariion_checker: Logical Unit is unbound or LUNZ" > sde: checker msg is "emc_clariion_checker: Logical Unit is unbound or LUNZ" > sdh: checker msg is "emc_clariion_checker: Logical Unit is unbound or LUNZ" > sdk: checker msg is "emc_clariion_checker: Logical Unit is unbound or LUNZ" > mpathd (36006016071e02e00b09286d09a7ae211) dm-1 DGC,VRAID > [size=4.0T][features=1 queue_if_no_path][hwhandler=1 emc][rw] > \_ round-robin 0 [prio=2][active] > \_ 3:0:0:3 sdd 8:48 [active][ready] > \_ 5:0:0:3 sdj 8:144 [active][ready] > \_ round-robin 0 [prio=0][enabled] > \_ 3:0:1:3 sdg 8:96 [active][ready] > \_ 5:0:1:3 sdm 8:192 [active][ready] > mpathc (36006016071e02e00ae9286d09a7ae211) dm-0 DGC,VRAID > [size=4.0T][features=1 queue_if_no_path][hwhandler=1 emc][rw] > \_ round-robin 0 [prio=2][active] > \_ 3:0:1:2 sdf 8:80 [active][ready] > \_ 5:0:1:2 sdl 8:176 [active][ready] > \_ round-robin 0 [prio=0][enabled] > \_ 3:0:0:2 sdc 8:32 [active][ready] > \_ 5:0:0:2 sdi 8:128 [active][ready] > > > > Em 11 de junho de 2014 10:08, Vitor Junior vitorj...@gmail.com > [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu: > > >> >> Pra mim pelo output está claro: >> -----------------nó 3 ------------------------------ >> --------------------------------- >> [oracle@sbsb198 ~]$ ls -ltrh /dev/oracleasm/disks/* >> ls: /dev/oracleasm/disks/*: No such file or directory >> [oracle@sbsb198 ~]$ ls -ltrh /dev/mapper/* >> crw------- 1 root root 10, 63 Jun 3 17:20 /dev/mapper/control >> brw-rw---- 1 root disk 253, 1 Jun 3 17:21 /dev/mapper/mpathd >> brw-rw---- 1 root disk 253, 0 Jun 3 17:21 /dev/mapper/mpathc >> [oracle@sbsb198 ~]$ >> >> Onde estão os outros devices? Eles não estão 'entregues' ao node 3. >> >> >> >> >> >> Att,/Regards, >> >> >> Vitor Jr. >> Infraestrutura / Infrastructure Team >> Oracle 11g DBA Certified Professional - OCP >> Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid >> Infrastructure Administrator - OCE >> Oracle Database 11g Performance Tuning Certified Expert - OCE >> Oracle Exadata 11g Certified Implementation Specialist >> Oracle Certified Associate, MySQL 5 >> mail, gtalk e msn: vitorj...@gmail.com >> http://certificacaobd.com.br/ >> skype: vjunior1981 >> https://mybizcard.co/vitor.jr.385628 >> >> >> Em 11 de junho de 2014 10:05, Orfeu Lima orfeu.l...@gmail.com >> [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu: >> >> >>> >>> Sim, está ativo. >>> Em 11/06/2014 07:06, "Wadson Ramon wra...@gmail.com [oracle_br]" < >>> oracle_br@yahoogrupos.com.br> escreveu: >>> >>>> >>>> >>>> Amigo verficou se o serviço do oracle asm foi inicilizado apos o >>>> reboot., vc tem a saída do oracleasm scandisks? >>>> Em 10/06/2014 23:09, "Orfeu Lima orfeu.l...@gmail.com [oracle_br]" < >>>> oracle_br@yahoogrupos.com.br> escreveu: >>>> >>>>> >>>>> >>>>> seguem informações das permissões nos discos dos 3 nós. >>>>> -----------------nó >>>>> 1-------------------------------------------------------- >>>>> brw-rw---- 1 oracle oinstall 253, 2 May 5 09:24 >>>>> /dev/oracleasm/disks/DG_DADOS1 >>>>> brw-rw---- 1 oracle oinstall 253, 3 May 5 09:24 >>>>> /dev/oracleasm/disks/DG_DADOS2 >>>>> brw-rw---- 1 oracle oinstall 253, 4 May 5 09:24 >>>>> /dev/oracleasm/disks/DG_ASM >>>>> brw-rw---- 1 oracle oinstall 253, 5 May 5 09:24 >>>>> /dev/oracleasm/disks/DG_DADOS >>>>> >>>>> [oracle@sbsb241 ~]$ ls -ltrh /dev/mapper/* >>>>> crw------- 1 root root 10, 63 May 5 09:23 /dev/mapper/control >>>>> brw-rw---- 1 root disk 253, 1 May 5 09:23 /dev/mapper/mpathd >>>>> brw-rw---- 1 root disk 253, 0 May 5 09:23 /dev/mapper/mpathc >>>>> brw-rw---- 1 root disk 253, 3 May 5 09:23 /dev/mapper/mpathdp2 >>>>> brw-rw---- 1 root disk 253, 2 May 5 09:23 /dev/mapper/mpathdp1 >>>>> brw-rw---- 1 root disk 253, 5 May 5 09:23 /dev/mapper/mpathcp2 >>>>> brw-rw---- 1 root disk 253, 4 May 5 09:23 /dev/mapper/mpathcp1 >>>>> >>>>> -------------------nó 2 >>>>> -------------------------------------------------------------- >>>>> [oracle@sbsb242 ~]$ ls -ltrh /dev/oracleasm/disks/* >>>>> brw-rw---- 1 oracle oinstall 253, 2 May 5 09:25 >>>>> /dev/oracleasm/disks/DG_DADOS1 >>>>> brw-rw---- 1 oracle oinstall 253, 3 May 5 09:25 >>>>> /dev/oracleasm/disks/DG_DADOS2 >>>>> brw-rw---- 1 oracle oinstall 253, 4 May 5 09:25 >>>>> /dev/oracleasm/disks/DG_ASM >>>>> brw-rw---- 1 oracle oinstall 253, 5 May 5 09:25 >>>>> /dev/oracleasm/disks/DG_DADOS >>>>> >>>>> [oracle@sbsb242 ~]$ ls -ltrh /dev/mapper/* >>>>> crw------- 1 root root 10, 63 May 5 09:23 /dev/mapper/control >>>>> brw-rw---- 1 root disk 253, 0 May 5 09:24 /dev/mapper/mpathd >>>>> brw-rw---- 1 root disk 253, 1 May 5 09:24 /dev/mapper/mpathc >>>>> brw-rw---- 1 root disk 253, 3 May 5 09:24 /dev/mapper/mpathdp2 >>>>> brw-rw---- 1 root disk 253, 2 May 5 09:24 /dev/mapper/mpathdp1 >>>>> brw-rw---- 1 root disk 253, 5 May 5 09:24 /dev/mapper/mpathcp2 >>>>> brw-rw---- 1 root disk 253, 4 May 5 09:24 /dev/mapper/mpathcp1 >>>>> >>>>> ------------------nó 3 >>>>> --------------------------------------------------------------- >>>>> [oracle@sbsb198 ~]$ ls -ltrh /dev/oracleasm/disks/* >>>>> ls: /dev/oracleasm/disks/*: No such file or directory >>>>> [oracle@sbsb198 ~]$ ls -ltrh /dev/mapper/* >>>>> crw------- 1 root root 10, 63 Jun 3 17:20 /dev/mapper/control >>>>> brw-rw---- 1 root disk 253, 1 Jun 3 17:21 /dev/mapper/mpathd >>>>> brw-rw---- 1 root disk 253, 0 Jun 3 17:21 /dev/mapper/mpathc >>>>> [oracle@sbsb198 ~]$ >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Em 10 de junho de 2014 12:43, Vitor Junior vitorj...@gmail.com >>>>> [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu: >>>>> >>>>>> >>>>>> >>>>>> Wadson, se ele usa multipath, conforme ele mesmo informou, as >>>>>> permissões que ele deve olhar são dos devices multipath, e não dos >>>>>> devices >>>>>> apresentados. >>>>>> Qual o caminho dos discos apresentados para o ASM? /dev/mapper? Como >>>>>> estão as permissões dentro desses devices? Qual a saída dos comandos >>>>>> nos 3 >>>>>> nodes: >>>>>> ls -ltrh /dev/oracleasm/disks/* >>>>>> ls -ltrh /dev/mapper/* >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Att,/Regards, >>>>>> >>>>>> >>>>>> Vitor Jr. >>>>>> Infraestrutura / Infrastructure Team >>>>>> Oracle 11g DBA Certified Professional - OCP >>>>>> Oracle Certified Expert, Oracle Real Application Clusters 11g and >>>>>> Grid Infrastructure Administrator - OCE >>>>>> Oracle Database 11g Performance Tuning Certified Expert - OCE >>>>>> Oracle Exadata 11g Certified Implementation Specialist >>>>>> Oracle Certified Associate, MySQL 5 >>>>>> mail, gtalk e msn: vitorj...@gmail.com >>>>>> http://certificacaobd.com.br/ >>>>>> skype: vjunior1981 >>>>>> https://mybizcard.co/vitor.jr.385628 >>>>>> >>>>>> >>>>>> Em 10 de junho de 2014 08:37, Wadson Ramon wra...@gmail.com >>>>>> [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu: >>>>>> >>>>>> >>>>>>> >>>>>>> Pelo visto amigo vc perdeu as permissões, vai ter que setar >>>>>>> novamente. >>>>>>> Em 09/06/2014 20:42, "Orfeu Lima orfeu.l...@gmail.com [oracle_br]" < >>>>>>> oracle_br@yahoogrupos.com.br> escreveu: >>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> segue as informações de permissões dos nós. >>>>>>>> ------------nós 1 e 2 ------------------------ >>>>>>>> [root@sbsb241 dev]# ls -la sd* >>>>>>>> brw-r----- 1 root disk 8, 0 May 5 09:23 sda >>>>>>>> brw-r----- 1 root disk 8, 1 May 5 09:23 sda1 >>>>>>>> brw-r----- 1 root disk 8, 2 May 5 09:23 sda2 >>>>>>>> brw-r----- 1 root disk 8, 3 May 5 09:23 sda3 >>>>>>>> brw-r----- 1 root disk 8, 16 May 5 09:23 sdb >>>>>>>> brw-r----- 1 root disk 8, 17 May 5 09:23 sdb1 >>>>>>>> brw-r----- 1 root disk 8, 18 May 5 09:23 sdb2 >>>>>>>> brw-r----- 1 root disk 8, 32 May 5 09:23 sdc >>>>>>>> brw-r----- 1 root disk 8, 33 May 5 09:23 sdc1 >>>>>>>> brw-r----- 1 root disk 8, 34 May 5 09:23 sdc2 >>>>>>>> brw-r----- 1 root disk 8, 48 May 5 09:23 sdd >>>>>>>> brw-r----- 1 root disk 8, 49 May 5 09:23 sdd1 >>>>>>>> brw-r----- 1 root disk 8, 50 May 5 09:23 sdd2 >>>>>>>> brw-r----- 1 root disk 8, 64 May 5 09:23 sde >>>>>>>> brw-r----- 1 root disk 8, 65 May 5 09:23 sde1 >>>>>>>> brw-r----- 1 root disk 8, 66 May 5 09:23 sde2 >>>>>>>> brw-r----- 1 root disk 8, 80 May 5 09:23 sdf >>>>>>>> brw-r----- 1 root disk 8, 81 May 5 09:23 sdf1 >>>>>>>> brw-r----- 1 root disk 8, 82 May 5 09:23 sdf2 >>>>>>>> brw-r----- 1 root disk 8, 96 May 5 09:23 sdg >>>>>>>> brw-r----- 1 root disk 8, 97 May 5 09:23 sdg1 >>>>>>>> brw-r----- 1 root disk 8, 98 May 5 09:23 sdg2 >>>>>>>> brw-r----- 1 root disk 8, 112 May 5 09:23 sdh >>>>>>>> brw-r----- 1 root disk 8, 113 May 5 09:23 sdh1 >>>>>>>> brw-r----- 1 root disk 8, 114 May 5 09:23 sdh2 >>>>>>>> brw-r----- 1 root disk 8, 128 May 5 09:23 sdi >>>>>>>> brw-r----- 1 root disk 8, 129 May 5 09:23 sdi1 >>>>>>>> brw-r----- 1 root disk 8, 130 May 5 09:23 sdi2 >>>>>>>> --------------nó 3 ---------------------- >>>>>>>> [root@sbsb198 ~]# ls -la /dev/sd* >>>>>>>> brw-r----- 1 root disk 8, 0 Jun 3 17:20 /dev/sda >>>>>>>> brw-r----- 1 root disk 8, 1 Jun 3 17:21 /dev/sda1 >>>>>>>> brw-r----- 1 root disk 8, 2 Jun 3 17:20 /dev/sda2 >>>>>>>> brw-r----- 1 root disk 8, 3 Jun 3 17:21 /dev/sda3 >>>>>>>> brw-r----- 1 root disk 8, 16 Jun 3 17:20 /dev/sdb >>>>>>>> brw-r----- 1 root disk 8, 32 Jun 3 17:20 /dev/sdc >>>>>>>> brw-r----- 1 root disk 8, 48 Jun 3 17:20 /dev/sdd >>>>>>>> brw-r----- 1 root disk 8, 64 Jun 3 17:20 /dev/sde >>>>>>>> brw-r----- 1 root disk 8, 80 Jun 3 17:20 /dev/sdf >>>>>>>> brw-r----- 1 root disk 8, 96 Jun 3 17:20 /dev/sdg >>>>>>>> brw-r----- 1 root disk 8, 112 Jun 3 17:20 /dev/sdh >>>>>>>> brw-r----- 1 root disk 8, 128 Jun 3 17:20 /dev/sdi >>>>>>>> brw-r----- 1 root disk 8, 144 Jun 3 17:20 /dev/sdj >>>>>>>> brw-r----- 1 root disk 8, 160 Jun 3 17:20 /dev/sdk >>>>>>>> brw-r----- 1 root disk 8, 176 Jun 3 17:20 /dev/sdl >>>>>>>> brw-r----- 1 root disk 8, 192 Jun 3 17:20 /dev/sdm >>>>>>>> >>>>>>>> >>>>>>>> Em 9 de junho de 2014 19:54, Marcelo Santino >>>>>>>> e...@marcelosantino.com.br [oracle_br] <oracle_br@yahoogrupos.com.br> >>>>>>>> escreveu: >>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Orfeu, >>>>>>>>> >>>>>>>>> Você configurou certinho o oracleasm (oracleasm configure -i) ? >>>>>>>>> E a lib asmlib foi instalada também? >>>>>>>>> >>>>>>>>> Uma vez perdi mó tempão quebrando a cabeça porque os discos >>>>>>>>> criados no node1 não estavam aparecendo no node2, até que eu me >>>>>>>>> liguei que >>>>>>>>> não tinha instalado a asmlib nele... Depois que instalei, rebootei e >>>>>>>>> os >>>>>>>>> discos já apareceram na boa... Mas só tomei problema quando iniciei a >>>>>>>>> instalação e não conseguia achar os discos pra adicionar ao ASM... >>>>>>>>> >>>>>>>>> Sei que é uma pergunta ridicula, mas as vezes passa um detalhe >>>>>>>>> bobo que não demos atenção... >>>>>>>>> >>>>>>>>> Abs, >>>>>>>>> >>>>>>>>> >>>>>>>>> *Marcelo Santino* >>>>>>>>> DBA SQL Server / Oracle >>>>>>>>> www.bau-de-dev.com <http://www-bau-de-dev.com> >>>>>>>>> +55 21 98206-9930 >>>>>>>>> >>>>>>>>> <http://www.facebook.com/CelaoRJ> >>>>>>>>> <http://br.linkedin.com/in/msantino> >>>>>>>>> >>>>>>>>> <http://twitter.com/#!/msantino> >>>>>>>>> >>>>>>>>> >>>>>>>>> 2014-06-09 19:48 GMT-03:00 Orfeu Lima orfeu.l...@gmail.com >>>>>>>>> [oracle_br] <oracle_br@yahoogrupos.com.br>: >>>>>>>>> >>>>>>>>> >>>>>>>>>> >>>>>>>>>> Bom dia Srs do grupo. >>>>>>>>>> ambiente >>>>>>>>>> S.O - rhel 5 >>>>>>>>>> SGBD - Oracle Rac 11.2.0.3 com 2 nós. >>>>>>>>>> Estou tentando adicionar um terceiro nó ao meu rac. >>>>>>>>>> Fiz as atualizações e configurei o asm. >>>>>>>>>> Configurei o multipath do mesmo modo que os outros dois nós, tendo me >>>>>>>>>> apresentando os volumes no terceiro nó. >>>>>>>>>> Ao tentar listar os discos pelo terceiro nó ele me apresentou os >>>>>>>>>> erros que >>>>>>>>>> estão no /var/log/oracleasm >>>>>>>>>> oracleasm-read-label: Unable to read device "/dev/sdb": Input/output >>>>>>>>>> error >>>>>>>>>> oracleasm-read-label: Unable to read device "/dev/sde": Input/output >>>>>>>>>> error >>>>>>>>>> oracleasm-read-label: Unable to read device "/dev/sdf": Input/output >>>>>>>>>> error >>>>>>>>>> oracleasm-read-label: Unable to read device "/dev/sdi": Input/output >>>>>>>>>> error >>>>>>>>>> >>>>>>>>>> Notei também que na partição /dev/mapper, as partições não estão >>>>>>>>>> aparecendo. >>>>>>>>>> Tentei forçar a listagem pelo /etc/init.d/oracleasm listdisk >>>>>>>>>> DG_DADOS, mas ele >>>>>>>>>> me retorna o seguinte >>>>>>>>>> Disk "DG_DADOS" does not exist or is not instantiated >>>>>>>>>> Se alguém já passou por isso ou souber aonde posso pesquisar eu >>>>>>>>>> agradeço. >>>>>>>>>> Já pesquisei alguns sites na internet, mas nada fala desse tópico. >>>>>>>>>> OBS : não tenho acesso ao metalink. >>>>>>>>>> Obrigado >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>> >>>>> >> >> > >
