Topic
No replies
SystemAdmin
SystemAdmin
6907 Posts
ACCEPTED ANSWER

Pinned topic Pcksh error: communications with remote host lost - Connection timed out

‏2013-02-17T07:48:52Z |
Apologies query is asked for AIX flavour

Application Flow
END USER logged on via internet through URL==> WEB SERVER==>APP SERVER ==> Query fired on database one synonyms ( Database one )
==>Synonym gets data from second database (tables) via DB LINK (Created on first Database)==>2nd database dataset returns to 1st database ==>APP server
==>App server creates response XML ==.WEB server (blank screen times out)

Currently TMOUT=600 sec (=10 Min) is configured on AIX server for application users
• (DBA) ran query two times one in background( setting off server output) query executes in few seconds but when she ran same query (server output on) it times out in few second with below error
Pcksh error: communications with remote host lost - Connection timed out
• Ideally TMOUT should be overruled when activity is going on.

Please let us know ASAP, why session is getting terminated when query is being run by doing set serveroutput on?

About Query
it actually run on 1st database and connect the 2nd database via db link and fetch the result. but it ends with this error while fetch the result

Pcksh error: communications with remote host lost - Connection timed out

please note that only 400-500 records are maximum being fetched