Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-25402

533889Jan 5 2007
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2007
Added on Jan 5 2007
0 comments
783 views