Concurrent connections

[Nobody's Hero]

I've got a K360 running a web server for field reps. We get an ORA-12154 error on around the 200th connection. What can I do to increase in the kernel to help this? I can't find any cases on the ITRC. all are related to OV.

[Nobody's Hero]

Would increasing the number of TCP/IP sockets help?

[Pete Randall]

Are you sure that isn't an Oracle limit?

Pete

[Nobody's Hero]

Im not sure. They are looking to me for help. I wouldn't know where to look in oracle.

[Pete Randall]

Robert,

I'll defer to the Oracle experts. The reason I asked is that Informix has a limit based on the number of users you're licensed for.

Pete

[Volker Borowski]

Hello Robert,

check out the oracle parameter file, usually named "init.ora".

Hunt for Prameters "processes" and "sessions". If these are in a range of 200, increase them and be sure to have sessions 10% bigger than processes. Will require to restart the database.

Consider to change your configuration from dedicated servers to multithreaded servers.

Good luck
Volker