Skip to Main Content
Forums

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!

ORA-30683: failure establishing connection to debugger ORA-12541: TNS:no listener

Ora-affJun 24 2014

I am connected to a remote Dev database through SQL Developer.

SQL Developer specifications are as follows:

Version 3.2.20.09

Java(TM) Platform 1.7.0

Oracle IDE 3.2.20.09.87

Versioning Support 3.2.20.09.87

When I try to debug the stored PL/SQL procedure, I get the following exceptions:

Connecting to the database XXXX.

Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( 'XX.XX.X.XXX', '49152' )

ORA-30683: failure establishing connection to debugger

ORA-12541: TNS:no listener

ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68

ORA-06512: at line 1 Process exited.

Disconnecting from the database XXXX.

I checked using netstat command and found that the PORT 49152 is listening. So it is not blocked. I tried using both the IPs: The IP of my machine and also the IP of the remote database server which is used to establish the connection.

What are the other things I should try?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 22 2014
Added on Jun 24 2014
#listener, #sql-developer
0 comments
1,745 views