RAC ASM server

[Roshan]

Oracle Database 12.1.0.2

Hello,

we have a production environment with 2 nodes cluster.

Database 12.1.0.2

It is clustered HP physical servers with the shared disk ( LUN ) on our 3PAR storage making use of Oracle ASM

Now, for the archiving part, it is proposed to deploy on VM infra. We propose to deploy according to the following best practice:

 https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/vmware-oracle-databases-on-vmware-best-practices-guide.pdf

Can you please confirm

Two VMs with shared 1.5 TB hard disk will be provisioned for as follows:

 

-        Shared disk on ISILON

-        Separate /var ,/tmp,/opt is separate from root

if we can go through?

Regards,

Roshan

[ErmanArslansOracleBlog]

What exactly you want to do?

Are you planning to build a 2 node RAC env on top of Guess VMs running on top of Vmware?
If so, what exactly is your concern? Please be specific.

[Roshan]

Yes. We are going to build 2 VMs and configure as a cluster same like production. I will follow the guideline and if any issue I will let you know.

Currently we are providing shared filesystem size as production ASM disk
ASM.png

[Roshan]

If on  the physical prod servers we have 7 cores CPU, how many vCPUs do we need?

 

section 6 - Memory sizing

sga: 20G

pga: 13G

Memory: 64G

how will I know the PGA stack space and sum of background process used memory?

 

It is recommended to use large memory pages. how much the size should be? Actually it is

getconf PAGESIZE

4096

[ErmanArslansOracleBlog]

Large pages are configured differently. You don't check it with getconf.

see -> HugePages on Linux: What It Is... and What It Is Not... (Doc ID 361323.1)

Memory size depends on your workload, a sizing is required to tell the numbers.. Vcpus, memory, disk size etc is related with sizing.
Vcpus are different than physical core bytheway. You can think like Vcpus like 1 core = 2 VCPU (hyperthreading)

You need to have a shared filesystem for RAC. ASM is a good option to use.
Another questions?

[Roshan]

Thanks for info.