Since I started a new job I also wanted to try out MacBook as my new laptop. I’ve never been a Mac user, but there seems to be a large group of people who think Macs are the best, so I needed to find out the goodness of Macs myself 🙂 A quick tip: Don’t upgrade to Yosemite if you laptop is bound to Active Directory. Doom 2 hell on earth wad.

One part of setting up my new laptop was also setting up SQL Developer WITH Oracle Driver, because a year or two ago I rolled out radius authentication for all users who need to access the production databases directly and radius (and other non-default-password authentication schemes) do not work with thin JDBC driver. Being new to Macworld and not finding any guides for this task online, it was quite a struggle in the beginning. Here I’m trying to share my experiences if anybody else find themselves in the similar situation. If you find any mistakes here, please let me know – I’m new to the world of MacOS 🙂

SQL Developer doesn't come with an Oracle database, it is a client application. Custom content for sims 4. You can't 'connect to SQL Developer', you use SQL Developer to connect to an existing database. There are no supported editions of Oracle database for Mac OS X at this time, the latest that was available was 10gR2.

1. Configure the SQL Developer on Mac OS X for AWS Cloud access Von Tobias Arnhold → 9.03.2018 I have struggled a while now to correctly configure my Mac so that I can access an Oracle database in the AWS cloud. Got a couple of strange connection errors: I/O-Fehler: General SSLEngine problem.
2. Another SQL Server GUI tool that you can use on your Mac (and Windows/Linux/Solaris) is DBeaver. DBeaver is a free, open source database management tool that can be used on most database management systems (such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, Microsoft Access, Teradata, Firebird, Derby, and more).
3. SQL Developer: Install and Configure for Mac SQL Developer can be used to create queries that can be used to retrieve data from the Data Warehouse. The preferred method for using SQL Developer is through the AppsToGo application. This method requires no configuration and can be accessed through any web browser.

Jan Karremans just today published a similar article about Mac and Instant client, but the goal of my blog post is to get SQL Developer connected through Instant Client.

JDK

First you need Java installed, I installed 64-bit JDK8, but it would be better to install 64-bit JDK7, since SQL Developer 4.0 is not supported on JDK8.

SQL Developer

When I’m writing this, SQL Developer 4.1 is in Early Adopter release and 4.0 is in production. I installed SQL Developer 4.0.3.

Oracle Instant Client

There is another reason to choose SQL Developer 4.0 over 4.1 – 4.1 requires version 12.1 of the Oracle Client and that is not yet released for MacOS. SQL Developer 4.0 requires Oracle Client 11.2.0.3 and that is available for MacOS. I downloaded Instant Client 11.2.0.3 (64-bit – since I installed 64-bit JDK): instantclient-basic-macos.x64-11.2.0.3.0.zip and instantclient-sqlplus-macos.x64-11.2.0.3.0.zip to be precise. I unzipped both these files under /opt so my Instant Client installation directory is /opt/instantclient_11_2. After unzipping, Instant Client installation instructions require creating the following symlinks:

Configuring SQL Developer

Open SQL Developer, open Preferences and go to Database > Advanced. Configure Oracle Client paths and check Use Oracle Client and Use OCI/Thick driver boxes. Here is the sample screenshot from my settings.
When you press the Configure button to set the Oracle client path, there is also a button to Test if the Client was loaded correctly. Currently this test should fail.

Setting the environment variables

We need to set two environment variables: DYLD_LIBRARY_PATH to make sure applications can find and load the instant client libraries and TNS_ADMIN so instant client could find sqlnet.ora and tnsnames.ora files. In my case sqlnet.ora is essential, since I need to use Radius authentication.

First I added these environment variables to ~/.profile:

After restarting terminal and verifying that these environment variables are indeed set, execute SQL Developer app directly from terminal by executing open /Applications/SQLDeveloper.app/.

Open preferences and press the Oracle Client Test button again, now the test should succeed and SQL Developer is connected through Instant Client.
All good! Great success! Guess again… Close SQL Developer and launch it from Docker/Launchpad and you will see the Oracle Client test failing again. This is because the environment variables under ~/.profile or ~/.bash_profile are loaded only inside Terminal.

Setting environment variables on login

This seems to be the most complex part of this story since it seems to change with every MacOS release. The method that is working for me under Yosemite (and in no way am I declaring that it is the best method, I am a Mac newbie after all), is this:

Open application Script Editor and paste the following AppleScript there:

Yes, it is also necessary to set TNS_ADMIN, since setting the TNS admin directory path under SQL Developer preferences does not work if you need to use specific settings in sqlnet.ora, for example authentication. Athan.

Save the script and in the save dialog set File format: Application. And finally System settings -> Users & Groups -> Login items press + sign and select the application you just saved. Now, log out from MacOS and log back in. Now SQL Developer should work with Instant Client even when you launch it from Launchpad.

I got this method from a Stackoverflow thread.

macOS Big Sur takes the most advanced operating system in the world to a whole new level of power and beauty, making your apps look better than ever on an all-new interface. New widget features and the new widget gallery help you deliver more value to your users. Adding intelligence to your apps with machine learning is even simpler and more extensive with new tools, models, training capabilities, and APIs. You can create more powerful Mac versions of your iPad apps with Mac Catalyst. And you can now easily bring your extensions to Safari — and to the App Store.

All-new Interface

macOS Big Sur brings a new design that’s been finely tuned for the powerful features that make a Mac a Mac. Core features, such as the menu bar and Dock, take advantage of the large Mac display, with translucent backings and spacious pull-down menus. The new Control Center, designed just for Mac, provides quick access to controls while keeping the menu bar clutter-free. Notification Center puts recent notifications and powerful new widgets together in a single view for at-a-glance information as you work. And a streamlined new design for apps features full-height sidebars and integrated toolbar buttons.

Widgets

Easily build widgets using the WidgetKit framework and the new widget API for SwiftUI. Widgets now come in multiple sizes, and users can visit the new widget gallery to search, preview sizes, and add them to Notification Center to access important details at a glance.

Safari Extensions

With support for the popular WebExtension API, it’s even easier to bring powerful extensions to Safari. Xcode 12 even includes a porting tool to streamline the process.

The new Extensions category on the Mac App Store showcases Safari extensions, with editorial spotlights and top charts to help users discover and download great extensions from the developer community.

Machine Learning

With macOS Big Sur, creating apps that leverage the power of machine learning is even easier and more extensive with additional tools in Core ML for model deployment, new models and training capabilities in Create ML, more APIs for vision and natural language, and improved resources for training on Mac and converting models to Core ML format.

Sql Developer On Mac Os X Downloads

Mac Catalyst

Oracle Sql Developer On Mac Os X

Create even more powerful Mac versions of your iPad apps. Apps built with Mac Catalyst now take on the new look of macOS Big Sur and help you better define the look and behavior of your apps. You can choose to turn off automatic scaling of iPad controls and layout, allowing you to precisely place every pixel on the screen. Provide full control of your app using just the keyboard, take advantage of the updated Photos picker, access more iOS frameworks, and more.

User privacy on the App Store.

Later this year, the Mac App Store will help users understand apps’ privacy practices. You’ll need to enter your privacy practice details into App Store Connect for display on your product page.

Tools and resources

Use Xcode 12 and these resources to build apps for macOS Big Sur.