More discussions in Oracle Database Express Edition (XE) This discussion is archived. PHP Release Management Process – Setting Web Development Environment (Mac OS X) PHP Release Management Process – Setting Database Development Environment (Mac OS X) PHP Release Management Process – Collaboration within Team (Mac OS X) PHP Release Management Process – Common Issues with Git (Mac OS X). This is intended to be a 2 PART article, PART 1 will setup and install Oracle XE 18C, PART 2 will then setup and configure Oracle Apex to use the Oracle XE 18C database. In this article we are going to setup and install the infrastructure to run Oracle XE 18c, all the components used will be free to use and download, and tested on a Windows 10. Download and import it into VirtualBox. It's easy to install your own Oracle Database 'XE' Express Edition 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. The good news is that Oracle provides a easy to install RPM. Download oracle-xe-10.2.0.1-1.0.i386.rpm; Under Linux, as root, run 'rpm -i oracle-xe-10.2.0.1-1.0.i386.rpm' Next step is to download and run Oracle RCU to prepare the data model, please refer to the next section for directions.
Oracle XE is a free Oracle database that you can run locally and is very handy for development purposes.
This post shows how to create a docker image with an instance of Oracle XE for you to manage and use in Linux (Ubuntu, RedHat, etc.), Mac, Windows, and other Operating Systems.
Download Oracle Xe 11g For Mac
Download Oracle XE
Go to Oracle XE Download Page.
Oracle Xe Mac
Download the version for Linux with
.rpm
extension.Docker Image from Oracle Official Dockerfiles
Clone the official Oracle repo from GitHub containing the Dockerfiles.
Copy the Oracle XE to the right folder, here I’m assuming version 18.4.0 and that you cloned the repo to the home folder.
Enter the folder with the script to build the image:
Finally, build the image using parameters
-x
because we are installing Oracle XE and -v 18.4.0
because that’s the version being used.Persistent volumes
As it is, everytime the container is destroyed the data is lost.
So let’s create a volume to persist our data on the host machine.
Give permissions on host for the user
oracle
in group dba
to write in your folder from inside the container.In the container, the user
oracle
has id 54321 and group dba
has id 54322, confirm that’s the same for you just in case.Running the container
To run the container, use the following
docker run
:Now we have a container named
oracle-xe
based on our image oracle/database:18.4.0-xe
.A volume mapping
/opt/oracle/oradata
to ~/docker-volumes/oracle-xe
.SYS and SYSDBA default password is
password123
.Port from the container 1521 is mapped to 91521, and 5500 is mapped to 95500.
Troubleshooting
After running for the first time, check the logs in the container to see if there is something like a
Permission Denied
error with:If so, try starting a session in the container:
Check the permissions for
/opt/oracle/data
:If the output shows
root:root
as owner, change it to oracle:dba
:Restart your container.
Quick commands
For logs:
Start a session in the container:
Stop the container:
Start the cotainer:
![Download Download](/uploads/1/2/5/8/125860691/465671777.jpg)
Connecting to Oracle SQL Developer
To connect Oracle SQL Developer or any other client running on our host to the Oracle XE instance running in the container use the following.
Download Oracle Database Xe 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.
Downloading the Oracle 12c Client
- Navigate to the Oracle Database downloads page.
- 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.
- Accept the 'License Agreement' by checking the box in the popup window.
- 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.
Installing the Oracle 12c Client
- Locate the zip archive containing the client installer on your computer's hard drive.
- 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.
- Open the resulting folder called 'Client32' (or 'Client64'.). Double-click on the application labeled 'setup' to launch the installer program.
- On the first installer screen choose 'Administrator' as the installation type.
- Click 'Next >' on the language selection screen.
- Make sure 'Use Windows Built-in Account' is selected, then click 'Next >'..
- 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. - 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
- Save UW TNSnames.ora file to the correct location in the Oracle directory: Adding, Edting, or Replacing Your TNSnames.ora File for InfoAccess
- 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.
- Test in Oracle.