473,574 Members | 2,230 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

The dreaded TNS-12500 error.

Hi Oracle experts,

We are getting this error on our Oracle system. I've searched Google,
MSDN, Oracle tech support and newsgroups to death, but our DBAs seem
to have already applied all the solutions suggested. Here's the
relevant part from the Listener log:

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error

Oracle is running on Windows 2000 - dual processor machine with
several gigs of RAM. The base error seems to be a Windows error 8 -
"not enough storage is available to complete this operation" - if I'm
reading the log correctly. Here are some facts:

- the error occurs when the DB is under heavy load, and at that point
is intermittent - some connection requests get rejected, whether they
come from SQLPlus or from the rich VB client over ODBC, but others are
honored.
- the server has plenty of spare RAM even when connections are being
refused.
- the server CPUs are at around 50% utilization when the problem
happens.
- we have already increased the PROCESSES parameter in the ini file to
way more than we need (I think it's currently at 700 and we only have
a couple hundred connections according to Spotlight - in any case we
are nowhere near the max connections)
- we used the 3GB process patch for Windows 2000 to make sure the
Oracle process has enough memory.
- we have reduced the "SGA" size as mentioned in several articles
- nothing is logged in the Oracle Alerts
- nothing is logged in any of the Windows 2000 Event Logs
- the Listener responds fine to tnsping (albeit with somewhat
increased ping times)

The only thing I can think is that the Listener is using some Windows
OS kernel object to communicate with the Oracle process (Semaphores
probably?) and there is some system-wide limit on whatever those
objects are, which the Listener is somehow exceeding.

Oracle technical support of course blames it on the O/S - "Oracle
consumes O/S resources just like any other app."

We are going to reengineer the app to use connections more
efficiently, but for now we need to put this fire out.

Any help much appreciated!

-Darren.
Jul 19 '05 #1
3 14127
da********@hotm ail.com (Darren) wrote in message news:<35******* *************** ***@posting.goo gle.com>...
Hi Oracle experts,

We are getting this error on our Oracle system. I've searched Google,
MSDN, Oracle tech support and newsgroups to death, but our DBAs seem
to have already applied all the solutions suggested. Here's the
relevant part from the Listener log:

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error

Oracle is running on Windows 2000 - dual processor machine with
several gigs of RAM. The base error seems to be a Windows error 8 -
"not enough storage is available to complete this operation" - if I'm
reading the log correctly. Here are some facts:

- the error occurs when the DB is under heavy load, and at that point
is intermittent - some connection requests get rejected, whether they
come from SQLPlus or from the rich VB client over ODBC, but others are
honored.
- the server has plenty of spare RAM even when connections are being
refused.
- the server CPUs are at around 50% utilization when the problem
happens.
- we have already increased the PROCESSES parameter in the ini file to
way more than we need (I think it's currently at 700 and we only have
a couple hundred connections according to Spotlight - in any case we
are nowhere near the max connections)
- we used the 3GB process patch for Windows 2000 to make sure the
Oracle process has enough memory.
- we have reduced the "SGA" size as mentioned in several articles
- nothing is logged in the Oracle Alerts
- nothing is logged in any of the Windows 2000 Event Logs
- the Listener responds fine to tnsping (albeit with somewhat
increased ping times)

The only thing I can think is that the Listener is using some Windows
OS kernel object to communicate with the Oracle process (Semaphores
probably?) and there is some system-wide limit on whatever those
objects are, which the Listener is somehow exceeding.

Oracle technical support of course blames it on the O/S - "Oracle
consumes O/S resources just like any other app."

We are going to reengineer the app to use connections more
efficiently, but for now we need to put this fire out.

Any help much appreciated!

-Darren.

Oracle is implemented on NT as a multithreaded application.
Each connection (assuming you are not running MTS) will use a thread.
There is a fixed limit of threads per processes.
So -whether you like it or not- OTS is correct.

You could do either one of two things
- configure Oracle to use MTS
- switch to a real operating system. You will never ever be capable to
manage 700 active connections on any Winblows O/S

Regads

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

Had the same problem. In our case the oracle.exe process was crossing
3GB boundry. Try this, monitor the Virtual Bytes of your application
with PERFMON. Watch the VB count rise as users log in. You may see
that as you cross the 3GB Virtual Bytes boundry that you get this
error. If that is the case then your user count (~2.7MB/user) is slowly
driving you over the max process size that Win2K allows with the /3GB
boot.ini switch enabled. If that is the case recommend a) switching to
MTS and b) resizing your SGA such that it fits completely with in the
3GB boundry.
--
Posted via http://dbforums.com
Jul 19 '05 #3

Hello,

I would to know how to modify the MTS because I'm getting error 12540.

Thank you in advance
--
Posted via http://dbforums.com
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
15613
by: John | last post by:
Hi Right password -> ORA-12154: TNS:Could not resolve service name wrong password => ORA-01017: invalid username/password; logon denied Tested on a Windows XP client connecting to Oracle on an AIX server. Using toad and sqlplusw Everything working fin connecting to other 8.1.7 Oracle servers on windows
0
5682
by: Aad Aldus | last post by:
How can I enable the trace functionality for the TNS listener on the server of the client. Aad.
5
13419
by: Axel Dachtler | last post by:
Hi, I have a listener problem. The listener cannot read SERVICE_NAME in TNS-Descriptor. The service-name I specified in Oracle Net Manager for this database is testdb as well. (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=axel-0560nntbn1) (PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb))) It is a local...
4
10553
by: Axel Dachtler | last post by:
Hello, I am little bit confuseed about the meaning of TNS (Transparent Network Substrate). I know what it does: It enables Applications to communicate with different network protocols. But I don't know exactly what it is! What is it: - Oracle's networking architecture (or the core technology of it)
2
27531
by: hazz | last post by:
if I can ask that in this newsgroup? <input message="tns:addRestaurantIn"/> what is the tns used for here in this wsdl? Thank you thank you.. -hazz
5
17097
by: jstmehr4u3 | last post by:
I just installed ODP.net 10.2.02 on my local machine (Windows XP Pro) running IIS. I have created a sample webservice in VS2003, connecting to localhost. I am getting: Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified at...
1
2353
by: Woolli | last post by:
Hello, Ive written an asp.net application which is to run on an intranet. The application is working fine on my locan maschine, but Im getting a tns timeout when runnng it on the webserver. when I logonto the webserver I can send a secsesful tnsping to the oracle database. Could it be that Im geting the timeout because the webserver trys to...
9
68604
by: vedapriya | last post by:
what do u mean by SID and TNS names.ORA in oracle.
5
17016
by: Nitvar | last post by:
When i am trying to connect to oracle it is giving me these two errors ORA-12224: TNS:no listener ORA-01034: ORACLE not available I am new to oracle ,plz help I am using solaris 5.6 and oracle 8.0.5 version I am posting my listener.ora and Tnsname
1
2146
by: bacterium | last post by:
Hi, Is there any way to solve the question :'ORA-12154: TNS:could not resolve service name' ,I import database in Oracle , but I can not logon into the database , while login through the SQL PLUS, it notes 'ORA-12154: TNS:could not resolve service name', I configured at net8s configure assistant , at the end it notes : ORA-12514: TNS:listener...
0
7720
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8044
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8230
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8096
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5618
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5299
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1056
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.