SQL Developer


ORA-12541: TNS:no listener in debugging mode of sql developer


My oracle database sits on the a unix restricted server. I have to use putty with ssh tunnel setup to connect to other server first. Then I can use Toad or Plsql in my XP windows to connect to the database. When I use SQLDeveloper, I have no problem to connect. I can view all the tables and procedures in the database. However, when I use the debug, I have the following errors. Could somebody have any idea how to correct this? I have tried both basic and tns and the result is the same.
onnecting to the database YPGFPTOTBE01_Test_rhatora2 .
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '127.0.0.1', '3021' )
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 
Is sql developer installed on your local client or the remote database server? The IP address the debugger should be connecting to is the host machine of the database. In addition to that, you have to make sure you're using a port that isn't being blocked.
I was going nuts trying to figure out why I could connect to the XE Database I had running on my laptop but not the dev server. Finally somebody from network support verified that the windows firewall was blocking the port range I was trying to use. 
Actually, it's the other way around: the database should be able to contact your PC at the supplied IP and port range.
As your IP isn't recognized automatically, provide it manually at least once by checking Preferences - Debugger - Prompt for Debugger Host.
Hope that helps,
K. 
Whoops, brain fart. I was thinking "the real IP address of your machine, not the loopback" and is somehow came out as server. 
Are you trying to use local debugging or remote debugging? 
I have tried but come back with the same error message. I used VPN to connect. I don't understand is why I can access my packages and procedures in SQL Developer but I cannot use debugger. I don't know which part I do it wrong. Could you help? 
I am trying to use local debugger. What I did was to connect to database in SQLDeveloper and then to select one of my procedures in the database, finally to compile with debug option. When I run the procedure in the SQLDeveloper, it finishes successfully. I only have problem in debugger. 
Then some firewall is probably blocking traffic from the server to your PC. Ask your network admin to open up traffic and test in a terminal that the DB server can reach your PC.
Hope that helps,
K.

Related Links

2.1.0.63 Issue accessing stored procedures
Unable to create Unit Testing Repository,on Tools>Unit Test>sel current rep
EA 2.1. Can't export CLOB columns.
unique constrain error while  importing xls data
Report Bug (2.1.0.63) : Cant show data in ObjectViewer
Run query on all connected databases
Unit Test in SQL Developer 2.1: Automated Builds
How to compare date in Varchar2(25 Byte) with dates
Copying subprograms to another schema
Can adhoc DML be echoed to Data Editor Log?
SQL Developer 1.5.5 Tables Node Works a few times
SQL tab not working in V2.1 EA1 for non-DBA users -- how to fix?
Wrong error line number
2.1 EA2 Error Message Line number off by 1.
Tiny 2.1 EA1 SQL Formatter Bug?
Dependencies option missing when exporting

Categories

ORACLE DEV
Database
XML
Designer
Server & Storage Systems
Database Mobile Server...
Recovery Manager (RMAN)
OO4O and Wizards [ARCH...
Customer Experience (CX)
Service
Integration and Events
Development Tools Arch...
UIX
Instant Client
Migration
ILM Assistant
Rules Manager & Expres...
Berkeley DB Java Edition
XML (Korean)
Web Service Manager (K...
Migration and Moderniz...
Technical Bulletin (Ko...
Technologies - Perform...
Oracle Clusterware
JDeveloper and OC4J 11...
Industrial Manufacturing
Architecture
Workshop
weblogic.developer.int...
opensource
weblogic.developer.int...
jrockit.developer.inte...
UI Customization
Publisher Office Add-i...
行业专区
只读栏目
WebLogic Server - JCA
Tutor
Java HotSpot Virtual M...
Java Web Start & JNLP
JavaServer Pages (JSP)...
Other Security APIs, T...
Abstract Window Toolki...
JavaBeans [ARCHIVE]
Sun Update Connection
Java EE SDK
Secure Global Desktop
HotSpot FAQs [ARCHIVE]
Distributed Real-Time
Java Enterprise System...
E-mail, Calendar, & Co...
テクノロジー
CRM On Demand Marketing
Oracle Application Exp...
R Technologies
Information Discovery
システム管理
Talent Management
Oracle Social Network
Oracle Mobile
Peer_Review
Architecture - General...
Oracle Developer Cloud...
Enterprise Metadata Ma...
Influence
ECOUG中文论坛
Portuguese
Oracle Database Backup...
Oracle Marketing Cloud...
Colorado Eloqua Users
Eloqua Users with MS C...
Road to Revenue Tour
Canadian B2B Marketers
Computershare
Oracle Process Cloud S...
Getting Started
Responsys UK User Foru...
Oracle Virtual Networking
Colombia
Modern Supply Chain Ex...
Supply and Demand
JAI
POUG
SQLcl
Oracle EMEA Partner Sales
Java.net Forge Sunset
JavaScript - Nashorn
20 Days of Java in Brazil
Chile
APEX Gruppe
Kansas City Eloqua Use...
Oracle Database Develo...
Oracle Service Cloud C...
Oracle Services for Mi...
Identity Manager
Database and Applicati...
Data Integrator
Enterprise 2.0
EPM System Management ...
weblogic.eventserver.g...
产品专区
WebLogic开发
User Productivity Kit ...
Java Programming
Java Native Interface ...
Servers General Discus...
Oracle Cloud - General...
BICS Upgrades
Imagine How
Transportation Management

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App