asked on

Oracle 11g AND application failed logins

Experts,

I am trying to do some research on an issue we are having with our Oracle db. Using the OEM, there are errors logged that a specific software is trying to login to the database but failing. Login attempts are 676 per half hour continuously. would this cause a connection refusal error from Oracle? As soon as we stopped using that piece of software the db stopped crashing.

Patmac951

Can you post the exact error from the Oracle log?

missymadi

ASKER

676 Failed login attempts in the last 30 minutes
675 Failed login attempts...
675.....
656..
676..
675..

slightwv (䄆 Netminder)

I'm not sure what you are asking here.

Failed log attempts should not cause a database to crash. It might flood the listener so no valid connections could get through.

I think what Patmac951 was asking is for you to check the database alert log for errors.

Please provide a little more information on what you would like us to assist with.

missymadi

ASKER

The exact error returns "all database connections are blocked" I'm thinking it is what you suggested that the listener gets flooded. How can I explain this technically so the higher ups will understand or how can I prove that a particular piece of software is causing the listener to go down? They automatically think it's the database that is not working.

Thanks, Missymadi

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial