Oracle/Windows question 2005-08-09 - By Sweetser, Joe
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
|
|
