Oracle The difference between the free version and the paid version ：
oracle It's really free for learners to use .
oracle The strategy is that you can download my product at will , Include oracle,weblogic For learning , The advantage is that people who want to learn can use it without buying software , There are more people using , Software is also popular , So if you just want to learn , It's safe to use , You don't have to look around for cracked versions .
Oracle Is it for free? ？
But if you learn , I want to use it at work and use it for commercial purposes ？ Then this product is charged , Although you can continue to use it for free , But it's the business environment after all , Because you're a free user , Many advanced functions for data recovery and backup cannot be used , And you can't get the latest software patches in time , If there is a big leak , It's just that you meet , Anything goes wrong oracle They won't be responsible , Because you're not legally used in a business environment .
If you want to use , You need to buy oracle The authorization number of , There are several ways to delegate , It's also relatively expensive . After getting the authorization, you will get the patch information for the first time , And if there is a problem in the use process oracle They will also help with the handling .
Oracle10g It is divided into 4 A version , Namely ：
1、Oracle Database Standard Edition One, The most basic commercial version , Including basic database functions .
2、Oracle Database Standard Edition , The standard version , Including the features of the above version and RAC, Only in 10g Only in the standard version of RAC.
3、Oracle Database Enterprise Edition, Enterprise Edition , Although it's the most powerful version , But not all of the features we often use are in this release , A lot of things still have to be paid extra , We'll talk about that later .
4、Oracle Database Personal Edition, Personal Edition , Except for not supporting RAC Besides, it contains all the functions of Enterprise Edition , But notice that , Only Windows Personal version is only available on the platform .
So let's see , stay Standard Edition One and Standard Edition Features not supported in （ I just selected some common or commonly used functions ）, Be careful , These functions are in addition to RAC Still included in the Personal Edition .
1、Oracle Data Guard, I won't support it .（ Customers who want high availability , You can't choose the Standard Version ）
2、 some Online operation , such as Online index maintenance,Online table redefinition Etc. not supported
3、 Some operations for backup and recovery are limited , For example, it doesn't support Block Level recovery （Block-level media recovery）, Parallel backup and recovery is not supported （Parallel backup and recovery）, Multiple backups （Duplexed backup sets） wait
4、Flashback function , In the standard edition Flashback Table,Flashback Database, Flashback Transaction Query They don't support
5、VPD（Virtual Private Database） I won't support it
6、FGA（Fine-grained auditing） I won't support it
7、Partitioning, Partitions are not supported either
8、Data compression, For example, table compression , Partition compression does not support
9、Bitmapped index and bitmapped join index, I won't support it ,（ If it's a data warehouse system, you can't choose the standard version ）
10、Export transportable tablespace,（ Be careful , It's just import that doesn't support ）, however Import transportable tablespace, Including cross platform import All supported , That is to say, if you choose the Standard Version , So it's hard to simply transfer the database to other platforms
11、 Some parallel operations don't support , Include Parallel query,Parallel DML,Parallel index build,Parallel Data Pump export and import.
12、 I won't support it Streams, Another high availability feasible solution is missing
13、 I won't support it Advanced Replication Of multimaster The way , One less high availability solution , Of course, the replication scheme of materialized views is still supported
14、Connection Manager I won't support it .
The standard version is available in 10g Although China supports RAC, however oracle There are limits , If you want to use RAC, Then only use Oracle Clusterware（ No other third party clustering software is supported ）, At the same time... Must be used ASM To do data file storage management （ No other third-party volume management or file system supports ）.
If you want to install another database as RMAN repository perhaps OEM Grid Control repository So there's no extra charge .
And if you buy the lowest level Standard One Version of , Then the following functions are not supported .
8、Oracle Management Packs
Finally, there is something about oracle Of the product FAQ：
- Oracle The version number of the database software currently on sale ？
A： What's on sale at the moment is Oracle 9i and Oracle 10g
- 10g Is it better than 9i Better ？
A： After a new version of the software came out , It has to go through a period of time , There will be quite a few patches in between . But new versions of software tend to have more new features and a more user-friendly interface .9i and 10g As two versions currently on sale , Each has . By comparison ,9i More stable and mature ,10g It provides more new features . It is suggested that users choose according to their own business needs , The best is the best . （ Because of this FAQ It was the year before last , Now it is recommended to choose oracle 10G R2 Version of ）
- Oracle There are several versions of database software ？
A：Oracle Database software is divided into personal version 、 The standard version 1、 The standard version 、 Enterprise Edition .
- Can you talk about personal version 、 The standard version 1、 The standard version 、 The characteristics and differences of Enterprise Edition ？
A： The standard version 1（Standard Edition One） Apply to 1-2CPU Server for , The price has a considerable advantage , But only for stand-alone environments , Suitable for small and medium-sized user entry-level applications ;
The standard version （Standard Edition） Apply to 1-4CPU Server for , Include 4CPU Single server or 2 Taiwan Shuang CPU Server configuration , It can be used for dual hot standby or RAC, The price is moderate , It is suitable for large and medium-sized user working group level and department level applications which have further requirements for database performance and security ;
Enterprise Edition （Enterprise Edition） For single machine 、 Two 、 many CPU Multi node cluster and other environments , The function is all ready , But the cost is also higher , It is suitable for large-scale database with high requirements for database performance and reliability 、 Super large users, enterprise class 、 High end enterprise applications .
For comparison of function modules, please refer to 《Oracle Database white paper 》.
- Is the enterprise version better than the Standard Version ？
A： The enterprise edition is fully functional , Provides higher reliability and performance , But it also means more hardware costs . Users are advised to determine the version according to their actual needs , The best is the best .
- Oracle How to order ？
A： There are two ways to order and press CPU Two ways to order , Among them, press CPU The so-called unlimited edition is also called unlimited edition .
- Oracle The official definition of the number of users ？
A： Every visit Oracle Database users , Whether it's a natural person or a device , Count as a user (Named User).
Official definition in English ：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.
- Oracle How to calculate the number of users ？
A：Oracle The official minimum number of users for each version is ：
Personal version ：1user*PC Count
The standard version 1= Server's CPU Count *5
The standard version = Server's CPU Count *10user
Enterprise Edition = Server's CPU Count *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 .
- Under what circumstances must be in accordance with CPU Order ？
A： visit Oracle There are a lot of users , Or if you can't estimate the number of users , It should be in accordance with CPU（Processor） Order .
- Processor Official definition ？
A： Equal to installation Oracle Database software server of CPU total .
Official definition in English ：Processor: shall be defined as all processors where the Oracle programs are installed and/or running. Programs licensed on a Processor basis may be accessed by your internal users (including agents and contractors) and by your third party users.
- Please give an example of ？
A： for example , If the user's application is based on Internet,Oracle As a website background database , according to Oracle The official definition of the number of users , Every one passes Internet Visit website （ database ） All of them count as 1 Users , So there are a lot of users , And it can't be predicted , Therefore, it should be in accordance with CPU Quantity order .
- Press CPU Is the order expensive ？
A： In general ,1CPU The cost of is approximately equal to 50user The cost of , So if the number of users >CPU Count *50, Then press CPU Ordering is more economical
- whether Internet or B/S The application of architecture must be in accordance with CPU Order ？
A： not always , If you visit Oracle The number of users of the database can be estimated , And the number of users is not large （ Less than server CPU Count *50）, You can also order according to the number of users .
- Oracle Open quotation of database software （List Price） How much is the ？
A： Please refer to the public offer （List Price） surface .
- Oracle How to calculate the price of database software ？
A： Calculation formula ：Q=(PN(1-D)(1+22%)+415)(1+17%)
Q： Price including tax after discount
P： Unit price without tax （ Per user or per CPU）
N： Number of users or CPU（Processor） Count ;
D： discount （%off）, The starting discount is 30%off.
22%： Standard service charge for one year , Among them, product support 7%, Upgrade support 15%;
C： Media fee , At present, it is RMB 600/ set .
17%： The VAT
- What's the discount ？
A：Oracle The official rules Oracle The starting discount for database software to end users is 25%off, End user information must be provided when applying for a special discount , Please refer to 《Oracle Software order confirmation letter 》.
- Whether the trial version is available ？ How long is the probation period ？
A： After reaching the order intention , A trial version is available for free trial 、 assessment , The probation period is one month . If you don't order after the probation period , The user must uninstall from the system 、 Remove installed Oracle Trial software .