patternMinor
Oracle 10.2.0.1.0 listener process stopped
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;
I am thinking of just running the
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
Then if it crashes again, you'll know why. You can also set the variables
Also your
LSNRCTL> trace admin
LSNRCTL> save_config
LSNRCTL> startThen 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> startContext
StackExchange Database Administrators Q#2057, answer score: 4
Revisions (0)
No revisions yet.