Quick Start

OracleShellInstall is a one-click automated Oracle Database installation script supporting Oracle 11gR2 through 26ai across 20+ Linux distributions. The script automatically handles OS parameter configuration, dependency installation, user creation, Oracle software installation, and database creation.

3-Step Install

1. Upload packages - Upload OracleShellInstall.sh and Oracle installation media to the /soft directory on your server
2. Configure parameters - Use the Command Generator or manually compose install parameters
3. Execute - Run the generated command as root in the /soft directory

Prerequisites

Directory Structure

Place the following files in the /soft directory:

/soft/
  OracleShellInstall.sh          # Install script
  LINUX.X64_193000_db_home.zip   # Oracle media (19c example)
  p35940989_190000.zip           # PSU/RU patch (optional)
  p35926646_190000.zip           # OJVM patch (optional)
  p6880880_190000.zip            # OPatch (optional, needed for patches)

System Requirements

• Supported OS: CentOS 7/8, RHEL 7/8/9, OracleLinux, Rocky Linux, Anolis OS, openEuler, Kylin, UOS, Ubuntu, Debian, etc.
• Bash version >= 4
• Recommended memory >= 2GB (production >= 8GB)
• Disk space: at least 15GB for Oracle software, data files as per business requirements
• Network: ensure yum/dnf/apt package sources are available, or use local repo (-lrp Y)
• SELinux: the script automatically disables SELinux, no manual action needed
• Firewall: the script automatically disables the firewall; re-configure after installation if needed

Installation Media

Different Oracle versions require different installation media files. Prepare the corresponding packages for your target version. The script automatically identifies ZIP files in the /soft directory.

How It Works

The OracleShellInstall script follows this automated workflow:

Execution Flow

1. Parameter Validation - Validates all input parameters, checks required fields, verifies password format
2. Environment Detection - Identifies OS type and version, detects CPU architecture, checks disk space
3. OS Configuration - Configures hostname, hosts, kernel parameters, resource limits, disables SELinux/firewall, configures NTP
4. Dependency Installation - Automatically configures package sources and installs Oracle-required dependencies
5. User Creation - Creates oracle/grid users and groups (oinstall, dba, asmadmin, etc.), sets environment variables
6. Directory Setup - Creates ORACLE_BASE, ORACLE_HOME directory structure with proper permissions
7. Disk Configuration (ASM/RAC) - Configures ASM disks via UDEV rules or multipath
8. Grid Installation (ASM/RAC) - Extracts and installs Grid Infrastructure, creates ASM disk groups
9. SSH Trust (RAC) - Establishes passwordless SSH between all nodes for root, oracle, and grid users
10. Database Software Install - Extracts Oracle media and runs silent installation
11. Patch Application (optional) - Applies PSU/RU and OJVM patches
12. Database Creation - Creates database instance via DBCA silent mode, creates PDBs if specified
13. Post-Install Config - Configures auto-start, optimizes parameters (if specified), configures HugePages (if specified)

Log Files

Two log files are generated during installation:

• print_shell_install_*.log - Installation summary log with key step results
• shell_install_output_*.log - Detailed output log with all command stdout and stderr

Single Instance Install

Single instance mode uses file system storage, suitable for development, testing, and small-medium business scenarios.

Minimal Install

sh OracleShellInstall.sh \
-install_mode single `# Single instance`\
-lf eth0 `# Public NIC name`

This command uses all defaults: database name orcl, character set AL32UTF8, install directory /u01, data directory /oradata.

Custom Install

sh OracleShellInstall.sh \
-install_mode single `# Single instance`\
-lf eth0 `# Public NIC name`\
-n oracledb `# Hostname`\
-o prod `# Database name`\
-dp 'Passw0rd#' `# DB password`\
-ds ZHS16GBK `# Character set`\
-pdb pdb01,pdb02 `# Create multiple PDBs`\
-opd Y `# Optimize DB params`

Standalone ASM Install

Standalone ASM mode requires Grid Infrastructure and ASM disks. The script automatically configures UDEV disk binding or multipath.

sh OracleShellInstall.sh \
-install_mode standalone `# Standalone ASM`\
-lf eth0 `# Public NIC name`\
-dd /dev/sdb,/dev/sdc `# DATA disks`

Custom ASM Install

sh OracleShellInstall.sh \
-install_mode standalone `# Standalone ASM`\
-lf eth0 `# Public NIC`\
-o prod `# Database name`\
-dp 'Passw0rd#' `# DB password`\
-mp N `# Skip multipath`\
-dd /dev/sdb,/dev/sdc,/dev/sdd `# 3 DATA disks`\
-dn DATADG `# Custom diskgroup name`\
-dr NORMAL `# NORMAL redundancy`\
-gpa 35940989 `# Grid patch`\
-opa 35940989 `# Oracle patch`

RAC Cluster Install

RAC mode runs on the first node. The script automatically configures SSH trust on all nodes, installs Grid, sets up ASM disks, and creates the database.

Basic 2-Node RAC

