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.

The Title speaks for itself.

We have this error message on the client side of the application. The devs suspect a problem on the database. The alert log on the database shows no errors at all. The only events I have are the regular archived logs shipping to the standby database.

I was suspecting processes and sessions parameters to be a bit too low, but currently

select count(*) from v$process shows 36 process running. Granted this is not peak time, but I would need to have ora-00020 in my alert log anyway should I hit this threshold...

What else could be happening?

share|improve this question
    
Do the steps here help? –  Ben Brocka Jan 6 '12 at 20:37
    
It'll be a network problem/firewall issue if other clients can connect to the database. Can you tnsping/ping/traceroute to the database server from the client? –  FreshPhilOfSO Jan 26 '12 at 12:46
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.