Re: Listener fails to start

>
> A couple of thoughts.
>
> 1. 9.2.0.1 is unconscionable. Personally I think running software in
> desupport offensive but even if you are forced to run Neolithic software
> there is no excuse for not applying patches: You are seven behind.
>
> 2. Drop and recreate the listener.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Hello Daniel,

(1)
I agree with the 9.2.0.1 - who ever wants that? If i could have a say in the situation, i would surely change it. I actually adviced it the first week i started here, but the reasons not to do it are many and all non-technical. And on 2 occasions i ran into bugs that were fixed in later patches. Care to join me in a little ' i-was-right' dance? :)

(ps i was hired here to install 10 on a new machine, so let's make the gap some smaller)

(2) ok i'll try to drop and recreate it - keep you informed.

Thanks for your help.

Frank,
the output is as follows:

[oracle_at_localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 27-OCT-2007 12:59:05

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /home/oracle/product/ora9i/bin/tnslsnr: please wait...

TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   Linux Error: 32: Broken pipe
[oracle_at_localhost ~]$

and the ip addr::

[root_at_localhost ~]# ip addr
1: lo: <LOOPBACK,UP> mtu 16436 qdisc noqueue

    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00     inet 127.0.0.1/8 scope host lo
    inet6 ::1/128 scope host

       valid_lft forever preferred_lft forever 2: eth0: <BROADCAST,MULTICAST,UP> mtu 1500 qdisc pfifo_fast qlen 1000

    link/ether 00:15:60:53:47:f5 brd ff:ff:ff:ff:ff:ff     inet 10.246.14.212/23 brd 10.246.15.255 scope global eth0     inet6 fe80::215:60ff:fe53:47f5/64 scope link

       valid_lft forever preferred_lft forever 3: eth1: <BROADCAST,MULTICAST> mtu 1500 qdisc noop qlen 1000

    link/ether 00:15:60:53:47:f4 brd ff:ff:ff:ff:ff:ff 4: sit0: <NOARP> mtu 1480 qdisc noop

    link/sit 0.0.0.0 brd 0.0.0.0
[root_at_localhost ~]#

status:

[oracle_at_localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 27-OCT-2007 13:04:40

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.246.14.212) (PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused Received on Sat Oct 27 2007 - 05:05:33 CDT