Re: help! trouble configuring Listener on linux

From: Adrian Hands <AHands_at_sprynet.com>
Date: Fri, 04 Dec 1998 21:34:32 -0500
Message-ID: <36689BB8.C426E848@sprynet.com>

I don't think it's a listener problem, because you're not getting "ORA-12224: TNS:no listener".
(The error message you are getting is what you would get with tnslnr running, but the db shutdown.)
but just to check:

Use the unix tcp/ip command "netstat" to make SURE tnslistner is really running and is on the port where it should be:

$ netstat -tan | grep ':1526'

tcp        0      0 0.0.0.0:1526            0.0.0.0:*              
LISTEN      

$

Also, try Oracle's "tnsping":

$ tnsping localhost

TNS Ping Utility for Linux: Version 8.0.5.0.0 - Production on 04-DEC-98 20:47:04

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1526)) OK (50 msec)
$

What are your $ORACLE_SID and $TWO_TASK set to ? tcp-loopback.world ? or MCNT1 ? or

Use lsnrctl to check the status of the listener:

$ lsnrctl

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 04-DEC-98 20:49:42

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=india)(PORT=1521)) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 -
Production
Start Date                01-DEC-98 18:55:35
Uptime                    3 days 1 hr. 54 min. 18 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u04/orahome/network/admin/listener.ora
Listener Log File         /u04/orahome/network/log/listener.log
Services Summary...
  alpha		has 1 service handler(s)

The command completed successfully
LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=india)(PORT=1521)) Services Summary...
  alpha has 1 service handler(s)
    DEDICATED SERVER established:16 refused:0       LOCAL SERVER
The command completed successfully
LSNRCTL> exit
$

Matthias Suencksen wrote:
>
> Oracle keeps saying: ORA-1034 Oracle not available
> when I connect via user/pass_at_tcp-loopback.world
>
> The database IS running and I can connect via user/pass :
>
> 1920 ? S 0:00 ora_pmon_MCNT1
> 1922 ? S 0:00 ora_dbw0_MCNT1
> 1924 ? S 0:00 ora_lgwr_MCNT1
> 1926 ? S 0:00 ora_ckpt_MCNT1
> 1928 ? S 0:00 ora_smon_MCNT1
> 1930 ? S 0:00 ora_reco_MCNT1
> 3518 ? S 0:00 /opt/oracle8/app/oracle/product/8.0.5//bin/tnslsnr
>
> The tnslistener is running. here is the config:
>
> nostromo_lsnr=
> (
> ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=127.0.0.1)
> (PORT=1526)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY=MCNT1)
> )
> )
>
> SID_LIST_nostromo_lsnr=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=MCNT1)
> (ORACLE_HOME=/disk4/oracle/oracle8/app/oracle/product/8.0.5)
> )
> )
>
> and tnsnames.ora:
>
>
> Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID=MCNT1)
> )
> )
>
> What I am doing wrong ??
>
> Matthias
>
> --
> Out-of-order Execution
> (Feature von modernen Microprozessoren)
Received on Fri Dec 04 1998 - 20:34:32 CST