Helma wrote:
> Hello everybody,
>
> I've got a problem with starting the listener after a reboot. The
> machine is a Linux RedHat , Oracle 9.2.0.1 .
>
> After a reboot i get:
>
> [oracle_at_localhost ~]$ lsnrctl status
>
> LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 26-OCT-2007
> 11:32:33
>
> 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
>
>
> a startup gives the additional linux error BROKEN PIPE.
> I've seen these messages before, they had to do with the listener
> logifle, if this file exceeds 2GB, the listener will break.
> I therefore switched off the logfile, so that's not the case here. Has
> anyone seen this error before?
>
> Also, i added some new harddrives to the computer, because one logical
> drive started to behave strange - i got out of space errors, although
> none of the files were on autoextend. Shrinking a file on the troubled
> partition didn't return the space as seen on a df -h .
> After install of extra drives, i rebooted, and saw that the df -h now
> showed correctly the space on the troubled partition.
> So i thought i was close to the solution, until this listener error
> kicked in. Any pointers?
>
> TIA,
> Helma
A couple of thoughts.
- 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.
- Drop and recreate the listener.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Oct 26 2007 - 16:00:58 CDT
