- Oracle Sql Plus Download
- Download Sqlplus Client For Windows
- Free Sql Plus Download
- Sqlplus Download Mac Installer
- Sqlplus Download Latest Sqlplus
MAC OS X 10.11, El-Capitan Install instructions are at the end of the download page. Instant Client contains libraries and tools allowing applications to connect to a local or remote Oracle Database for development and production deployment. Mar 03, 2016 Download the desired Instant Client ZIP files from OTN. All installations require the Basic or Basic Lite package. Open a terminal and unzip the packages into a single directory such as '/instantclient112'. For example, to use SQL.Plus: cd unzip instantclient-basic-macos.x64-11.2.0.4.0.zip unzip instantclient-sqlplus-macos.x64-11.2.0.4.0.zip.
- Written by: ilmarkerm
- Category: Blog entry
- Published: Oracle Sql Plus DownloadSince 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.SQL.Plus® User’s Guide and Reference Release 10.2 B14357-01 June 2005. SQLPlus is installed either as a standalone client; or as part of the database install. To use SQL Developer, you need to have a separate database - either on a remote server, or installed locally. In your case I suspect you must have a database installed on windows 7 as you were able to create an account and connect. Installing SQLite on your Mac is pretty straightforward. Just follow these steps: Head over to SQlite.org and download the C source code file, named sqlite-autoconf-3130000.tar.gz or similar, from.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 ?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.Download Sqlplus Client For Windows
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.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.Step 1: Download
You will need to download at least 3 files from oracle. In order to do so, you may need to register as an Oracle developer, or log in. The three files you need are the “basic”, “SDK” and “sqlplus” files for instantclient. They can all be found on the Oracle website.- instantclient-basic-macosx-<version>.zip
- instantclient-sdk-macosx-<version>.zip
- instantclient-sqlplus-macosx-<version>.zip
Download them to a temporary folder on your machine.Step 2: Uncompress and Copy Files
Uncompress the files to the /op/oracle/ folder on your machine. You will have to first create the folder:Then uncompress the zip files in to that folder. You can do this from your temp directory with this command:After you uncompress the files, you can create an alias for the instantclient folder. This will enable you to upgrade later, simply by changing where the link points.Now some of the dylib files include versions in their filenames, but some programs such as SQL*Plus do not look for the versioned file, they look for the generic filename. So to resolve that problem, we need to also create links for them.So up to this point, we now have all the files on our machine, and are ready to start configuring oracle client.Step 3: Configure Oracle
You can configure oracle for all users of the system (and that is part of the reason we placed all the files in /opt/oracle instead of the users home folder.) But this configuration is per user, not system wide. Modify the users .bash_profile, and add the following lines:You can set the NLS_LANG to be whatever is right for your situation, I choose AMERICAN_AMERICA.UTF8 since that is correct for me. You will also note I did not set the TNS_ADMIN folder to be /etc, the default location, instead I placed it in the users home directory. This is up to you, I find it easier to have each user manage their own TNS_NAMES. Finally it adds the executables to the path.Once that is finished you can source the file, or open another terminal window, and then you will be able to run SQL*Plus.Free Sql Plus Download
You should be greeted by the version of the release that you just installed.To configure your tns_names.ora file, if needed, you should create the directory etc in your home folder, and ad the file.Sqlplus Download Mac Installer
Using your favorite editor, edit the tnsnames.ora file. For more information on configuring the file, check this link.Sqlplus Download Latest Sqlplus
After doing this a few times, I made a bash file that can do most of the work for you. You have to run this script from the folder after you have downloaded the oracle zip files.