I will explain Compute Node in other words Database Machine in Oracle Exadata in this post.
Read previous Exadata articles to learn What is the Exadata and Why Exadata ?
Physical Exadata components in a cabinet are as follows.
- Database Server
- Storage Server (Cell Server)
- Infiniband Network
Now lets examine what is the database server and its role in Exadata.
Database Server is known as Compute node that Grid Infrastructure ( Real Application Cluster ) and Oracle Database Software is run on that.
For the Exadata X7-2 version, each database server has 2×24 Core CPUs, 384GB of RAM (up to 1.5TB) and 40Gb / sec Infiniband supported network (which can connect to other Database nodes and Storage servers) and 10 Gigabit for Public network or 25 Gigabit networks.
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.
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.
You can list local disk or mount points of Database Server like following.
[root@devecidbadm01 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbSys1 30G 14G 16G 47% / tmpfs 253G 51M 253G 1% /dev/shm /dev/sda1 504M 43M 437M 9% /boot /dev/mapper/VGExaDb-LVDbOra1 99G 69G 26G 74% /u01 /dev/mapper/VGExaDb-u02 1.4T 583G 726G 45% /u02 [root@devecidbadm01 ~]#
You can query image version of Database server like following.
[root@devecidbadm01 ~]# imageinfo Kernel version: 2.6.39-400.277.1.el6uek.x86_64 #1 SMP Wed Feb 24 16:13:42 PST 2016 x86_64 Image kernel version: 2.6.39-400.277.1.el6uek Image version: 220.127.116.11.1.160411 Image activated: 2016-05-15 08:43:15 -0700 Image status: success System partition on device: /dev/mapper/VGExaDb-LVDbSys1
You can check Exadata version which is X5 or X6, or X7 and even X8
[root@devecidbadm01 ~]# dmidecode -s system-product-name ORACLE SERVER X6-2 [root@devecidbadm01 ~]#
You can check also Exadata version like following.
[root@devecidbadm01 ~]# cat /opt/oracle.SupportTools/onecommand/databasemachine.xml | grep -i machinetype <MACHINETYPE>762</MACHINETYPE> <MACHINETYPES>X6-2 Eighth Rack HC 8TB</MACHINETYPES> [root@devecidbadm01 ~]#
In this example our exadata is X6-2 Eighth Rack HC 8TB. It means 1/8 Exadata X6-2 High Capacity with 8TB disks.