Home > IT Answers > Networking > Oracle connection dropping out
Rcapuyan
5 pts.
 Oracle connection dropping out
connecting networks, Oracle
Oracle connection to the server is dropping down after 2, 3, 4hrs. no error's displayed, it will just close the window.

Software/Hardware used:
ASKED: December 5, 2007  7:18 PM
UPDATED: December 6, 2007  6:28 AM
RELATED QUESTIONS
Answer Wiki:
I do not know which oracle version and user you are connected as, in Oracle 10.1.0.2.0 do SHOW USER in sql prompt and get your user name and then run select profile from dba_users where username = 'xxx'; select limit from dba_profiles where profile = 'pname' and resource_name = 'CONNECT_TIME'; if it is not UNLIMITED make it alter profile your_profile_name limit CONNECT_TIME UNLIMITED
Last Wiki Answer Submitted:  December 6, 2007  6:28 am  by  Sr1234   70 pts.
All Answer Wiki Contributors:  Sr1234   70 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _