Oracle - License Costs

Posted on 2009-02-24
Last Modified: 2013-12-18
We wish to install Oracle to be used in our development environment, where changes will be made and tested by customers and will eventually be promoted to production.  My understanding is that the license for Oracle is free for development but not for an environment that will be used to support a production environment?  

Also, is Oracle licenses paid for yearly?  Or is it an outright purchase?

Should mention that Oracle XE won't do, due to table size restrictions.

Question by:grahamcorp
    LVL 27

    Accepted Solution

    You can use oracle for a one man show development for free.

    Apart from that you have to license the server after 30 days.

    Named users (min 5) or cpu based.

    Payment is per year.

    Also note that you cannot license your testing stack with named users while using a cpu license for your productive environment.

    All you are allowed to handle is the number of cpus you assign to which development stage.

    1 for dev, 1 for testing, 2 for prod result in a 4 CPU license.

    The trick is to use the standard edition for development and the enterprise edition (if needed at all) for productive environment.

    A cpu license is needed if you cannot count the number of users on the application that use your oracle database. (Or when the cpu license gets cheaper than named users) So defining just 1 oracle users in your application with 1000 users in your application relying on metadata from oracle DB does count as 1000 named users)

    More details here (also describing the different database types):

    Software investment guide


    LVL 1

    Author Comment

    Couple of questions Tolo


    a) should my client be paying a yearly Oracle License Cost regardless of what license they have purchased?

    b) If the application always connects through the same Oracle user, regardless of the fact that there are 10 end users using the application, does this count as one Oracle user?


    LVL 27

    Expert Comment

    a) You should get an invoice from oracle (ask you oracle representative in that matter what to pay)

    b) nope - this counts as 10 users (oracle wants to get rich ;-)
    LVL 27

    Expert Comment

    For 10 users buying a 10 users license should be much cheaper than an cpu license (I think the break even is at about 200 users)
    LVL 27

    Expert Comment

    This is important about what to pay:

    Perpetual vs. Term License
    Oracle offers both term and perpetual licenses for all its products. A perpetual
    license is a one-time license fee that allows continued use of the software program
    for as long as the customer complies with all terms of the license agreement.
    A term license is for a specific, limited period of time, during which the user is
    allowed to access and use the software. At the end of the term, the user must stop
    using the software or extend the term or purchase new licenses through an
    agreement with the software vendor. Oracle offers annual term licenses for all its
    products in 1-year, 2-year, 3-year, 4-year or 5-year terms. Term licenses are a
    percentage of the perpetual license of a given Oracle product, and the term length
    (i.e., 1 to 5 years) a customer chooses, determines the percentage amount.

    LVL 27

    Expert Comment

    not sure if a perpetual license covers maintenance costs. I think we got such a license still have to pay those "famous" 18% each year for maintenance and support.

    Expert Comment


    Costs given in
    is perpetual license cost or one year cost?

    Is it includes support and maintenance cost ?

    if $ 47500/- is perpetual cost then for five yrs howmuch i need to pay for Oracle Enterprice server license and for support ? Pls give details separately.


    Naveen Chhibber

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now