[oracle_br] iniciar uma instancia remotamente
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
Re: [oracle_br] iniciar uma instancia remotamente
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
[oracle_br] Re: iniciar uma instancia remotamente
Fala Marcelo, cara eu ja fiz isso, se eu nao tivesse feito isso, eu nao conseguiria me conectar no standby pelo primario usando as sysdba certo?? --- Em oracle_br@yahoogrupos.com.br, Marcelo Procksch marceloprocksch@... escreveu 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.longhi@... 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...