Oracle Database Discussions

Hi everyone,

I recently read on My Oracle Support this document : How To Configure Server Side Transparent Application Failover [ID 460982.1]

In this document they suggest to use the package DBMS_SERVICE with the procedure MODIFY_SERVICE.

It work well until I shutdown one of the nodes of the RAC. But after that, it seam that server-side TAF configuration disapear.

Before stoping instance on one node:

SQL> select name,failover_method,failover_type from dba_services where service_id = 3;

NAME
--------------------------------------------------------------------------------
FAILOVER_METHOD
--------------------------------------------------------------------------------
FAILOVER_TYPE
--------------------------------------------------------------------------------
ORCLCLUSTER
BASIC
SELECT

After stopping and restarting instance on one node of the RAC:

SQL> select name,failover_method,failover_type from dba_services where service_id = 3;

NAME
--------------------------------------------------------------------------------
FAILOVER_METHOD
--------------------------------------------------------------------------------
FAILOVER_TYPE
--------------------------------------------------------------------------------
ORCLCLUSTER
NONE
NONE


How to make service parameters permanant so that, it will not reset to 'NONE' after instance restart.

Regards.

Carl

Edited by: plhtyuk on Apr 1, 2011 7:46 AM