Re: ORA-12500: TNS:listener failed to start a dedicated server process

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 29 Aug 2005 09:31:14 +0200
Message-ID: <kbe5h1lmclnitf51pde9m4tsni4n3q4on6@4ax.com>

On 28 Aug 2005 23:22:04 -0700, "Brijesh" <brijeshmathew_at_gmail.com> wrote:

>Thanks Daniel for your reply.
>
>To get things rolling, I did reboot the server (as i could not connect
>to db as sys), and it did fix the problem, however, I wanted to know
>why this problem happened so that I can prevent this from happening in
>future.

Possibly likely causes for ora-12500
1 the listener is running but Oracle isn't 2 The number of connections exceeds the processes parameter in init.ora

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Aug 29 2005 - 02:31:14 CDT