Oracle RAC 11g Database on Linux Using VirtualBox By Sergei Romanenko August - December, 2012 This article describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Linux 6.3 64-bit) using VirtualBox (4.1.14+). This shows you how to install the cx_Oracle library for Python 2.7 on Fedora Linux. If Fedora has it on the server you can download it with the following yum command. 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. Windows phone application for mac. 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'. Actually, that’s the essence of Chrome OS. The total setup of google chrome is completely free. Download google chrome for mac free. In short, Chrome is essentially designed to be an operating system within an operating-system, the window through which you run all of your applications. 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/service_name 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 DYLD_LIBRARY_PATH to the Instant Client directory. Update: with Instant Client 12.1, you do not need to set DYLD_LIBRARY_PATH. 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. Office for mac 2016 install on multiple computers. 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.
0 Comments
Leave a Reply. |