Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle/Windows question
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-lReceived on Tue Aug 09 2005 - 12:50:19 CDT
![]() |
![]() |