Home » RDBMS Server » Networking and Gateways » ORA-12520 when performing simultaneous requests
ORA-12520 when performing simultaneous requests [message #202318] Thu, 09 November 2006 01:57 Go to next message
eb1421
Messages: 3
Registered: November 2006
Junior Member
Hello,

I am a complete Oracle beginner and I am working with Oracle 10g Express Edition.
My configuration is the one automatically set during installation.

I have 10 users sending a series of queries simultaneously (for benchmark purpose).
If I have 1 user, everything is OK.
When I have 10 users, for most of the queries I get the following error:
ORA-12520: TNS:listener could not find available handler for
requested type of server
I think it is a problem of number of simultaneous connections.

I have tried to :
- increase PROCESSED and PARALLEL_MAX_SERVERS in init.ora
- set QUEUE_SIZE in listener.ora
- set RECV_BUF_SIZE and SEND_BUF_SIZE in listener.ora and sqlnet.ora
...
and it does not help

Besides, the result of lsnrctl services seems OK.

Can someone help me with this problem ?
Thank you very much

Eve
Re: ORA-12520 when performing simultaneous requests [message #202324 is a reply to message #202318] Thu, 09 November 2006 02:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

check few things

1.cmd>lsnrctl services

all instance is register to listener.

2.check or post listener.log file. ( oracle-home/network/log/)

for any error or help

3.increase processes parameter.
sql>show parameter processes

alter system set processes = integer scope=spfile

bounce ur database.


Re: ORA-12520 when performing simultaneous requests [message #202338 is a reply to message #202324] Thu, 09 November 2006 03:39 Go to previous message
eb1421
Messages: 3
Registered: November 2006
Junior Member
Thank you very much
The "alter system set processes " made my tests work

Eve
Previous Topic: WB_RT tables in OWB
Next Topic: DB Link Problem from 9i Database to 8i Database
Goto Forum:
  


Current Time: Tue Dec 03 09:20:30 CST 2024