I am trying to debug a simple pl/sql code using SqlDeveloper 1.5.1
Though I am able to get connected to the database, I get an error while establishing connection to debugger.
The error is thrown by:
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TC
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TC
This procedure takes 2 parameters:
1. IP Address: The error is the same if i provide my pc's IP address or the remoteDB's IP address
2. Port#: Port# 1528 is open, as it is the same port# mentioned in tnsnames file.
I have also got this confirmed that the port# 1528 is open from the networks team, and there is no firewall blocking the port# 1528.
and using traceart i am able to see the packets comming from the remote db 11.111.11.111 to my pc 22.222.22.222
I have also enabled Tools->Properties->Prompt for database host for debugging check box.
Supplying IP address of my pc: 11.111.11.111
Connecting to the database PBSD.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TC
ORA-30683: failure establishing connection to debugger
ORA-12560: TNS:protocol adapter error
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database Remotedb.
Supplying IP address of my pc: 22.222.22.222
Connecting to the database PBSD.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TC
ORA-30683: failure establishing connection to debugger
ORA-12560: TNS:protocol adapter error
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database Remotedb.
When my IP supplied is correct and the port# 1528 is open and exists, then why do i get this error?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
try this for now before the firewall thing;this will solve your problem as per Oracle
from menu-->'Tools --> preferences --> debugger'
check 'Prompt for debugger host for database debugging'
With this option SQL Developer ask the IP address where it is installed;this should resolve your problem;if you are using TNS connection ;
it-rex:
"where it is installed" i think you mean where the database is installed.
I am already using this feature of sqldeveloper. I am entering the ip address of the database server.
I think the error is with the port.
Want to know how to show the support guys that here is the firewall block i am talking about.
telnet does not work either. telnet 147.107.XX.XXX
My tnsnames is using the port 1528.
RAC1_abc =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abc.com)
(PORT = 1528))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = abc)
(INSTANCE_NAME = xyz21)
)
)
My pc is connecting to the db on port 1528 as seen on the above entry.
Can i connect to the debugger of sqldevleloper using the same port ie. 1528.
I have tried this but still i could not connect.
Someone told me i cannot connect the debugger as well as the db on the same port, why?
it-rex:
I am able to connect to sqldeveloper debugger.
The debugger requires two parameters:
CALL DBMS_DEBUG_JDWP.CONNECT_TC
The problem was that my IP is modified intermittently as it passes through hJXX to hBXX, due to which there was a communication barrier.
I was entering a static ip got through ipconfig command
I resolved it by providing the host name given by the network team, and it always resolves to the new ip through dnsnames server
Business Accounts
Answer for Membership
by: it-rexPosted on 2009-08-26 at 09:01:28ID: 25189195
gram77 before anything please execute the same code in sqlplus ;
and show the results;
sqldeveloper is really...you know