Listener problem

From: Jovan Sarai <jsarai_at_tpg.au.com>
Date: Fri, 30 Apr 1999 15:44:56 +1000
Message-ID: <6rbW2.98$kx2.1174@nswpull.telstra.net>

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

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 Received on Fri Apr 30 1999 - 00:44:56 CDT