ORA-12540: TNS:internal limit restriction exceeded in <file> (w/PHP)

[derekludwig]

I've recently inherited a database that has been w/o an active dba in a while, so I am playing catch up with the various issues. I am currently working on:

Warning: ocilogon(): _oci_open_server: ORA-12540: TNS:internal limit restriction exceeded in /data/htdocs/

http://www.starchefs.com/poll/poll.php

on line 3

which, until recently, was working.

While I am making queries in the PHP forums ... can you point me in a direction for solving this issue?

Many thanks.

----------------
Derek Ludwig
derek<at>ludwig.com

 

[SantaMufasa]

Derek,

If you ran it again (now, assuming its after hours), it would probably work. The problem is too many TNS connections open simultaneously.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:34 (20Jan04) GMT, 23:34 (19Jan04) Mountain Time)

 

[derekludwig]

Thanks for the information.

You would think an error like

  ORA-314159: too many TNS connections

could have been used here.

Ah well.



----------------
Derek Ludwig
derek<at>ludwig.com