Oracle Tutorials: Oracle Database 11g Express Installation Step by step. Oracle says, 'Oracle Database 10.2 and 11.1 are no longer available for download. The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. Install Oracle Virtualbox for MAC. Create a VM running OLinux, RHEL or CentOS and install Oracle software OR. Download a pre-built Oracle appliance and use. In my case, I had an Oracle Express edition version 11g previously installed, so, I had to uninstall it first. To do that I had to go to the Control Panel, then search for the option to “Uninstall a program”, and there I located the Oracle Database Express 11g software, and double clicked on it to uninstall it. Free database 11g express download. Development Tools downloads - Oracle Database 11g Express Edition by Oracle Corporation and many more programs are available for instant and free download.
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
The parameters set in this file are explained in more details in the silent mode installation procedure: Performing a Silent Installation. /etc/sysconfig/oracle—xe–18c.conf
file. 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. |
Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page.
Oracle 11g Setup Download
- 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. 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.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:
Download Oracle 11g Express For Mac
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:
In an environment where EPG is used to access Oracle Application Express, the existing minimally privileged account
ANONYMOUS
is used.Download Oracle Database 11g Express Edition For Mac
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.'
Oracle 11g Express Windows
![Download Oracle 11g Express Edition For Mac Download Oracle 11g Express Edition For Mac](/uploads/1/2/6/4/126433012/971885567.png)
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'