Step-3: Portal and database prerequisites
Choose a Portal Server. Install the IT Analytics Portal software on its own, dedicated server. For performance reasons, the IT Analytics Portal software must not be installed on the same server as the Data Collector. Root privileges are required for the Portal software installation tasks.
For new Portal installations, the minimum server memory requirement is 64 GB. Oracle database requires a minimum of 24 GB of memory. Portal installations will fail if sufficient memory resources are not available on the Portal server.
The Oracle server has the following memory requirements:
Total physical memory (physical + virtual) must be greater than 64 GB, otherwise Oracle will fail to start. Add more physical memory to the Portal server.
Total temporary file system (tmpfs) memory must be 24 GB or greater, otherwise Oracle will fail to start. Increase the size of tmpfs, typically in
/etc/fstab.Shared memory (kernel.shmmax parameter) must be 24 GB or greater, otherwise Oracle will fail to start. Increase the value of the shmmax parameter, typically in /etc/sysctl.conf. After increasing the value for the shmmax parameter, execute: sysctl -p.
Swap space of minimum 16 GB must be created.
Note:
If you need to install Oracle or the IT Analytics portal with less than the default memory requirements, you can copy the
config.shfile inside the ISO mount path to the local system, edit it appropriately, and then pass the absolute path ofconfig.shto the installer script with -C option.Example:
<Installer_script> -C <path of config.sh> Itanalyticsinstaller.sh -C /tmp/config.sh
The parameters that you can modify are:
ORACLEMEMORYTARGET= for Oracle installation.
PORTALMEMORYTARGET= for portal installation.
SPLITPORTALMEMORYTARGET= for split portal installation.
Verify the OS of the Portal Server. Check that the OS is one of the certified operating systems listed in the Certified Configurations Guide.
Verify that sufficient disk space exists on the designated Portal Server. For the database file systems, the amount specified is the minimum to create the database. The database grows in size over the period of time. The growth of database dependents on various factors such as subsystems from which data is collected, type of systems collecting data from, retention periods for data(which is configurable), and so on.
IT Analytics supports installation of binaries and database files at custom locations on the file system. By default, the binaries are installed under
/optand the database files are created under/data01through/data06folders. If you choose to install at the default path, the file system space requirements must be as below.File
System/
Directory
Minimum
Disk Space
Recommended Disk Space
Maximum Disk Space for DB Growth
Notes
/opt
50 GiB
100 GB
200 GB
/tmp
5 GiB
10 GiB
20 GiB
Both /tmp and /var/tmp must be writable by the user aptare and /tmp must not be mounted with noexec option.
/data01
50 GiB
100 GiB
750 GiB
Required for data and index tablespaces.
/data02
50 GiB
100 GiB
750 GiB
Required for data and index tablespaces.
/data03
90 GiB
250 GiB
1800 GiB
Required for data and index tablespaces.
/data04
200 GiB
200 GiB
300 GiB
Temporary table space.
/data05
60 GiB
60 GiB
60 GiB
Temporary table space (undo log).
/data06
10 GiB
10 GiB
10 GiB
Temporary table space (redo log).
If you choose to install at a custom path, the file and space requirements are as below:
File
System/
Directory
Minimum
Disk Space
Recommended Disk Space
Maximum Disk Space for DB Growth
Notes
<install_path>
(custom install path of the Portal)
50 GiB
100 GiB
200 GiB
/tmp
5 GiB
10 GiB
20 GiB
Both /tmp and /var/tmp must be writable by the user aptare and /tmp must not be mounted with noexec option.
<install_path>
(custom install path of the database)
305 GiB
565 GiB
3445 GiB
If you choose to install a custom path with Split Architecture, the file and space requirements are as below:
File
System/
Directory
Minimum
Disk Space
Recommended Disk Space
Maximum Disk Space for DB Growth
Notes
/opt/aptare (install_path for oracle on Database server)
50 GiB
100 GiB
200 GiB
/opt (install_path for Portal on Portal server)
30 GiB
50 GiB
50 GiB
/tmp
2 GiB
2 GiB
10 GiB
Both /tmp and /var/tmp must be writable by the user aptare and /tmp must not be mounted with noexec option.
/data01
/data02
/data03
/data04
/data05
/data06
300 GiB
560 GiB
3400 GiB
dbf files are created here.
Review third-party software details.
If you plan to export or email reports as PDF files, to ensure proper rendering of these output formats, a graphics manager such as X Virtual Frame Buffer (Xvfb) is required. Contact your IT organization to configure this capability. See Configure X Virtual Frame Buffer (Xvfb).
Verify the rpm fontconfig is installed. This is required for the Portal installer. Fontconfig is a library designed to provide system-wide font configuration, customization and application access. If the rpm fontconfig is not installed, exporting reports to XLS and PDF formats will fail.
If the Portal system is having low entropy, it can affect the performance of cryptographic functions and such steps can take considerable amount of time to complete. You can identify the entropy level of the system from the content of the
/proc/sys/kernel/random/entropy_availfile using command # cat /proc/sys/kernel/random/entropy_avail. If this value is not more than 400 consistently, install the rng-tools and start the services as described below on the Portal system.For RHEL or OEL:
Access the command prompt.
Install the rng-tools.
yum install rng-tools
Start the services.
systemctl start rngd
Enable the services.
systemctl enable rngd
For SUSE:
Access the command prompt.
Install the rng-tools.
zypper install rng-tools
Start the services.
systemctl start rng-tools
Enable the services.
systemctl enable rng-tools
Verify that the necessary rpms exist on your system based on the OS.
For RHEL 9, use the following command:
rpm -q bc binutils compat-openssl11 elfutils-libelf fontconfig gcc glibc glibc-devel ksh libaio libasan liblsan libX11 libXau libXi libXrender libXtst libxcrypt-compat libgcc libibverbs libnsl librdmacm libstdc++ libxcb libvirt-libs make policycoreutils policycoreutils-python-utils smartmontools sysstat perl-TermReadKey perl-English-1.11-480.el9.noarch --qf '%{name}.%{arch}\n'|sortThe command returns:
bc.x86_64 binutils.x86_64 compat-openssl11.x86_64 elfutils-libelf.x86_64 fontconfig.x86_64 gcc.x86_64 glibc-devel.x86_64 glibc.x86_64 ksh.x86_64 libaio.x86_64 libasan.x86_64 libgcc.x86_64 libibverbs.x86_64 liblsan.x86_64 libnsl.x86_64 librdmacm.x86_64 libstdc++.x86_64 libvirt-libs.x86_64 libX11.x86_64 libXau.x86_64 libxcb.x86_64 libxcrypt-compat.x86_64 libXi.x86_64 libXrender.x86_64 libXtst.x86_64 make.x86_64 perl-English.noarch perl-TermReadKey.x86_64 policycoreutils-python-utils.noarch policycoreutils.x86_64. smartmontools.x86_64 sysstat.x86_64
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 4 patches from the Veritas Download Center if Oracle is provided by Veritas or from Oracle Support Center if you have your own Oracle license.
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)
For RHEL 8, use the following command:
rpm -q perl-TermReadKey perl-Data-Dumper binutils glibc libaio elfutils-libelf perl-Getopt-Long binutils gcc gcc-c++ glibc-devel ksh libaio-devel libgcc libstdc++ libXtst libXrender libstdc++-devel sysstat psmisc bc make libnsl.x86_64 --qf '%{name}.%{arch}\n'|sortThe command returns:
bc.x86_64 binutils.x86_64 elfutils-libelf.x86_64 gcc-c++.x86_64 gcc.x86_64 glibc-devel.x86_64 glibc.x86_64 ksh.x86_64 libaio-devel.x86_64 libaio.x86_64 libgcc.x86_64 libnsl.x86_64 libstdc++-devel.x86_64 libstdc++.x86_64 libXtst.x86_64 libXrender.x86_64 make.x86_64 perl-Data-Dumper.x86_64 perl-Getopt-Long.noarch perl-TermReadKey.x86_64 psmisc.x86_64 sysstat.x86_64 unzip
For SLES 12 Linux Enterprise, use the following command:
rpm -q perl-Term-ReadKey bc binutils glibc glibc-devel libXau6 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libgcc_s1 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libaio-devel libaio1 libXrender1 make mksh pixz rdma-core smartmontools sysstat xorg-x11-libs xz unzip libX11-6 libelf-devel libjpeg-turbo libjpeg62 libjpeg62-turbo --qf '%{name}.%{arch}\n'|sortFor SLES 15 Linux Enterprise, user the following command:
rpm -q perl-Term-ReadKey bc binutils glibc glibc-devel libXau6 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libgcc_s1 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libaio-devel libaio1 libXrender1 make mksh pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz unzip insserv-compat libX11-6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libelf1 libjpeg8 libgfortran4 compat-libpthread-nonshared --qf '%{name}.%{arch}\n'|sort
Download the application binaries for both the Oracle Database Installer and the Portal Installer from www.veritas.com. Use the instructions provided in the confirmation of your purchase agreement.
Troubleshooting User Account Creation: The Portal installation process will create user accounts for Oracle, Portal, Apache and Tomcat. If you are using non-local user management (such as LDAP or NIS) to manage the Linux user accounts, the useradd command may fail to execute successfully. Take the following steps to manually pre-create the required users:
Using your normal process of creating user accounts in LDAP, pre-create the user accounts aptare and tomcat with home directories under /home.
Application component
User ID
Primary Group
Supplementary Groups
ORACLE
aptare
aptare
dba
TOMCAT
tomcat
tomcat
aptare
APACHE
apache
apache
PORTAL
aptare
aptare
Note:
You can customize these user group names or create them in advance according to your organization's user management policy. Copy the
config.shfile inside the ISO mount path to the local system, edit it appropriately, and then pass the absolute path of config.sh to the installer script with -C option.Example:
<Installer_script> -C <path of config.sh> Itanalyticsinstaller.sh -C /tmp/config.sh
Some environments, particularly virtualized ones, using automount, will fail to create the home directories when the useradd command is used. In this situation, manually create the /home/aptare and /home/tomcat directories and chown them to aptare and tomcat respectively.
Verify that the users, groups, permissions, and home directory paths match the values listed in the table above before proceeding.
Considerations:
The Tomcat user name and Tomcat primary group name must be identical, and the Tomcat supplementary group name must match with Oracle primary group.
The Oracle user name and Oracle primary group name must be identical.
The Portal user name must match the Oracle user name, and the Portal primary group name must match the Portal user name.
In modern Linux distributions and some other Unix systems, it is a standard and a recommended practice to have a default primary group created with the same name as the user. This is known as the User Private Group (UPG) scheme. This practice, while not a universal original UNIX standard, is practically a standard in the Linux world (used by default on systems like Red Hat, Debian, and Arch Linux) for several key reasons, such as:
Enhanced security
Simplified group collaboration
Flexibility
Troubleshooting script issues: A known issue associated with Security Enhanced Linux (SELinux) may arise when executing scripts that require Java. This results in a permission denied error message. To resolve this issue, configure SELinux to allow the use of shared libraries with text relocation.
The installer expects the SELinux configuration to be either disabled or permissive.
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.