Oracle free version and paid version, description of each version

osc_4qu6doqx 2020-11-11 14:13:01
oracle free version paid version

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 .



3、Data Mining

4、Advanced Security

5、Label Security



8、Oracle Management Packs

Finally, there is something about oracle Of the product FAQ:

  1. 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

  1. 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 )

  1. 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 .

  1. 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 》.

  1. 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 .

  1. 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 .

  1. 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.

  1. 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 .

  1. 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 .

  1. 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.

  1. 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 .

  1. 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

  1. 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 .

  1. Oracle Open quotation of database software (List Price) How much is the ?

A: Please refer to the public offer (List Price) surface .

  1. Oracle How to calculate the price of database software ?

A: Calculation formula :Q=(PN(1-D)(1+22%)+415)(1+17%)

among :

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

  1. 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 》.

  1. 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 .


  1. 【计算机网络 12(1),尚学堂马士兵Java视频教程
  2. 【程序猿历程,史上最全的Java面试题集锦在这里
  3. 【程序猿历程(1),Javaweb视频教程百度云
  4. Notes on MySQL 45 lectures (1-7)
  5. [computer network 12 (1), Shang Xuetang Ma soldier java video tutorial
  6. The most complete collection of Java interview questions in history is here
  7. [process of program ape (1), JavaWeb video tutorial, baidu cloud
  8. Notes on MySQL 45 lectures (1-7)
  9. 精进 Spring Boot 03:Spring Boot 的配置文件和配置管理,以及用三种方式读取配置文件
  10. Refined spring boot 03: spring boot configuration files and configuration management, and reading configuration files in three ways
  11. 精进 Spring Boot 03:Spring Boot 的配置文件和配置管理,以及用三种方式读取配置文件
  12. Refined spring boot 03: spring boot configuration files and configuration management, and reading configuration files in three ways
  13. 【递归,Java传智播客笔记
  14. [recursion, Java intelligence podcast notes
  15. [adhere to painting for 386 days] the beginning of spring of 24 solar terms
  16. K8S系列第八篇(Service、EndPoints以及高可用kubeadm部署)
  17. K8s Series Part 8 (service, endpoints and high availability kubeadm deployment)
  18. 【重识 HTML (3),350道Java面试真题分享
  19. 【重识 HTML (2),Java并发编程必会的多线程你竟然还不会
  20. 【重识 HTML (1),二本Java小菜鸟4面字节跳动被秒成渣渣
  21. [re recognize HTML (3) and share 350 real Java interview questions
  22. [re recognize HTML (2). Multithreading is a must for Java Concurrent Programming. How dare you not
  23. [re recognize HTML (1), two Java rookies' 4-sided bytes beat and become slag in seconds
  24. 造轮子系列之RPC 1:如何从零开始开发RPC框架
  25. RPC 1: how to develop RPC framework from scratch
  26. 造轮子系列之RPC 1:如何从零开始开发RPC框架
  27. RPC 1: how to develop RPC framework from scratch
  28. 一次性捋清楚吧,对乱糟糟的,Spring事务扩展机制
  29. 一文彻底弄懂如何选择抽象类还是接口,连续四年百度Java岗必问面试题
  30. Redis常用命令
  31. 一双拖鞋引发的血案,狂神说Java系列笔记
  32. 一、mysql基础安装
  33. 一位程序员的独白:尽管我一生坎坷,Java框架面试基础
  34. Clear it all at once. For the messy, spring transaction extension mechanism
  35. A thorough understanding of how to choose abstract classes or interfaces, baidu Java post must ask interview questions for four consecutive years
  36. Redis common commands
  37. A pair of slippers triggered the murder, crazy God said java series notes
  38. 1、 MySQL basic installation
  39. Monologue of a programmer: despite my ups and downs in my life, Java framework is the foundation of interview
  40. 【大厂面试】三面三问Spring循环依赖,请一定要把这篇看完(建议收藏)
  41. 一线互联网企业中,springboot入门项目
  42. 一篇文带你入门SSM框架Spring开发,帮你快速拿Offer
  43. 【面试资料】Java全集、微服务、大数据、数据结构与算法、机器学习知识最全总结,283页pdf
  44. 【leetcode刷题】24.数组中重复的数字——Java版
  45. 【leetcode刷题】23.对称二叉树——Java版
  46. 【leetcode刷题】22.二叉树的中序遍历——Java版
  47. 【leetcode刷题】21.三数之和——Java版
  48. 【leetcode刷题】20.最长回文子串——Java版
  49. 【leetcode刷题】19.回文链表——Java版
  50. 【leetcode刷题】18.反转链表——Java版
  51. 【leetcode刷题】17.相交链表——Java&python版
  52. 【leetcode刷题】16.环形链表——Java版
  53. 【leetcode刷题】15.汉明距离——Java版
  54. 【leetcode刷题】14.找到所有数组中消失的数字——Java版
  55. 【leetcode刷题】13.比特位计数——Java版
  56. oracle控制用户权限命令
  57. 三年Java开发,继阿里,鲁班二期Java架构师
  58. Oracle必须要启动的服务
  59. 万字长文!深入剖析HashMap,Java基础笔试题大全带答案
  60. 一问Kafka就心慌?我却凭着这份,图灵学院vip课程百度云