Oracle 10.2.0.1.0 listener process stopped

Question

When I am checking my servers I see that there is an error about listener process stopped. I logged in and checked the status of listenere. please see the below status;

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
TNS-12541: TNS:no listener    
  TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
      Solaris Error: 146: Connection refused
        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
          TNS-12541: TNS:no listener
            TNS-12560: TNS:protocol adapter error
              TNS-00511: No listener
                Solaris Error: 2: No such file or directory>

I am thinking of just running the start command but my concern is why is this issue arised ?

Answer 1

There is probably not enough logged at the default level to give you any real insight to root cause, so the best thing to do is restart the listener at a higher logging level. Enter

LSNRCTL> trace admin
LSNRCTL> save_config
LSNRCTL> start

Then if it crashes again, you'll know why. You can also set the variables trc_directory, trc_file and trc_level to customize this behavior.

Also your HOST=0.0.0.0 looks odd to me... Shouldn't that be the IP address of your host? What do you have in LISTENER.ORA?