Download and install Oracle SQL developer – MAC OS X – All Go to and download the Oracle SQL Developer 3.2.2 (3.2.20.09.87) for MAC. Do not forget to accept the license agreement. Locate the tar file in the Downloads folder and launch the install. CNET Download provides free downloads for Windows, Mac, iOS and Android devices across all categories of software and apps, including security, utilities, games, video and browsers. In this video tutorial I will show you the step by step process of installing Oracle Database 18c XE on Docker Container running on Mac OS. There are many bl.
- Oracle Mac Os
- Oracle Xe 11g Download For Mac
- Oracle Xe Database Download For Mac
- Oracle Xe 11g Download
- Oracle 10g Xe Free Download
- Download Oracle 10g for Mac to enterprise/standard edition database server.
- As was mentioned by bighornsheep in another post, Oracle provides a free version of their 10g database product to work with if you're a student, developer, or simply wanting to get some hands-on practice with the Oracle product, (much like Microsoft's SQL Server Express).
Perform the following steps to install and configure Oracle Database XE using RPM packages.
Before attempting to install Oracle Database XE 18c, uninstall any existing Oracle Database XE or database with the SID
An Oracle Database XE installation will consume around 9 gigabytes of disk space under XE
from the target system. /opt
. If this disk partition does not have the required disk space available, you must add space or mount an alternative partition as /opt/oracle
. This disk partition is the defined Oracle Base where the software and database will reside. Note:
The Oracle Database XE installation does not support usage of symbolic links (symlink) for that disk.
Installing Oracle Database XE RPM
- Execute as user
root
usingsudo
. - For Oracle Linux, the Database Preinstallation RPM is pulled automatically, proceed to the next step. For Red Hat compatible Linux distributions, download and install the Database Preinstallation RPM using the following:
- For Red Hat Enterprise Linux 6, run these commands:For Red Hat Enterprise Linux 7, run these commands:Note:Use the
-y
option if you wantyum
to skip the package confirmation prompt.
- Access the software download page for Oracle Database RPM-based installation from Oracle Technology Network :
- Download the
oracle-database-xe-18c-1.0-1.x86_64.rpm
file required for performing an RPM-based installation to a directory of your choice. - Install the database software using the
yum localinstall
command.
The Database Preinstallation RPM automatically creates Oracle installation owner and groups and sets up other kernel configuration settings as required for Oracle installations. If you plan to use job-role separation, then create the extended set of database users and groups depending on your requirements. Check the RPM log file to review the system configuration changes.
For example, review this file for latest changes:
/var/log/oracle-database-preinstall-18c/results/orakernel.log
. The installation of Oracle Database software is now complete.
After successful installation, you can delete the downloaded RPM files, for example:
Creating and Configuring an Oracle Database
The configuration script creates a container database (
XE
) with one pluggable database (XEPDB1
) and configures the listener at the default port (1521) and Enterprise Manager Express on port 5500. You can modify the configuration parameters by editing the
/etc/sysconfig/oracle—xe–18c.conf
file. Oracle Mac Os
The parameters set in this file are explained in more details in the silent mode installation procedure: Performing a Silent Installation.To create the Oracle XE database with the default settings, perform the following steps:
- Execute as user
root
usingsudo
. - Run the service configuration script:At the prompt, specify a password for the
SYS
,SYSTEM
, andPDBADMIN
administrative user accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].See Also:The same password will be used for these accounts. The password should conform to the Oracle recommended standards. See Oracle Database Security Guide for more information about guidelines for securing passwordsAfter the configuration completes, the database and listener are started.
Configuration, Database Files and Logs Location
Table 5-1 Configuration, Database Files and Logs Location
File Name and Location | Purpose |
---|---|
/opt/oracle | Oracle Base. This is the root of the Oracle Database XE directory tree. |
/opt/oracle/product/18c/dbhomeXE | Oracle Home. This home is where the Oracle Database XE is installed. It contains the directories of the Oracle Database XE executables and network files. |
/opt/oracle/oradata/XE | Database files. |
/opt/oracle/diag subdirectories | Diagnostic logs. The database alert log is /opt/oracle/diag/rdbms/xe/XE/trace/alert_XE.log |
/opt/oracle/cfgtoollogs/dbca/XE | Database creation logs. The XE.log file contains the results of the database creation script execution. |
/etc/sysconfig/oracle-xe-18c.conf | Configuration default parameters. |
/etc/init.d/oracle-xe—18c | Configuration and services script. |
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
![Mac Mac](/uploads/1/1/8/7/118795105/885835038.png)
Go to Oracle XE Download Page.
Oracle Xe 11g Download For 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.
Oracle Xe Database Download For Mac
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
Oracle Xe 11g Download
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.
Oracle 10g Xe Free Download
Quick commands
For logs:
Start a session in the container:
Stop the container:
Start the cotainer:
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.