Task 3: Install Oracle database application binaries (Linux)

This section covers the prerequisites and installation of Oracle database application binaries for both shared service edition and non-shared service edition. Typically, the Oracle Database application binaries are installed on the same server as the Portal binaries.

Prerequisites

Typically, the Oracle Database application binaries are installed on the same server as the Portal binaries. Some OS-specific basic requirements are listed below for quick reference. Detailed prerequisites are described under Pre-installation configuration section of the IT Analytics Portal Install and Upgrade Guide for Linux and Windows respectively.

Identify the portal server.
Ensure the OS on the portal server is certified according to the IT Analytics Certified Configuration Guide and has sufficient disk space.
Ensure the third-party software as specified under Supported third-party and open-source products are available on the server.
Ensure the fontconfig rpm and other OS-specific (RHEL 7,8; CENTOS 7; or SUSE Linux Enterprise) rpms are available on the server.
Ensure ports 80/tcp, 8011, and 8017 are open in the firewall for proper functioning of the portal.
Ensure that either ss or netstat command is available on the system.

Also, refer the instructions provided with your purchase agreement confirmation email and consult Veritas Support for additional assistance.

Install Oracle database binaries for shared service edition:

Prerequisites for the installation of Oracle database binaries for the shared service edition:

For an installer-based deployment, download LINUX.X64_193000_db_home.zip from Oracle Download Center.
Obtain a Standard or Enterprise edition license.
For an Enterprise edition license, set the environment veriable ORACLE_LICENSE_OPTION to EE.
```
# export ORACLE_LICENSE_OPTION=EE
```

Install Oracle database binaries for shared service edition:

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 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
```
where you substitute the relevant name of the ISO file that you downloaded.
Enter the following commands to start the installer:
```
cd /
/mnt/diskd/install_oracle.sh
```
The command copies the Oracle binaries into /opt/aptare/oracle.

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

This takes 3-5 minutes to complete, as it installs files into /opt/aptare/oracle19c.

A complete log of this session is in this file /opt/aptare/logs/install/install_oracle_xxxxxxxxxxxxxxxxxxxxx.log
**************************************************************************
*  IT Analytics ORACLE Installer Version 19.3.0.0.0 (xxxxxxxxxxxxx)
**************************************************************************
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: accept
Creating group aptare ...groupadd: group 'aptare' already exists
Done.
Creating group dba ...groupadd: group 'dba' already exists
Done.
Adding user aptare to group dba ...Done.
Adding user aptare to group dba ...Done.

This Oracle database installer requires Oracle Database 19c zip "LINUX.X64_193000_db_home.zip" to be available on this system. 
Enter the absolute directory path containing the Oracle Universal Installer zip file:/tmp/oracle_zip/
Creating ORACLE_HOME directory in /opt/aptare/oracle ... Done.
Creating ORACLE_HOME/logs directory ...
Setting up IT Analytics database directories 
/data01 /data02 /data03 /data04 /data05 /data06 ...Done.

Installing Oracle binaries in /opt/aptare/oracle ...
Extracting files ... 
This process may take 3-5 minutes to complete ... Done.
.
.
   creating: 31281355/etc/config/
  inflating: 31281355/etc/config/actions.xml
  inflating: 31281355/etc/config/inventory.xml
  inflating: 31281355/README.html
  inflating: PatchSearch.xml
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs
                    /opatch/opatchxxxxxxxxxxxxxxx.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   31281355

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this 
ORACLE_HOME on the local system.
(Oracle Home = '/opt/aptare/oracle')


Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '31281355' to OH '/opt/aptare/oracle'


Done.

A complete log of this session can be found at
 /opt/aptare/logs/install/install_oracle_xxxxxxxxxxxxxxxxx.log

Oracle patches required to install the database on RHEL9 host

The following Oracle patches are required to install the binaries on a RHEL9 host. To download these 4 patches, login to the Oracle support site, click Patches and update. Wherever prompted by the installer, provide the absolute directory path of the folder containing these Oracle patches.

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)

Task 3: Install Oracle database application binaries (Linux)

Feedback

Feedback