Step-4: Install Oracle database application binaries

Oracle installer requires sydba privileges to create database and users in it.

This section covers:

Prerequisites of the installation.
Required Oracle patches to install the binaries on a RHEL9 host
Installation of Oracle database application binaries:
- Install Oracle database binaries for Standard Edition: This is the most common installation, in which you install the database binaries for Cohesity-provided Oracle and you have the Standard license. This involves a single instance of Oracle Standard Edition embedded within the NetBackup IT Analytics software and is usually installed on the NetBackup IT Analytics Portal server.
- Install Oracle database binaries for Shared Service Edition: You need to provide your own Oracle license in this deployment.
Installation of Oracle database after installing the Oracle database application binaries.

Prerequisites

Make sure there are no other Oracle database instances installed on the portal server when you check for the following prerequisites:

Current version of the Oracle 19c Installer binaries
Absolute path of the Oracle install location
Absolute path of database install location
Oracle service name
Database server IP

Note:

Ensure you install the latest Oracle patch during the installation. Get the latest patch from the download site if you are performing installation for a Standard Edition. For Shared Service Edition, see Oracle documentation to obtain the latest patch.

Oracle patches required to install the database on RHEL9 host

The following Oracle patches are required to install the Oracle 19c database on a RHEL9 host for both Standard Edition and Shared Edition licenses. Download these four patches from the Cohesity Download Center if Oracle is provided by Cohesity or from Oracle Support Center if you have your own Oracle license. If you download from Cohesity Download Center, these patches are bundled in a single patchset zip file, for example itanalytics_dbinstaller_193000-01_SE2_EE_RH9_oracle_patchset_v1.zip. Unzip this downloaded zip file and extract the four patch files prior to running the installer. Provide the absolute path of the directory containing these Oracle patches wherever prompted by the installer.

patch 35775632 (p35775632_190000_Linux-x86-64.zip)
patch 6880880 by selecting the 19.0.0.0.0 release (p6880880_190000_Linux-x86-64.zip)
19.20 DBRU Patch 35320081 (p35320081_190000_Linux-x86-64.zip)
19.20 DB MLR 35904951 (p35904951_1920000DBRU_Linux-x86-64.zip)

Install Oracle database binaries for Standard Edition

Follow this installation provided you plan to use Cohesity-provided Oracle with NetBackup IT Analytics and you have a Standard edition license.

To install the Oracle database binaries for Standard Edition:

Verify that you have the current version of the Oracle 19c installer binaries.
Login as root on the server where the NetBackup IT Analytics database will be installed. Typically, this is also the Portal server.
Place the ISO image into the /mnt directory.
Mount the ISO image that you downloaded.
```
mkdir /mnt/diskd
```
```
mount -o loop <itanalytics_dbinstaller_XXXXX_XXX_linux.iso> /mnt/diskd
```
Substitute the relevant name of the ISO file that you downloaded in the above command.
Enter the following commands to start the installer:
```
cd /
/mnt/diskd/install_oracle.sh
```

Press Enter to read the entire EULA and the pre-acceptance process will begin.

**************************************************************************
*  NetBackup IT Analytics ORACLE Installer Version 19.3.x.x ()
**************************************************************************
To use this software you must agree to the following terms and
 conditions. Press ENTER to continue:
Enter "accept" to accept these Terms and Conditions

Enter the absolute path of the directory where you want to install Oracle and press Enter.

To install Oracle at the default location (/opt), just press Enter.

Enter the absolute path to install the Oracle 19c database binaries. Ensure minimum 10.00 GB free space is available at the specified location. (Default install location: /opt):

Enter the absolute path of the directory where you want to install Oracle database and press Enter.

To install the database at the default location (/), just press Enter.

Enter the absolute path of the directory where Oracle 19c can create its database files. This directory must have minimum 110 GB free space and must have the ability to expand as required. (Default database location: /):

Enter the Oracle Service name and press Enter.

Enter the Oracle Service name of the Oracle 19c database instance: (default Oracle service name is scdb):

Enter the database server IP and press Enter.

Enter IP Address for your database server: (N.N.N.N):

Verify the details entered for Oracle installation and enter y to continue with the installation.
This step is required only when you are installing the binaries on a RHEL9 host. The installer prompts to download the required Oracle binaries and provide the absolute path of their location as mentioned below. Since this requirement is already covered in the prerequisites of this section, you must have the patches already downloaded.
The following Oracle patches are required to install the database. (Download them from Oracle Support.)
- patch 35775632 (p35775632_190000_Linux-x86-64.zip)
- patch 6880880 by selecting the 19.0.0.0.0 release (p6880880_190000_Linux-x86-64.zip)
- 19.20 DBRU Patch 35320081 (p35320081_190000_Linux-x86-64.zip)
- 19.20 DB MLR 35904951 (p35904951_1920000DBRU_Linux-x86-64.zip)
The aptare user must have write access to the directory where these patches are downloaded. Enter the absolute directory path where these patches are downloaded.

At this step, you can choose to create the database along with the Oracle installation or create it later. Enter y to install the database, or else enter n when the below message is displayed.

