Listener problem

Listener problem

Post by Jovan Sara » Sat, 01 May 1999 04:00:00



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:

Quote:>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 :

Quote:> 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:


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

 
 
 

Listener problem

Post by Pete Sharma » Sat, 01 May 1999 04:00:00


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


> 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:


> 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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  psharman.vcf
< 1K Download

 
 
 

1. lsnrctl problem , listener problem

Hi,
I'm having problem with the listener on Solaris 2.6 . Compared the
tnsname.ora,listener.ora on the server A with a different server B that
works and they seem to be ok.
If I run lsnrctl on the  server B I get the status etc for the listener.

With the server A the message below is what I get and I can't find any help
on this. What message file is the error mess refering to?

I am trying to connect from a remote workstation using the Oracle for NT
products. This works with the server B, no problem running SQL Worksheet
(NT) with the UNIX based database.

Any suggestions?

Thank you very plenty!!

/Jerra

LSNRCTL> services listener
Message 1053 not found; No message file for product=NETWORK,
facility=TNSMessage 1029 not found; No message file for product=NETWORK,
facility=TNS  Message 1039 not found; No message file for product=NETWORK,
facility=TNS
    Message 1036 not found; No message file for product=NETWORK,
facility=TNS
      Message 1050 not found; No message file for product=NETWORK,
facility=TNS
  Message 1039 not found; No message file for product=NETWORK, facility=TNS
    Message 1036 not found; No message file for product=NETWORK,
facility=TNS
      Message 1050 not found; No message file for product=NETWORK,
facility=TNS
Message 1052 not found; No message file for product=NETWORK,
facility=TNSLSNRCTL>

2. error 177 ??? with ak dostats

3. Problem to connect to Oracle 8.1.5 - Listener Problem

4. ~Converting application to applet, Pls Help!!

5. OLEDB Simple Provider Listener Problem

6. executing a DTS package on client

7. Oracle 8.1.7 Listener problem

8. For XML Auto

9. Listener Problem

10. Listener problem

11. Oracle listener problem

12. 8i Listener Problem