sh OracleShellInstall.sh \
-install_mode rac `# RAC cluster`\
-lf eth0 `# Public NIC`\
-pf eth1,eth2 `# Heartbeat NICs`\
-n orcl `# Hostname prefix`\
-hn orcl01,orcl02 `# All node hostnames`\
-ri 10.0.0.101,10.0.0.102 `# Public IPs`\
-vi 10.0.0.103,10.0.0.104 `# Virtual IPs`\
-si 10.0.0.105 `# Scan IP`\
-rp 'rootPasswd' `# root password`\
-od /dev/sdb `# OCR disks`\
-dd /dev/sdc `# DATA disks`

Production RAC (with ARCH Diskgroup and Patches)

sh OracleShellInstall.sh \
-install_mode rac `# RAC cluster`\
-lf ens192 `# Public NIC`\
-pf ens224,ens256 `# Dual heartbeat NICs`\
-n dbprod `# Hostname prefix`\
-hn dbprod01,dbprod02 `# Node hostnames`\
-ri 192.168.1.101,192.168.1.102 `# Public IPs`\
-vi 192.168.1.103,192.168.1.104 `# Virtual IPs`\
-si 192.168.1.105 `# Scan IP`\
-rp 'R00t#2024' `# root password`\
-o proddb `# Database name`\
-dp 'Oracle#2024' `# DB password`\
-ds ZHS16GBK `# Character set`\
-od /dev/sdb,/dev/sdc,/dev/sdd `# OCR disks`\
-or NORMAL `# OCR NORMAL redundancy`\
-dd /dev/sde,/dev/sdf,/dev/sdg `# DATA disks`\
-dr NORMAL `# DATA NORMAL redundancy`\
-ad /dev/sdh,/dev/sdi `# ARCH archive disks`\
-ar EXTERNAL `# ARCH redundancy`\
-gpa 35940989 `# Grid patch`\
-opa 35940989 `# Oracle patch`\
-jpa 35926646 `# OJVM patch`\
-opd Y `# Optimize DB params`\
-hf Y `# Configure HugePages`

Common Parameters

ASM Parameters

RAC Parameters

Advanced Usage

Step-by-Step Installation

In some scenarios, you may need to split the installation into separate stages:

OS Configuration Only

sh OracleShellInstall.sh \
-install_mode single \
-lf eth0 \
-m Y `# Only configure OS, do not install Oracle`

Useful when you need to verify OS configuration first or make additional manual adjustments.

Install to DB Software Only

sh OracleShellInstall.sh \
-install_mode single \
-lf eth0 \
-ud Y `# Install to DB software only, no database creation`

Useful when you need to create the database manually (custom templates or special configuration).

RAC Install to Grid Only

sh OracleShellInstall.sh \
-install_mode rac \
-lf eth0 -pf eth1 \
-hn orcl01,orcl02 -ri 10.0.0.101,10.0.0.102 \
-vi 10.0.0.103,10.0.0.104 -si 10.0.0.105 \
-rp 'rootPasswd' -od /dev/sdb -dd /dev/sdc \
-ug Y `# Install to Grid only, no DB installation`

One-Click Patching

Place patch files and OPatch tool in the /soft directory and specify patch IDs via parameters:

/soft/
  OracleShellInstall.sh
  LINUX.X64_193000_db_home.zip     # Oracle media
  p35940989_190000_Linux-x86-64.zip # PSU/RU patch
  p35926646_190000_Linux-x86-64.zip # OJVM patch
  p6880880_190000_Linux-x86-64.zip  # Latest OPatch

Multi-Instance Installation

Pass multiple database names (comma-separated) via the -o parameter to create multiple instances on the same host:

sh OracleShellInstall.sh \
-install_mode single \
-lf eth0 \
-o proddb,testdb `# Create two database instances`

VirtualBox Environment

When installing ASM/RAC in VirtualBox VMs, add the -vbox Y parameter to fix VirtualBox SCSI disk detection issues:

sh OracleShellInstall.sh \
-install_mode standalone \
-lf eth0 \
-dd /dev/sdb \
-vbox Y `# VirtualBox fix`

Post-Install Verification

After installation, verify success with the following checks:

Single/Standalone Verification

Check Listener Status

su - oracle
lsnrctl status

The listener should be in READY state with services registered.

Check Database Status

sqlplus / as sysdba
SELECT instance_name, status FROM v$instance;
SELECT name, open_mode FROM v$database;
SELECT name, open_mode FROM v$pdbs; -- if PDBs exist

Database status should be OPEN, PDB status should be READ WRITE.

Check ASM (Standalone/RAC)

su - grid
asmcmd lsdg

All disk groups should show MOUNTED status with expected free space.

RAC Cluster Verification

Check Cluster Status

su - grid
crsctl stat res -t

All resources should be ONLINE.

Check Cluster Nodes

olsnodes -n
crsctl check cluster -all

Check Scan VIP

srvctl status scan
srvctl status scan_listener
srvctl status database -d proddb

Troubleshooting

General Troubleshooting Steps