Oracle Database xx.x.x is installed. Refer to the Oracle documentation and apply the latest Critical Patch Updates from Oracle.
You can create the database as a part of this installation or create it later using create_itanalytics_database.sh script.
Do you want to create the database as a part of this installation (y/n)?

This completes the Oracle installation. If the Portal database was not created during the above-mentioned Oracle installation, see Create database after Oracle installation. Database creation is essential for the Portal installation to succeed.

Install Oracle database binaries for Shared Service Edition

Follow this installation provided you already have a licensed Oracle database and you plan to use it as NetBackup IT Analytics database.

Prerequisites for the installation:

Download LINUX.X64_193000_db_home.zip from Oracle Download Center.
Standard or Enterprise edition Oracle license.
For the Enterprise Edition license, you must set the environment variable ORACLE_LICENSE_OPTION to EE and export the variable.
```
export ORACLE_LICENSE_OPTION=EE
```

To install the Oracle database binaries for Shared Service Edition:

Verify that you have the current version of the Oracle 19c installer binaries.
Login as root on the server where the NetBackup IT Analytics database will be installed. Typically, this is also the Portal server.
Place the ISO image into the /mnt directory.
Mount the ISO image that you downloaded.
```
mkdir /mnt/diskd
```
```
mount -o loop <itanalytics_dbinstaller_shared-service_linux.iso> /mnt/diskd
```
Substitute the relevant name of the ISO file that you downloaded in the above command.
Enter the following commands to start the installer:
```
cd /
/mnt/diskd/install_oracle.sh
```

Press Enter to read the entire EULA and the pre-acceptance process will begin.

**************************************************************************
*  NetBackup IT Analytics ORACLE Installer Version 19.3.x.x ()
**************************************************************************
To use this software you must agree to the following terms and
 conditions. Press ENTER to continue:
Enter "accept" to accept these Terms and Conditions

Enter the absolute path of the directory where you want to install Oracle and press Enter.

To install Oracle at the default location (/opt), just press Enter.

Enter the absolute path to install the Oracle 19c database binaries. Ensure minimum 10.00 GB free space is available at the specified location. (Default install location: /opt):

Enter the absolute path of the directory where you want to install Oracle database and press Enter.

To install the database at the default location (/), just press Enter.

Enter the absolute path of the directory where Oracle 19c can create its database files. This directory must have minimum 110 GB free space and must have the ability to expand as required. (Default database location: /):

Enter the Oracle Service name press Enter.

Enter the Oracle Service name of the Oracle 19c database instance: (Default Oracle Service name: scdb):

Enter the database server IP and press Enter.

Enter IP Address for your database server: (N.N.N.N):

Verify the details entered for Oracle installation and enter y to continue with the installation.

The following details will be used for Oracle installation. Please verify:
INSTALLATION PATH: /<install-path>
DATABASE DIRECTORY PATH: /
ORACLE SERVICE NAME: scdb
DATABASE IP: N.N.N.N
Continue?  (y/n)

This step is required only when you are installing the binaries on a RHEL9 host. The installer prompts to download the required Oracle binaries and provide the absolute path of their location as mentioned below. Since this requirement is already covered in the prerequisites of this section, you must have the patches already downloaded.
The following Oracle patches are required to install the database. (Download them from Oracle Support.)
- patch 35775632 (p35775632_190000_Linux-x86-64.zip)
- patch 6880880 by selecting the 19.0.0.0.0 release (p6880880_190000_Linux-x86-64.zip)
- 19.20 DBRU Patch 35320081 (p35320081_190000_Linux-x86-64.zip)
- 19.20 DB MLR 35904951 (p35904951_1920000DBRU_Linux-x86-64.zip)
The aptare user must have write access to the directory where these patches are downloaded. Enter the absolute directory path where these patches are downloaded:
Enter the absolute directory path containing the Oracle Universal Installer zip file LINUX.X64_193000_db_home.zip and press Enter
At this step, you can choose to create the database along with the Oracle installation or create it later. Enter y to install the database, or else enter n when the below message is displayed.
```
Oracle Database xx.x.x is installed. Refer to the Oracle documentation and apply the latest Critical Patch Updates from Oracle.
You can create the database as a part of this installation or create it later using create_itanalytics_database.sh script.
Do you want to create the database as a part of this installation (y/n)?
```
This completes the Oracle installation in a shared environment. If the Portal database was not created during the above-mentioned Oracle installation, see Create database after Oracle installation below. Database creation is essential for the Portal installation to succeed.

Create database after Oracle installation

To create database after installing Oracle for Standard or Shared Edition:

Logon to the Oracle server with your Oracle credentials and run these commands:
```
su - <oracle-user>
```
For example: su - aptare
```
/mnt/diskd/create_itanalytics_database.sh
```

Type continue and press Enter when you see the below message.

WARNING. WARNING. WARNING. 
WARNING. WARNING. WARNING. 
WARNING. WARNING. WARNING.
By continuing this script you will be COMPLETELY ERASING YOUR ENTIRE IT Analytics database. ARE YOU ABSOLUTELY SURE that you wish to continue (type the word \continue\ to proceed) ?

Database is created on the Oracle server.

Step-4: Install Oracle database application binaries

Feedback

Feedback