Bom dia a todos.
Estou tentando configurar um data guard em
com Oracle 10.2.0.3 e Windows XP. A seguir partes dos
arquivos envolvidos:
Init.ora do banco primário (PRIM):
*.DB_NAME=ORCL
*.DB_UNIQUE_NAME=PRIM
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,SEC)'
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_DEST_1='LOCATION=d:\oracle\archive\
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL'
*.LOG_ARCHIVE_DEST_2='SERVICE=SEC LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=SEC'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.FAL_SERVER=SEC
*.FAL_CLIENT=PRIM
Init.ora do banco secundário (SEC)
*DB_NAME=ORCL
*.DB_UNIQUE_NAME=SEC
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,SEC)'
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_DEST_1='LOCATION=d:\oracle\archive\
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL'
*.LOG_ARCHIVE_DEST_2='SERVICE=PRIM LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=PRIM'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.FAL_SERVER=PRIM
*.FAL_CLIENT=SEC
Tnsnames.ora para os dois:
SEC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.0.197)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
PRIM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.0.196)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
Mensagem do alert.log do PRIM:
Errors in file
d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_2424.trc:
ORA-12170: TNS:Ocorreu timeout da conexão
FAL[server, ARC1]: Error 12170 creating remote archivelog
file 'SEC'
FAL[server, ARC1]: FAL archive failed, see trace file.
Mon Sep 14 22:59:50 2009
Errors in file
d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_2424.trc:
ORA-16055: solicitação FAL rejeitada
ARCH: FAL archive failed. Archiver continuing
Mon Sep 14 22:59:59 2009
FAL[server]: Fail to queue the whole FAL gap
GAP - thread 1 sequence 31-31
DBID 1224851350 branch 697070614
Mensagem do arquivo de trace do PRIM:
Error 12170 received logging on to the standby
Error 12170 connecting to destination LOG_ARCHIVE_DEST_2
standby host 'SEC'
Error 12170 attaching to destination LOG_ARCHIVE_DEST_2
standby host 'SEC'
ORA-12170: TNS:Ocorreu timeout da conexão
Obs.:
Em princípio achei que poderia ser a conexão, mas
desativei o firewall nas duas máquinas, testei com TNSPING
e SQLPLUS e funcionou normalmente.
____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
