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. 3 14144 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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
by: Aad Aldus |
last post by:
How can I enable the trace functionality for the TNS listener on the server
of the client.
Aad.
|
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 database so I tried testdb.localhost, but this didn't
|
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)
|
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
| |
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
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32
errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*
pOpoSqlValCtx, Object src,...
|
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 connect to the oracle server with its local account and this is being rejected from the database?
...
|
by: vedapriya |
last post by:
what do u mean by SID and TNS names.ORA in oracle.
|
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
|
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 could not resolve SERVICE_NAME given in connect descriptor. but on the file tnsnames.ora :
KANKYO =
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |