Pessoal, se alguem mais tiver alguma dica para tentar resolver esse problema, pois ainda não consegui resolver.... agradeço a atenção...
_____ De: oracle_br@yahoogrupos.com.br [mailto:[EMAIL PROTECTED] Em nome de Sharif G Raduan Enviada em: segunda-feira, 28 de maio de 2007 17:50 Para: oracle_br@yahoogrupos.com.br Assunto: RES: [oracle_br] Erro envio Archive para Standby Sim verifiquei e cheguei até dar um chmod 777 R,mas mesmo assim nada... _____ De: [EMAIL PROTECTED] <mailto:oracle_br%40yahoogrupos.com.br> os.com.br [mailto:[EMAIL PROTECTED] <mailto:oracle_br%40yahoogrupos.com.br> os.com.br] Em nome de Cyro Enviada em: segunda-feira, 28 de maio de 2007 17:19 Para: [EMAIL PROTECTED] <mailto:oracle_br%40yahoogrupos.com.br> os.com.br Assunto: Re: [oracle_br] Erro envio Archive para Standby Eu dei uma olhada por cima no seu erro. Mas aparentemente parece que vc não tem permissão de escrita em um diretório: Errors in file /db/oracle/admin/dbdsv07/bdump/dbdsv07_arc0_10752.trc: ORA-01031: insufficient privileges Confere lá para ver se vc tem mesmo permissão. On 5/28/07, Sharif G Raduan <sharif_raduan@ <mailto:sharif_raduan%40yahoo.com.br> yahoo.com.br> wrote: > > Pessoal, montei um ambiente de standby database de teste, mas estou > tendo o > problema abaixo no momento de envio dos archives.... o ambiente todo é em > uma mesma máquina..... > > Ambiente...: > > [EMAIL PROTECTED] dbs]$ uname -a > > Linux oralinux.jmahfuz.com.br 2.6.9-55.0.0.0.2.ELsmp #1 SMP Wed May 2 > 15:06:32 PDT 2007 x86_64 x86_64 x86_64 GNU/Linux > > [EMAIL PROTECTED] dbs]$ > > Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit > Production > > ERRO NO ALERT DA BASE PRINCIPAL...: > > Mon May 28 17:05:54 2007 > > Errors in file /db/oracle/admin/dbdsv07/bdump/dbdsv07_arc0_10752.trc: > > ORA-01031: insufficient privileges > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > TRACE DA BASE PRINCIPAL... > > --------------- > > Dump file /db/oracle/admin/dbdsv07/bdump/dbdsv07_arc0_10752.trc > > Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit > Production > > With the Partitioning, OLAP and Data Mining options > > ORACLE_HOME = /db/oracle/product/10gR2 > > System name: Linux > > Node name: oralinux.jmahfuz.com.br > > Release: 2.6.9-55.0.0.0.2.ELsmp > > Version: #1 SMP Wed May 2 15:06:32 PDT 2007 > > Machine: x86_64 > > Instance name: dbdsv07 > > Redo thread mounted by this instance: 1 > > Oracle process number: 17 > > Unix process pid: 10752, image: [EMAIL PROTECTED] <mailto:oracle%40oralinux.jmahfuz.com.br> jmahfuz.com.br<oracle%40oralinux.jmahfuz.com.br>(ARC0) > > *** SERVICE NAME:() 2007-05-28 16:20:44.975 > > *** SESSION ID:(871.1) 2007-05-28 16:20:44.975 > > kcrrwkx: nothing to do (start) > > *** 2007-05-28 16:21:44.907 > > Redo shipping client performing standby login > > OCIServerAttach failed -1 > > .. Detailed OCI error val is 12541 and errmsg is 'ORA-12541: TNS:no > listener > > ' > > *** 2007-05-28 16:21:45.150 60679 kcrr.c > > Error 12541 received logging on to the standby > > *** 2007-05-28 16:21:45.150 60679 kcrr.c > > Check whether the listener is up and running. > > Error 12541 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 12541 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-12541: TNS:no listener > > *** 2007-05-28 16:21:45.150 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 12541. > > *** 2007-05-28 16:21:45.150 58941 kcrr.c > > kcrrfail: dest:2 err:12541 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:22:46.635 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:23:46.798 > > Redo shipping client performing standby login > > OCIServerAttach failed -1 > > .. Detailed OCI error val is 12541 and errmsg is 'ORA-12541: TNS:no > listener > > ' > > *** 2007-05-28 16:23:47.044 60679 kcrr.c > > Error 12541 received logging on to the standby > > *** 2007-05-28 16:23:47.044 60679 kcrr.c > > Check whether the listener is up and running. > > Error 12541 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 12541 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-12541: TNS:no listener > > *** 2007-05-28 16:23:47.062 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 12541. > > *** 2007-05-28 16:23:47.062 58941 kcrr.c > > kcrrfail: dest:2 err:12541 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:24:47.110 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:25:47.112 > > tkcrrxmp: Stopping ARC1 to reduce ARCH processes from 2 to 1 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:25:52.778 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:25:52.778 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:25:52.778 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:26:52.797 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:27:52.819 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:27:52.971 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:27:52.971 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:27:52.971 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:28:52.979 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:29:52.981 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:29:53.067 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:29:53.067 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:29:53.067 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:30:53.075 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:31:53.076 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:31:53.141 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:31:53.142 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:31:53.142 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:32:53.148 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:33:53.170 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:33:53.235 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:33:53.235 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:33:53.235 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:34:53.243 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:35:53.245 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:35:53.369 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:35:53.369 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:35:53.369 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:36:53.394 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:37:53.396 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:37:53.462 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:37:53.462 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:37:53.462 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:38:53.470 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:39:53.472 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:39:53.537 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:39:53.537 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:39:53.537 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:40:53.561 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:41:53.562 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:41:53.626 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:41:53.626 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:41:53.626 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:42:53.633 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:43:53.635 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:43:53.698 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:43:53.728 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:43:53.728 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:44:53.735 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:45:53.737 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:45:53.801 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:45:53.801 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:45:53.801 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:46:53.807 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:47:53.808 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:47:53.870 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:47:53.870 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:47:53.870 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:48:53.878 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:49:53.879 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:49:53.980 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:49:53.980 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:49:53.980 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:50:53.988 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:51:53.989 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:51:54.053 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:51:54.054 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:51:54.054 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:52:54.060 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:53:54.062 > > Redo shipping client performing standby login > > OCISessionBegin failed -1 > > .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient > privileges > > ' > > *** 2007-05-28 16:53:54.126 60679 kcrr.c > > Error 1031 received logging on to the standby > > Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host > 'standby' > > ORA-01031: insufficient privileges > > *** 2007-05-28 16:53:54.126 60679 kcrr.c > > PING[ARC0]: Heartbeat failed to connect to standby 'standby'. Error is > 1031. > > *** 2007-05-28 16:53:54.126 58941 kcrr.c > > kcrrfail: dest:2 err:1031 force:0 blast:1 > > kcrrwkx: nothing to do (end) > > *** 2007-05-28 16:54:54.133 > > kcrrwkx: nothing to do (end) > > ---------- > > [EMAIL PROTECTED] dbs]$ tnsping standby > > TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 28-MAY-2007 > 17:08:32 > > Copyright (c) 1997, 2005, Oracle. All rights reserved. > > Used parameter files: > > /db/oracle/product/10gR2/network/admin/sqlnet.ora > > Used TNSNAMES adapter to resolve the alias > > Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = > oralinux.jmahfuz.com.br)(PORT = 1521)) (CONNECT_DATA = (SERVER = > DEDICATED) > (SERVICE_NAME = standby))) > > OK (0 msec) > > [EMAIL PROTECTED] dbs]$ > > ------------------------------- > > [As partes desta mensagem que não continham texto foram removidas] > > > -- [ ]´s Cyro [As partes desta mensagem que não continham texto foram removidas] [As partes desta mensagem que não continham texto foram removidas] [As partes desta mensagem que não continham texto foram removidas]