Shulou(Shulou.com)06/01 Report--

1. The difference between authentic Oracle products and piracy

Get to the point, which is what many R & D don't pay attention to. For business (that is, you are not at home and play by yourself), strictly speaking, it is the difference between a piece of license paper. No matter when, the downloaded version can set up a database and develop normally, but if it is used for business, it is illegal, and I don't have to talk about the consequences. As for the high price, in fact, a large part of the maintenance fee, in addition, the download version can not be patched (not that you can not hit, but you do not have an account to download, in addition, any act of patching the free version is illegal). The official version has a product service code, which can be used for online services, upgrades, etc., and can provide different door-to-door services according to your purchase. As for the price of each version, it is indeed different. You can consult the agent. As far as I know, the win version is the cheapest, but also the most unstable.

two。 Can you talk about the respective characteristics and differences of individual version, standard version 1, standard edition and enterprise edition?

A: put it simply

1. Standard version 1 (Standard Edition One) is suitable for 1-2CPU servers. The price has a considerable advantage, but it is limited to stand-alone environment and is suitable for entry-level applications for small and medium-sized users.

2. Standard Edition (Standard Edition) is suitable for 1-4CPU servers, including 4CPU single server or 2 dual CPU servers, can do dual hot backup or RAC, moderate price, suitable for large and medium-sized user workgroup-level and department-level applications with further requirements for database performance and security.

3. Enterprise Edition (Enterprise Edition) is suitable for various environments such as single machine, dual machine, multi-CPU multi-node cluster and so on. It has complete functions, but the cost is relatively high. It is suitable for large-scale, super-large user enterprise-level and high-end enterprise applications with high requirements for database performance and reliability. For comparisons on functional modules, please refer to the Oracle Database White Paper.

3. What is the ordering method of Oracle?

A: there are two ways to order by number of users and by CPU, in which ordering by CPU is the so-called unlimited user version.

4. The official definition of the number of Oracle users?

A: every user who accesses the Oracle database, whether it is a natural person or a device, counts as a Named User.

English official definition: Named User Plus: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted.

5. How is the number of users of Oracle calculated?

The minimum number of users for each version officially required by A:Oracle is:

Personal version: number of 1user*PC

Standard version 1 = number of CPU of the server * 5

Standard version = number of CPU of the server * 10user

Enterprise Edition = number of CPU of the server * 25user

Users should order according to their actual number of users, and not less than the minimum number of users required by the corresponding version.

6. Could you give me an example?

A: for example, if the user's application is based on Internet,Oracle as the back-end database of the website, according to Oracle's official definition of the number of users, each user who accesses the website (database) through Internet is counted as 1 user, so the number of users is very large and cannot be estimated, so you should order according to the number of CPU.

7. Is it necessary to order according to CPU for the application of Internet or Bracer S architecture?

