Is there a way for TDP to ping the database at specified interval times or is there a Keep Alive or a Ping feature to prevent network timeouts? Gets error: ORA-03135: connection lost contact Process ID: 0 Session ID: 618 Serial number: 29841.
WORKAROUND 1:
Ask your Network or IT Helpdesk to increase the network timeout for you.
WORKAROUND 2:
1) Open an Editor Window.
2) At the bottom part of screen, click on the “Messages” Tab.
3) Click or depress the “Poll DBMS Output for lines” icon (looks like a clock icon).
4) You can increase the Poll Frequency from 5 seconds, but max is 30 seconds.
5) From then on, TDP will send a code similar the one below to your database. This will act like a ‘ping’ to keep your database connection alive.
Timestamp: 6/21/2011 3:48:14 PM
begindbms_output.get_lines(lines => :lines, numlines => :numlines); end; -- 145
numlines=[0]
Elapsed time: 0.000
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center