Oracle Client for Mac OSX 262149 Apr 22, 2002 4:20 PM I have an Oracle 9i Database Server on Windows 2000, but I'd like to access it from my MAC running OSX. Subject to the Oracle Technology Network License Agreement for Oracle Instant Client software, licensees are authorized to use the version of Oracle Instant Client downloaded from this Oracle Technology Network webpage to provide third party training and instruction on the use of Oracle Instant Client.
. (Optional) Select your preferred language.
Select a language from the language list and click the Check icon. The Welcome page is displayed in the selected language. Click Install the Oracle Secure Global Desktop Client.
The Oracle Secure Global Desktop page is displayed. Download the SGD Client installation program. Click Download the Secure Global Desktop Client for Microsoft Windows. Save the installation program to a temporary directory on the client computer. The SGD Client installation program is sgdcwin- lang.msi, where lang is the selected language.
Change to the temporary directory and install the SGD Client. Double-click sgdcwin- lang.msi and follow the instructions on the screen. In a browser, go to an SGD web server.
For example, The SGD web server Welcome page is displayed, as shown in. (Optional) Select your preferred language. Click a language from the language list and click the Check icon.
The Welcome page is displayed in the selected language. Click Install the Oracle Secure Global Desktop Client. The Oracle Secure Global Desktop Client page is displayed.
Download the SGD Client installation files. Installation files are available for the following platforms. For a tar file, do the following: Change to the temporary directory and extract the tar file. $ cd / tempdir $ tar xvf tarfile Run the install script: $ sh sgdc/install Follow the instructions on the screen. For an RPM package, do the following: Change to the temporary directory and install the package. For example: # yum install -nogpgcheck sgdclient- version.el7.x8664.rpm. For a deb package, do the following: Change to the temporary directory and install the package.
For example: # apt-get install./sgdclient version-ubuntu16.04x8664.deb. In a browser, go to an SGD web server. For example, The SGD web server Welcome page is displayed, as shown in. (Optional) Select your preferred language. Click a language from the language list and click the Check icon. The Welcome page is displayed in the selected language.
Click Install the Oracle Secure Global Desktop Client. The Oracle Secure Global Desktop Client page is displayed. Download the SGD Client tar file. Click Download the Secure Global Desktop Client for platform, where platform is the operating system for your computer platform. Save the tar file to a temporary directory on your computer.
Tar file names indicate a platform, as follows. In a browser, go to an SGD web server. For example, The SGD web server Welcome page is displayed, as shown in. (Optional) Select your preferred language. Click a language from the language list and click the Check icon. The Welcome page is displayed in the selected language.
Click Install the Oracle Secure Global Desktop Client. The Oracle Secure Global Desktop Client page is displayed. Download the SGD Client installation program. Click Download the Secure Global Desktop Client for Mac OS X.
Save the installation program to a temporary directory on the Mac. The SGD Client installation program is OracleSecureGlobalDesktopClient.dmg. Install the SGD Client. Change to the temporary directory and double-click OracleSecureGlobalDesktopClient.dmg to open the installer disk image. In the window that appears, double-click the Oracle Secure Global Desktop Client.pkg package to install the SGD Client.
Follow the instructions on the screen.
Tl;dr Your OS X applications can connect to Oracle Database as if it was running natively on OS X if you simply run Oracle Database in a VirtualBox VM with port forwarding enabled (easy). To work backwards through the installation process: in the Network window of the VirtualBox GUI, I enable a NAT Network adapter.
Then, under Networking - Advanced - Port Forwarding, I create a TCP rule with Host IP 127.0.0.1 and both the Host and Guest Port fields set to the port number that the Oracle Network Listener in the VM is using: the Oracle default is 1521. I leave the Guest IP field blank. I click OK twice, dismissing the 'The current port forwarding rules are not valid. None of the host or guest port values may be set to zero.'
Dialog Start the VM. If the, you don't even need to log in. Update: If you have Oracle Database 12c you can use the new EM Express console for DB management and monitoring. Just enable port forwarding for port 5500 and then browse (from OS X) to See by Gerald Venzl.
Update: If you want to access the database from a second, NAT-configured VM, simply configure the DB VM's port forwarding as described in this article. In your second VM, applications can use an Oracle connect string like '10.0.2.2/orcl'. The IP address to use is the VirtualBox gateway, see in the VirtualBox documentation. The Client Connecting to the database from OS X tools and clients uses the same forms of Oracle connect string as if the database was native on OS X.
For example, using the hostname/servicename form, I can simply use 'localhost' as if the database was on OS X: cjones@mac:$ sqlplus cj/welcome@localhost/orcl SQL.Plus: Release 11.2.0.4.0 Production on Mon Jan 19 09: Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL Here I was using SQL.Plus from the free, easy to install Instant Client bundle. Download the Basic, SDK and SQL.Plus ZIP files.
Unzip them, create the two symbolic links given in the, and set DYLDLIBRARYPATH to the Instant Client directory. Update: with Instant Client 12.1, you do not need to set DYLDLIBRARYPATH. The Instant Client can be used, among other things, for building PHP, Python, Node.js and other language drivers. With each of these you would use exactly the same connect string to connect to the database. Prebuilt VMs There are prebuilt VMs with Oracle Database already installed, such as the. Download and import it into VirtualBox.
The Database It's easy to install your own database for development. After the XE RPM is installed on Oracle Linux 5 and 6, run its simple configuration script to set up the administration passwords, the listener port (default is 1521), and whether to autostart during boot. Install XE by following the ten steps in Chapter 4 of or check the. Alternately you could install the for free ('only for the purpose of developing, testing, prototyping, and demonstrating' - read the click-through license). There are to autostart the DB at VM machine boot.
The OS If you need an OS, Oracle Linux is free from. Download the ISO, create a new VirtualBox VM and tell it where to find the ISO.
Boot and follow the install prompts. VirtualBox VirtualBox is free from and runs on OS X, Windows, Linux and Solaris. The only 'trick' to using VirtualBox is to remember the magic cursor-releasing key, e.g. The Left Command Key on OS X. This key is useful if/when you haven't installed the VirtualBox 'Guest Additions' into the VM and clicking into the VM window captures the cursor. The specific key combination is shown as a reminder on the bottom right of the containing VirtualBox VM window. Pressing it returns cursor control to the host OS.
Luckily, once you install the 'Guest Additions' the cursor is automatically released when you mouse out of the VM window.