Hi,
I'm using Oracle RAC 12.2.0.1.
I've create service for Transparent Application Failover using this commands:
srvctl add service -d epodr -s epodtaf -r epodr1 -a epodr2 -P BASIC -y AUTOMATIC -q TRUE -j LONG -z 180 -w 5 -e SELECT -m BASIC
srvctl start service -d epodr -s epodtaf
and add to tnsnames.ora
TAFEPODSVC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = epscan)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = epodtaf)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
I've checked configuration and look OK:
[oracle@eprac2 ~]$ srvctl status database -d epodr -v
Instance epodr1 is running on node eprac1 with online services epodtaf. Instance status: Open.
Instance epodr2 is running on node eprac2. Instance status: Open.
[oracle@eprac1 admin]$ lsnrctl status
(...)
Service "epodtaf" has 1 instance(s).
Instance "epodr1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@eprac1 samples]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Dec 3 17:23:26 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Polaczono z:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> select name, service_id from dba_services where name = 'epodtaf';
NAME SERVICE_ID
---------------------------------------------------------------- ----------
epodtaf 3
SQL> SELECT name, failover_method, failover_type, failover_retries,goal, clb_goal, aq_ha_notifications
FROM dba_services
WHERE service_id = 3; 2 3
NAME
----------------------------------------------------------------
FAILOVER_METHOD
----------------------------------------------------------------
FAILOVER_TYPE
----------------------------------------------------------------
FAILOVER_RETRIES GOAL CLB_G AQ_
---------------- ------------ ----- ---
epodtaf
BASIC
SELECT
180 NONE LONG YES
But when I try to login via new service I've got such error:
[oracle@eprac1 admin]$ sqlplus system/********@epodtaf
SQL*Plus: Release 12.2.0.1.0 Production on Mon Dec 3 17:42:57 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Is that anything more that I have to check?