Based on the above information i want suggestions on below points:
2)Feasibility of the plan to have total 16 servers (including both DC and DR sites) for the new setup. What alternative approach could be suggested for this plan.
3)Considering the new plan, how many CDB's needs to be created and what could be the possible steps for RAC setup.
4)Pre-requisites to be considered.
1. Currently you have 4 servers with 16 cores each that results in 4x16=64 socket licenses.
Target system is (if I understood correctly):
- 2 nodes (16 cores each) RAC x 4 on primary
- 2 nodes (16 cores each) RAC x 4 on DR
If so, you will need +192 DB socket licences and +256 RAC option socket licenses.
Assuming Active DG additional licenses will be required.
2. Information about CPU peak load and RAM peak utilization is not enough for planning HW resources. A load profile of each DB is important.
But let assume (for some reasons) that servers are underloaded. Increase of the number of servers (RAM, CPUs) will decrease resources utilization while increase the costs. You will achieve HA and will pay for it. Depending on the business requirements it may be reasonable.
3. The use of CDBs is a matter of choice. You may or may not use multitenancy. Keep in mind that multitenance requires additional licensing with the same metrics as DBMS itself.
4. Pre-requisite are described in installation guide and on number of documents in MOS. You may consider them as minimal values.
can you help with calculation of +192 DB socket licences
1 person found this helpful
Assume you are using processor licenses.
Currently you have 4 servers 16 cores on each. Oracle licenses each core (http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf). Totally you have:
4x16=64 cores (licenses)
You plan to install 8 servers on primary and 8 servers in DR. Each server is the same as current:
8 servers x 16 cores x 2 sites = 256 cores.
256 (plan) - 64 (current) = 192 required licenses.
now i got it..
Thanks Igoroshka for the detailed explanation.