I experienced the exact same problem this morning when trying to install/run sqldeveloper-18.104.22.168.45-macosx to get Oracle SQL Developer 2.1 Patch 1 (22.214.171.124.45) to work for my studies. I am working on a (regular) macbook and I followed the instructions. I ran Software Update to find my macbook is up to date (and hence also my JDK). Are you missing the feature to record and playback a macro in SQL-Developer? Well, it’s there, just a bit hidden! Update: If you use SQL Developer version 4.01 or newer please read this post. Innovate with Microsoft data and developer solutions–easily incorporate intelligence into your applications while using the tools and platforms of your choice. Build apps and services that can ingest and crunch large volumes of data. Gain transformative insights and take advantage of predictive. We are using app insights with ASP.NET MVC targeting.NET 4.6.1, using AppInsights 2.2.0 and data access through EntityFramework. When viewing SQL dependencies in app insights through the azure portal, our actual query isn't being logged.
Are you missing the feature to record and playback a macro in SQL-Developer?
Well, it’s there, just a bit hidden!
[Update: If you use SQL Developer version 4.01 or newer please read this post: Using macros – Update for version 4.01 ++]
Activate the macro functions
- Select “Tools/Preferences” from the main menu.
- Select “Shortcut Keys” in the list on the left.
- Enter “macro” the right search field.
- Assign “Ctrl+Period” to “Macro Playback”. Period is the “.” key on your keyboard.
- Assign “Ctrl+Shift+Period” to “Macro Toggle Recording”.
Record a macro
To start the recording of the macro, use an editor window of SQL-Developer and press the keys control (ctrl), shift and period (.) together.
The status bar on the bottom shows “Keystroke recording started.”
Any key you will press from now on will be recorded for replay through this macro.
When you are done press the keys control (ctrl), shift and period (.) together again.
The status bar on the bottom shows “Keystroke recording ended.”
There is only one drawback: You can only have one macro at a time. When you record a new macro the previous macro is gone!
Use the macro
Just press the keys control (ctrl) and period (.) together and your macro gets played back.
Adding quotes and commas to a list
Ever wanted the get rid of manually adding quotes and commas to a list of strings?
With a macro it is easy to get from this:
Here is how:
Sql Developer For Macbook Pro
- Go to the first line of the list.
- Start the recording by pressing the keys control (ctrl), shift and period (.) together.
- Press the following keys (pos1) (‘) (end) (‘) (,) and (“arrow down”) one after each other.
- End the recording by pressing the keys control (ctrl), shift and period (.) together again.
- Play back the macro by pressing the keys control (ctrl) and period (.) together.
- Repeat step 5 until the list is done.
- Written by: ilmarkerm
- Category: Blog entry
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 126.96.36.199 and that is available for MacOS. I downloaded Instant Client 188.8.131.52 (64-bit – since I installed 64-bit JDK): instantclient-basic-macos.x64-184.108.40.206.0.zip and instantclient-sqlplus-macos.x64-220.127.116.11.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
Sql Developer For Mac Download
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. Download dev c++ windows 8.1 64 bit.
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.
Sql Developer For Mac
I got this method from a Stackoverflow thread.