Issue connecting with local database from sql developer

Question

I am getting the following error while connecting to a local database (After I enter the
username and password

Following are the properties for this database that I am trying to

The services 1. OracleXETNSListener 2. OracleServiceXE
are running. I am not sure what could be causing this error and I am able to connect
to local DB with sqlplus command although with a different username and password
The listener.ora has the following entry:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = L05015765)(PORT = 1521))
    )
  )  

Also, I couldn't find any output for
netstat -aof | findstr :1521
netstat -aof | findstr :8080
netstat -aof | findstr :8082
which probably means nothing is running on 1521, and so the local connection that I
want to make it on port 1521 as per the properties window in SQL developer.
I am not sure how to debug this further and what could be going wrong

Answer 1

Your listener configuration shows that is listening on port 1521 on L05015765. That is your PC's name, and in network terms will presumably resolve to your LAN IP address (e.g. 192.168.0.1).

Your SQL Developer connection is to port 1521 on localhost, which is a different network adapter, which will resolve to a different private, fixed , IP address, 127.0.0.1. (Although it may not actually work at all by default on Windows, I believe).

If you change your connection to use L05015765 to match the listener configuration, you will be able to connect.