Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

1062926Jan 4 2014 — edited Jan 4 2014

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>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2014
Added on Jan 4 2014
2 comments
160 views