Ini Kebetulan saya ada info dr Metalink :
Problem Description
-------------------
You are receiving an ora TNS-12540 error intermitently
when trying to make connections to the database. OPS
and MTS are not being used in this configuration.
The error might be:
TNS-12540: TNS:internal limit restriction exceeded
The alert log has an entry that looks like:
skgpspawn failed category 27143
The skgpspawn failed message refers to a failure to spawn
a new session.
Solution Description
--------------------
Performance monitor shows that the instance that that has
the TNS-12540 error occurring is using right around 2gb of
memory. The SGA for the instance is about 1.8gb of memory.
Reconfiguring the SGA to take less memory allows for connections
to be made sucessfully.
The most significant init.ora settings that are a candidate to
to reduce the size of the SGA are:
db_block_buffers
shared_pool_size
java_pool_size
sort_area_size
sort_area_retained_size
Explanation
-----------
Because non Enterprise Windows NT Server limits the amount of memory
used per process to 2gb, the process for the instance could not
allocate more memory for new connections.
References
----------
A Microsoft document that explains what is termed 4GT RAM Tuning can
be found at:
http://support.microsoft.com/support/kb/articles/Q171/7/93.ASP
Ini Biasa nya karena memory Exhausted karena dedicated connectionnya.
Semoga Membantu :)
CMIIW
Andrew E.K.
lospubro <[EMAIL PROTECTED]> wrote: Dear all,
Saya ada setting koneksi dari oracle ke MS SQL, melalui database link.
setelah user bertambah dan memaikai koneksi tersebut muncul error :
TNS-12540 TNS:internal limit restriction exceeded
Cause: Too many TNS connections open simultaneously.
Action: Wait for connections to close and retry.
Asumsi saya adalah karena terlalu bayak user yang konek dari oracle ke
MS SQL. Apakah rekan-rekan ada yang bisa bantu, bagaimana menentukan
banyaknya open connection yang diperbolehkan dari oracle ke MS SQL
melalui TNS?
Thanks,
LP
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
SPONSORED LINKS
Membership database
software Database mortgage software
Pda database software
Database management
software Oracle database
administration Oracle database
management
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indo-oracle" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! DSL Something to write home about. Just $16.99/mo. or less
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
