Additional, there is a new MS tool available, similar to SSMS which runs also on macOS and on Linux: Download and install SQL Operations Studio (preview) Olaf Helper Blog Xing MVP. Search for How To Download Express Vpn On Mac And Oracle Vpn Download Ads Immediately. 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. 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.
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 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
rootusingsudo.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-yoption if you wantyumto 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.rpmfile required for performing an RPM-based installation to a directory of your choice.Install the database software using the
yum localinstallcommand.
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.
To create the Oracle XE database with the default settings, perform the following steps:
Execute as user
rootusingsudo.Run the service configuration script:
At the prompt, specify a password for the
SYS,SYSTEM, andPDBADMINadministrative 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 |
|---|---|
| Oracle Base. This is the root of the Oracle Database XE directory tree. |
| 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. |
| Database files. |
| Diagnostic logs. The database alert log is |
| Database creation logs. The |
| Configuration default parameters. |
| Configuration and services script. |
This section covers the following topics:
5.1 Running the Installer
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.
Note:
- Before attempting to install Oracle Database XE 18c, uninstall any existing Oracle Database XE or database with the
SID XEfrom the target system. - Installer will use
SID XEfor database creation. AnySIDother thanSID XEwill not be allowed. - See Migrating Data and Applications if you need to move data from Oracle Database Express Edition to Oracle Database Enterprise Edition 18c.
- See Exporting and Importing Data between Oracle Database XE 11.2 and 18c if you need to move data from XE 11.2 to XE 18c.
To install Oracle Database XE:
Log on to Windows with
Administratorprivileges.You must be part of the
Administratorsgroup on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network. Otherwise, you may receive a prerequisite check failure forAdministratorprivileges during the install.If the
ORACLE_HOMEenvironment variable has been set, then delete it.Download the Microsoft Windows version of Oracle Database XE.
Extract the downloaded
zipfile to a temporary location. Locatesetup.exeand double click it.In the Welcome to the InstallShield Wizard for Oracle Database 18c Express Edition window, click Next.
In the License Agreement window, read the text of the agreement and if you agree to its terms, select I accept the terms in the license agreement and then click Next. If you do not accept the terms, cancel the installation and delete the Oracle Database 18c Express Edition software from the computer.
- The installer now performs a prerequisite check to ensure that the version of Windows is supported, that the installation user has administrative privileges, and that there is no
Oracle Database XEservice already created. If any of these checks fail a Prerequisite Checks window will open notifying the user. In that case, cancel the installation, fix the problem, and retry the installation. In the Choose Destination Location window, either accept the default or click Change to select a different installation directory. (Do not select a directory that has spaces in its name.) Then click Next.
In the Specify Database Passwords window, enter and confirm the single database password to use for the
SYS,SYSTEM, andPDBADMINdatabase accounts. Then click Next.Note:
The same password will be used for these accounts.
Oracle recommends that the password entered should be at least
12characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. The password should conform to the Oracle recommended standards. See Oracle Database Security Guide for more information about guidelines for securing passwords.In the Summary window, review the installation settings, and if you are satisfied, click Install. Otherwise, click Back and modify the settings as necessary.
When the installation is complete, the Oracle Database Installed Successfully window is displayed.
Make a note of the connection strings provided for multitentant container database and the pluggable database, as well as the EM Express URL. Click Finish to close the installer.
Configuration, Database Files, and Logs Location
The following table lists important locations such as Oracle Base, Oracle Home, Database files, and logs. <INSTALL_DIR> is the installation directory chosen by you during the time of install. The default installation directory is C:app<username>product18.0.0, where <username> is the name of the Windows user performing the installation.
Table 5-1 Configuration, Database Files and Logs Location
| File Name and Location | Purpose |
|---|---|
| Oracle Base This is the root of the Oracle Database XE directory tree. |
| 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. |
| Database files |
| Diagnostic logs The database alert log is |
| Database installation, creation, and configuration logs. The |
| Software installation logs. |
5.2 Performing a Silent Installation
If you plan to install Oracle Database XE on multiple computers or bundle it with a third-party application, then you may want to perform a silent installation, in which you download the installation executable and run it at a command line using the provided response files.
If you have an existing version of Oracle Database XE, you can save your data by exporting it to data files. After you install the new version of Oracle Database XE, you can import this data into the new database.
To perform a silent installation of Oracle Database XE:
Log on to Windows with Administrator privileges.
You must be part of the
Administratorsgroup on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network.Download Oracle Database XE for Microsoft Windows. Extract the files to a temporary directory.
Open the
XEInstall.rspresponse file and modify the settings if necessary.Note:
For information on response file parameters, see Table 5-2.If the ORACLE_HOME environment variable has been set, then delete it.
Run the installation executable with the
XEInstall.rspresponse file.For example, if you extracted the
setup.exeexecutable and theXEInstall.rspfile to a directory calledxe_temp, you would enter the following command:After the installation is complete, Oracle Database XE starts.
Response File Parameters
The following table describes the important response file parameters. The parameter value cannot be empty. You must specify a valid value for the parameters.
Table 5-2 Response File Parameters
| Parameter | Purpose | Default Value |
|---|---|---|
| The install directory location. Replace |
|
| The XE Database password. All users are set with this password. Reset the password immediately after the installation is complete. |
|
| The listener port. |
If listener port is set to |
| The EM express port. |
If EM express port is set to |
| The character set of the database. |
|
Note:
After the installation is successfully completed, the following message is available in the log file that you have specified as the parameter to setup.exe. For example, c:xe_tempsetup.log:
MSI (c) (28:B8) [Timestamp]: Windows Installer installed the product. Product Name: Oracle Database 18c Express Edition. Product Version: 18.4.0.0.0. Product Language: [Current Language ID]. Manufacturer: Oracle Corporation. Installation success or error status: 0.
Since silent install runs asynchronously, you can check the log file for the completion status.
If the installation fails, see the following installation log files:Oracle Express Application
- general logs: located at
%Program Files%OracleInventorylogs - database creation logs: located at
<Oracle_base>cfgtoollogs
Comments are closed.