Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to handle Oracle MAX Connection Limit Exceeded problem in PHP?

RENGANATHANMGJul 19 2013 — edited Aug 13 2013

Hi All,

Our application is based on PHP & Ajax.

Occasionally, we are getting "Oracle MAX Connection Limit Exceeded " issue in our application.

We want to alert the user that some problem in oracle database connection.

We did the mistake to not taking care of db error handling.

Is there any way to handle wisely ? Instead of changing or handling errors in all ajax calls.

we have the common PHP & Js files in all the modules.

Any suggestions or feedback are welcome.

Thanks,

Renga

Comments

The Explorer

Hi,
Please make sure that listener has been started and you are able to tnsping it.
Thanks

EdStevens

Well, he did say
After trying to start the listener, i am getting the error
Failed to start listener service, error 2: The system cannot find the file specified.

EdStevens

So the first thing seems to be to get your listener started.
What OS is the database installed on?
From the database server, show us the contents of 'listener.ora' and 'sqlnet.ora'. When you post it, please format it as 'code'. (https://community.oracle.com/tech/apps-infra/kb/articles/12-format-text)

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 10 2013
Added on Jul 19 2013
#php
2 comments
4,535 views