Vertica Database won't start

Article Id: 102344

Status: Published

Updated On: 12-03-2019 08:24

Products:

CA Infrastructure Management , CA Infrastructure Management , CA Performance Management - Usage and Administration , CA Performance Management - Data Polling

Issue/Introduction:

Found the following errors in the dbLog (/catalog/drdata/dbLog) when trying to start Vertica database.

ERROR: Host does not meet minimum requirements: Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.
ERROR: Host does not meet minimum requirements: Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.
ERROR: Host does not meet minimum requirements: Not enough open file handles allowed (1024 available/32768 required); see 'ulimit -n'.

Environment:

Release:
Component: IMSTOR

Resolution:

Edit the file /etc/ssh/sshd_config and make sure UsePAM is set to yes example below:

# Set this to 'yes' to enable PAM authentication, account processing,
# and session processing. If this is enabled, PAM authentication will
# be allowed through the ChallengeResponseAuthentication and
# PasswordAuthentication. Depending on your PAM configuration,
# PAM authentication via ChallengeResponseAuthentication may bypass
# the setting of "PermitRootLogin without-password".
# If you just want the PAM account and session checks to run without
# PAM authentication, then enable this but set PasswordAuthentication
# and ChallengeResponseAuthentication to 'no'.
#UsePAM no
UsePAM yes

Do this on all nodes

The restart sshd
service sshd restart

Start the database using admintools.