Database link error after the remote database restarts (comes up after down for a while)

Hi All,
 I have a stored procedure which select rows from transactional  database and a remote database (using datbase link)  

 Example:
 SELECT someId FROM sometable
 UNION
 SELECT someId FROM sometable_at_SOMELINK;  

 Now, when I stop the Link server and restart it and try to execute the  stored procedure, I get an error as
 ORA-02068: following severe error from SOMELINK  ORA-12571: TNS:packet writer failure  

 I also used views and synonyms but it doesnot help  can any body help me.

 When I recompile the stored procedure its works but this is also  not a solution as this is not possible in production.

 I am using Oracle 8.1.7.0.0 - Production  OS : Solaris/W2K (I tried on both).

 I will appreciate all the response
 Thanks in advance.
 Rajesh Received on Wed Nov 27 2002 - 23:29:46 CST