QueuePool and ORA-12519

Exception-1

    raise exc.DBAPIError.instance(None, None, e) DatabaseError: (DatabaseError) ORA-12519: TNS:no appropriate service handler found
 None None

Solution i found in the net:

1. Run SQL*Plus and login
2. Run the command “alter system set processes=150 scope=spfile;” in the SQL*Plus
3. Restart the database.

Question:

        Is the correct way to solve this problem?

Exception -2

QueuePool limit of size 10 overflow 10 reached, connection timed out, timeout 30
Traceback (most recent call last):

    raise exc.TimeoutError("QueuePool limit of size %d overflow %d reached, connection timed out, timeout %d" % (self.size(), self.overflow(), self._timeout))
TimeoutError: QueuePool limit of size 10 overflow 10 reached, connection timed out, timeout 30

Question:

        How can i find the Pool size to be used? Received on Mon Aug 16 2010 - 07:42:43 CDT