Error ORA-25401: can not continue fetches occurs when using server configured TAF against SCAN
Hi All,
query - select * from dba_objects where rownum<99999 order by 1,3,5,7 desc;
No issues with the query: select * from dba_objects
Issue does not reproduce when using 11.2 client but does reproduce using an 12 client.
12c client tns entry
OEMDGTST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racdba-scan.mycmsc.com)(PORT = 3200))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMDGTST_TAF)
)
)
11gr2 client tns entry
OEMDGTST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racdba-scan.mycmsc.com)(PORT = 3200))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMDGTST_TAF)
)
)
connect string - username@OEMDGTST
Can someone please suggest.
regards,
Raj