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

To be more specific:
until 8:00 am users can't connect to the database, ORA-12500 error. after 8:00 am: no problem
I'm thinking about oracle profile or some side effect of a non-oracle tool scheduled somewhere on the network or server.

A friend told me he had this error on linux, it was a permission issue on binaries. I think this can't apply to my case, maybe yours.

David

David Guyon Martin a écrit:

> I also have this problem once, and it fixed itself after 1 or 2 hours! We
> really wonder what happened...
>
> The user has a NT 4.0 with a client using 16bit sql*net reading config
> files in c:\orawin\network\admin.
> Same error message as you.
> I tried with my NT 4.0 and 32bit sql*net, the connection was ok.
> Unix database server: no one connected on the instance but me.
>
> I'd like to have an answer too ( if I found one I'll send it to you ).
> (please remove .nospam.please from my email to answer)
>
> David
>
> Kerri Leonard a écrit:
>
> > Hi,
> >
> > When users connect to the Oracle Database Server through Windows 3.1,
> >
> > they are getting the following error messages:
> >
> > ORA-12500 TNS: listener failed to start a dedicated server process
> >
> > ORA-01203 TNS, Unable to Connect to Destination
> >
> > ORA-12223 TNS: Internal limit restriction exceeded
> >
> > We are also receiving similiar error messages when trying to print,
> >
> > logging on to TNVT and in our SQLNET.log file.
> >
> > The number of processes in the init.ora have been increased. There is
> >
> > appoximately 80 concurrent users logged on when this error message
> >
> > occurs. Oracle 7.3 is installed on a Unix server version 5.
> >
> > We need to have approximately 300 concurrent users processes.
> >
> > Any suggestions to correct this problem?
> >
> > Thanks,
> >
> > Kerri
> >
> > -**** Posted from RemarQ, http://www.remarq.com/?b ****-
> > Real Discussions for Real People
Received on Fri Apr 23 1999 - 01:54:24 CDT