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.
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.
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
Joined: Oct 16, 2008
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?