Oracle autoreconnect on connection failure

As debasisdas already mentioned that is application feature that you either have implement by your self or depending on used language you can use libraries like Hibernate for Java that will help you to handle this stuff

http://bit.ly/jL1tJo