Oracle DataBase Installation

A pre-configured VirtualBox virtual machine from Oracle engineers can be downloaded from the following URL:

https://www.oracle.com/database/technologies/databaseappdev-vm.html


P.S.

Colleagues have posted a video on how to deploy a database using Vagrant + SSH scripts. It uses Oracle Linux 8 and an Oracle 19C database. To install, copy the distribution to the required directory and run vagrant. The scripts will handle everything else.

https://www.youtube.com/watch?v=0ogLoZfYOYs&t=0s

https://github.com/oraclebase/vagrant/tree/master/database/ol8_19


For information:


If there is no need to install Oracle on a specific operating system and the primary goal is to learn Oracle, I recommend installing the database on Oracle Linux. Oracle took the RedHat source code and built its own distribution. The Oracle Linux public repository contains packages that can greatly simplify database installation and additional packages that extend standard capabilities. In addition to all of the above, you can use the customized UEK kernel, which in some cases has some advantages over the standard one. But you need to test your specific application. Links to the Oracle Linux distribution are in the installation topic.


Preparation for Oracle Database Installation:


(Use if the document itself lacks information on how to do this)



Single-Instance Architecture


Installing Oracle Database on Microsoft Windows:




May also be useful:


Installing Oracle Database on Oracle Linux:




Installation using ASM:


ASM is a more “correct” way to prepare the Oracle environment. The idea is that data is stored not on a file system (e.g., ext*) designed for regular operating system operations, but on a file system developed by Oracle specialists for data storage.

“Raw” hard disks without a file system are combined into pools using Oracle tools, which allows them to be organized logically and have (some) advantages over the operating system file system.

This creates an additional Oracle instance, installs GRID, and provides (some) additional capabilities. Administration becomes somewhat more complex.

Personally, I have not had extensive experience working with environments where ASM was used (so I might not know some things), but I have installed (installed, handed over, and forgot) and configured ASM in a RAC environment.

If I understood something incorrectly, please correct me.


Installing Oracle Client:

Oracle Client is needed to connect to the database using a wide range of database management tools, such as PL/SQL Developer, SQL Navigator, TOAD.

Oracle’s SQL Developer can connect without installing Oracle Client.


Instantclient - an alternative to the standard Oracle Client. Simpler to install on Linux (if you need to install a client on Ubuntu, it’s better to use this one). It is a minimal set of libraries for remote connection to the database server. In addition, I usually install the SQLPlus command-line utility. That’s all you really need for normal operation.


Installing Free Oracle Database Editions:


Distributed System Architectures:


DataGuard (Standby)


Real Application Cluster (RAC)


Configs for Oracle autostart using systemd



Streams, GoldenGate

Oracle had a data replication solution between databases called Streams. The big corporation bought a competitor to this technology, one of the leaders in this class of tasks - Golden Gate. I haven’t worked with Streams, but I have configured Golden Gate.