Test Case Overview

Test Case Setup

Test Case Steps

Test Case Summary

 

With VMware Cloud on AWS, ESXi hosts traditionally reside in an AWS Availability Zone (AZ) and are protected by vSphere HA.

The VMware Cloud on AWS setup with 6 ESXi hosts is shown in Hardware Resources.

 

 

Test Case Overview

 

Deploying a single instance Oracle database in VMware Cloud on AWS is no different than deploying the same on-premises.  

This test case focuses on

  • Deploying a new VM Oracle122-OEL74 from a template Template-OEL74-OL122-VMC as per Oracle on VMware best practices
  • Creating a single instance Oracle database ORA12C in this new VM.

 

 

Test Case Setup

 

A new VM Oracle122-OEL74 is deployed from a template Template-OEL74-OL122-VMC as per Oracle best practices.

 

A single instance Oracle database ORA12C is then created in this new VM as per Oracle documentation.

 

The VM Oracle122-OEL74 was created with the following attributes:

  • 8  vCPUs and 32GB memory
  • Oracle Enterprise Linux 7.4 OS
  • Oracle 12.2.0.1.0 Grid Infrastructure and RDBMS binaries
  • Oracle SGA set to 8GB and PGA set to 2GB
  • Oracle ASM and Oracle ASM Filter Driver (AFD) was used
  • For performance and queue depth purposes, all ASM disk groups disks were presented on different PVSCSI controllers
  • All database-related VMDKs were partitioned using Linux utilities, with proper alignment offset and labeled with Oracle AFD
  • Oracle ASM disk groups DATA_DG, FRA_DG and REDO_DG were created with external redundancy
  • All best practices for Oracle workloads on VMware SDDC were followed in accordance with the Oracle Databases on VMware Best Practices Guide here.

 

 

Below table provides Oracle VM Oracle122-OEL74 disk layout and ASM disk group configuration.

Name

SCSI TYPE

SCSI ID (Controller, LUN)

Size

Type

Hard Disk

Disk Name

Operating System (OS) /

Paravirtual

SCSI (0:0)

50GB

ext4 file system

1

/dev/sda1

Oracle binary disk /u01

Paravirtual

SCSI (0:1)

50GB

ext4 file system

2

/dev/sdb1

FRA Disk 1

Paravirtual

SCSI (1:0)

200GB

FRA_DG

3

FRA_DISK01

REDO Disk 1

Paravirtual

SCSI (1:1)

30GB

REDO_DG

4

REDO_DISK01

 

The Oracle Databases on VMware Best Practices Guide provides best practice guidelines for deploying Oracle workloads on the VMware SDDC. 

Test Case Steps

1. Oracle Restart command was run to ensure that all Oracle services were running after the deployment.

[root@sb-ol73-ora122 ~]#  /u01/app/12.2.0/grid/bin/crsctl status resource -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ACFS_EXPORT.dg

               ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.DATA_DG.dg

               ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.FRA_DG.dg

               ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.REDO_DG.dg

               ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.asm

               ONLINE  ONLINE       sb-ol73-ora122           Started,STABLE

ora.ons

               OFFLINE OFFLINE      sb-ol73-ora122           STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.driver.afd

      1        ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.evmd

      1        ONLINE  ONLINE       sb-ol73-ora122           STABLE

ora.ora12c.db

      1        ONLINE  ONLINE       sb-ol73-ora122           Open,HOME=/u01/app/o

                                                             racle/product/12.2.0

                                                             /dbhome_1,STABLE

--------------------------------------------------------------------------------

[root@sb-ol73-ora122 ~]#

 

 

2. A command was run to check the database and instance status

 

oracle@sb-ol73-ora122:ORA12C:/home/oracle> srvctl status database -d ORA12C

Database is running.

oracle@sb-ol73-ora122:ORA12C:/home/oracle>

 

 

3. A command was run to check the database status

 

SQL> select NAME,LOG_MODE,OPEN_MODE from v$database;

NAME      LOG_MODE     OPEN_MODE

--------- ------------ --------------------

ORA12C    ARCHIVELOG   READ WRITE

SQL>

 

 

Test Case Summary

 

This test case successfully created a new VM Oracle122-OEL74 from a template Template-OEL74-OL122-VMC as per Oracle best practices. A single instance Oracle database ORA12C was then created in this new VM.

This test also demonstrated that deploying a single instance Oracle database in VMware Cloud on AWS is no different than deploying the same on-premises.

check-circle-line exclamation-circle-line close-line
Scroll to top icon