I spent a few hours today trying to figure this out. Thought I'd turn to the forum's wisdom before I spend much more time, to make sure I'm not missing some easy pointers (and/or to make sure this is even possible).
I have Oracle 12 on my Windows 10 laptop, and it works fine. I installed it as a stand-alone DB (not in the CDB/PDB setup). I've been using it for a while, it's all good. SQL Developer on it, too, to work with the DB.
Now I would like to be able to access it from a Mac laptop, OS X / Intel 64. I know Oracle no longer supports the DB on Mac. However, they do support SQL Developer, and somehow I got the idea that it should be possible to access my DB from the Windows computer through SQL Developer on the Mac.
Is that completely idiotic, or does it make sense? I was able to download and install JDK 8 and SQL Developer on the Mac, so far so good. I wasn't able to establish a connection though, I spent an hour or so looking through the documentation but I am not able to find what I am looking for.
The setup is a HOME network. I don't know much about networking - some time ago I got the idea, which may be wrong, that computers that share an Internet connection all have the same IP address, and I don't know if that is an issue. What I tried was to set up a connection just like I did on my Windows computer: Connection Type = Basic, Hostname = the name of my laptop (as recognized on the laptop, for example, by SELECT host_name FROM v$instance; ) I am able to see the Windows machine, under the exact same name, from the Mac, in a Finder window. On the Windows machine I shared the entire "app" directory created when I installed Oracle; the path to the Oracle Home is C:\app\intro\product\12.1.0\dbhome_1\ (shown just to explain what the directory "app" is). I am, indeed, able to see everything in this directory and its subdirectories on the Mac. Is there anything else I need to "share" on the Windows machine to allow SQL Developer on the Mac to access the DB on the Windows machine? Then, continuing with the Connection setup: I gave it a username and password I use on the Windows machine, Port=1521, Service Name = orcl (all are the same as on the Windows machine).
When I tested the connection with these settings, I got the following error message: Status: Failure - Test failed: IO Error: The Network Adapter count not establish the connection.
I think I am pretty good at following instructions (and also at asking follow-up questions if and as needed), so if this, or some of it, is already answered somewhere, please just point me in the right direction.
Thank you! mathguy