Saturday, February 4, 2012

lsnrctl hung . Unable to start or check on status.

./pcmScheduler|10411|01/25/12 15:24:24|       Raw data: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data:
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data:
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data:       FROM pcm_schedule
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data:            *
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data: ERROR at line 2:
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data:
./pcmScheduler|10411|01/25/12 15:24:24|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:24|       Raw data:
./pcmScheduler|10411|01/25/12 15:24:25|     Error With Sql Return
./pcmScheduler|10411|01/25/12 15:24:25|       Raw data:       FROM pcm_schedule


acshc:ccuser[live]/u/ccuser 104> lsnrctl status

LSNRCTL for HPUX: Version 10.1.0.5.0 - Production on 25-JAN-2012 15:16:32

Copyright (c) 1991, 2004, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

...hang indefinitely right here ... It turns out, 2 listeners of the same name were running. Not sure how that's possible but it does. Killed both and restarted the lsnrctl .. everything worked fine.