Database Networking (MOSC)

MOSC Banner

Error ORA-25401: can not continue fetches occurs when using server configured TAF against SCAN

edited Feb 23, 2015 10:02AM in Database Networking (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center