Listener fails to start

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 Received on Fri Oct 26 2007 - 04:17:43 CDT