HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Oracle 10.2.0.1.0 listener process stopped

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
stoppedprocessoraclelistener

Problem

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 ?

Solution

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?

Code Snippets

LSNRCTL> trace admin
LSNRCTL> save_config
LSNRCTL> start

Context

StackExchange Database Administrators Q#2057, answer score: 4

Revisions (0)

No revisions yet.