NOTAFF SERVICE

RAC

CHECK STATUS :

srvctl status database -d orcl
srvctl status database -d orcl -v

srvctl add service -d ORCL -s NOTAFSERVICE -r RACDB1 -a RACDB2         : NOTAFSERVICE--> service name(no property of TAF) , connection should first redirected
to instance 1 , if inst 1 (RACDB1) fails then inst 2(RACDB2)

srvctl status service -d orcl
service NOTAFSERVICE not running.

srvctl start service -d orcl

srvctl status service -d orcl
service NOTAFSERVICE is running on instance(s) RACDB1

CHECK SCAN
==========
cat /etc/hosts | grep scan
check where scan listener is running  ===> crsctl status resource -t

create RAC TNS NAMES with this service
NOTAFSERVICE =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE =ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE = NOTAFSERVICE)
)
)

CONNECT TO SCOTT USING THIS TNS NAMES.

sqlplus scott/tiger@notaffservice   ----------->> verify to which instance it is connected.

SQL> select inst_id,username,service_name,failover_type,failover_method