RE: ora-12500 on windows
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <mark.powell@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Feb 2004 09:18:59 -0500
I figure it is an OS limit but what... This is W2K. Looks like process size
has not reached 2 G, overall memory has not reached max.
>>> mark.powell@xxxxxxx 2/18/04 9:12:50 AM >>>
Jeff, just some possibilities to consider
What is your OS limit? Oracle may have returned an error because the OS was
unable to create a process for Oracle? Another possibility is the OS user
limit for Oracle may have been reached. It should be unlimited, but I have
seen Oracle set up with too low ulimit values (on UNIX systems).
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeffrey Beckstrom
Sent: Wednesday, February 18, 2004 8:12 AM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
oracledba@xxxxxxxxxxx; oracle-databases@xxxxxxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
Subject: ora-12500 on windows
Users receiving "unable to launch a dedicated server process. ora-12500 in
an Oracle Apps 11i database. Processes were 298 with processes in init.ora
of 400. Stopped apache and restarted it and processes decreased. Now connect
with no problem. Why are we getting the error when have not reached max
processes. Is there a listener limit of some sort.
oracle.exe process was 1.4 G per task manager - well under the 2 G
limit.
Swap space is set to max of 4 G
commit charge peak is 2.4 G
commit charge limit is 5.8 G
We should be well under the limits
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
