Host Checker for external connectors

Overview

The Host Checker for External Connectors utility performs various checks to ensure Delphix’s Oracle EBS Source and Target environments (hosts) are configured correctly. We recommend using this utility to validate a fresh environment or following an environment’s database upgrade.

  • The scripts provided as part of this automation package are provided as-is and are intended to help you easily check the feasibility of linking and provisioning operations.

  • Although the scripts have been tested by Delphix Continuous Data Engineering, they are not officially supported by Delphix. This means that Delphix is not liable for any bugs or defects in this implementation.

  • You can create or add your own scripts to support implementing the Host Checker for External Connectors operations using the EBS utilities of your choice.

Structure

The Host Checker for External Connectors utility is structured as follows:

  • The utility is designed to be easily extensible, with new checks being added as required.

  • The utility is designed to be easily customizable, with parameters that can be changed to suit specific requirements.

Workflows

The Host Checker for External Connectors utility provides four specific environment workflows:

  • AppsTier - Source

  • AppsTier - Target

  • DbTier - Source

  • DBTier - Target

Prerequisites

  • Linux or Solaris environment

Exclusions For Solaris OS

  1. For Solaris, Delphix will not check the sudoers entries. The utility won't ask if you are running privilege elevation.
    If you are running privilege elevation on Solaris, see the Host requirements section on Requirements for Oracle source databases for linking for required sudoers entries.

  2. Kernel shmmax and shmall values are not being checked for Solaris, see /etc/hosts section on Requirements for Oracle EBS target databases for provisioning for required values.

Instructions

Follow the steps below to run the Host Checker for External Connectors utility. It runs in interactive mode through the command terminal.

  1. Download the Host Checker for External Connectors utility from the Delphix Download Portal.

    1. Find the Host Checker for External Connectors utility under the Utilities section in the Delphix Product Releases > Continuous Data Connectors download page.

  2. Manually copy it to the Source or Target environment you intend to validate.

  3. Extract the zip file and view its contents.

  4. Grant the main.sh file execution permissions using the command: chmod +x main.sh

  5. Run the Host Checker utility using the command: ./main.sh

  6. Follow the terminal prompts to validate your chosen environment.

The following is a sample runtime log from an AppsTier Target Environment: 

[applvis@e27a171at-app ebs-hostchecker]$ ./main.sh
Select the host type:
1. AppsTier
2. dbtier
Enter your choice (1 or 2): 1
Select the AppsTier host type:
1. source
2. target
Enter your choice (1 or 2): 2
Executing checks for AppsTier target host..
Enter the toolkit directory path: /var/tmp
Enter AppsTier target hostname(fqdn): e27a171at-app.dlpxdc.co
Enter dbtier target hostname(fqdn): e27a171at-db.dlpxdc.co
Do you want to use privilege elevation? [y/n]: y
Enter the 'high' privilege user used for privilege elevation in sudoers entries: applvis
Enter the 'low' privilege user used for privilege elevation in sudoers entries: delphix_os
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Current CPU utilization: 2 percent
CPU utilization is below threshold i.e. 80.
###Printing server results###
Server_Configuration | Current_Value | Required_Value
------------------------------------------------------------------------------------------------------
Architecture | x86_64 Linux |
Kernel version | 4.18.0-240.el8.x86_64 |
Total CPU cores on server | 8 cores | Minimum 2 cores
Total memory on server | 32149 MB | Minimum 8GB
Free memory on server | 31805 MB | Minimum 8GB
kernel.shmmax value set on server | 31814338025095168 bytes | 30340517068 bytes
kernel.shmall value set on server | 8291456 Pages | 8230392 pages
------------------------------------------------------------------------------------------------------
For EBS sizing Refer- https://docs.oracle.com/cd/E26401_01/doc.122/e22950/T422699i4773.htm#ebs_sizing
------------------------------------------------------------------------------------------------------
Memory utilization OK.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Checking for expect
found expect utility at - /usr/bin/expect
Checking for ss
found ss utility at - /usr/sbin/ss
Checking for netstat
found netstat at - /usr/bin/netstat
Checking for make
found make at - /usr/bin/make
Checking for ld
found ld at - /usr/bin/ld
Checking for gcc
found gcc at - /usr/bin/gcc
Checking for g++
found g++ at - /usr/bin/g++
Checking for ar
found ar at - /usr/bin/ar
Utility check completed successfully
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Available disk space in toolkit directory: 511817 MB
There is enough disk space in the toolkit directory.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Ping to e27a171at-app.dlpxdc.co succeeded. IP address: 10.110.237.75
Entry for e27a171at-app.dlpxdc.co with IP address 10.110.237.75 exists in /etc/hosts.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Ping to e27a171at-db.dlpxdc.co succeeded. IP address: 10.110.241.161
Entry for e27a171at-db.dlpxdc.co with IP address 10.110.241.161 exists in /etc/hosts.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Checking sudoers file entries. Using : AppsTier_tgt_sudo.sh
Sudoers entry check completed successfully!
Following entries not found in /etc/sudoers:
/bin/su - applvis -c rm -f *updateDSpwd.py,
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Central Inventory location is /u01/oracle/VIS12210/oraInventory
Make sure Oracle installation owners you intend to use have the Oracle Inventory group oinstall as their primary group
Printing members of oinstall group, group id 9999 using /etc/group file
applvis
delphix_os
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
### Beginning ulimit check ###
### Oracle Software Installation Owner Resource Limit Recommended Ranges for Standard Installations ###
-----------------------------------------------------------------------------------------------------------------------------
Resource Shell Limit | Resource | Soft Limit | Hard Limit
-----------------------------------------------------------------------------------------------------------------------------
Open file descriptors | nofile | at least 1024 | at least 65536
Number of processes available to a single user | nproc | at least 2047 | at least 16384
Size of the stack segment of the process | stack | at least 10240 KB| at least 10240 KB, and at most 32768 KB
Maximum locked memory limit | memlock | unlimited | unlimited
-----------------------------------------------------------------------------------------------------------------------------
For EBS sizing, refer to:
Checking Resource Limits for Oracle Software Installation Users
https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/checking-resource-limits-for-oracle-software-installation-users.html#GUID-293874BD-8069-470F-BEBF-A77C06618D5A:~:text=Table%205%2D1%20Oracle%20Software%20Installation%20Owner%20Resource%20Limit%20Recommended%20Ranges%20for%20Standard%20Installations
-----------------------------------------------------------------------------------------------------------------------------
Current system settings:
-----------------------------------------------------------------------------------------------------------------------------
Resource Shell Limit | Resource | Soft Limit | Hard Limit
-----------------------------------------------------------------------------------------------------------------------------
Open file descriptors | nofile | 4096 | 65536
Number of processes available to a single user | nproc | 2047 | 16384
Size of the stack segment of the process | stack | 10240 | 16384
-----------------------------------------------------------------------------------------------------------------------------
Other ulimit settings |
-----------------------------------------------------------------
Resource Shell | Limit |
-----------------------------------------------------------------
max locked memory | 64 in KB |
max memory size | unlimited in KB|
virtual memory | unlimited in KB|
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-----------------------------------------------------------------------------------------------------------------------------
Health checker warnings!
-----------------------------------------------------------------------------------------------------------------------------
Following entries not found in /etc/sudoers:
/bin/su - applvis -c rm -f *updateDSpwd.py,
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------