Instalación Oracle Linux 9 + Grid Infrastructure + Database 19.26

Antecedentes

Guía de instalación en Oracle Linux 9 para:

  • Grid Infrastructure Single Node (Oracle Restart)
  • Oracle Database 19c RU 19.26

Requisitos de Infraestructura

  • 1 máquina con Oracle Linux 9
  • 4 discos:

Disco 1 → SO (100G)   → Todo en /
Disco 2 → /u01 (100G)
Disco 3 → DATA01 (100G)
Disco 4 → FRA01 (200G)

Software Requerido


database_193_V982063-01.zip
grid_193_V982068-01.zip
1929_DB_p38291812_190000_Linux-x86-64.zip
1929_GRID_p38298204_190000_Linux-x86-64.zip
oracleasmlib-3.1.1-1.el9.x86_64.rpm
p6880880_190000_Linux-x86-64.zip

1. Configuración Inicial del Sistema

Deshabilitar SELinux

setenforce 0

Editar:

/etc/selinux/config
SELINUX=permissive

Configurar /etc/hosts


192.168.122.10  19cgrid 19cgrid.polluxdata.local

Instalar paquete preinstall

dnf install oracle-database-preinstall-19c

2. Configuración de /u01 (LVM)


parted /dev/vda --script mklabel gpt
parted /dev/vda --script mkpart primary 0% 100%
parted /dev/vda --script set 1 lvm on

pvcreate /dev/vda1
vgcreate vg_u01 /dev/vda1
lvcreate -n lv_u01 -l 100%FREE vg_u01

mkfs.xfs /dev/vg_u01/lv_u01
mkdir /u01
mount /dev/vg_u01/lv_u01 /u01

Agregar en /etc/fstab usando UUID.


3. Instalación ASMLIB


dnf config-manager --enable ol9_addons
dnf install oracleasm-support
dnf install oracleasmlib-3.1.1-1.el9.x86_64.rpm

Inicializar:

oracleasm configure -i

4. Preparación Discos ASM

Crear particiones


parted /dev/vdc --script mklabel gpt
parted /dev/vdc --script mkpart primary 0% 100%

parted /dev/vdd --script mklabel gpt
parted /dev/vdd --script mkpart primary 0% 100%

Etiquetar discos


oracleasm createdisk DATA01 /dev/vdc1
oracleasm createdisk FRA01  /dev/vdd1
oracleasm listdisks

5. Instalación Grid Infrastructure (19.26)

Variables grid


export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/19.0.0/grid
export ORACLE_SID=+ASM
export CV_ASSUME_DISTID=OL9

Instalación silenciosa aplicando RU


./gridSetup.sh -silent \
-responseFile /home/grid/grid_silent.rsp \
-applyRU /home/grid/p38298204_190000/38298204 \
-waitforcompletion \
-ignorePrereqFailure

Validar:

crsctl stat res -t

6. Crear Diskgroup FRA


sqlplus "/ as sysasm"

CREATE DISKGROUP FRA
EXTERNAL REDUNDANCY
DISK 'ORCL:FRA01';

7. Instalación Oracle Database 19.26

Variables oracle


export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
export ORACLE_SID=CDB1
export CV_ASSUME_DISTID=OEL8

Instalación Software Only con RU


./runInstaller -silent -waitforcompletion \
-applyRU /home/oracle/p38291812_190000/38291812 \
oracle.install.option=INSTALL_DB_SWONLY \
oracle.install.db.InstallEdition=EE \
DECLINE_SECURITY_UPDATES=true

8. Creación de Base de Datos


dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname cdb1 \
-sid CDB1 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName FJA1 \
-storageType ASM \
-datafileDestination "+DATA" \
-recoveryAreaDestination "+FRA" \
-characterset AL32UTF8

Notas

  • La base queda en NOARCHIVELOG por defecto.
  • Configurar ARCHIVELOG según requerimientos.
  • Validar RU aplicado con opatch lsinventory.