What is the cost of Oracle database license? Let’s find out!

We must have been involved in only technical activities and issues on Oracle database every day, but most of the DBA’s must have a limited or no knowledge on how Oracle charges customers with their license models. Most of us might know that Oracle database is free for learning, testing and for any non-profit applications or firms. When I have asked few of my colleagues about the commercial license, they just say that Oracle database licensing is based on a number of cores in your processor. Hope you might be one of them too 🙂 .

To the professionals who do not know, there are two models from Oracle in purchasing database licenses for commercial purposes. Let us check the licensing terms and their prices for the most widely used features in database enterprise edition.

These license details are gathered from Oracle as on 21-Jan-2016 and might change any time.

Type of licenses:

Oracle has two types of database licenses and one for software update and meta-link that you can choose from.

1. User based (Named User Plus).

Licensed based on a number of users accessing the database whether programmatically or end user. This sort of licensing is very much suitable for a fixed intranet application where users are fixed and no major scalability. But Oracle sells a minimum of 25 users for Enterprise Edition per CPU.

Cons: Even though your application have only 10 users, you will need to pay for 25.

2. Processor based.

From the name, though we understand it per processor with respect to Oracle this is different to multi-core processors. Today, every server is running on multi-core processors. Oracle calculates the number of processors on the server as “(number of cores) * (multi-core factor)”.

Each make of processor has their respective multi-core factor. Few examples:

• 0.5 for Intel/AMD.
• 0.25 for UltraSPARC.
• 1.00 for IBM Power systems.

Cost for Enterprise edition:

1. For User-based:
Price per user: 950 $
Software update and support price: 209 $
2. For Processor based:
Processor license: 47,500 $
Software update and support price: 10,450 $

It will be interesting to know how much would few of EE options like RAC, Partitioning etc… would cost. Isn’t it? Let us see that.

Option

Per user license

Support license

Processor license

Support license

Diagnostic pack

150 $

33 $

7500 $

1650 $

Tuning pack

100 $

22 $

5000 $

1100 $

12c Multitenancy

350 $

77 $

17500 $

3850 $

Partitioning

230 $

50 $

11500 $

2530 $

Compression

230 $

50 $

11500 $

2530 $

RAC

460 $

101 $

23,000 $

5060 $

Active dataguard

230 $

50 $

11500 $

2530 $

These prices are additional on top of enterprise license that is purchased.

Case study:

Hope the numbers that are projected are scattered to get a clear picture of total costs incurred in the database. Let us take a scenario and calculate the licensing costs.

Requirement – Calculate license for Oracle database EE with Diagnostic pack, Partitioning and tuning pack including support on Intel quad-core processor for unlimited users.

Calculation –

• It falls under processor based licensing as the requirement is for unlimited users.
• Number of processors (P) = (Quad Core)*(multi-core factor) = 4*0.5 = 2.
• EE Oracle database cost (DB) = 47500 $.
• EE options cost (OP) = Diagnostic + Tuning + Partitioning = 7500 $ + 5000 $ + 11500 $ = 24000 $.
• Support license cost (SP) = EE + Diagnostic pack + Tuning + Partitioning = 10450 $ + 1650 $ + 1100 $ + 2530 $ = 15730 $

Total cost is now calculated as = Number of processors*(EE Oracle database cost + EE options cost) + Support license cost = P*(DB+OP) + SP = 2*(47500+24000) $ + 15730 $ = 158730 $

It’s 158730 $, that’s very huge isn’t it?

You must be now thinking what will be the validity of this license 🙂 , right? That’s another tricky one from Oracle, they have licenses without any term validities and also with 5 or 4 or 3 or 2 or 1 years of term validity. It’s only my perception that the total price we calculated in our case study is valid until you seek for termination.

For further details on licensing please refer – http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

Bullet-ins:

• Not just production systems, Oracle licenses are applicable to your non-production systems as well.
• Oracle may track your “Named User Plus” licenses based on results from the v$license.
• Oracle may track your “Processor” licenses from any of your AWR reports that you upload to meta-link.

Was this useful? Like it and share it.

Leave your comments!

Feel free to give additional information in the comments, that I can validate and include in blog posts or update this as well.

Related Posts

About The Author

27 Comments

  1. Navakanth.talluri@gmail.com'
    Navakanth
    January 28, 2016
    • Pawan Kumar Yaddanapudi
      January 28, 2016
      • fk36@hotmail.com'
        Farooq Khalid
        January 28, 2016
        • Pawan Kumar Yaddanapudi
          January 29, 2016
  2. jagadsri@yahoo.com'
    Jagadish
    January 28, 2016
    • Pawan Kumar Yaddanapudi
      January 28, 2016
  3. logkrishnag@gmail.com'
    Anonymous
    February 3, 2016
    • Pawan Kumar Yaddanapudi
      February 3, 2016
  4. balumaduru@gmail.com'
    Balu
    February 17, 2016
    • Pawan Kumar Yaddanapudi
      February 17, 2016
      • balumaduru@gmail.com'
        Balu
        February 17, 2016
        • Pawan Kumar Yaddanapudi
          February 18, 2016
  5. gopal892@gmail.com'
    Gopal
    February 1, 2017
  6. sreegreat@gmail.com'
    nsshenoy
    February 2, 2017
    • Pawan Kumar Yaddanapudi
      March 16, 2017
      • federicoer@gmail.com'
        Fedderico10
        March 22, 2017
        • Pawan Kumar Yaddanapudi
          April 10, 2017
  7. utkarsh18@gmail.com'
    utkarsh
    April 7, 2017
    • Pawan Kumar Yaddanapudi
      April 10, 2017
  8. zuber23g@gmail.com'
    Zubear
    May 23, 2017
  9. devenpuri@gmail.com'
    DP
    July 24, 2017
    • Pawan Kumar Yaddanapudi
      July 24, 2017
      • devenpuri@gmail.com'
        DP
        July 25, 2017
        • Pawan Kumar Yaddanapudi
          July 25, 2017
          • devenpuri@gmail.com'
            DP
            July 25, 2017
          • Pawan Kumar Yaddanapudi
            July 25, 2017
  10. tej.rawat@citiustech.com'
    Tej
    November 28, 2017

Add Comment