Re: SQL*NET V2

In article <726q84$rn0$1_at_hermes.is.co.za>,   "nick" <nick_at_NOSPAM.co.za> wrote:
> I am running SQL*NET v1 and v2 on AIX, I have no trouble connecting to the
> DB with V1 but V2 gives me the following ERROR:
>
> ERROR: ORA-12500: TNS:listener failed to start a dedicated server process
>
> Can anybody help.
>
> Regards
>
> Nick
>
>

We were getting this error after bringing a new database up under Oracle 7.3.4 on our HP. To get rid of it, we reduced the number of processes in the init.ora file from 100 to 50 for all our databases. It did not make much sense to me at the time, but it seemed to work. The error was cropping up from time to time and has now vanished.

I SPECULATE that the database instance reserves the number of processes in init.ora at startup, and that the listener does not use this reserved pool. If too many processes are reserved for the instance, there would be none left for the listener to get when someone trys to connect using sql*net. Prehaps someone else can clarify this? Also, does anyone know if the number of processes for a system is a parameter of the operating system kernal that can generally be set?

As a temporary measure, I was able to shut off some batch processes that came in though SQL*Net to allow more important processes to connect and complete.

Andrea Morris

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 09 1998 - 14:06:41 CST