| ora-12500 [message #277102] |
Sun, 28 October 2007 22:39  |
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  |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
