Oracle Xe Download For Mac

  

This document describes the installation process for the Oracle 12c Client software. The University of Wisconsin-Madison doesn't require any particular version installation of the Oracle client, but for best compatibility, it is recommended users install the 12c client. It is NOT recommended users running the Oracle 11g client update to 12c unless they are experiencing technical issues with the 11g client.

  • Most users will install Oracle Database XE by downloading the installation package, extracting the files, double-clicking setup.exe, and answering graphical user interface prompts as needed.
  • Has to be owned by the Unix user „oracle“ or set appropriately. If omitted the database will not be persisted over container recreation. Use the Oracle XE container. Stop the container with docker stop or start it with docker start. Connect to the database from macOS using localhost, port 1521 and SID XE.
  • I have been trying to download Oracle Database 11g release 2 for mac os but in the given link by oracle I can only see Linux x86 and Linux x86-64. Is this ok to use this Linux file for installing.
  • As far as I'm aware the only (latest) release of Oracle on PPC is 10.1.0.3 which runs APEX quite happily. I don't believe there is a version of Oracle for intel mac (unless someone knows otherwise). There is also no version of XE for PPC or Intel mac, although I would love to see one.

Start Oracle system using Linux command line: sudo service oracle-xe start and type the password “a” without double quotes. Then Oracle system will be started and you should see these messages. Now you can start to exploit default scheme using command line: sqlplus scott/tiger.

Downloading the Oracle 12c Client

  1. Navigate to the Oracle Database downloads page.

  2. Scroll down to the client options and click the download link for your appropriate OS.

    • Note: 32-bit Windows applications will not work with Oracle's 64-bit ODBC driver. Therefore, users of 64-bit versions of Windows may need to install the 32-bit version of the Oracle Client if they intend to make ODBC connections with 32-bit applications. For instance, if you are running 64-bit Windows 7 but you plan to use a 32-bit copy of MS Access to connect to EPM, you should install the 32-bit version of the Oracle Client. If you intend to use both 64-bit and 32-bit applications to create ODBC connections, you will need to install both clients.

  3. Accept the 'License Agreement' by checking the box in the popup window.

  4. You will be prompted to sign in with an Oracle account, or to create one (free). Once you have signed in, or created your account and then signed in, you will be asked to download the client. Choose to Save the file to an easily accessible location on your computer's hard drive.

    The zip archive containing the client installer is large and may take several minutes to download. Once the download is complete, you can continue to the installation process.

    Download psiphon 3 for pc free

Installing the Oracle 12c Client

  1. Locate the zip archive containing the client installer on your computer's hard drive.

  2. Right-click the zip archive and select 'Extract All..'. Windows will decompress the contents of the zip archive into a folder in the same location.

  3. Open the resulting folder called 'Client32' (or 'Client64'.). Double-click on the application labeled 'setup' to launch the installer program.

  4. On the first installer screen choose 'Administrator' as the installation type.

  5. Click 'Next >' on the language selection screen.

  6. Make sure 'Use Windows Built-in Account' is selected, then click 'Next >'..

  7. On the 'Specify Installation Location' screen change the default 'Oracle Base' location to C:app, and Software Location to C:appclientproduct12.2.0client_1. Click 'Next >' to continue with the installation.


    The image below does not have the correct install paths. Please follow the install paths above.

  8. The installer program will check for prerequisites and initiate the installation process. Once the installation is complete, you will be taken to a summary screen.

Final Setup Instructions

  1. Save UW TNSnames.ora file to the correct location in the Oracle directory: Adding, Edting, or Replacing Your TNSnames.ora File for InfoAccess

  2. Set up ODBC connection (using either 32 or 64 bit as appropriate): Configuring an ODBC connection to InfoAccess in Windows . It is critical to name the Data Source Name in ODBC as 'UW Data Warehouse' otherwise BA's Access files will give errors when connecting to InfoAccess. Test connection.

  3. Test in Oracle.

Recently I tried to install Oracle XE into a docker container on Mac OS Sierra using the official docker file from Oracle. I had no luck, because the installation failed with this error message:

This system does not meet the minimum requirements for swap space. Based on the amount of physical memory available on the system, Oracle Database 11g Express Edition requires 2048 MB of swap space. This system has 0 MB of swap space. Configure more swap space on the system and retry the installation.

The problem is, that you can't do anything for this on a Mac - the system manages the swap files by itself and if you need for an example 64 GB you will get it. Microsoft explorer for mac download free. My new standard MacBook has 8 GB RAM and there is currently no reason for a swap file.

So, what can we do? After a short search I found this blog post, which describes how to alter the pre-installation script of the RPM installation file with the help of the repmrebuild command. Unfortunately this command is not available on Mac OS. I found only rpmbuild as part of the rpm installation with Homebrew.

Luckily I found another way to modify a rpm package under Mac OS: There is a Ruby based tool to build packages for multiple platforms called fpm. So, lets start:

If you don't have Homebrew on your Mac, install this first:

Install rpm:

Install tar:

Install fpm:

Unzip the downloaded Linux XE installation archive and go into the directory Disk1:

Write rpm scripts to text file:

Find this loop (from line 197 until line 212 as of this writing) and comment out or delete it:

Find this line (starting on line 328 as of this writing) and delete the line and everything behind until the file end:

Delete the very first line containing this code:

Save the file and bring it back into the rpm with this command (will take some time):

Go out of Disk1 and update the zip archive, because the Oracle provided build script needs it compressed (will take some time):

Oracle Mac Os

For

When you now do the Docker build you will face another error message:

package oracle-xe-11.2.0-1.0.x86_64 is intended for a different operating system

To fix this is fairly easy. Open the Dockerfile.xe, go to line 61 (as of this writing) and change this code:

Oracle Xe Download For Mac

Oracle Xe 11g Download

to this one:

Oracle xe download mac os

When you now start the docker build you should be successful (will take some time):

The last step is to run the container - on the first startup the database is created (will take some time, align the name to your needs):

Download jre 1.7

Oracle Xe Download For Mac

If you plan to use APEX without any dedicated webserver (maybe because you are the only user and it is only a small dev instance) you should pimp the EPG a little bit:

I use currently a Node.js based proxy server running directly on my Mac OS, because I need a webserver there anyway. The nice thing is, that the EPG don't need to serve the images and I also don't need to install the images into the EPG, when I upgrade to a newer APEX version. This saves me time and the EPG runs faster because of less number of requests. I will cover this topic in the next post.

Happy installing :-)
Ottmar