4 Replies Latest reply on Jul 26, 2017 12:34 PM by MKJ10930279

    Database upgrade and RAC setup

    MKJ10930279

      Hi All,

       

      I want suggestions on the below inputs. One of the client is planning to upgrade database, setup RAC and create of DR site with RAC for the existing production database system.

      They have 8 production DB's with 2 DB's each on separate physical servers and all these DB's are standalone DB's and separate applications run on all these DB's.

      There is no dependency between any of these DB's or applications.

       

      Existing System information (All Servers and DB's):

      1)OS: Red Hat Linux version 5

      2)DB version:10.2.0.5

      3)RAM: 132 GB

      4)CPU:32

      5)Cores:16

      6)Sockets:2

      7)SGA:20 GB

      8)PGA:5 GB

      9)Memory utilization (Peak time): 120 GB (for all the 4 servers)

      10)CPU utilization (Peak time): 30% (for all the 4 servers)

      11)Non-ASM using SAN storage.

       

      New System information (All DB's):

      1)DB version: 12cR2

      2)OS: Red Hat Linux 7

      3)RAM, CPU, Cores and Sockets will be same.

      4)2 node RAC for all the 8 DB's both at DC and DR site.

      5)ASM using SAN storage.

       

      The plan is to have 4 new separate servers with 2 DB's on each servers at both DC and DR sites and setup 2 node RAC at both DC and DR sites.

       

      Based on the above information i want suggestions on below points:

      1)License requirements.

      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.

       

      Thanks,

      Mukesh

        • 1. Re: Database upgrade and RAC setup
          Igoroshka

          Based on the above information i want suggestions on below points:

          1)License requirements.

          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.

           

          Thanks,

          Mukesh

          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.

          • 2. Re: Database upgrade and RAC setup
            MKJ10930279

            Hi,

            can you help with calculation of +192 DB socket licences

            • 3. Re: Database upgrade and RAC setup
              Igoroshka

              Sure.

              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.

              1 person found this helpful
              • 4. Re: Database upgrade and RAC setup
                MKJ10930279

                now i got it..

                Thanks Igoroshka for the detailed explanation.