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 !!!
How to increase the number of connections to the database
-
- Rank: DBA Júnior
- Posts: 181
- Joined: Wed, 09 Feb 2005 12:30 pm
- Location: SÃO BERNARDO DO CAMPO - SP
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
If this is, change this parameter to greater than 100. You view the amount of open sessions, typing at the SQLPlus prompt
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 !!!
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 !!!
We tested here by increasing sessions for 200 and processes for 175 by restarting Oracle Instance Service and OracleOradB10G_Home1tnSlistener
but kept the problem = (
but kept the problem = (
The error is this
The select result was this below:
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)))
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
-
- Rank: DBA Júnior
- Posts: 181
- Joined: Wed, 09 Feb 2005 12:30 pm
- Location: SÃO BERNARDO DO CAMPO - SP
In the V $ Resource_Limit Your parameter is still still with 100, Max Usation is still 100.
Open:
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
The select result was this below:
Open:
sqlplus / as sysdba
shutdown immediate
startup
If it is correct, Max Usation must be 200
: Sex, 21 Aug 2009 2:38 pm Subject:
---------------------------- -------------------------------------------------- -
The error is this
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)))
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ---------------------- ---------------------- ------------------ -----------
processes 90 100 100 100
sessions 94 104 115 115
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
Would this name be valid?
because there are several.
init.ora.512006184356
I did not find MAX_SHARED_SERVERS in this file.
-
- Rank: DBA Júnior
- Posts: 181
- Joined: Wed, 09 Feb 2005 12:30 pm
- Location: SÃO BERNARDO DO CAMPO - SP
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.
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.
Oops face
really did not have or.ini
was the spfile
with this alter system command needs to restart ???
really did not have or.ini
was the spfile
with this alter system command needs to restart ???
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 !!!
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 !!!
Oops Paulo.
Thank you dear. It worked out here.
vlw =)
Thank you dear. It worked out here.
vlw =)
-
- Rank: Estagiário Júnior
- Posts: 1
- Joined: Thu, 03 Apr 2014 12:14 pm
It also helped me! 2014 and still works!
obg!
obg!
-
- Information
-
Who is online
Users browsing this forum: No registered users and 8 guests