2 Replies Latest reply on Jan 4, 2014 5:04 PM by rp0428

    Hi all, I can't use Oracle's SQL developer due to 12505 error. can you please help me.

    a002a872-2f4c-49cc-a2ab-677d83ae7abe

      C:\Windows\system32>lsnrctl stop

       

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 04-JAN-2014 13:11

      :46

       

       

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

       

       

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

      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=localhost)(PORT=1521)))

      The command completed successfully

       

       

      C:\Windows\system32>lsnrctl start

       

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 04-JAN-2014 13:12

      :57

       

       

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

       

       

      Starting tnslsnr: please wait...

       

       

      TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

      Log messages written to c:\app\sakthi\diag\tnslsnr\LALITHA\listener\alert\log.xm

      l

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LALITHA)(PORT=1521)))

       

       

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ

      ction

      Start Date                04-JAN-2014 13:13:03

      Uptime                    0 days 0 hr. 0 min. 5 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Log File         c:\app\sakthi\diag\tnslsnr\LALITHA\listener\alert\log.

      xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LALITHA)(PORT=1521)))

      The listener supports no services

      The command completed successfully

       

       

      C:\Windows\system32>lsnrctl service

       

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 04-JAN-2014 13:13

      :38

       

       

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

       

       

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

      The listener supports no services

      The command completed successfully

       

       

      C:\Windows\system32>lsnrctl status

       

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 04-JAN-2014 13:13

      :53

       

       

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

       

       

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ

      ction

      Start Date                04-JAN-2014 13:13:03

      Uptime                    0 days 0 hr. 0 min. 54 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Log File         c:\app\sakthi\diag\tnslsnr\LALITHA\listener\alert\log.

      xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LALITHA)(PORT=1521)))

      Services Summary...

      Service "orcl" has 1 instance(s).

        Instance "orcl", status READY, has 1 handler(s) for this service...

      Service "orclXDB" has 1 instance(s).

        Instance "orcl", status READY, has 1 handler(s) for this service...

      The command completed successfully

       

       

      C:\Windows\system32>