Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle/Windows question

Oracle/Windows question

From: Sweetser, Joe <Joe.Sweetser_at_i-structure.com>
Date: Tue, 9 Aug 2005 10:48:06 -0700
Message-ID: <8FB2C86BB1EB01498A59A762F6CD556F0243A66F@MAPI.iconnection.com>


Oracle 9.2.0.4.0
Windows 2000 SP4
3gb memory

The database is about 100gb. I seem to be having a problem with system resources that is causing new connections to the database to not happen during peak times. Last time this occurred, I increased the processes parameter (from 300 to 400) and this alleviated the problem at the time. But now it happened again. I just restarted the database and all is well for the time being, but I want to figure out what's happening.

There are no errors in the alert log. The listener.log shows repeated entries similar to this (I substituted actual names with <>'s):

09-AUG-2005 11:06:56 * (CONNECT_DATA=
(SERVICE_NAME=<TNS service name>)
(CID=(PROGRAM=C:\Temp\<xxxxxx>\1df\PCXWIN.EXE)
(HOST=<source-hostname>)(USER=<username>)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=<IP address>)(PORT=2948)) * establish * <TNS service name> * 12500 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

Metalink research for the TNS 510 error (Note:171636.1) indicates there is a system resource issue. My problem is that I'm pretty green on Windows ("unix weenie, am I" -Yoda) and don't know where to look to see what's being used up. Task manager doesn't show any constraints with memory or CPU.

Any/all suggestions/hints/ideas are welcome.

Thanks,
-joe

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 09 2005 - 12:50:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US