Vertica 3 Node Cluster Upgrade:

n  Before starting with OBR 10.0x Vertica 3 Node Environment upgrade. Please follow the steps mentioned in the Interactive Installation Document to complete Prerequisites and libraries installation

n  Extract OBR 10.20 BITS on to primary or vertica Node 1

n  su – verticadba

n  touch /tmp/verticaUpgrade.log

n  admintools

n  Select Stop Database and click ok

n  Check pmdb and click ok

n  Enter VerticaDBA password

n  Select Proceed and press Enter

n  Once the Database is stopped successfully press ok

n  Select Exit and press enter

n  su root

n  rpm -Uvh --nodeps --nosignature "<OBR10.20BITS_Extracted_path>/packages/vertica-7.2.3.x86_64.rpm"  >> /tmp/verticaUpgrade.log

n  /opt/vertica/sbin/update_vertica --rpm <OBR10.20BITS_Extracted_path>/packages/vertica-7.2.3.x86_64.rpm -u <VERTICADBAUSERNAME> -g <VERTICADBAUSERNAME> --failure-threshold FAIL --accept-eula --license '/opt/HP/BSM/PMDB/config/license/00003169_ITOM_SaaS_100TB.dat' >> /tmp/verticaUpgrade.log

n  rpm -Uvh --nodeps --nosignature "<OBR10.20BITS_Extracted_path>/packages/vertica-8.0.1.rpm"  >> /tmp/verticaUpgrade.log

n  /opt/vertica/sbin/update_vertica --rpm <OBR10.20BITS_Extracted_path>/packages/vertica-8.0.1.rpm -u <VERTICADBAUSERNAME> -g <VERTICADBAUSERNAME> --failure-threshold FAIL --accept-eula --license '/opt/HP/BSM/PMDB/config/license/00003169_ITOM_SaaS_100TB.dat' >> /tmp/verticaUpgrade.log

n  su – verticadba

n  admintools

n  Select start Database & press enter

 

n  Select pmdb & press enter

n  Enter verticadba password and press enter

 

n  One database started successfully click on ok