How to increase the number of connections to the database

[LordElfo]

Environment information:
* Oracle version: 10g
* Operating system: Windows 2003 Server

Hello everyone.
I would like to know if anyone knows how I can increase the number of possible connections to the BD.
is giving an error that when it comes next to 100 connections it does not allow any anymore.

If someone knows warns beleza?
vlw !!!

[Dulima-SP]

your base is set to shared ???

You have already increased the max_shared_servers ???

[pauloaleo]

Well, I assume you must have a bank with the session parameter set at the init and the connections are dedicated.

If this is, change this parameter to greater than 100. You view the amount of open sessions, typing at the SQLPlus prompt

[LordElfo]

Oops my base is dedicated.
With this command I obtiv a more detailed result ...
I tried to change the INI to have more sessions but it seems that it did not work
would be for him correct? to increase the parameter?

vlw !!!

[pauloaleo]

You do this:

In the init Put the parameter as below:

Select all

sessions=200

of Stop and Instance Start.

Then he changes.

[pauloaleo]

SIM, this parameter only changes with STOP / START of the instance.

is a startup parameter.

[LordElfo]

We tested here by increasing sessions for 200 and processes for 175 by restarting Oracle Instance Service and OracleOradB10G_Home1tnSlistener
but kept the problem = (

[pauloaleo]

As it maintained the problem. It passes the result of the query

Select all

select * from v$resource_limit;

which error happens when reaches 100 connections.

[LordElfo]

The error is this

Select all

Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=blablabla.com.br)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=prd))) 

The select result was this below:

Select all

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE 
------------------------------ ---------------------- ---------------------- ------------------ ----------- 
processes 90 100 100 100 
sessions 94 104 115 115 
enqueue_locks 67 77 1650 1650 
enqueue_resources 18 41 724 UNLIMITED 
ges_procs 0 0 0 0 
ges_ress 0 0 0 UNLIMITED 
ges_locks 0 0 0 UNLIMITED 
ges_cache_ress 0 0 0 UNLIMITED 
ges_reg_msgs 0 0 0 UNLIMITED 
ges_big_msgs 0 0 0 UNLIMITED 
ges_rsv_msgs 0 0 0 0 
gcs_resources 0 0 0 0 
gcs_shadows 0 0 0 0 
dml_locks 0 52 504 UNLIMITED 
temporary_table_locks 0 1 UNLIMITED UNLIMITED 
transactions 0 8 126 UNLIMITED 
branches 0 0 126 UNLIMITED 
cmtcallbk 0 2 126 UNLIMITED 
sort_segment_locks 50 55 UNLIMITED UNLIMITED 
max_rollback_segments 11 11 126 65535 
max_shared_servers 1 1 UNLIMITED UNLIMITED 
parallel_max_servers 0 0 40 3600

[pauloaleo]

In the V $ Resource_Limit Your parameter is still still with 100, Max Usation is still 100.
Open:

Select all

sqlplus / as sysdba 
shutdown immediate 
startup

With the changed init As I said.

If it is correct, Max Usation must be 200




: Sex, 21 Aug 2009 2:38 pm Subject:

---------------------------- -------------------------------------------------- -

The error is this

Select all

Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=blablabla.com.br)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=prd))) 

The select result was this below:

Select all

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE  
------------------------------ ---------------------- ---------------------- ------------------ -----------  
processes 90 100 100 100  
sessions 94 104 115 115

[pauloaleo]

Sorry, no and max usation, I copied the wrong column. It's Limit Value.

[LordElfo]

Hmm I'm looking here .. I think I'm changing the different init ...

Would this name be valid?
because there are several.

init.ora.512006184356

[LordElfo]

I did not find MAX_SHARED_SERVERS in this file.

[pauloaleo]

No, the init stays in the $ Oracle_Home / DBS

His name is initnomedainstance.ora

is always this.

or if it is spfile, has a spfilenomedainstance.ora

if it is spfile you go at the prompt of sqlplus and type

]

If you are Init, change the same file.

[LordElfo]

Oops face
really did not have or.ini

was the spfile

with this alter system command needs to restart ???

[pauloaleo]

Yes.

This parameter is startup.

[LordElfo]

I rebooted and increased ... but gave the same mistake this time I got to 103 connections ...
I'll try the same command but with processes to increase they too ... As soon as I can restart again I post here If it worked ..
vlw even help !!!

[pauloaleo]

Process, Sessions, etc., are boot parameters. So you change and do STOP / START on the bank.

[LordElfo]

Oops Paulo.
Thank you dear. It worked out here.
vlw =)

[melaniemrp]

It also helped me! 2014 and still works!
obg!