This content has been marked as final. Show 5 replies
Stop and restart this service and also check tns entries on network clients.
sample on 10gr2
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host3-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = host4-vip)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.com)
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 10)
(DELAY = 1)
sample 11gr2 using SCAN
sales.mycompany.com = (DESCRIPTION= (CONNECT_TIMEOUT=10)(RETRY_COUNT=3)
Were you finally able to solve this issue?
We are experiencing the same problem.
this is client side taf configuration,no sever side
i have the same problem now
You have to use srvctl utility to manage services, not dbms_service package.
Edited by: Ivica Arsov on Feb 12, 2013 2:21 PM