Re: Error code ORA-12500

Paul Baumgartel (paulb_at_pcnet.com) wrote:
: leng_at_cougar.vut.edu.au (Leng Kaing) wrote:
 

: >: When I connect to database, I received the following errors:
: >: ora-12500:TNS:listener failed to start a dedicated server process
: >: It has been happening very frequently. What are the ways to remedy it?
 

: [snip]
 

: >I'd like to know as well. Even after immediately bouncing the
: >listener I get this error. But it's not consistent. Sometimes it shows
: >up, at other times it doesn't. Oracle Support seems to think that it's
: >an o/s problem, eg: lacking in some kind of resource. could
: >happen any day now...
 

: [snip]
 

: I've experience the same problem on VMS systems. When a VMS system is heavily
: loaded, process creation can be very slow; if it takes too long, the listener
: times out and returns this error.
 

: Possible solutions:
 

: 1. Use multi-threaded server. Then no dedicated server processes need be
: spawned on connection.
: 2. Specify pre-spawned shadow processes in LISTENER.ORA. (N.B.: in order
: to get pre-spawned shadows to work on VMS, Oracle 7.1.5, you need to get a
: patch from Oracle Support).

: ********************************************************************
: Paul Baumgartel, Principal Consultant paulb_at_pcnet.com
: Adept Computer Associates, Inc.
: ********************************************************************

The solution around my problem was to increase the number of Maximum Declared Objects to 300. Problem hasn't surfaced again.

Leng.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344