In this case, /Applications/sqlcl/bin/sql is the full path, hr is the username, and oracle is the password. Once you’ve done that, you can launch SQLcl by opening a Terminal window and entering the full path, followed by the default username and password: /Applications/sqlcl/bin/sql hr/oracle For example, you could move it to your Applications folder. If the sqlcl folder is in your Downloads folder, feel free to move it to another location. This extracts a folder called sqlcl that contains various other folders and files. Download SQLclįirst, download SQLcl from the Oracle Website. If not, you can download the JRE from the Java website. If your Java version starts with 1.8, you’re good to go.
Java HotSpot(TM) 64-Bit Server VM (build 25.291-b10, mixed mode) Java(TM) SE Runtime Environment (build 1.8.0_291-b10) In my case, it returns the following: java version "1.8.0_291" If you’re not sure whether you have it or what version it is, open a Terminal window and run the following command: java -version SQLcl requires that you have at least Java Runtime Engine (JRE) 8. You might also want to add its folder to your PATH variable (see the “Add to Path” heading below). However, the version may be different – you’ll need to check the version against the latest available. In that case, you can run SQLcl as soon as you’ve installed SQL Developer. SQL Developer comes with a copy of SQLcl.
Note: If you also plan on installing SQL Developer, then you won’t need to install SQLcl separately. Here’s a quick rundown on the steps I used to install SQLcl on a Mac. It’s available on many major operating systems, including MacOS. The last step of the installation launches SQL Developer, as shown below:Ĭlick the Connections icon to create an initial connection, like the following:Īfter connecting to the database, you can write and execute a query as shown in the next screen capture:Īs always, I hope that this helps those who require an example to install SQL Server on a Mac OS.SQLcl is a command line tool for working with Oracle Database. If you launch SQL Developer with the Security “Anywhere” setting, it displays the following dialog:Īfter you launch the program, you will see the following progress dialog: Just make sure you reset it to the “Mac App Store and identified developers” setting after you install SQL Developer. If you reset the Mac Security to an “Anywhere” setting, you can install Oracle SQL Developer on Yosemite. If you attempt to launch the installation and you’ve set your Mac Security to the “Mac App Store and identified developers” setting, you should raise the following exception: Below is a screen shot of the Oracle download web page where I’ve accepted the license agreement: After installing the Java JDK or SDK, you should download SQL Developer 4.1 from Oracle’s web site.
It is a standard Mac OS installation, which is why I didn’t bother showing any dialog messages. I’ve opted to install Netbeans 8 with JDK 8u45, as you can tell from the screen capture after you launched the file: You have the option of installing the Java SDK or JDK.
You must accept the Java license to install Java 8 on the Mac OS X operating system: No Java runtime present, requesting install.