Hello experts, I'm using the 23ai virtual box image on my personal computer without any issue, using sql developer on the windows 11 host.
But I can't connect sql developer on my corporate laptop using the same 23ai image installed on this laptop.
I'm getting this error trying to connect.
"An error was encountered performing the requested operation:
IO Error: Connection reset, connect lapse 499 ms., Authentication lapse 0 ms.
Vendor code 17002"
Also I've tried using Visual Code Sql Developer Extension without luck.
If I try to use
http://localhost:8080/ords/sql-developer, I'm able to connect without any issue.
I've already check the lsnrctl status
[oracle@vbox ~]$ lsnrctl status
LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 24-SEP-2024 01:22:52
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 23.0.0.0.0 - Production
Start Date 24-SEP-2024 01:19:17
Uptime 0 days 0 hr. 3 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service FREE
Listener Parameter File /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/vbox/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "176858bcadf91ba6e0630100007f7de0" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "FREE" has 2 instance(s).
Instance "FREE", status UNKNOWN, has 1 handler(s) for this service...
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "FREEXDB" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
Service "freepdb1" has 1 instance(s).
Instance "FREE", status READY, has 1 handler(s) for this service...
The command completed successfully
____________________________________________________________
Because its a corporate laptop I'm not able to disable windows firewall, I've added inbound and outbound rules to allow 1521, with not luck.
Any ideas? @thatjeffsmith-oracle
Regards
José