Re: Listener problem

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 30 Apr 1999 08:47:05 -0700
Message-ID: <3729D079.B7CC2CE3@us.oracle.com>

Jovan

Error: ORA 12500
Text: 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've also seen this when the server was so overloaded it couldn't start another process (unusual, but it does happen). Try turning trace on and see what happens.

HTH. Pete

Jovan Sarai wrote:

> Hello everyone,
> I have a problem to remotely connect to installation of Oracle 8.0.5 on Red
> Hat Linux.
>
> Listener has been started with status report:
>
> >lsnrctl start
>
> TNSLSNR for Linux: Version 8.0.5.0.0 - Production
> System parameter file is
> /home/oracle/product/8.0.5/network/admin/listener.ora
> Log messages written to /home/oracle/product/8.0.5/network/log/listener.log
> Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=203.12.160.34)(PORT=1521))
> Connecting to (ADDRESS=(PROTOCOL=TCP)(KEY=dvlp)(HOST=rand.tpg.com.au)
> PORT=1521))
>
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 8.0.5.0.0 - Production
> Start Date 30-APR-99 15:41:22
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /home/oracle/product/8.0.5/network/admin/listener.ora
> Listener Log File
> /home/oracle/product/8.0.5/network/log/listener.log
> Services Summary...
> dvlp has 1 service handler(s)
> The command completed successfully
>
> And also works the following :
>
> > tnsping dvlp
>
> NS Ping Utility for Linux: Version 8.0.5.0.0 - Production on 30-APR-99
> 15:43:55
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact
> (ADDRESS=(COMMUNITY=world)(PROTOCOL=tcp)(HOST=rand.tpg.com.au)(PORT=1521))
> OK (10 msec)
>
> But when I try to connect remotely with:
>
> sqlplus scott/tiger_at_dvlp
>
> ERROR:
> ORA-12500: TNS:listener failed to start a dedicated server process
>
> In tnsnames.ora I have a service called DVLP (as the Oracle sid as well):
>
> DVLP = (DESCRIPTION =
> (ADDRESS=
> (COMMUNITY=world)
> (PROTOCOL=tcp)
> (HOST=rand.tpg.com.au)
> (PORT=1521)
> )
> (CONNECT_DATA=
> (SID=dvlp)
> (GLOBAL_NAME=dvlp.tpg.com.au)
> )
> )
>
> Same error has been reported when I try to connect from NT client or either
> locally.
> What else can be wrong?
>
> Thanks
> Jovan Sarai

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Fri Apr 30 1999 - 10:47:05 CDT