For the subject, we must install two programs 'Oracle SQL Developer' and 'Oracle Database Express Edition'. There is a Mac version Oracle SQL Developer but only Windows or Linux for Oracle Database Express Edition. I tried to install the latter with Docker but keep running into issues.
- Oracle 12c Express Edition Download
- Oracle Database Express Xe Downloads
- Oracle 11g Personal Edition Download
Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page.
- For installations where the development will be in English only, download the file
apex_5.1_en.zip
from the Oracle Application Express download page. If the development will include languages other than English, downloadapex_5.1.zip
from the Oracle Application Express download page. See:Note that the actual file name may differ if a more recent release has shipped since this document was published. - Unzip downloaded zip file:
- If English only, unzip
apex_5.1_en.zip
as follows, preserving directory names:- UNIX and Linux:
$ unzip apex_5.1_en.zip
- Windows: Double click the file
apex_5.1_en.zip
in Windows Explorer
- If multiple languages, unzip
apex_5.1.zip
as follows, preserving directory names:- UNIX and Linux:
$ unzip
apex_5.1.zip
- Windows: Double click the file
apex_5.1.zip
in Windows Explorer
Note:You should keep the directory tree where you unzip the files short and not under directories that contain spaces. Visual studio 2017 enterprise download mac. For example, within Windows unzip toC:TEMP
. - Change your working directory to
apex
. - Start SQL*Plus and connect to the database where Oracle Application Express is installed as
SYS
specifying theSYSDBA
role. For example: - Disable any existing password complexity rules for the default profile. See “Configuring Password Protection” in Oracle Database Security Guide.
- Select the appropriate installation option.Full development environment provides complete access to the App Builder environment to develop applications. A Runtime environment enables users to run applications that cannot be modified.Available installation options include:
- Full development environment. Run
apexins.sql
passing the following four arguments in the order shown:Where:tablespace_apex
is the name of the tablespace for the Oracle Application Express application user.- Canon ij printer utility windows.
tablespace_files
is the name of the tablespace for the Oracle Application Express files user. tablespace_temp
is the name of the temporary tablespace or tablespace group.images
is the virtual directory for Oracle Application Express images. For installations using EPG,/i/
is the required value for the images argument. To support future Oracle Application Express upgrades, define the virtual image directory as/i/
.
Example:Note:If you receive the following error, exit SQL*Plus and change your working directory to where you unzipped the installation file, for exampleC:TEMP
in Windows, before starting SQL*Plus:SP2-0310: unable to open file 'apexins.sql
' - Runtime environment. Run
apxrtins.sql
passing the following arguments in the order shown:Where:tablespace_apex
is the name of the tablespace for the Oracle Application Express application user.tablespace_files
is the name of the tablespace for the Oracle Application Express files user.tablespace_temp
is the name of the temporary tablespace or tablespace group.images
is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as/i/
.
Example:
When Oracle Application Express installs, it creates three new database accounts:
APEX_050100
- The account that owns the Oracle Application Express schema and metadata.FLOWS_FILES
- The account that owns the Oracle Application Express uploaded files.APEX_PUBLIC_USER
- The minimally privileged account is used for Oracle Application Express configuration with Oracle REST Data Services or Oracle HTTP Server andmod_plsql
.
Note:
Oracle Database 11g Release 2. Standard Edition, Standard Edition One, and Enterprise Edition. 7/13: Patch Set 11.2.0.4 for Linux and Solaris is now available on support.oracle.com.Note: it is a full installation (you do not need to download 11.2.0.1 first). 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 oracle database in mac.
In an environment where EPG is used to access Oracle Application Express, the existing minimally privileged account
ANONYMOUS
is used.If you are upgrading from a previous release, then
FLOWS_FILES
already exists and APEX_PUBLIC_USER
is created if it does not already exist.Tip:
Oracle Application Express must be installed from a writable directory on the file system. See 'Reviewing a Log of an Installation Session.'
See Also:
- 'Configuring Password Protection' in Oracle Database Security Guide
- 'About the Oracle Application Express Runtime Environment'
- 'SQL*Plus User's Guide and Reference for more information about SQL*Plus'
- 'Reviewing a Log of an Installation Session'
Oracle puts out a Windows and Linux binary for their Oracle Database servers, but what if you want to run it on a Mac? The solution for a while was to use a VM and boot up the linux version. Nowadays using Docker is a little bit easier.
I will say that running Oracle DB on docker is not quite as easy as installing SQL Server on a Mac with Docker, but it is also not too difficult.
Oracle 12c Express Edition Download
Download the Oracle Database Linux Binary
Your first step is to download the Download the Oracle Express Edition version 18c (xe) Linux rpm from oracle.com. Oracle's docker files do support other editions, but the Express Edition is sufficient for getting started.
![Download Oracle Database Express Edition Mac Download Oracle Database Express Edition Mac](/uploads/1/2/6/7/126735147/684576368.png)
Clone the Oracle Dockerfile Repo
Oracle has a GitHub repo with all its Dockerfiles, you can clone it (download it) by running:
Copy Binary to Dockerfiles dir
Within the git repository you just cloned, go to the OracleDatabase dockerfiles folder:
Copy the binary you downloaded in step 1 to the 18.4.0 folder within the dockerfiles folder:
Build a Docker Image
Run the script:
The
-x
tells the script that you are installing the express edition, and the -v 18.4.0
tells it which version you are installing.Oracle Database Express Xe Downloads
This step will take a few minutes.
Look for local docker image
Oracle 11g Personal Edition Download
![Download Oracle Database Express Edition Mac Download Oracle Database Express Edition Mac](/uploads/1/2/6/7/126735147/886389289.png)
You should now have a docker image named
oracle/database:18.4.0-xe
which you can start using docker. Run docker images
from Terminal to look for it and make sure it is there. The total size of the image will be around 8-9GB.Start an Oracle Database Using docker-compose
Finally we'll create a docker-compose.yml file so we can easily startup the db whenever we need it:
Now we can start up our container by running:
If you omit the
ORACLE_PWD
environment variable it will just generate a presumably random password and output it during startup. The startup takes a few minutes to initialize.After it starts up you will have an oracle database that is accessible on your local machine on port
11521
.