Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm having a problem with Oracle, it happens randomly around once in three weeks or once a month. The instance that i'm using suddenly hangs, and no logins can be established to it.It won't accept connections and I can't login to it. I would see no error in the alert logs. I would restart my application but the application still can't connect to it. There were no locks at that time. The thing is, there was no error in the alert logs as well, it would just hang all of a sudden. The only way to recover is to restart it. In my java thread dumps, I would see that the application is hanging at Socket.read part

What are Oracle's problems when I can't login to it at all? I can't initialize a connection that's why I need to resrtart the database. After restarting, I can connect again. There are no error on the alert logs.

What do you think I should look at?

Thanks

share|improve this question
    
Any clues in the alert log? What is your PROCESSES and SESSIONS parameter set to? If these are low then you may have bumped your head on this limit when trying to log in. –  David Mann Dec 7 '11 at 14:26
add comment

1 Answer

Start monitoring memory usage. Does your application terminate old sessions? If not, there is a connection leak that eventually takes away all processes your database instance can use and prevent new connections. There also could be a memory leak, that is why monitoring memory and swap could be smart to do.

Most likely to me seems to be the connection leaking. You can easily monitor this by making counts of v$session or v$process. These counts should not grow unlimited. Since you use jdbc (thin client I asume) Dead Client Detection could also be useful. This gives the rdbms the ability to clean up unused sessions. Unused sessions are those that do not react upon a ping from the server.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.