ORA-12541 TNS :no listener

ORA-12541 TNS :no listener

Error:

The OracleOraDb11g_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=david-vaio)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

  32-bit Windows Error: 61: Unknown error

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))

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

Solution:

Delete existing Listener using 'netca' command and re-create the Listener.

Then follow below steps:-

SQL> show parameter local_listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      

SQL> alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=DAVID-VAIO)(PORT=1521))';

System altered.

SQL> alter system register;
System altered.

Restart the Listener.

Then check the status the Listener is Registered or not ?

SQL> show parameter local_listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      (ADDRESS = (PROTOCOL = TCP)(HO

                                                                 ST = DAVID-VAIO)(PORT = 1521))

Issue is fixed.