Save money by understanding the Oracle licensing model. Oracle and licenses. The general feeling most of the time is that you pay too much for the use of the Oracle products, and its not always sure if you are compliant, because of the complexity of the rules. This hopefully clarifying   blog is part of a small series and is an updated blogpost of one I wrote a few years ago. Since then the Oracle world has changed a bit, felt the need to update, and I will try to give some clarity about the licensing model which will hopefully help you to save money by utilizing your Oracle Environment. Ill start with the basics part I and then I will treat topics like virtualizing, engineered systems, SE2, Unlimited License Agreements, Cloud and so on. E15315_09/help/oracle.eclipse.tools.database.doc/html/gettingStarted/images/NewTableMenu.gif' alt='Download Oracle Database 10G Express Edition' title='Download Oracle Database 10G Express Edition' />The information in this post is not intended to be used as legal statements or sources for negotiations with Oracle. I will be referring to some other documents and blogposts which can and should be used. The information is not exhaustive but will hopefully give the reader a guide how to cope with the model of Oracle at this moment 2. Subjects in this part 1 Scope Full Use Hosting. Development and testing environment. Prices and contract. Databases species. Types of licenses. Processor NUP Employee based. Support Scope Full Use Hosting. Sumtogob.gif' alt='Download Oracle Database 10G Express Edition' title='Download Oracle Database 10G Express Edition' />The following models are to be recognized Full Use  end user license, suitable for running tailor made applications. The legal entity of the firm is owner of the full use license. Application Specific Full Use ASFU Example  SAP. You can only use the Oracle software for that particular purpose. Not even allowed to use Enterprise Manager Packs. Embedded Software License ESL. Only to be used for specific to be used applications, and the database schema is not accessible to the end user but only to the application runtime. Sample CV for freshers Write an impressive CVimprove your CV with our sample CVs for freshers. This definition explains the meaning of Oracle and provides details on the technology vendor of that name, its flagship database and other Oracle products. Why DB2 ExpressC DB2 ExpressC is the free version of one of the most advanced database management systems in the world. Why pay when you can have all you need. Oracle Database Downloads. The version of Oracle Database you are looking for is no longer available on OTN. Please visit any of the following links for. Download Oracle Database 10G Express Edition' title='Download Oracle Database 10G Express Edition' />Hosting licenses more detail in a coming post. Generic Hosting. Third party or multi application hosting. Multiple customers. Propriarty Application Hosting PAH. Single application, multiple customers. Specified End Users. Hosting Environment dedicated to a single end user. For the Hosting licenses approval is needed by Oracle Scope in this post  Full Use model, in a post later on I will talk about the different Hosting licenses which is different from Cloud credits Oracle starts asking questions when the number of licences of management packs doesnt match the number of database licenses. In your example, with the assumption. October 14th, 2008 at 1123 pm. Hello, This tools is just what I was looking for, load a dbf file into ORACLE 10g. But, I have problems with numbers that are stored. As was mentioned by bighornsheep in another post, Oracle provides a free version of their 10g database product to work with if youre a student. Development and test licenses. You may use the Oracle software free for generally 3. This period may sometimes be extended to generally 9. Oracle, and is used for proof of concepts and that kind of stuff. Development and test environments for an application must be licensed, with at least one rare exception. The exception and the rules around development and testing I described in this blog. Prices and contracts, what are you paying for. First years costs can be calculated as purchase purchase discount support costs 2. Support costs are calculated of the purchase minus the discount. You get support as long as you pay the yearly support costs. Oracle has the right to increase the support amount with a few percent a year. So when you are a local customer for a decade or so, the support costs may be substantial higher, and may not be in proportion anymore with the discount you got at the beginning. Licenses without support of perpetual licenses is possible first year support is mandatory, but then you have got no access to Metalink support, patches and upgrades. Be aware, theres a huge difference between stopping the support, and eliminate the license. When just stopping the support, you will still be the owner in the case of perpetual license   When you made a mistake, and want to get into support again after a period of time, youll have to pay a so called re instatement fee. This is all explained in the Oracle Software Support policies. Purchase is also possible for a period of 1, 2, 3, 4 or 5 years Term Licenses, purchase support is mandatory  which isbased on the price of the perpetual licenses More on support later on. On www. oracle. com are the  so called list prices in dollars. These are the prices with no purchase discount at all. This discount depends greatly on the volume you buy, and there are some fixed staggered discounts you can agree on with Oracle. By the way  the discount is based on the sum of the purchases. When you decide over time to end a part of the purchase, this will lead to a recalculation, and could be influencing your yearly costs, because of stumbling into a lower staggered discount. Prices will be adjusted on a regular basis. Changes will occur within June, see also this blog. For Europe, changes will also depend on  the rate of the dollar. Oracle has also a so called  Matching Service Level Policy sometimes it does not matter what you are using, but it does matter what you bought in the past. Example you purchased database licenses for 3 servers together with 3 diagnostic and tuning pack licenses. Termination or stopping the support of the diagnostic and tuning pack licenses is not allowed. Those management packs are linked one on one to the databases, consequence is that you have to terminate or stop the support of the databases as well. Oracle does not pro actively monitor this at this time. So it helps sometimes to act low profile. Species of databases. Enterprise Edition. Most expensive, complete database. Standard Edition 2. Less functionalities, e. But includes RAC. A lot of questions are answered by this blog. Personal Edition single user databaseOracle Express edition. Differences in functionality you can see here. Enterprise Edition is required with the following configurations When the server has got more than 2 sockets or. You are using Oracle Enterprise Manager Packs, like Tuning pack or. You are using Database Options e. PartitioningYou have to pay for the Database Options, besides the default Enterprise Edition database licenses, e. Real Application Clusters. Partitioning. Advanced Security. Database Vault. Advanced Compression. Active Data Guard. Real Application Testing. Label Security. Total Recall. Spatial. In Memory Database Cache. Data Mining. OLAPMedia Pack. No licenses necessary Apex  Oracle Application Express, included in Standard nd Enterprise Edition. Bloqueo Este Software Porque No Puede. Oracle Express edition. Types of licenses. With Full Use licenses you can choose from 3 types of licenses Processor based  ProcNamed User Plus NUPEmployee EMP license. Processor based ProcYou pay per processor, but a processor according to the definition of Oracle. As the processors become increasingly powerful and have multiple cores, Oracle has created a core element. For Intel and AMD dual core CPU typically a factor of 0. Oracle will count this processor as 1  Oracle processor 2 cores x 0. This is no different from the number of CPUs in this case. But customers also uses servers with 2 quad core cpus. Suppose this has also a factor of 0. Oracle will count this as four processors 2 CPUs x 4 cores 8  cores. Oracle processors. The core factor table Oracle uses is to be found here. Thus, if a database on a server is installed on two quad core processors running as previous example, 4 processor licenses must be paid for. On that server you are free to install multiple databases, regardless of the version The processor based license is paid per server and not per database. Another example Oracle is not supporting virtual servers, except their own Oracle.