Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I couldn't start oracle, I check services, listener was not started, I try start get error:

The OracleOraDb10g_home1TNSListener service on Local Computer and then stopped. 
Some services stop automaticlly if they have no work to do,for example, the Performance Logs and Alerts sercice

I check listener status. This is what I get:

SQL> $ lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-SEP-2012 13:10
 :31

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
 TNS-12541: TNS:no listener
   TNS-12560: TNS:protocol adapter error
     TNS-00511: No listener
 32-bit Windows Error: 2: No such file or directory
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bobs-d84c5aae0f)(PORT=15
 21)))
 TNS-01189: The listener could not authenticate the user

I try start listener from sqlplus -

 SQL> $ lsnrctl start

 LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-SEP-2012 13:17
 :41

 Copyright (c) 1991, 2005, Oracle.  All rights reserved.

  TNS-01106: Listener using listener name LISTENER has already been started

How to fix this?

share|improve this question

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.