Copia o arquivo de senhas do primario para o standby e faça o teste novamente. On Apr 20, 2013 1:20 PM, "netodba" <neto.lon...@gmail.com> wrote:
> ** > > > Pessoal, > como eu faço pra iniciar um instancia remotamente? > > site primario: > O.S: Oracle Enterprise Linux 6.3 64 bits > Oracle Rac 11.2.0.3 64 bits (2 nodes) > owner RDBMS: "oracle" > owner ASM: "grid" > Database name: TCDB > instance names: TCDB1 and TCDB2 > hostnames: rac3 and rac4 > > site standby: > O.S: Oracle Enterprise Linux 6.3 64 bits > Oracle single instance 11.2.0.3 64 bits > owner RDBMS: "oracle" > owner ASM: "grid" > Database_name: TCDB > unique_name: STANDBY > hostname: DG > > olha meu caso, pra eu conseguir fazer um switchover limpo com o > databroker, o databroker irá fazer um shutdown na instancia primaria e na > standby, e irá startar as instancias novamente. > > só que na hora do switchover ocorre o erro > ORA-01031: insufficient privileges > > então pra concluir o switchover tenho que startar a instancia standby > manualmente. > > Pra verificar esse problema, fiz testes tentando me conectar pelo sqlplus > mesmo. > > LISTENER standby > > LISTENER2 = > (DESCRIPTION= > (ADDRESS_LIST= > (ADDRESS=(PROTOCOL=tcp)(HOST=dg)(PORT=1522)) > ) > ) > > SID_LIST_LISTENER2= > (SID_LIST= > (SID_DESC= > (SID_NAME=STANDBY) > (ORACLE_HOME=/u01/app/grid/product/11.2.0/grid) > (GLOBAL_DBNAME=STANDBY) > ) > (SID_DESC= > (SID_NAME=STANDBY) > (ORACLE_HOME=/u01/app/grid/product/11.2.0/grid) > (GLOBAL_DBNAME=STANDBY_DGMGRL) > ) > ) > > TNSNAMES primário > > STANDBY = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = dg)(PORT = 1522)) > ) > (CONNECT_DATA = > (SERVER = DEDICATED)(UR=A) > (SERVICE_NAME = STANDBY) > ) > ) > > LSNRCTL STATUS LISTSNER2 NO HOST STANDBY QUANDO A INSTANCIA STANDBY ESTÁ > DOWN > > [grid@dg ~]$ lsnrctl status listener2 > > LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-APR-2013 12:49:10 > > Copyright (c) 1991, 2011, Oracle. All rights reserved. > > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg)(PORT=1522))) > STATUS of the LISTENER > Alias listener2 > Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production > Start Date 20-APR-2013 12:37:05 > Uptime 0 days 0 hr. 12 min. 5 sec > Trace Level off > Security ON: Local OS Authentication > SNMP OFF > Listener Parameter File > /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora > Listener Log File /u01/app/grid/diag/tnslsnr/dg/listener2/alert/log.xml > Listening Endpoints Summary... > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg)(PORT=1522))) > Services Summary... > Service "STANDBY" has 1 instance(s). > Instance "STANDBY", status UNKNOWN, has 1 handler(s) for this service... > Service "STANDBY_DGMGRL" has 1 instance(s). > Instance "STANDBY", status UNKNOWN, has 1 handler(s) for this service... > The command completed successfully > > AGORA VOU TENTAR CONECTAR NO STANDBY PELO PRIMÁRIO > > [oracle@rac3 ~]$ sqlplus sys/oracle@standby as sysdba > > SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 20 12:51:42 2013 > > Copyright (c) 1982, 2011, Oracle. All rights reserved. > > ERROR: > ORA-01031: insufficient privileges > Enter user-name: > > AGORA VOU STARTAR A ISNTANCA STANDBY EM MODO NOMOUNT > > [oracle@dg ~]$ sqlplus / as sysdba > > SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 20 12:52:38 2013 > > Copyright (c) 1982, 2011, Oracle. All rights reserved. > > Connected to an idle instance. > > SQL> startup nomount > ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance > ORACLE instance started. > > Total System Global Area 626327552 bytes > Fixed Size 2230952 bytes > Variable Size 184550744 bytes > Database Buffers 436207616 bytes > Redo Buffers 3338240 bytes > SQL> > > LSNRCTL STATUS LISTSNER2 NO HOST STANDBY QUANDO A INSTANCIA STANDBY ESTÁ > NOMOUNT > > [oracle@dg ~]$ lsnrctl status listener2 > > LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-APR-2013 13:00:13 > > Copyright (c) 1991, 2011, Oracle. All rights reserved. > > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg)(PORT=1522))) > STATUS of the LISTENER > Alias listener2 > Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production > Start Date 20-APR-2013 12:37:05 > Uptime 0 days 0 hr. 23 min. 7 sec > Trace Level off > Security ON: Local OS Authentication > SNMP OFF > Listener Parameter File > /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora > Listener Log File /u01/app/grid/diag/tnslsnr/dg/listener2/alert/log.xml > Listening Endpoints Summary... > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg)(PORT=1522))) > Services Summary... > Service "STANDBY" has 2 instance(s). > Instance "STANDBY", status UNKNOWN, has 1 handler(s) for this service... > Instance "STANDBY", status BLOCKED, has 1 handler(s) for this service... > Service "STANDBY_DGMGRL" has 1 instance(s). > Instance "STANDBY", status UNKNOWN, has 1 handler(s) for this service... > The command completed successfully > > AGORA VOU TENTAR ME CONECTAR NOVAMENTE NO STANDBY PELO PRIMÁRIO > > [oracle@rac3 ~]$ sqlplus sys/oracle@standby as sysdba > > SQL*Plus: Release 11.2.0.3.0 Production on Sat Apr 20 12:53:32 2013 > > Copyright (c) 1982, 2011, Oracle. All rights reserved. > Connected to: > Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit > Production > With the Partitioning, Automatic Storage Management, OLAP, Data Mining > and Real Application Testing options > > SQL> > > OK FUNCIONA, MAS ESSE NAO É O MEU PROBLEMA, > O MEU PROBLEMA É O ORA-01031: insufficient privileges QUANDO A INSTANCIA > ESTA DOWN > > ENTÃO, ALGUEM SABE COMO INICIAR UMA INSTANCIA REMOTAMENTE NO 11Gr2??? > > > [As partes desta mensagem que não continham texto foram removidas] ------------------------------------ -------------------------------------------------------------------------------------------------------------------------- >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira >responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ -------------------------------------------------------------------------------------------------------------------------- >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure » >Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE: >http://www.oraclebr.com.br/ ------------------------------------------------------------------------------------------------------------------------ Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: oracle_br-unsubscr...@yahoogrupos.com.br <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html