ORA-25402
In our database,we have a view over dblink to a SQL server database. We have a web based application and we use weblogic. One of the portlets has a simple select to this view. We started getting sporadic ORA-25402 in the logs. By sporadic, i mean sometimes portlet was returning data and sometimes not. Investigations indicated that it all started with ORA-02068. Same portlet is called at another place also and it was working fine. We were not getting any error while executing the query from SQL*Plus. Finally the problem was solved by bouncing the weblogic. Is there a way to avoid this error after network interruptions?