Não tinha prestado atenção no show parameter instance_name. My Bad! Atenciosamente, Gleyson Melo
Em 6 de dezembro de 2013 15:11, Gleyson Melo <gleysonm...@gmail.com>escreveu: > Fala Vitor, > > Na verdade, o nome das instâncias está diferente (rac7, rac8). > > O que está igual é o nome do Database (PDERP01), que é o mesmo para as > duas instâncias no RAC. > > []´s > > Atenciosamente, > Gleyson Melo > > > 2013/12/6 Vitor Junior <vitorj...@gmail.com> > >> >> >> Cenário: >> host8:/home/oracle>oslevel -g >> Fileset Actual Level Maintenance >> Level >> >> ----------------------------------------------------------------------------- >> bos.rte 5.3.12.1 5.3.0.0 >> >> >> SQL> select * from v$version; >> >> BANNER >> ---------------------------------------------------------------- >> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi >> PL/SQL Release 10.2.0.3.0 - Production >> CORE 10.2.0.3.0 Production >> TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio >> NLSRTL Version 10.2.0.3.0 - Production >> >> SQL> select * from v$active_instances; >> >> INST_NUMBER INST_NAME >> ----------- ------------------------------------------------------------ >> 7 host7:rac7 >> 8 host8:rac8 >> >> SQL> select * from v$instance; >> >> INSTANCE_NUMBER INSTANCE_NAME >> --------------- ---------------- >> HOST_NAME >> ---------------------------------------------------------------- >> VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE >> LOG_SWITCH_WAIT >> ----------------- --------- ------------ --- ---------- ------- >> --------------- >> LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO >> ---------- --- ----------------- ------------------ --------- --- >> 7 rac7 >> host7 >> 10.2.0.3.0 03-OCT-13 OPEN YES 7 STARTED >> ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO >> >> >> SQL> show parameter instance_name >> >> NAME TYPE VALUE >> ------------------------------------ ----------- >> ------------------------------ >> instance_name string PDERP01 >> SQL> >> >> SQL> select * from v$instance; >> >> INSTANCE_NUMBER INSTANCE_NAME >> --------------- ---------------- >> HOST_NAME >> ---------------------------------------------------------------- >> VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE >> LOG_SWITCH_WAIT >> ----------------- --------- ------------ --- ---------- ------- >> --------------- >> LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO >> ---------- --- ----------------- ------------------ --------- --- >> 8 rac8 >> host8 >> 10.2.0.3.0 03-OCT-13 OPEN YES 8 STARTED >> ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO >> >> >> SQL> show parameter instance_name >> >> NAME TYPE VALUE >> ------------------------------------ ----------- >> ------------------------------ >> instance_name string PDERP01 >> >> >> Resumidamente, o instance_name está IDÊNTICO nos dois nodes do RAC. >> Alguém já tinha passado por isso? Conseguem enxergar algum efeito >> colateral que isso poderia causar? >> Também o que achei estranho foi que ao executar o show parameter retornou >> o nome da instance PDERP01 e ao executar um select na v$active_instances ou >> na v$instance o nome da instance retorna respectivamente 'rac7' e 'rac8'. >> >> Abraços. >> >> >> 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 >> >> >> > >