A: not necessarily. If the number of users accessing the Oracle database can be estimated and the number of users is small (number of CPU * factor * 50, it is more economical to order by CPU.

Each License also has a classification of validity [whether User License or CPU License], which is 1 year, 2 years, 3 years, 4 years, 5 years, and permanent. Of course, the price also increases in turn.

The above are list price list prices. For specific discount discounts, please see the settlement on shop.oracle.com or the actual discounts of specific agents.

About the calculation of Oracle license on vmware:

If Oracle is installed on VMWARE, is it calculated in the same way? In other words, is the License calculation of Oracle on the virtual machine VMWARE also calculated according to the allocated number of CPU cores? With regard to License computing for ORACLE on virtual machines, ORACLE introduces the following concepts of Soft partitioning (soft partition) and Hard partitioning (hard partition) (shown below), and explicitly specifies that VMware is a soft partition and specifies Soft partitioning is not permitted as a means to determine or limit the number of software licenses required for any given server.

That is to say, on a physical machine, if a virtual Linux server is used as Oracle Database Server and another Windows server is used as a SQL Server server, there are two physical CPU on the physical machine, each of which is 4 Core, which is evenly distributed to these two servers. At this time, the License of Oracle is calculated.

License Number = 2 * 4 = 0.5 = 4 instead of License Number = 1 * 4 = 0.5 = 2.

For more information:

Many Oracle products are available in different versions, and the most common ones are roughly divided into three versions:

Enterprise Enterprise Edition (EE)

The price is the highest, full-function, no use restrictions.

Standard Standard Edition (SE)

Moderate price, mainly limited to a maximum of 4 CPU, and prohibited from installing on machines with more than 4 Socket (CPU slots).

Standard 1Standard Edition One (SE1)

The lowest price, limited to 2 CPU, and prohibited from being installed on machines that support more than 2 Socket (CPU slots).

The authorized calculation method of Oracle is one of the two endpoints of command transmission when the computer is working.

That is, User (operator) or Processor (processor / CPU)

If Processor is priced

EE version

Processor number = CPU* (Core number / per CPU) * Core_Factor, carry unconditionally when there is a decimal. Suppose on a certain Server:

1CPUfocus 6 cores, Core_Factor=0.25

Number of Processor = 1'6 '0.25' 1.5-> 2Processor

2CPU focus 4 cores, Core_Factor=0.5

Number of Processor = 2*4*0.5=4Processor

SE/SE1 version

Number of processor = the number of socket with CPU inserted on the host version of occupied socket=, that is to say, it is calculated directly according to the number of CPU

If User is priced

Oracle calls this pricing according to User as Named User Plus License, or NUP for short. Here the so-called Named User= User, which can be called, is divided into two categories:

Automatic equipment:

Automatic operation and access to Oracle software.

Because it is the starting point of operation command, it can also be regarded as a Named User.

Living people:

There are living people who operate computers and use Oracle software.

As for the equipment that needs to be operated (PC/NB), it does not count.

In addition to calculating the actual User, the minimum purchase quantity for each version must be met:

EE version: 25NUP/Processor

SE/SE1 version: 5NUP/Socket

Note here that NUP is software-limited, version-limited, and Server/Instance-free:

Limited software:

Oracle has a lot of software, and Oracle ERP's NUP is not available for Oracle CRM or other Oracle software.

Limited version:

For the same software of Oracle, SE's NUP cannot be used on SE1 and EE. In other words, if a User uses both SE and EE, you have to buy one copy of each version of NUP.

But as long as [software + version] is correct and licensed enough, Oracle no matter how many Server are connected to a User, no matter how many copies of the same software you have to run on the same Server.

If Oracle DB is purchased directly on shop.Oracle.Com based on Taiwan dollar pricing, the purchase price of each version (including support for the first year, calculated on the basis of Taiwan dollar pricing on 2012.10.29 and Shop.Oracle.Com) is as follows:

EE version

By Processor (1 Processor):

14060480309331

= 1715379

By NUP (min 25NUP):

(312466,874) / NUP*25NUP

= 38120/NUP*25NUP

= 742100

SE version

ByProcessor (1 Processor):

575575 and 126627

= 702202

ByNUP (min 5NUP):

(115122533) / NUP*5NUP

= 14045/NUP*5NUP

= 70225

SE1 version

ByProcessor (1 Processor):

190762 / 41968

= 232730

ByNUP (min 5NUP):

(5920 / 1302) / NUP*5NUP

= 7222/NUP*5NUP

= 36110

Basically, when the number of User is small, it is more cost-effective to rely on NUP authorization. Compare the proportion of expenses:

EE version: Processor/1NUP=1715379/38120=45 times

-> when the number of User on each Processor exceeds 45, it is more affordable to be billed according to Processor.

SE version: Processor/1NUP=702202/14045=50 times

-> when the number of User on each Processor exceeds 50, it is more affordable to be billed according to Processor.

SE1 version: Processor/1NUP=232730/7222=32.24 times

-> when the number of User on each Processor exceeds 32, it is more affordable to be billed according to Processor.

On the contrary, NUP should be used for billing when the number of people is small, and SE1 must be used if RAC is not needed.

In the case of a business with about 200 people, suppose:

In addition to the head office, there are also 3 business outlets, and this company has set up a total of 4 Server

Every Server has 2CPU, all CPU are 4Core, and Core Factor is 0.5.

All User of the company use computers, and all AP must be connected to Oracle DB, and all AP are not authorized by Oracle-> must be authorized by Oracle Database.

When purchasing Oracle DB, there are 6 price levels based on version and billing method:

EE:

Actual Processor=4Server*2Cpu*4Core*0.5factor=16Processor

Actual 200NUP, at least NUP=16*25=400NUP, so it is calculated according to 400NUP

ByProcessor:

171537916027446064

ByNUP:

3812000000015248000

SE:

Actual Processor=4Server*2Socket=8Processor

Actual 200NUP, at least NUP=8*5=40NUP, in terms of 200NUP

ByProcessor:

7022022008 5617616

ByNUP:

14045,200,000 2809000

SE1:

Actual Processor=4Server*2Socket=8Processor

Actual 200NUP, at least NUP=8*5=40NUP, in terms of 200NUP

ByProcessor:

2327308 1861840

ByNUP:

7222200001444400

Therefore, my personal advice is:

Carefully try to calculate the ratio of the number of people to Processor, if the list of personnel operating the computer is clear and the number of people is small, be sure to use NUP, but if the cost is about the same, it is relatively light to charge according to Processor.

Never use Oracle as the underlying layer of public WebPage, because user is not sure who there are, and it is difficult to calculate NUP. Oracle will definitely require pricing according to Processor.

Don't mess with the EE version unless necessary, it's terrible to include Core.

When you have a good budget, spend your money on RAM instead of buying too high-end motherboards:

If there are more than 2 CPU Socket, Oracle will require you to buy at least SE version.

If there are more than 4 CPU Socket, Oracle will ask you to buy the EE version.

Don't buy the same software (such as Oracle DB) with the same version, you'd better make it clear that you have to do it all at once. If required, you can change from SE1 to SE or EE, but $$is ready.

There are three documents in Oracle.Com that you'd better read carefully first. This article is written as follows:

Core Factor Table

OSIG (Oracle Software Investment Guild)

OLSA (Oracle License and Service Agreement)

Core Factor Table is used to calculate the copyright of the EE version, which lists the models of each manufacturer's multi-Core CPU and their Core Factor. Note that the model not mentioned above is CoreFactor=1, that is to say, 4 cores with 4 Processor,8 cores are 8 Processor.

OSIG is Oracle's advice to customers, and there are examples that are easier to read. These examples have several features:

EE version

Large number of User (hundreds)

Processor is a single core.

Calculation seems to be based on Processor cheaper, it is not difficult to see that Oracle would like you to buy according to Processor, you light his Happy.

While OLSA is a formal provision to be recognized when buying from Oracle, the description of the authorization rules in these two articles is basically the same, so we should read it clearly in order to negotiate. However, OLSA states that Oracle has the right to audit your usage:

We will first give written notice and cooperate with the audit within 45 days. Oracle promises not to interfere with your daily operation.

If overuse is found during the audit, a written notice will be given to supplement the authorization.

If you do not cooperate with the audit or supplementary authorization, Oracle reserves the right to terminate the license and cancel the transaction (refund), but will sue you.

It is fair in terms of the content of the contract, but it is still necessary to understand the formula for calculating authorization. If the auditor miscalculates and causes you to buy more, Oracle will not refund the money afterwards.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.