[Oracle DataBase 12.2 Installation on Oracle Linux 7.4]
Last installed using this guide for test tasks on 24.11.2017. (Need to fix the material in kernel parameter settings.)
This document describes one way to install an Oracle database on the Oracle Linux operating system.
Use it if you are just starting to learn the basics of Oracle database administration. If you need to use it in a production environment, be sure to provide backup, multiplexing of critical database files and properly configure system parameters.
If you find errors, inaccuracies, typos, or know better ways, write to the chat or email address.
Latest versions (at the time of writing):
- Oracle Linux - 7.4
- Oracle DataBase - 12.2
Installation is performed on a remote server without GUI.
Management of the installation and configuration process is done from a workstation using an SSH client. On Windows it can be Putty, on Linux a standard Terminal.
Distributions:
This time I took the distributions from the official Oracle website. This is the database and Oracle Linux.
Oracle Linux can be downloaded from linux.oracle.com. Please note that you need to click on the “Download” button, not try to log in. I downloaded the database from oracle.com while logged in as a user. In the new website interface, it’s quite difficult to find what you need.
Creating a VirtualBox virtual machine for database installation:
Installing Oracle Linux 7.4:
Preparing the Linux operating system for Oracle database installation:
- Configuring network interfaces
- Setting OS parameters before starting
- Installing mandatory packages
- Configuring time synchronization services
- Preparing hard disks for database installation
- Configuring system users, system parameter settings
- Creating directory structure and assigning necessary permissions
- Configuring Display Manager
- Copying database distributions to the server
Database installation:
- Installing Oracle DBMS (DataBase Software)
- Creating a remote connection service to the server (Listener)
- Creating a database instance
Post-installation:
- Configuring Oracle autostart after reboot
- Setting FAST RECOVERY AREA parameters
- Creating a backup of the created database (cold backup)
- Updating the database with patches recommended by Oracle (I don't have access to download patches right now. Was demonstrated during Oracle 11 installation)
- Restrict remote connection to the database server by root user
- Allow remote connection to the server via SSH only from specific IP addresses by creating rules in iptables (possible improvement, not described here)
- Block the ability to connect to the server after entering an incorrect password more than 5 times (Fail2ban) (possible improvement, not described here)
Ensuring additional fault tolerance and reliability:
- Multiplexing controlfiles
- Multiplexing redologs
- Enable ARCHIVELOG mode
- Multiplexing archivelog
- Changing data file location
- Extending tablespaces (creating additional files for tablespaces)
- Enable FLASH BACK mode
- Final backup (hot backup)
Connecting to the database from a client computer:
- Installing Oracle Client 12C (32 bit) on Windows 7 (64 bit) (PL/SQL Developer and similar programs do not work with a 64-bit client)