My Experiments With Oracle


HP Vertica – an analytic database management software – Installation

Posted by sriram on November 5, 2013


The grid-based, column-oriented, Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The product claims to drastically improve query performance over traditional relational database systems, provide high-availability, and petabyte scalability on commodity enterprise servers.

Its design features include:

  • Column-oriented storage organization, which increases performance of sequential record access at the expense of common transactional operations such as single record retrieval, updates, and deletes.[6]
  • Standard SQL interface with many analytics capabilities built-in, such as time series gap filing/interpolation, event-based windowing and sessionization, pattern matching, event series joins, statistical computation (e.g., regression analysis), and geospatial analysis.
  • Out-of-place updates and hybrid storage organization, which increase the performance of queries, insertions, and loads, but at the expense of updates and deletes.
  • Compression, which reduces storage costs and I/O bandwidth. High compression is possible because columns of homogeneous datatype are stored together and because updates to the main store are batched.[7]
  • Shared nothing architecture, which reduces system contention for shared resources and allows gradual degradation of performance in the face of hardware failure.
  • Easy to use and maintain through automated data replication, server recovery, query optimization, and storage optimization.
  • Support for standard programming interfaces ODBCJDBC, and ADO.NET.

Key Features of the Vertica Analytics Platform

Today ..I am going to install  HP vertica  On one of my test server……

A proper & complete Installation guide can be found @

Lets Download and install vertica from  on  RHEL5 64 Bit

[root@sriram ~]# rpm – iv /media/20131105_1301/vertica-6.1.3-0.x86_64.RHEL5.rpm
Preparing packages for installation…

Vertica Analytic Database V6.1.3-0 successfully installed on host sriram.localdomain

Important Information
If you are upgrading from a previous version, you must backup your database before
continuing with this install. After restarting your database, you will be unable
to revert to a previous version of the software.

To download the latest Vertica documentation in zip or tar format please visit the
myvertica web site.

To complete installation and configuration of the cluster,
run: /opt/vertica/sbin/install_vertica

[root@sriram ~]# /opt/vertica/sbin/install_vertica

Vertica Analytic Database 6.1.3-0 Installation Tool
Upgrading admintools meta data format..
scanning /opt/vertica/config/users
WARNING: No hostname list provided. Installing to localhost
Starting installation tasks…
Getting system information for cluster (this may take a while)….
backing up admintools.conf on
Default shell on nodes: /bin/bash
Checking/fixing OS parameters…..

Setting vm.min_free_kbytes to 51200 …
Info! The maximum number of open file descriptors is less than 65536
Setting open filehandle limit to 65536 …
Info! The session setting of is not set in /etc/pam.d/su
Setting session of in /etc/pam.d/su …
Info! Parameter vm.max_map_count is less than 253086
Setting vm.max_map_count to 253086 …
Detected cpufreq module loaded on
CPU frequency scaling is enabled. This may adversely affect the performance of your database.
Vertica recommends that cpu frequency scaling be turned off or set to ‘performance’

Creating/Checking Vertica DBA group

Creating/Checking Vertica DBA user

Password for dbadmin:
Installing/Repairing SSH keys for dbadmin

Creating Vertica Data Directory…

Updating spread configuration…
Verifying spread configuration on whole cluster.
Creating node node0001 definition for host
… Done
Error Monitor 0 errors 2 warnings
Installation completed with warnings.
Installation complete.

To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu

** The installation modified the group privileges for dbadmin.
If you used sudo to install vertica as dbadmin, you will
need to logout and login again before the privileges are applied.

[root@sriram ~]#

To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu

Now login as dbadmin and accept the license agreement ! Once after that now a window  will appear, using which  you can create & configure Vertica DB.


After Database creation you can see the below Interactive window for Regular operations !



You can See the documentation Guide @

Thanks for reading this ! 

Sriram Sanka|Sr.Oracle DBA


10 Responses to “HP Vertica – an analytic database management software – Installation”

  1. I blog frequently and I genuinely thank you for your content.
    Your article has truly peaked my interest. I will take a note of your blog
    and keep checking for new information about once a
    week. I subscribed to your RSS feed too.

  2. This will Pass

    My brother recommended I may like this web site. He was once totally right. This post actually made my day. You cann’t believe simply how much time I had spent for this information! Thank you!

  3. I’ve got be shown a very few good items here. Definitely worthy of social bookmarking with regard to revisiting. I wonder exactly how a great deal of effort you set to generate such a good helpful site.

  4. HP Vertica – an analytic database management software – Installation «

  5. HP Vertica – an analytic database management software – Installation «

  6. torrent said

    I haven’t checked in here for a while because I thought it was getting boring, but the last few posts are good quality so I guess I will add you back to my daily bloglist. You deserve it friend 🙂

  7. Hey! I’m at work surfing around your blog from my
    new iphone 4! Just wanted to say I love reading your blog and
    look forward to all your posts! Keep up the excellent work!

  8. Wow, that’s what I was looking for, what a material! present here at this
    web site, thanks admin of this site.

  9. Excellent read, I just passed this onto a colleague who was doing some research on that. And he just bought me lunch since I found it for him smile So let me rephrase that: Thank you for lunch!

  10. data loss said

    Your means of explaining all in this article is really pleasant, every one be capable of effortlessly understand it,
    Thanks a lot.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Oracle DBA's Daily Work

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Anand's Blog

My experiences and views on Oracle Database

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

OraExpert Academy

Consulting and Training


The Ramblings and Ravings Of Author Jason A. Rust

So Many Oracle Manuals, So Little Time

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them! I'll have a long beard by the time I read them”—Lobel, Arnold. Whiskers and Rhymes. William Morrow & Co, 1988.


Oracle databases, storage and the high-performance world of flash memory


The thoughts of Jason Arneil

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting


Dominic Brooks on Oracle Performance, Tuning, Data Quality & Sensible Design ... (Now with added Sets Appeal)

Martins Blog

Trying to explain complex things in simple terms

Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Talip Hakan Ozturk's ORACLE BLOG

The secret of success is at your fingertips!...

Martin Widlake's Yet Another Oracle Blog

Oracle performance, Oracle statistics and VLDBs

Richard Foote's Oracle Blog

Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music

Oracle Scratchpad

Just another Oracle weblog

Oracle DBA Blog

Procedures, learnings and fixes encountered by a Junior DBA

Oracle ACE Director Kai Yu's Oracle Blog

Share Oracle Tips and Tricks and Related News



Online Identity & Access Management

One Stop Shop for Identity & Access Management

Babu B


Uwe Hesse

about Database Technology

Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite. is the best place for your personal blog or business site.

Kamran Agayev's Oracle Blog

Oracle Certified Master

%d bloggers like this: