{"id":14807,"date":"2020-10-08T11:47:47","date_gmt":"2020-10-08T09:47:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/"},"modified":"2020-10-08T11:47:47","modified_gmt":"2020-10-08T09:47:47","slug":"getting-started-with-exasol-installation-from-iso","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/","title":{"rendered":"Getting started with Exasol &#8211; Installation from ISO"},"content":{"rendered":"<p>Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described <a href=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-setting-up-an-environment\/\" target=\"_blank\" rel=\"noopener noreferrer\">in the first post<\/a>, the VM is running with <a href=\"https:\/\/www.virtualbox.org\/manual\/UserManual.html#network_hostonly\" target=\"_blank\" rel=\"noopener noreferrer\">host only adapters<\/a> and you can not connect to anything outside the Exasol system. This is however required if you want to store the backups outside the cluster. I&#8217;ve tried various things, like adding an additional NAT interface, but in the end I decided to do a clean re-installation from scratch using the ISO. Doing it that way gives you more information how the installation actually works and how the network is going to be set up. Better do it right from the beginning.<\/p>\n<p><!--more--><\/p>\n<p>I&#8217;ve configured the Virtual Machine like this in Virtual Box:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\" alt=\"\" width=\"582\" height=\"408\" class=\"aligncenter size-full wp-image-43913\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-11.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-11.jpg\" alt=\"\" width=\"577\" height=\"410\" class=\"aligncenter size-full wp-image-43914\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-22.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-22.jpg\" alt=\"\" width=\"580\" height=\"410\" class=\"aligncenter size-full wp-image-43915\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-36.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-36.jpg\" alt=\"\" width=\"593\" height=\"476\" class=\"aligncenter size-full wp-image-43916\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-46-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-46-1.jpg\" alt=\"\" width=\"598\" height=\"469\" class=\"aligncenter size-full wp-image-43917\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-59.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-28-59.jpg\" alt=\"\" width=\"591\" height=\"469\" class=\"aligncenter size-full wp-image-43918\" \/><\/a><\/p>\n<p>As I do not need any audio or USB support in the Exasol system I&#8217;ve disabled that:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-32-20.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-32-20.jpg\" alt=\"\" width=\"744\" height=\"574\" class=\"aligncenter size-full wp-image-43919\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-32-32.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-32-32.jpg\" alt=\"\" width=\"745\" height=\"564\" class=\"aligncenter size-full wp-image-43920\" \/><\/a><\/p>\n<p>Now comes the important part: Exasol uses an internal network for communication between the nodes and a public network for the clients to connect to, and for communication out side of the Exasol system. That means you need at least two adapters configured in VirtualBox for that. The first one will be used for the internal network, and the second one will be used for the public network. I decided to go for host only for the internal network (no need for communication outside of the cluster) and for bridged for the public one (NAT would also be possible but then you need to configure port forwarding):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-36-44.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-36-44.jpg\" alt=\"\" width=\"748\" height=\"575\" class=\"aligncenter size-full wp-image-43921\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-37-10.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-37-10.jpg\" alt=\"\" width=\"745\" height=\"566\" class=\"aligncenter size-full wp-image-43922\" \/><\/a><\/p>\n<p>The installation is quite easy: Once you&#8217;ve attached the ISO and booted the VM it looks like this (you&#8217;ll quickly notice that the operating system is based on Red Hat, actually it is CentOS 7):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-39-14-2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-39-14-2.jpg\" alt=\"\" width=\"720\" height=\"473\" class=\"aligncenter size-full wp-image-43925\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-39-37-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-39-37-1.jpg\" alt=\"\" width=\"720\" height=\"610\" class=\"aligncenter size-full wp-image-43927\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-40-18.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-40-18.jpg\" alt=\"\" width=\"720\" height=\"606\" class=\"aligncenter size-full wp-image-43928\" \/><\/a><\/p>\n<p>This needs to match your first adapter (the host only one in my case):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-41-31.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-41-31.jpg\" alt=\"\" width=\"720\" height=\"608\" class=\"aligncenter size-full wp-image-43929\" \/><\/a><\/p>\n<p>The password you specify will be used later to logon to the system in the VirtualBox console:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-41-55.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-41-55.jpg\" alt=\"\" width=\"720\" height=\"610\" class=\"aligncenter size-full wp-image-43930\" \/><\/a><\/p>\n<p>This is the configuration for the public network. On my workstation the bridged network is this one:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n4: virbr0:  mtu 1500 qdisc noqueue state DOWN group default qlen 1000\n    link\/ether 52:54:00:2e:0f:94 brd ff:ff:ff:ff:ff:ff\n    inet 192.168.122.1\/24 brd 192.168.122.255 scope global virbr0\n       valid_lft forever preferred_lft forever\n<\/pre>\n<p>&#8230; and it is bridged to this one:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n3: wlp2s0:  mtu 1500 qdisc noqueue state UP group default qlen 1000\n    link\/ether e4:70:b8:93:2a:6f brd ff:ff:ff:ff:ff:ff\n    inet 192.168.178.42\/24 brd 192.168.178.255 scope global dynamic noprefixroute wlp2s0\n       valid_lft 851419sec preferred_lft 851419sec\n<\/pre>\n<p>&#8230; so I need an IP address from that network and the gateway for that network:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-42-22.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-42-22.jpg\" alt=\"\" width=\"720\" height=\"612\" class=\"aligncenter size-full wp-image-43931\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-42-36.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-42-36.jpg\" alt=\"\" width=\"720\" height=\"605\" class=\"aligncenter size-full wp-image-43932\" \/><\/a><\/p>\n<p>You&#8217;ll see a standard Red Hat \/ CentOS (kickstart) installation going on:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-42-48.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-42-48.jpg\" alt=\"\" width=\"720\" height=\"607\" class=\"aligncenter size-full wp-image-43933\" \/><\/a><\/p>\n<p>&#8230; until it finally completes:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-59-49.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-59-49.jpg\" alt=\"\" width=\"720\" height=\"606\" class=\"aligncenter size-full wp-image-43934\" \/><\/a><\/p>\n<p>You can now login with the user &#8220;maintenance&#8221; and the password you specified during the installation:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-11-01-33.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-11-01-33.jpg\" alt=\"\" width=\"720\" height=\"608\" class=\"aligncenter size-full wp-image-43935\" \/><\/a><\/p>\n<p>If everything went fine, the web console should be up and running (in my case http:\/192.168.178.111, user=admin, password=admin):<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-11-06-34.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-11-06-34.jpg\" alt=\"\" width=\"687\" height=\"423\" class=\"aligncenter size-full wp-image-43937\" \/><\/a><\/p>\n<p>You&#8217;ll notice that no database is running, so we need to do a bit more work, compared to the OVA installation where a database already is there:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-11-07-16.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-11-07-16.jpg\" alt=\"\" width=\"927\" height=\"459\" class=\"aligncenter size-full wp-image-43938\" \/><\/a><\/p>\n<p>Before we can bring up the database, storage needs to be configured. Basically there are two options:<\/p>\n<ul>\n<li>data volumes: used for the databases<\/li>\n<li>archive volumes: used for backup purposes<\/li>\n<\/ul>\n<p>Storage can be configured in the storage section, so let&#8217;s create a new data volume:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-04-57-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-04-57-1.jpg\" alt=\"\" width=\"679\" height=\"439\" class=\"aligncenter size-full wp-image-43943\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-10-04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-10-04.jpg\" alt=\"\" width=\"711\" height=\"582\" class=\"aligncenter size-full wp-image-43944\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-10-34.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-10-34.jpg\" alt=\"\" width=\"832\" height=\"568\" class=\"aligncenter size-full wp-image-43945\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-11-09.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-11-09.jpg\" alt=\"\" width=\"681\" height=\"833\" class=\"aligncenter size-full wp-image-43946\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-11-31.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-11-31.jpg\" alt=\"\" width=\"913\" height=\"676\" class=\"aligncenter size-full wp-image-43947\" \/><\/a><\/p>\n<p>Having the storage ready, we can go ahead and create the first database:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-17-10.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-17-10.jpg\" alt=\"\" width=\"877\" height=\"457\" class=\"aligncenter size-full wp-image-43949\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-18-50.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-18-50.jpg\" alt=\"\" width=\"719\" height=\"925\" class=\"aligncenter size-full wp-image-43950\" \/><\/a><\/p>\n<p>At this stage the database is not yet created, we&#8217;ve only created the specifications the database will run in:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-21-43.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-21-43.jpg\" alt=\"\" width=\"961\" height=\"425\" class=\"aligncenter size-full wp-image-43951\" \/><\/a><\/p>\n<p>We can do that by selecting the name of the database:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-22-42.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-22-42.jpg\" alt=\"\" width=\"960\" height=\"434\" class=\"aligncenter size-full wp-image-43952\" \/><\/a><\/p>\n<p>In the upper right corner switch from &#8220;Startup&#8221; to &#8220;Create&#8221; and then create the database:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-29-38.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-29-38.jpg\" alt=\"\" width=\"961\" height=\"915\" class=\"aligncenter size-full wp-image-43954\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-30-16.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-30-16.jpg\" alt=\"\" width=\"960\" height=\"338\" class=\"aligncenter size-full wp-image-43955\" \/><\/a><\/p>\n<p>On the overview page the status is now &#8220;Created&#8221; and we can start it up:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-30-51.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-30-51.jpg\" alt=\"\" width=\"973\" height=\"457\" class=\"aligncenter size-full wp-image-43956\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-31-16.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-31-16.jpg\" alt=\"\" width=\"973\" height=\"420\" class=\"aligncenter size-full wp-image-43957\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-31-34.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-13-31-34.jpg\" alt=\"\" width=\"983\" height=\"455\" class=\"aligncenter size-full wp-image-43958\" \/><\/a><\/p>\n<p>Finally, to confirm everything is fine, test that you can connect with EXAPlus (or whatever tool you prefer):<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\ndwe@dwe:~\/EXAplus-7.0.0$ \/home\/dwe\/EXAplus-7.0.0\/exaplus -c 192.168.178.111:8563 -u sys -p exasol \nEXAplus 7.0.0 (c) EXASOL AG\n\nThursday, October 8, 2020 at 1:38:46 PM Central European Summer Time\nConnected to database my_exa_db1 as user sys.\nEXASolution 7.0.2 (c) EXASOL AG\n\nCOLUMN   user_name ON\nFORMAT   a30\nCOLUMN   sql_text ON\nFORMAT   a30\nCOLUMN   effective_user ON\nFORMAT   a30\nCOLUMN   limit_value ON\nFORMAT   a30\nCOLUMN   status ON\nFORMAT   a15\nCOLUMN   index_schema ON\nFORMAT   a30\nCOLUMN   index_table ON\nFORMAT   a30\nCOLUMN   index_type ON\nFORMAT   a15\nCOLUMN   column_name ON\nFORMAT   a30\nCOLUMN   column_comment ON\nFORMAT   a50\nCOLUMN   CONSUMER_GROUP_COMMENT ON\nFORMAT   a30\nCOLUMN   SYS_CONSUMER_GROUP ON\nFORMAT   a30\nCOLUMN   CONSUMER_GROUP_NAME ON\nFORMAT   a30\nSQL_EXA&gt; \n<\/pre>\n<p>Btw: The formatting stuff you see here comes from the &#8220;exaplus.sql&#8221; script that is executed automatically (very much like SQL*Plus from Oracle):<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\ndwe@dwe:~\/EXAplus-7.0.0$ cat exaplus.sql \ncol user_name for a30;\ncol sql_text for a30;\ncol effective_user for a30;\ncol limit_value for a30;\ncol status for a15;\ncol index_schema for a30;\ncol index_table for a30;\ncol index_type for a15;\ncol column_name for a30;\ncol column_comment for a50;\ncol CONSUMER_GROUP_COMMENT for a30;\ncol SYS_CONSUMER_GROUP for a30;\ncol CONSUMER_GROUP_NAME for a30;\n<\/pre>\n<p>Finally all is setup, and we are really ready for the next post: Backup and Restore.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described in the first post, the VM is running with host only adapters and you can not connect [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":14808,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[2127,2128],"type_dbi":[],"class_list":["post-14807","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-exasol","tag-mpp"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Getting started with Exasol - Installation from ISO - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting started with Exasol - Installation from ISO\" \/>\n<meta property=\"og:description\" content=\"Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described in the first post, the VM is running with host only adapters and you can not connect [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-08T09:47:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"582\" \/>\n\t<meta property=\"og:image:height\" content=\"408\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Getting started with Exasol &#8211; Installation from ISO\",\"datePublished\":\"2020-10-08T09:47:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\"},\"wordCount\":639,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\",\"keywords\":[\"Exasol\",\"MPP\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\",\"name\":\"Getting started with Exasol - Installation from ISO - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\",\"datePublished\":\"2020-10-08T09:47:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg\",\"width\":582,\"height\":408},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting started with Exasol &#8211; Installation from ISO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Getting started with Exasol - Installation from ISO - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/","og_locale":"en_US","og_type":"article","og_title":"Getting started with Exasol - Installation from ISO","og_description":"Initially I wanted to write about Backup and Restore of Exasol databases but I quickly ran into issues, and this is the reason why this post is coming first. When you import the Exasol Community OVA as described in the first post, the VM is running with host only adapters and you can not connect [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/","og_site_name":"dbi Blog","article_published_time":"2020-10-08T09:47:47+00:00","og_image":[{"width":582,"height":408,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg","type":"image\/jpeg"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Getting started with Exasol &#8211; Installation from ISO","datePublished":"2020-10-08T09:47:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/"},"wordCount":639,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg","keywords":["Exasol","MPP"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/","url":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/","name":"Getting started with Exasol - Installation from ISO - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg","datePublished":"2020-10-08T09:47:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot-at-10-27-55.jpg","width":582,"height":408},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/getting-started-with-exasol-installation-from-iso\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting started with Exasol &#8211; Installation from ISO"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14807"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14807\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14808"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14807"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}