Adam wrote:
>
> 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!!!
Is Transparent Application Failover something that only runs on NT or are
there also versions for Solaris?
Received on Mon Feb 07 2000 - 13:21:42 CST
