Oracle 10.2.0.1.0 listener process stopped

oracleoracle-10g

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 ?

Best Answer

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?

Related Question