Avatar of Raf
Raf

asked on 

Configuring Server to add new Oracle instances

Hi experts,
I've an Oracle 19c RAC 2 Nodes with following current system information:

[root]# lscpu
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                16
On-line CPU(s) list:   0-15
Thread(s) per core:    2
Core(s) per socket:    8
Socket(s):             1
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 158
Model name:            Intel(R) Xeon(R) E-2278G CPU @ 3.40GHz
Stepping:              13
CPU MHz:               3400.000
BogoMIPS:              6816.00
Virtualization:        VT-x
L1d cache:             32K
L1i cache:             32K
L2 cache:              256K
L3 cache:              16384K
NUMA node0 CPU(s):     0-15

[root]# cat /etc/os-release
PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)"

[root]# free -g
              total        used        free      shared  buff/cache   available
Mem:             31           9           0          18          21           2
Swap:            31           0          31


[root]# cat /proc/meminfo
MemTotal:       32658052 kB
MemFree:          579684 kB
MemAvailable:    2688660 kB
Buffers:           10520 kB
Cached:         21602760 kB
SwapCached:        14664 kB
Active:         24884000 kB
Inactive:        2819184 kB
Active(anon):   23289168 kB
Inactive(anon):  2170548 kB
Active(file):    1594832 kB
Inactive(file):   648636 kB
Unevictable:      483604 kB
Mlocked:          483604 kB
SwapTotal:      33554428 kB
SwapFree:       32763496 kB

query on v$asm_diskgroup:
GROUP_NAME      STATE         TYPE      total_gb     free_gb                           
DG_CRS        'MOUNTED'     'EXTERN'      50            50                               
DG_DATA       'CONNECTED'   'EXTERN'    500            365                            
DG_FRA        'CONNECTED'   'EXTERN'     500            498                              
DG_MGMT       'MOUNTED'     'EXTERN'    100            76     

Open in new window


Oracle Memory:
sga_target = 15G
pga_aggregate_target = 5G

Now I'd like to add 5 new instances to my RAC database.

Based on my current configuration of memory, CPU, storage, could you please tell me which better configuration I should use to add 5 new instances to my RAC database?

Thanks in advance!
Raf
LinuxStorageOracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon