Re: Problem with SQL*NET V2.1 on HP UX 10.20

In article <eBeDqYHv9GA.238_at_ntdwwaaw.compuserve.com>,   "-" <jrh_at_dorotech.fr> wrote:
> We have install SQL*NET V2.1 (using TCP/IP) on a HP server UX 10.20 with
> Oracle 7.1.
> The *;ora files are correct.
> The service is running
>
> We have the following error :
> 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.
>
> The trace file listener.trc is :
> 1 newly-posted event(s)
> event is 0x1, on 1
> 1 posted event(s)
> opening transport...
> waiting to accept a connection.
> valid node check on incoming node 172.29.50.197
> Accepted Entry: 172.29.50.197
> transport is open
> global context check-in (to slot 0) complete
> doing connect handshake...
> 179 bytes from transport
> got NSPTCN packet
> command = establish
> connecting...
> detaching from parent with additional fork
> About to exec oracle:
> environ[0] = "ORACLE_HOME=/home/baloo/oracle"
> environ[1] = "PATH=/home/baloo/oracle/bin/"
> environ[2] = "TZ=MET-1METDST"
> environ[3] = "ORACLE_SID=miraje2"
> environ[4] = "NLS_LANG=american_america.we8iso8859p1"
> environ[5] = "HOME=/home/baloo/oracle"
> result string is NTP0 7554
> added pid 7554
> hdl[IR]=13, hdl[IW]=12
> NT layer IPC connection has been established.
> doing connect handshake...
> NSE=12538
> -<ERROR>- nsres: id=0, 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 0) complete
> Deallocating cxd 0x400357b8.
> 0 pre-posted event(s)
> waiting for transport event (1 thru 1)...
> 1 newly-posted event(s)
> event is 0x1, on 1
> 1 posted event(s)
> opening transport...
> waiting to accept a connection.
>
> Think for your help
> --
> Olivier GICQUEL
> olivier.gicquel_at_dorotech.fr
>
>

I suppose ytou have already looked at the documentation ??

One thing I can think of which is not really clear from the documentation - is that the problem might be due to the fact that the listener tries to create a new UNix process - and that the maximum number of processes has been attained. In that case it suffices to increase the number of maximum processes for the operating system i.e. HP UX. Now I don't know how to do that on HP UX - but we had exactly this problem on AIX and we could just increase the parameter online.

HTH --
Oliver Willandsen
European Commission
http://europa.eu.int
All remarks are my own and do not necessarily reflect official European Commission policy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 31 1998 - 09:45:17 CDT