AW: TAF

Hi Bryan,  

> 1) Are you connecting using the "virtual" instance or are you
> connecting directly to the instance on the node or using "/
> as sysdba"? Run the query the previous poster sent and check
> you connection parameters.

I tried with 'sqlplus / as sysdba' and 'sqlplus sys as sysdba' + pw.

Query:

INSTANCE_NAME HOST_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER ------------- --------- ------------- --------------- -----------

gwit1         linora1p
                        NONE          NONE            NO

INSTANCE_NAME HOST_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER ------------- --------- ------------- --------------- -----------

gwit2         linora1e
                        NONE          NONE            NO
   

> 2) Are you connecting from a 9i client? On a recent job I
> discovered that the
> 9.2.0.1 client does not failover properly for a 10g database.

I am directly using the sqlplus on the server.

> As far as adding (FAILOVER = on) I have seen the TAF
> failover work without this, but I always add it to any RAC
> tnsnames.ora file. You might also want to add (ENABLE=broken)

Does not work either ...

Cheers,

Nora

--
http://www.freelists.org/webpage/oracle-l