This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Need to Start oracle services after long time Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need to Start oracle services after long time" Watch "Need to Start oracle services after long time" New topic
Author

Need to Start oracle services after long time

amol l a lekurwale
Ranch Hand

Joined: Oct 16, 2008
Posts: 30
Please let me know if this is the right thread to post this topic.

I have a complex application, wherein the user needs to login as per his assigned user id and password. If the screen is left untouched for some time (5 min) the session expires. If the screen is left unattended for about an 1 hr, and no other operation occurs with Oracle server, login does not occur even after entering the right data. The oracle services need to be restarted, and then the login process succeeds.

I would like to ask so as to why such a kind of situvation(need of restarting oracle) arrives and any solutions for the same.

Regards,
Amol
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


I would like to ask so as to why such a kind of situvation(need of restarting oracle) arrives and any solutions for the same.

There is no need to restart Oracle. Can you explain more about what the problem is? What makes you think its the Oracle service that is the issue?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
amol l a lekurwale
Ranch Hand

Joined: Oct 16, 2008
Posts: 30
Well, the problem is with my application. I can externally access oracle through command prompt. But if system is kept idle for about an hour, login fails. And then oracle needs to be restarted. As far as the application is concerned, I close the connection after a transaction.
What I need is which part in my application is responsible for such a kind of situvation. There are about 20 tables with no high complex relationships between themselves.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


But if system is kept idle for about an hour, login fails. And then oracle needs to be restarted

Why? This is not normal operation for Oracle. A failed login should not cause Oracle to fail.
amol l a lekurwale
Ranch Hand

Joined: Oct 16, 2008
Posts: 30
Paul,
Login fails means even if I enter the correct user id and password ( which would have otherwise caused login to succeed ), I am not able to login.
Is this a concern of any registry entries, or some cache mechanism?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


Is this a concern of any registry entries, or some cache mechanism?

I've never heard of Oracle behaving this way. Connections may timeout - but Oracle doesn't need restarted when this happens.

When you try to login how do you do this and what is the text of the error message you get?
 
wood burning stoves
 
subject: Need to Start oracle services after long time