All about oracle-database-preinstall-19c (Oracle Linux 8, 7)

Installing oracle-database-preinstall-19c RPM

This document outlines the process for downloading and installing the oracle-database-preinstall-19c RPM package, and explains its effects on your Oracle Linux system.

1. How to Download

The oracle-database-preinstall-19c RPM is available directly from Oracle's YUM repositories. Choose the correct link based on your Oracle Linux version:

• For Oracle Linux 8 (OEL8): https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm

• For Oracle Linux 7 (OEL7 - Latest): https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm

• For Oracle Linux 7 (OEL7 - Older Version): https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

To download the RPM: You can use wget or curl directly from your Linux server. For example, for OEL8:

Bash

wget https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm

Note: It's generally recommended to use yum install oracle-database-preinstall-19c (or dnf install on OL8) as it will automatically download the correct version and handle dependencies.

2. How to Install

Once downloaded, you can install the RPM package using the yum (or dnf on OL8) command as root.

Command:

Bash

sudo yum install oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm
# Replace the RPM filename with the one you downloaded for your specific OS version.

Using yum directly (recommended for dependency resolution):

Bash

sudo yum install oracle-database-preinstall-19c
# Or on OL8:
sudo dnf install oracle-database-preinstall-19c

To verify installation:

Bash

rpm -qa | grep oracle-database-preinstall-19c

(Note: The command rpm -qa oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm you provided would only work if the full filename matches exactly and is not the standard way to query all installed packages containing a string.)

3. What it Will Do

The oracle-database-preinstall-19c RPM automates many of the prerequisite configurations required for Oracle Database 19c installation:

• Create an oracle user: A dedicated operating system user named oracle is created for database administration.
• Create groups: Essential OS groups such as oinstall, dba, backupdba, dgdba, kmdba, and racdba are created.
• Update kernel parameters: System kernel parameters (e.g., shmmax, shmall, semaphores, file-max, ip_local_port_range) are adjusted to recommended values for Oracle Database.
• Install dependencies: Installs various dependent packages required by Oracle Database.

4. What Happens if Existing User/Group Exists?

The preinstall RPM is designed to handle existing configurations gracefully:

• Existing oracle user: If an oracle user already exists, the RPM will ignore its creation. It will not modify the existing user's home directory, UID, or primary group unless specifically necessary for group membership.
• Existing groups: If any of the required groups (e.g., oinstall, dba) already exist, the RPM will add the oracle user to these groups if they are not already members. It will not recreate or modify the GIDs of existing groups. New required groups that don't exist will be created.
• Kernel parameters: The RPM will replace existing kernel parameters (typically found in /etc/sysctl.conf or a file under /etc/sysctl.d/) with the recommended values for Oracle Database 19c. It's crucial to review these changes if you have custom kernel parameter settings.

orainstRoot and ROOT.SH after the Installation

orainstRoot.sh needs to be run to change the Permissions and groupname to 770 and to dba.

Root.sh (ORACLE_HOME) location needs to be run to create a ORATAB in /etc/oratab or /opt/var/oratab in Solaris and to copy dbhome, oraenv and coraenv to /usr/local/bin.

orainstRoot.sh

[root@oracle11g ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory to 770.

Changing groupname of /u01/app/oraInventory to dba.

The execution of the script is complete

root.sh

[root@oracle11g ~]# /u01/app/oracle/product/11.1.0/db_1/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

Creation of Physical standby DB

alter database create standby controlfile as '/orcl/oradata/PROD2/ctrl_PROD_01.ctl';

$ rman target /
RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT ‘/backup/%d_%s_%T_CONTROL_STDBY’ ;

Export ORACLE_SID=standby_db

rman target sys/passwd@Primary_db auxiliary /

run {
allocate auxiliary channel c1 type disk;
allocate auxiliary channel c2 type disk;
allocate auxiliary channel c3 type disk;
allocate auxiliary channel c4 type disk;
allocate auxiliary channel c5 type disk;
allocate auxiliary channel c6 type disk;
DUPLICATE TARGET DATABASE FOR STANDBY;
}

Kernel Parameters

Parameter	Command
semmsl, semmns, semopm, and semmni	# /sbin/sysctl -a | grep semThis command displays the value of the semaphore parameters in the order listed.
shmall, shmmax, and shmmni	# /sbin/sysctl -a | grep shm
file-max	# /sbin/sysctl -a | grep file-max
ip_local_port_range	# /sbin/sysctl -a | grep ip_local_port_range



/etc/sysctl.conf 

/sbin/sysctl -p