Home » Infrastructure » Windows » ora-12500
ora-12500 [message #277102] Sun, 28 October 2007 22:39 Go to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
Help me.
My problem that is resulting in ora-12500's is many, many connections being fired at one time. Informatica fires in the neighborhood of 200 connections all at the same time, the exact same second.

Windows 2003 Datacenter Edition x86
Memory 16 GB
Oracle 9.2.0.1

shared pool - 400mb
buffer cache - 768mb
java pool - 72mb
large pool 16mb
PGA - 1024mb
process - 1000
sessions - 1200
work_area_size - AUTO
Re: ora-12500 [message #277103 is a reply to message #277102] Sun, 28 October 2007 22:50 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
12500, 00000, "TNS:listener failed to start a dedicated server process"
// *Cause:  The process of starting up a dedicated server process failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the operation.
// Verify that the ORACLE Server executable is present and has execute
// permissions enabled. Ensure that the ORACLE environment is specified
// correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being 
// called may not be installed on the local hard drive.  Please check that
// the correct Protocol Adapter are successfully linked.
// If error persists, contact Oracle Customer Support.

[Updated on: Mon, 29 October 2007 02:06] by Moderator

Report message to a moderator

Previous Topic: from disk to tape under windows OS
Next Topic: how to write AWE_WINDOW_MEMORY
Goto Forum:
  


Current Time: Thu Dec 12 23:18:16 CST 2024