![]() ![]() 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. 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. 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). I am, indeed, able to see everything in this directory and its subdirectories on the Mac. 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). 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. 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. I can't see any process named SQLDeveloper or process ID to permit killing it. The app window disappears but the icon stays in the task bar. ![]() 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. HI, I have recently been experiencing issues with the application failing to stop on a mac client 10.11.5 El Capitan running Java 1.8U91 JDK and 4.1.3 SQLDev. 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. 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. I know Oracle no longer supports the DB on Mac. Now I would like to be able to access it from a Mac laptop, OS X / Intel 64. When you connect from SQL Developer on your laptop, it's a remote connection so OS Authentication isn't normally possible. SQL Developer on it, too, to work with the DB. When you login in the terminal, Oracle lets you in because the user oracle on the server 10.10.1.64 is a member of the OSDBA group on that machine. I've been using it for a while, it's all good. I installed it as a stand-alone DB (not in the CDB/PDB setup). I have Oracle 12 on my Windows 10 laptop, and it works fine. 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 went to the Oracle Java Downloads page at Īnd downloaded the file: jdk-17.0.1_macos-aarch64_bin.I spent a few hours today trying to figure this out. The following is what actually worked for me. I'll spare you all the various different combinations and attempts that I made that didn't work. You can also run any number of provided reports, as well as create and save your own. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. 100% of the credit goes to those that contributed in the forum. Oracle SQL Developer is a graphical tool that enhances productivity and simplifies database development tasks. ![]() ![]() Most of what I did comes from what I gleaned reading various posts there. While looking for a solution, I took a look at some of the forum posts on. Sometimes it would crash immediately, sometimes after a few minutes. Very soon, I saw that SQL Developer was crashing. I got my new MacBook Pro (M1 Pro) a few days ago, and then set it up by restoring a Time Machine backup from my MacMini (also M1 architecture) and quickly started using my new laptop. I'm hoping that this will be of help to others facing similar issues. This is the solution that I am currently using. Note: See updates, -29 below concerning the use of GraalVM's JDK as an alternative to JDK 17. Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |