This content has been marked as final. Show 4 replies
Is it RAC DB or two different instances of different DB's ?
Can you check if sql developer behaves in similar way with below two situations
1. login with the owner of the TLO & execute queries
2. drop public synonym & restructure query to use table name as "TLO"@"GIPS_E" & execute queries
I have just restructured the query in SQLDev and explicitly use TLO@GIPS_E in the FROM clause and it works ! I got the correct result...
What can I do instead of recreate the public synonym ?
Thanks for your help...
Note : However with Toad I always have the ORA-03106 !
Good to hear that , now for ORA-03106: fatal two-task communication protocol error has multiple reasons of fialure
Let me know ..
1. Do you have multiple oracle home install at client ? it yes then kindly keep only one unless required
2. Does sql developer & TOAD points to same oracle home & TNS admin ? if not then please change it to point to working oracle home i.e. of developer
Actually I would like to resolve the public synonym error before the client's problem...
What can I do to make this query giving the good result :
SELECT ZONE,CP_6,INS,SOA,RUN,COM,LOC,CP FROM TLO WHERE TLO = 1234;