What limits the number of MII connections to Oracle.

[Former Member]

We are using MII 12.0.5 and an Oracle database and are seeing errors in the logs to the effect:

SQL error occurred on connection jdbc:oracle:thin:@mii001:1527:SMD: code=0, state="null", message="Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

mii001:1527:SMD

".

I am ot an Oracle expert and I have not seen this issue before. What is limiting the number of connections? Is this a MII configuration issue that I am not aware of or an Oracle database issue?

[agentry_src · Accepted solution]

Hi Sparks,

Not that familiar with Oracle either, but googling the Oracle error code (ORA-12518) has almost always pointed towards the cause and often to a solution as well.

Regards,

Mike

[Former Member]

Hello sparks,

I assume you are getting this error when you are trying to connect to databse while configuring Dataservers in MII,if fo what are the value you passed in the fields PoolMax and PoolSize while connecting to the database.

Regards,

Kumar

Edited by: Sudhir Kumar Shambana on May 6, 2010 10:50 AM