Hi!
I'm trying to create a connection between Oracle SQL Developer and Oracle XE 21c in Windows, however the status is like “Status: FailedTest failed: ES Error: The Network Adapter could not establish the connection (CONNECTION_ID=Hiwq1aa5RVixjanaXFP3tA== ) ”, Could you please help me and solve the problem?
I created a new rule on the firewall to allow port 1521 and still nothing. I believe it is worth mentioning that the services are running normally:
- Below is the configuration of my tnsnames file:
DR: “C:\app\sanvi\product\21c\dbhomeXE\network\admin\tnsnames.ora”
xe =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
(CONNECT\_DATA =
(SERVER=DEDICATED)
(SERVICE\_NAME=xe)
)
)