Installing Oracle DataBase Server 11.2.0.3.2 on Oracle Linux 6.3 x86_64
Warning Due to the time change by our "Government". The time on the server may still use the old rules. In some cases, Enterprise Manager does not work correctly because of this. This is fixed by patches that can be downloaded by those with access to Oracle support. I currently do not have this capability. If someone provides them, I will attach the patches to the topic. At the time of writing the article, there was no such problem, and I had access to Oracle support. The problem is fixed by the patch with the code name DST v23.
This document describes one of the ways to install an Oracle database on Oracle Linux.
It should be used if you are just starting to learn the basics of Oracle database administration. If you need to use it in a production environment, you must ensure backup, multiplexing of critical database files, and properly configure system parameters.
If you find errors, inaccuracies, typos, or know better methods, write to the chat or email.
Latest versions (at the time of writing):
- Oracle Linux - 6.3 (better install 6.7)
- Oracle DataBase - 11.2.0.3 (better install 11.2.0.4)
Installation is performed on a remote server without GUI.
The installation and configuration process is managed from a Windows workstation with putty and xming installed.
Commands are executed on the server via the putty console. Xming is needed to display graphical images.
Documentation:
Distributions:
Preparing the Linux Operating System for Oracle Database Installation:
- Setting Some Operating System Parameters
- Configuring Network Interfaces
- Installing Mandatory Packages
- Setting Up Accurate Time
- Preparing Disks for Database Installation
- Configuring System Users and System Parameters
- Autostart Only Selected Programs
- Creating Directory Structure and Setting Necessary Permissions
- Copying Database Distributions to the Server
Database Installation:
- Installing Oracle DBMS (DataBase SoftWare)
- Creating Remote Server Connection Service (Listener)
- Creating a Database Instance
After Installation:
- Configuring Oracle Autostart After Reboot
- Creating a Backup of the Created Database (Cold Backup)
- Updating the Database with Oracle Recommended Patches
- Disable Remote Root Login to the Database Server
Ensuring Additional Fault Tolerance and Reliability:
- Multiplexing Controlfiles
- Multiplexing Redologs
- Enable ARCHIVELOG Mode
- Multiplexing Archivelogs
- Extending Tablespaces (Creating Additional Files for Tablespaces)
- Enable FLASH BACK Mode
- Final Backup (Hot Backup)