Problem fetching data from link server once it is down and then restarted

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.

Thanks in advance.
Rajesh Received on Wed Nov 27 2002 - 04:04:29 CST