Pl sql developer without tnsnames.ora
All rights reserved.ĭ:\app\Vnameit\product\12.1.0\dbhome_1\network\admin\sqlnet.ora Instance "ORA12c", status UNKNOWN, has 1 handler(s) for this service.Īnd just double checking - when you did the ACL, it was the fully qualified name (ie, it matched the hostname from the ipconfig command ?) Instance "ora12c", status READY, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=5500))(Security=(my_wallet_dire (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1524ipc))) Listener Log File D:\app\Vnameit\diag\tnslsnr\LT035221\listener_ora12c\alert\log.xml Listener Parameter File D:\app\Vnameit\product\12.1.0\dbhome_1\network\admin\listener.ora Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1524)))
made the below changes to listener and it work fine, when away from network ( everything is done via localhost a.k.a 127.0.0.1 )īut when connected to network things fail - today my IP Address is 10.191.52.69, when i started to debug from connection over network it fails.Įxecuting PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.191.52.69', '56589' )ġ) Grant DBA TO demo then things works fine either inside/outside the network.Ģ) just keep looking for IP changes and add those IP's (10.242.144.87) to ACL for each changes.įor now moving with option-1, let me know if any permanent workarounds availableĬ:\Users\179818>lsnrctl status listener_ora12c So when I'm doing stuff on my local database, everything is done via localhost. Is that a right approach ( to make ACL entry for each IP address) ? So do i need to make two ACL entries like this ?ĭay#1 - When i walk into office and connect to network, got this IP Address as 10.191.61.36 - make an ACL entry for this IP (10.191.61.36)ĭay#2 - When i walk into office and connect to network, got this IP Address as 10.191.61.86 - again make an ACL entry for this IP (10.191.61.86) Please see above, when i posted this question my IP address was 10.191.61.86 without connected to the network my IP address is 127.0.0.1īut when connected to network and the IP changes dynamically.Įthernet adapter Local Area Connection 2:Ĭonnection-specific DNS Suffix. In my case, database server is available on my laptop (and i connect to this DB server using SQL Dev from the same laptop - so client and server are same to me). So I added the ACL I needed:įor example, I connected via SQL Dev using a tnsnames.ora entry which nominated a different hostname in my hosts file (which resolves in this case to 192.168.1.10) In my case, you can see I wanted to connect to 127.0.0.1, so "laptop01" must not be resolving to that. That all looks fine, but when I try the debugger, I get:Įxecuting PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '127.0.0.1', '61625' )ĭisconnecting from the database demo_np12. SQL> grant execute on DBMS_DEBUG_JDWP to demo SQL> grant debug connect session to demo SQL> grant create session,create procedure to demo Your steps look fine, so most likely cause is a name resolution one. ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68ĭisconnecting from the database DEMO_ORA12C.Ĭould you help us to understand what privilege is missing to debug this procedure ? ORA-24247: network access denied by access control list (ACL)
Procedure tried to debug from SQL Developer got this error messageĮxecuting PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUEĮxecuting PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.191.61.86', '60590' ) Procedure alter procedure p compile debug PL/SQL procedure successfully conn create or replace procedure p as Grant grant execute on DBMS_DEBUG_JDWP to demo Ĥ ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') ,Ħ principal_type=>sys.XS_ACL.PTYPE_DB) ) Grant grant debug connect session to demo User grant create session,create procedure to demo