1. Check the summary log: cat /soft/print_shell_install_*.log
2. Check the detailed log: cat /soft/shell_install_output_*.log
3. Identify the specific failed step and error message
4. After fixing the issue, re-run with -m Y to skip OS configuration

Common Errors and Solutions

Dependency Package Installation Failure

Symptom: yum/dnf fails to install certain RPM packages.

Solution:

• Check that correct package sources are configured, or use -lrp Y for local repo
• For network repo, set -nrp Y and ensure internet access
• For domestic OS (Kylin, UOS), ensure built-in package sources are complete

ASM Disk Discovery Failure

Symptom: ASM cannot discover disk devices after Grid installation.

Solution:

• Verify disk devices exist: ls -l /dev/sd*
• Confirm disks are not partitioned or mounted: lsblk
• Check if UDEV rules are applied: ls -l /dev/oracleasm/
• For multipath, check configuration: multipath -ll
• VirtualBox environments must use -vbox Y

RAC SSH Trust Failure

Symptom: Cannot establish SSH connection between nodes, "Permission denied" error.

Solution:

• Verify all nodes have the same root password
• Check /etc/ssh/sshd_config allows root login and password authentication
• Confirm network connectivity between all nodes: ping test public and heartbeat IPs

Insufficient Memory for DBCA

Symptom: Database creation fails with insufficient memory or ORA-00845 error.

Solution:

• Ensure available memory >= 2GB
• If HugePages enabled (-hf Y), verify HugePages configuration is correct
• Check that /dev/shm is mounted and adequately sized

OPatch Version Too Old

Symptom: Patching fails with OPatch version incompatibility error.

Solution: Download the latest OPatch tool (p6880880) and place it in the /soft directory. The script automatically replaces the old version.

FAQ

Q: What Oracle installation media formats are supported?

The script automatically recognizes Oracle installation media in ZIP format. Simply place the ZIP file in the /soft directory — no manual extraction needed.

Q: What if the installation is interrupted?

Check the log files print_shell_install_*.log and shell_install_output_*.log to identify the failure. After fixing the issue, use -m Y to skip completed OS configuration steps.

Q: What network requirements exist for RAC installation?

Public and heartbeat networks must be reachable between all nodes. The root password must be the same on all nodes. The script automatically establishes SSH trust.

Q: What are the database password requirements?

The database password (-dp) must start with a letter and can only contain letters, numbers, and the special characters _ # $. Wrap passwords containing special characters in single quotes.

Q: How to filter multipath disks?

Use the -fd parameter to filter multipath disks and get unique device names. For example: -fd /dev/sda excludes the system disk.

Q: Does it support offline installation?

Yes. Use -lrp Y to configure a local package source (requires the OS installation ISO). The script automatically mounts the ISO and configures local yum/dnf repos without internet access.

Q: How to install a second database on an existing Oracle environment?

Use the -o parameter to specify the new database name. The script detects the existing environment and skips completed configuration steps. You can also use -m Y to skip OS configuration entirely.

Q: What OS configurations does the script modify?

The script modifies the following system configurations:

• Hostname and /etc/hosts
• Kernel parameters (/etc/sysctl.conf)
• Resource limits (/etc/security/limits.conf)
• Disables SELinux and firewall
• Creates oracle/grid users and groups
• Configures NTP/Chrony time synchronization
• Sets user environment variables (.bash_profile)

Q: Does it support ARM architecture servers?

Yes. The script automatically detects CPU architecture (x86_64/aarch64) and uses the corresponding installation media and dependencies. Make sure to use the ARM version of Oracle media.

Q: How to uninstall Oracle installed by the script?

The script does not provide an uninstall function. Manual steps: Stop database and listener → Remove Oracle directories → Delete users and groups → Clean up system configurations → Remove /etc/oraInst.loc and /etc/oratab.

Changelog

v5.0.0 (2024-08-22)

• Added Oracle 26ai version support
• Added AFD (ASM Filter Driver) configuration support
• Added GIMR configuration support
• Added more domestic OS support: Huawei openEuler, CMCC NFS, NeoKylin, etc.
• Improved installation log output and progress display
• Enhanced parameter validation logic

v4.2.0 (2024-03-15)

• Added Oracle 21c installation support
• Added Rocky Linux 9, AlmaLinux 9 support
• Added -hf parameter for automatic HugePages configuration
• Improved ARM (aarch64) architecture compatibility
• Fixed dependency installation issues on Ubuntu 22.04

v4.0.0 (2023-09-10)

• Major script architecture refactoring with modular design
• Added Debian/Ubuntu series support
• Added -opd parameter for database parameter optimization
• Added multi-instance installation support (-o orcl1,orcl2)
• Improved multipath and UDEV disk binding logic

v3.5.0 (2023-04-20)

• Added UOS and Kylin V10 support
• Added -nrp parameter for network repository configuration
• Improved RAC SSH trust establishment logic
• Fixed CentOS 8 Stream compatibility issues

v3.0.0 (2022-11-01)

• Added Oracle 19c RAC installation support
• Added automatic ASM disk configuration feature (-adc)
• Added VirtualBox compatibility parameter (-vbox)
• Improved installation log output mechanism