I have dblink from server A to server B, and on server A executing 3
scripts(procedures) (sqlplus+winscheduler) in wich asking few records from
server B;

its work fine last 10 months and now start to have problems, every day with
one of this scripts and errors :

ORA-3113: TNS:End of file on communication channel (few times)

TNS-12518 TNS:listener could not hand off client connection (only one times)

When one procedure have problem, other two doesn't have,

and I sow on server A, after breaking procedure, sometimes stay active
connection for sqlplus with that procedure after sqlplus is closed, and if I
kill that from EMC this don't help to next execution of procedure (help only
if I restart that A server).

Today some other application have problem with slow reponse in connection
with B server, but not for all time.

Server A and B is connected with only one router and on administrator can't
find on router any problematic flow to servers.

How to find where is problem, on server A or B and what is problem?

Thanks, Ed






Oracle LazyDBA home page