Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ?

share|improve this question
add comment

1 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?

share|improve this answer
    
thanks for your comments Gaius; I checked the oracle instance on my both server. and see that the problemmatic server has nothing working belongs the oracle user. ps -ef returns nothing related with oracle user. in this case it seems oracle instance has stopped. –  Olgun Kaya Apr 5 '11 at 5:55
    
would it be enough for me to use >startup commmand or do I need to use something else ? –  Olgun Kaya Apr 5 '11 at 6:06
    
You mean to restart Oracle? Yes startup in SQL*Plus will do it. If once started you do show parameter background_dump_dest and look in that directory there will be an alert log file that should give you a clue as to why it stopped. –  Gaius Apr 5 '11 at 10:17
    
I tried to startup the server but couldn't make it get working. I checked the alarm in bdomp directory and find the error below : Tue Apr 5 10:36:24 2011 ALTER DATABASE MOUNT Tue Apr 5 10:36:26 2011 ORA-00202: control file: '/ldap/oracle/oradata/mtv/control01.ctl' ORA-27086: unable to lock file - already in use SVR4 Error: 11: Resource temporarily unavailable Additional information: 8 Additional information: 22464.. I think an invisible process preventing me from starting the server. I will restart the server ( not oracle )and try to start the db instance again. wish me luck :) –  Olgun Kaya Apr 5 '11 at 11:46
    
Is that a local disk or is it NFS? There may still be a lock hanging around on the storage device. –  Gaius Apr 5 '11 at 12:15
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.