I am new to Oracle SQL, but I want to give it a shot and play around with the HR schema.
I don't want to use a VM, because I had a lot of issues with them.
Setup:
Oracle Server setup on WIN64 PC. HR and SYS works fine. (10.0.0.10 –> to understand later on)
Trying to connect via MacOS and SQL Developer (10.0.0.23).
On my Mac I am able to ping 10.0.0.10 and the other way around (10.0.0.10 (PC) to 10.0.0.23 (MAC)).
So then I setup my listener (listener.ora) and my tnsnames.ora in the way oracle wants me to do (examples folder).
After this setup I rebooted the server.
Now I tried to connect as HR to my 10.0.0.10 machine.
(On my win pc I can connect and use HR and sys schema.)
connectionHR
After trying to connect, a "Testing connection" window opens and closes after 1 minute.
Status: No success: I/O-Error: The Network Adapter could not establish the connection
Ive also tried to import the tnsnames.ora file and start from this file, but this wouldn't work either.
EDIT:
I updated my listener.
Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS des LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Startdatum 27-DEZ-2020 00:11:42
Uptime 0 Tage 0 Std. 3 Min. 14 Sek.
Traceebene off
Sicherheit ON: Local OS Authentication
SNMP OFF
Parameterdatei des Listener C:\Users\Ben\Desktop\db_home\network\admin\listener.ora
Logdatei des Listener D:\benOracle\diag\tnslsnr\DESKTOP-FT8E4S1\listener\alert\log.xml
Zusammenfassung Listening-Endpunkte...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=DESKTOP-FT8E4S1)(PORT=5500))(Security=(my_wallet_directory=D:\BENORACLE\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services ▄bersicht...
Dienst "52448234712340b69f274bcc790ecfe0" hat 1 Instanzen.
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "CLRExtProc" hat 1 Instanzen.
Instanz "CLRExtProc", Status UNKNOWN, hat 1 Handler f³r diesen Dienst...
Dienst "cfc353defce0494a8a440e7d1f817c2d" hat 1 Instanzen.
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "orcl" hat 1 Instanzen.
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "orclXDB" hat 1 Instanzen.
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "orclpdb" hat 1 Instanzen.
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Der Befehl wurde erfolgreich ausgef³hrt.
Host= Localhost
Why is host still the local ?
–> This is in German. Comment if translation is needed.
Best Answer
Your
listener.Ora
file is set to listen on localhost rather than your 10.0.0.10 ip. Change that, then restart the listener and make sure your instance is getting registered with it. Note that yourtnsnames.Ora
Isn’t involved here as you’re specifying everything in your sql developer connection, but you also need to correct thehost
there.