{"id":8198,"date":"2019-04-12T11:35:27","date_gmt":"2019-04-12T11:35:27","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8198"},"modified":"2020-05-13T11:50:24","modified_gmt":"2020-05-13T11:50:24","slug":"compute-node-oracle-exadata-database-server","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/compute-node-oracle-exadata-database-server\/","title":{"rendered":"Compute Node or Database Server in Oracle Exadata"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I will explain Compute Node in other words Database Machine in Oracle Exadata in this post.<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>Read previous Exadata articles to learn What is the Exadata and Why Exadata ?<\/p>\n<p>&nbsp;<\/p>\n<p>https:\/\/ittutorial.org\/exadata-tutorial-x8-oracle-database-machine-3\/<\/p>\n<p>&nbsp;<\/p>\n<p>Physical Exadata components in a cabinet are as follows.<\/p>\n<ul>\n<li>Database Server<\/li>\n<li>Storage Server (Cell Server)<\/li>\n<li>Infiniband Network<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4161\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-gc3b6rc3bcnc3bcm2.png\" alt=\"\" width=\"622\" height=\"699\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-gc3b6rc3bcnc3bcm2.png 622w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-gc3b6rc3bcnc3bcm2-267x300.png 267w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Now lets examine what is the database server and its role in Exadata.<\/p>\n<p><strong>Database Server<\/strong><\/p>\n<p>Database Server is known as\u00a0Compute node that Grid Infrastructure ( Real Application Cluster ) and Oracle Database Software is run on that.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4174\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2018\/03\/database-machine.png\" alt=\"\" width=\"614\" height=\"185\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/database-machine.png 1459w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/database-machine-300x90.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/database-machine-768x231.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/database-machine-1024x308.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>For the Exadata X7-2 version, each database server has 2&#215;24 Core CPUs, 384GB of RAM (up to 1.5TB) and 40Gb \/ sec\u00a0 Infiniband supported network\u00a0 (which can connect to other Database nodes and Storage servers) and 10 Gigabit for Public network or 25 Gigabit networks.<\/p>\n<p>&nbsp;<\/p>\n\n<p>Grid Infrastructure ( RAC ) and Oracle database software installed in the Exadata Database machine are not special to Exadata. These Softwares published for non Exadata servers are also valid in exadata.<\/p>\n<p>&nbsp;<\/p>\n<p>It is also recommended to use RAC on Exadata as shown below, but Single Instance can also be installed and used. Customers without RAC license can use Exadata as a single Instance without paying RAC license.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4175\" src=\"https:\/\/salihdeveci.files.wordpress.com\/2018\/03\/exadata-x7-2-rac.png\" alt=\"\" width=\"614\" height=\"274\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-x7-2-rac.png 1183w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-x7-2-rac-300x134.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-x7-2-rac-768x343.png 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/exadata-x7-2-rac-1024x457.png 1024w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>You can list local disk or mount points of Database Server like following.<\/p>\n<pre>[root@devecidbadm01 ~]# df -h\r\nFilesystem            Size  Used Avail Use% Mounted on\r\n\/dev\/mapper\/VGExaDb-LVDbSys1\r\n                       30G   14G   16G  47% \/\r\ntmpfs                 253G   51M  253G   1% \/dev\/shm\r\n\/dev\/sda1             504M   43M  437M   9% \/boot\r\n\/dev\/mapper\/VGExaDb-LVDbOra1\r\n                       99G   69G   26G  74% \/u01\r\n\/dev\/mapper\/VGExaDb-u02\r\n                      1.4T  583G  726G  45% \/u02\r\n[root@devecidbadm01 ~]#  \r\n\r\n<\/pre>\n\n<p>You can query image version of Database server like following.<\/p>\n<pre>[root@devecidbadm01 ~]# imageinfo\r\n\r\nKernel version: 2.6.39-400.277.1.el6uek.x86_64 #1 SMP Wed Feb 24 16:13:42 PST 2016 x86_64\r\n<span style=\"color: #ff0000;\">Image kernel version: 2.6.39-400.277.1.el6uek<\/span>\r\nImage version: 12.1.2.3.1.160411\r\nImage activated: 2016-05-15 08:43:15 -0700\r\nImage status: success\r\nSystem partition on device: \/dev\/mapper\/VGExaDb-LVDbSys1\r\n\r\n<\/pre>\n\n<p>&nbsp;<\/p>\n<p>You can check Exadata version which is X5 or X6, or X7 and even X8<\/p>\n<pre>[root@devecidbadm01 ~]# dmidecode -s system-product-name\r\nORACLE SERVER X6-2\r\n[root@devecidbadm01 ~]#<\/pre>\n<p>&nbsp;<\/p>\n<p>You can check also Exadata version like following.<\/p>\n\n<p>&nbsp;<\/p>\n<pre>[root@devecidbadm01 ~]# cat \/opt\/oracle.SupportTools\/onecommand\/databasemachine.xml | grep -i machinetype\r\n&lt;MACHINETYPE&gt;762&lt;\/MACHINETYPE&gt;\r\n&lt;MACHINETYPES&gt;X6-2 Eighth Rack HC 8TB&lt;\/MACHINETYPES&gt;\r\n[root@devecidbadm01 ~]#<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>In this example our exadata is\u00a0X6-2 Eighth Rack HC 8TB. It means 1\/8 Exadata X6-2 High Capacity with 8TB disks.<\/p>\n<pre><\/pre>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Exadata detailed, then read the following articles.<\/span><\/h4>\n<p><a href=\"https:\/\/ittutorial.org\/exadata-tutorials-oracle-magic-database-machine-exadata-lessons\/\">https:\/\/ittutorial.org\/exadata-tutorials-oracle-magic-database-machine-exadata-lessons\/\u00a0<\/a><\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h5>\n<p><a href=\"https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/\">https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain Compute Node in other words Database Machine in Oracle Exadata in this post. &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":4174,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,1994],"tags":[3432,3428,3429,3427,3430,2672,7842,7853,11072,579,580,3386,3435,3388,581,587,3434,3387,593,3433,595,596,11071,3384,3431,599,601,3382,2473,3385,11068,2671,1030,1120,1257,1258,11070,7847,1345,2673,11067,11069,3383],"class_list":["post-8198","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-exadata","category-oracle","tag-check-exadata-version","tag-compute-nod-in-oracle-exadata","tag-compute-node-in-oracle-exadata","tag-compute-node-or-database-server-in-oracle-exadata","tag-database-server-in-oracle-exadata","tag-database-tutorial","tag-dbs_group-exadata","tag-exadata-commands-cheat-sheet","tag-exadata-compute-node","tag-exadata-danismanlik","tag-exadata-database-machine","tag-exadata-database-machine-oracle","tag-exadata-dmidecode","tag-exadata-documents","tag-exadata-dokumani","tag-exadata-egitimi","tag-exadata-imageinfo","tag-exadata-lessons","tag-exadata-rac","tag-exadata-scripts","tag-exadata-smart-scan","tag-exadata-storage-index","tag-exadata-tutorial-pdf","tag-exadata-tutorials","tag-exadata-version","tag-exadata-versiyonlari","tag-exadata-x7-2","tag-exadata-x8-2-database-machine","tag-goldengate-tutorial","tag-history-of-exadata","tag-how-to-check-exadata-configuration","tag-it-tutorial","tag-mehmet-salih-deveci-exadata","tag-oracle","tag-oracle-exadata","tag-oracle-exadata-database-machine","tag-oracle-exadata-documentation","tag-oracle-exadata-tutorial","tag-oracle-support","tag-oracle-tutorial","tag-what-is-cell-node-in-exadata","tag-what-is-exadata","tag-what-is-the-exadata"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2018\/03\/database-machine.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=8198"}],"version-history":[{"count":7,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8198\/revisions"}],"predecessor-version":[{"id":12998,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8198\/revisions\/12998"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/4174"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}