Hello all,
I am experimenting with Transparent Application Failover with Oracle 8i.
I have setup two servers exactly the same way with the same schemas and same
accounts/passwords (to emulate an OPS environment). I am connecting with
SQLPLUS (version 8.1.5.0.0) using a tnsnames.ora similar to the one below. I
then shut down the active server to emulate system failure. If I am doing
simple select statements, the failover works perfectly. However, if I start
a transaction (i.g. insert statement) , I get an ORA-25402 error indicating
that the "transaction must roll back". I understand the error and find it to
be reasonable, When I attempt the rollback though, I get an ORA-00000 error
with the message: "normal, successful completion". All future attempts to
query the database results in the same error. I would have expected the
rollback to work and then have to redo the transaction. Can anyone explain
this behavior? Can anyone point me to any recent Oracle High Availability
white papers? Thanks!!!
- tnsnames.ora -----------
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(SOURCE_ROUTE = OFF)
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = server1.domain.com)(PORT =
1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server2.domain.com)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(failover_mode =
(type = select)
)
)
)
Received on Mon Feb 07 2000 - 13:18:57 CST
