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

In article <32F87583.7E1E_at_web-data.fr>, Pierre says...
>
>Hello
>
>I have a problem with Windows 95 Dev2000 client and Oracle 7.2.3
>on Sun Solaris 2.4 with SQL*Net v2.
>
>I don't know what TCP/IP adapters i have to choose. I try a lot.
>I use Net Chameleon, MS Windozs for Worgroups ...
>Maybe i miss something.
>
>The error is:
>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 maybe 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. If error persists, contact Worldwide
>Customer
>// Support.
>
>I did that, and here is the trace:
>
>
>opening transport...
>waiting to accept a connection.
>valid node check on incoming node 194.167.231.15
>Accepted Entry: 194.167.231.15
>transport is open
>global context check-in (to slot 4) complete
>doing connect handshake...
>234 bytes from transport
>got NSPTCN packet
>command = establish
>connecting...
>detaching from parent with additional fork
>About to exec oracle:
> environ[0] = "ORACLE_HOME=/home/hotcisi/oracle/product/7.2.3"
> environ[1] = "PATH=/home/hotcisi/oracle/product/7.2.3/bin/"
> environ[2] = "TZ=WET"
> environ[3] = "ORACLE_SID=ATHESA"
> environ[4] = "HOME=/home/hotcisi/oracle"
>result string is NTP0 557
>added pid 557
>hdl[IR]=15, hdl[IW]=14
>NT layer IPC connection has been established.
>doing connect handshake...
>NSE=12538
>-<ERROR>- nsres: id=4, op=72, ns=12538, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0
>sending NSPTRF packet
>130 bytes to transport
>no timer allocated
>closing transport
>global context check-out (from slot 4) complete
>Deallocating cxd 0x196348.
>
>Thanks in advance
>
>Pierre Didierjean

Hello Pierre,
I experienced the same problem on an Oracle 7.3, AIX 4.1.4 box. I'm not sure in your enviroment to check, but in Unix the problem was that the user Oracle (who owns all of those dedicated processes) had a limit of only 40 processes. As soon as I went into SMIT and raised this number of processes this problem was resolved.
Hope that helps...
Carl Christianson Received on Thu Feb 06 1997 - 00:00:00 CET