111

ORACLE DATABASE STD ED 2 PROC PRP LIC

Mfg. Part: L103399 | CDW Part: 3844289 | UNSPSC: 43232304
Request Pricing
Close

Have leasing questions? Let us know how can we help.

Note: Leasing is available to organizations only. Leasing is not available to individuals.
800.808.4239
Mon-Fri 7am-7:30pm CT
Availability:
Ships today if ordered within 4 hrs 38 mins
  • License
  • 1 processor
  • Linux
  • Win
  • AIX
  • HP-UX
  • Solaris
View More
Product Overview
Main Features
  • License
  • 1 processor
  • Linux
  • Win
  • AIX
  • HP-UX
  • Solaris
Oracle Database Standard Edition 2 is an affordable, full-featured database built for unprecedented ease of use, power, and performance. From singleserver environments for small business to highly distributed branch environments, Oracle Database Standard Edition 2 includes all the features necessary to build business applications.

Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
System Requirements
Platform: AIX , HP-UX , Linux , Solaris , Windows

Software
License Category: License
License Qty: 1 processor
License Type: License

Header
Brand: Oracle
Compatibility: PC , Unix
Manufacturer: Oracle Software
Model: Database Standard Edition 2
Packaged Quantity: 1
Product Line: Oracle

General
Category: Business applications
Installation Type: Locally installed
Subcategory: Business - databases / database tools

Product Reviews
Rated 4.1 out of 5 by 37reviewers.
Rated 4 out of 5 by Performance, Durability, Security. Valuable Features:* Performance* Durability* SecurityImprovements to My Organization:For a long time I've been working as a performance tuner for Oracle and Java. The tuning of the performance is very important for me.Room for Improvement:I want the price to be lowered.Stability Issues:Oracle solutions are the most used, so we don't need to do verification of the product on our own. We can assume that the product's reliability is high enough. Based on Oracle products we are able to run our own developed applications at very high performance levels.Scalability Issues:What we do is that based on a certain understanding about the product speck, based on the maximum transaction we can assume for our businesses, we are going to decide the sizing and then we confirm the capability and we decide the threshold. Then after that we do the scale up. Based on the recent cloud environment, I cannot really say that it's easier for us to do the scale up.Technical Support:The people who used to work in Oracle are responsible for the tentative troubleshooting at the 1st stage. Then if we need more further investigation, then we exchange the technical support contract. Based on that agreement they will provide us with support. Once we purchase the product from the Oracle, then they offer the knowledge. The structure of the knowledge is quite well-shaped.Other Advice:For colleagues who are in the financial business and are looking into what kind of product they want to use for their databases - I would recommend using the Oracle Database because in terms of the security and in terms of the audit process it's top notch. When it comes to audits, as long as we say we are using Oracle Database, then they give us a certain assurance. They're confident about it.Disclaimer: I am a real user, and this review is based on my own experience and opinions. December 24, 2016
Rated 4 out of 5 by With multi-tenancy, you can set up background processes and memory at the container level. Valuable Features:The most valuable feature we have found is the multi-tenancy. You can set up background processes and memory at the container level, not at the pluggable level. he second thing is, I can set up a disaster recovery solution for the container database, not at the pluggable level, so that if I have more pluggable databases, I do not need to worry about disaster recovery setup at the pluggable database level. I only have to set it up one time at the containment level. I can reduce my time, effort, cost, everything. I feel this is one of the best features in 12c, multi-tenancy.Another valuable feature Oracle has released is the Flex ASM in RAC. In 10g and 11c, if something goes wrong for you with A, some instance, your database will go down. But in 12c, if something goes wrong for you with A, some instance, your database will not go down. You automatically use the next two machines, A, some instance. These are two wonderful features that we have used in database 12c.One more very cool feature is called Information Lifecycle Management, ILM. It is one of the best features right now.Improvements to My Organization:Instead of maintaining multiple servers, multiple databases, multiple disaster recovery solution setups for several levels, if you implement the 12c multi-tenancy, I only have to set it up for one container, not for all of the pluggable databases. I can reduce my support, my time, my effort, my cost, my server cost.Room for Improvement:Upgrades.Use of Solution:We have been using 12c for 10 months.Stability Issues:We have been using it for the past 10 months. We have not had any stability issues, at all. We updated the PSU patches, just the CPU patches; it's up and running for months.Scalability Issues:We haven’t exactly scaled it right now. Once we upgrade the remaining databases, we can go ahead with scaling it.Technical Support:We raised a couple of SR requests with the Oracle team, and they responded quickly. We have successfully upgraded one database to 12c.We are really pretty happy. In the coming months, we are going to upgrade three to four databases to 12c. I attended an Oracle OpenWorld conference to get some information about how I can upgrade with nearly zero down time. I was looking for that.Initial Setup:Upgrading it is not easy, because application to application could be different architecture. Before upgrading to 12c, we have to go into QA and development, from us to QA and development. Once that is successful, you can go ahead with production. Until now, out of six databases, we have upgraded to 12c on one platform; it was smooth.Other Advice:When you upgrade from 11g to 12c, consider your execution plans. Before upgrading, check it out in the QA and development environments. The third thing is, when you go about upgrading from 11g to 12c, plan how many databases you are going to make as pluggable, and how much memory it requires, and what flat file from exactly you are moving to upgrade. These are the three things you have to keep it mind when it comes to upgrading from 11g to 12c.Although it is smooth coming into production, you have to be careful. Until now, it has been very smooth. We didn't raise any issues, but we have raised a couple of SR requests. Oracle has provided a smooth solution.Disclaimer: I am a real user, and this review is based on my own experience and opinions. December 22, 2016
Rated 4 out of 5 by Oracle is our product of choice because of its stability, scalability, reliability, and flexibility. Valuable Features:RDBMS, we still believe, is Oracle's core product. Hence any time we are looking at any database features or building a new database, Oracle is always our product of choice because of its stability, scalability, reliability, and flexibility.Improvements to My Organization:It would be the stability that's improved our organization the most. We are a 24/7 manufacturing plant. We take one day off a year, Christmas Day. Other than that, we're building and creating drugs and the stability of the Oracle database enables us to have near 100% uptime 24/7/364.Room for Improvement:It's so expensive, particularly Enterprise Edition, and that would be my number one gripe. It's very, very expensive. Also, Oracle makes a big show of its new features and enhancers with each new release, but it's very rare that any of those enhancements come with Database by default. You have to pay for each of those enhancement -- and pay heavily at that.Deployment Issues:In the latter versions of the 12c product, I've actually found it a little bit more difficult to set up than it was before. I find that Oracle is introducing many, many, many new features with each part of the database. Sometimes I think they're losing focus of the core components and what customers actually need. I think if they concentrated on the core elements of RDMS, which, for me, is their number one product, I think before going on the periphery and looking at small enhancements or additions to the product, they should look into making it even more stable before they do these major releases.Stability Issues:It's been very stable for us.Scalability Issues:I would say the scalability sets it apart from others. We run a big manufacturing plant and the database is growing at a very very, high rate, but we know with the Oracle RDBMS, it can sustain growth from now and into the future.Initial Setup:I actually found that the earlier versions of RDBMS were actually easier to set up, so I've been working with the Oracle product right from Oracle 7, and I obviously will in 12c. I find now in 12c, I would expected laying out Oracle Database to become easier, but I actually think it's a little bit more complicated now in these later versions. I can categorically say that the joining up with the Oracle agent between RDBMS and Oracle Enterprise Manager is an extremely complicated process. When we were on TNG before we'd done any upgrades, the agent to get the database to talk to Enterprise Manager was a really, really simple thing to do. In fact, right now it's extremely complicated.Other Advice:For installing the database or looking at the database, I would say look at the components that you need within the database. What we generally find is that most of the features that we want, or most of the features that are available in Enterprise Edition, we actually wouldn't use, so take time and you might actually see them only by using Standard Edition.Disclaimer: I am a real user, and this review is based on my own experience and opinions. December 12, 2016
Rated 4 out of 5 by It's a database that's easy to recover if you need ways to restore and recover. Valuable Features:It's very stable. It's a database that's easy to recover if you need ways to restore and recover, and I like the performance.Room for Improvement:The feature that I would like is a way to grant select tables of one user to another without needing to specify each one separately, or creating a trigger to do this automatically. Being able to grant all privileges of some object or some schema to another schema would be good.Also, I would like to have a better Export Data Hub. The old export allowed you to export remotely, and Data Hub is just locally using directories or a database link. I would like to have Export Data Hub using the SQL match instead of directories or another database. Just like the old export.Use of Solution:I've been using it for around 10 years.Stability Issues:It's stable.Scalability Issues:It's scalable. When I need to deploy other databases or other schemas, it's very easy to do. Now with the multitenant model, it's even easier.Technical Support:They have this thing that you can only create a P1 for something that is harming your production. Sometimes I would like to create a P1 for other problems, but I can't, because it's something that is putting my company at risk. They are good in supporting us, but I don't like the policy of P1, P2, P3, or P4.Initial Setup:It's very easy to set up, not for someone who has never worked with it, but if you had a junior or someone a little more experienced than a junior, they are good enough to deploy.Cost and Licensing Advice:I think it's very expensive when compared to the others. Depending on the size of the company, smaller ones will not choose Oracle because they can get fixed solutions or less expensive solutions. If I were Oracle, I would create a solution that would serve these small companies for a better price, maybe with a lot less options, but not as expensive as some other options.Other Advice:I think security is a concern in the database, so you need to take care before granting some privileges to a DBA and it can become very easy to break. I would say to be very careful before granting permissions or configuring the database.Disclaimer: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. November 23, 2016
Rated 5 out of 5 by I consider one of the top features to be the concurrency and consistency model that allows many simultaneous users with little or no locking. Valuable Features:The powerful SQL language for working with, analyzing and manipulating lots of data. The concurrency and consistency model that allows many simultaneous users with little or no locking. The extensibility using PL/SQL and Java to extend legacy application with modern features like webservices via the database.Improvements to My Organization:Rewriting legacy procedural modules to SQL with analytic functions has on several occasions turned multi-hour jobs into few-minute jobs. High concurrency enables sales persons in shops to service customers swiftly with no waiting even on peak days with several sales per second. Even though legacy application cannot interface with external services, the database is capable of doing so, which enables the business to get new ideas without thinking of technological hindrances.Room for Improvement:There's not much - new features come along in every version helping to keep up withtechnological advances. There are some small technical issues such as support forwindowing clause in LISTAGG function and a few similar small issues in SQL. There are a few nice-to-have extensions, like allowing external table syntax on the content of a CLOB.Use of Solution:I've used it since 1996.Stability Issues:Some of the time, a Real Application Cluster version was used, which turned out on very rare occasions to performed unmotivated failover to other node. The problem really was sub-optimal coding of the legacy application in the use of the locking methods of Oracle, which was magnified when propagating locks to other nodes, however would have been nice if RAC could have handled it, even when sup-optimal. After switching some years ago to a single server non-RAC solution, the database has been rock steady - only instabilities was when O/S or hardware failed, not the database.Technical Support:Highly knowledgeable and competent tech support - once you get past the first level and get the case assigned to the right people. However, it can take quite a bit of time to explain details to first level support and gather debug and log information, that in some cases aren't necessarily relevant but is merely correct procedure in order to get the case assigned. On the other hand, many key Oracle people engage in the community, so a finicky question about a PL/SQL detail might get attention and answers from product managers themselves.Previous Solutions:Before 1996 we used a legacy application, but it would locked on a table level. That meant practically no concurrency, for example phone sales people could not enter order data while talking to the customer but wrote on paper. Then one guy would enter all orders later. After a demonstration of Oracle database giving high concurrency, it was very easy for my boss to decide to buy Oracle.Initial Setup:An external consultant was hired for the setup and there was no trouble with the database setup. The legacy application needed a bit extra setting up to get it to run properly with Oracle, but that was not the fault of Oracle.Cost and Licensing Advice:Bargain with the sales representative for good discounts - particularly if you buy several licences at once. But beware when buying multiple licenses together you get them on a single CSI, which may give trouble in future if you need to cancel one license out of the total, as that in principle means cancelling all licences and renegotiating so you may get new prices with less discount on the yearly support fees for the licences you have left. Research all the things that actually is possible with the basic licence so you get your value-for-money and only pay for options if you really need them.Other Solutions Considered:There weren't many options at the time. A database supported by the legacy application had to be chosen, and the native legacy database just wasn't up to concurrency demands as described above, so Oracle was the other choice.Other Advice:Oracle database can do many things that you may think it is necessary to supplement with other products. Look into how you may use all of the features to get value-for-money - then it might turn out in the long run to be cheaper than having to integrate multiple products.Disclaimer: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer:Oracle partners November 19, 2016
Rated 3 out of 5 by All queries see a read consistent view of the database so that readers do not block writers and vice versa. I've encountered bugs with the implementation of optional features. Valuable Features:Oracle is the premier relational database platform for enterprise environments. Any organization that purchases enterprise applications will likely have Oracle in place since so many applications require or prefer it.The most valuable features of Oracle database from my perspective are:* Read consistency (all queries see a read consistent view of the database so that readers do not block writers and vice versa).* Data Guard: standby database, with options for maximum performance, availability and protection. I use it in full-synchronous mode to ensure a “hot standby” is available with zero data loss.* Ability to run non-Windows OS, particularly Linux.* Ability to monitor and tune; lots of instrumentation built in.Room for Improvement:Oracle Database is a big, complex technology stack with many options, features, management packs, etc. The base product (Oracle Database Enterprise Edition) is generally rock solid. Some of the oldest, most mature options are also quite reliable (example: Partitioning option). However, most of the other optional products create additional issues. Almost every time I have pursued the implementation of an optional feature I have encountered bugs, limitations or other unexpected behavior.I would like to see Oracle follow a model like Microsoft’s SQL Server Enterprise Edition, where all products and features are included by default. There are no “options” you can purchase with SQL Server EE. It seems like one of the results of Oracle’s plethora of optional offerings is confusion and quality issues.Use of Solution:I've been using Database for over 20 years. There are many additional options and management packs (examples: Partitioning, Tuning Pack, Diagnostics Pack, Lifecycle Management Pack, Active Data Guard, Advanced Compression, Advanced Security, RAC, etc.).Deployment Issues:A “simple” deployment of just Oracle Database Enterprise Edition is generally a trouble-free activity, albeit still tedious. The RDBMS kernel is perhaps the most mature on the market (Oracle and IBM’s DB2 were released about the same time).Stability Issues:It is one of the most stable solutions on the market.Scalability Issues:There are no issues with scaling it.Technical Support:Technical support is very good. I don’t use Oracle Support often to open a new case. Questions and issues I have are most often answered via the support portal. On the rare occasion a new service request is opened, I find the responses timely and helpful.Previous Solutions:In the past, I have used RAC (and before that OPS, its ancestor). In general, like most shared clustering technologies, the “solution” creates more problems than it solves. RAC’s complexity level requires full-time attention in my opinion. I abandoned the option in favor of VMware and virtual servers, which cover availability from a hardware-loss perspective. In cases where more availability is needed, the Data Guard option is sufficient and MUCH simpler to configure and use.I started with IBM’s DB2 and used SQL Server (Sybase initially, then Microsoft SQL Server after they split in the 90’s) before Oracle, so have used and evaluated all three of the major RDBMS vendors. I no longer use DB2 because the platform it was on (mainframe) was retired, but I still actively use Microsoft SQL Server.Both products have their place. I prefer SQL Server for the smaller, departmental applications and Microsoft-related back-office applications due to its ease of deployment and management. I prefer Oracle for most enterprise-scale applications due to its overall strength in this area (performance, scalability, availability) and ability to run on a non-Windows OS (we use Linux exclusively).Initial Setup:Oracle is a complex product, there is no way around that. Compared to Microsoft SQL Server, which can be installed with a few mouse clicks, Oracle takes planning, preparation and significantly more time and expertise.Implementation Team:We have always installed, configured, and managed Oracle with in-house personnel. I would not recommend outsourcing the implementation unless all support for the product were being outsourced. Oracle database requires expertise and constant attention. If an organization intends to support it internally, the personnel responsible for that support need to be the same that install and configure it.ROI:Oracle is very expensive. No organization that didn’t “have to” use Oracle would do so. If I were in a small business or an organization that did all of its own applications development, I would avoid Oracle simply due to its cost. Other databases on the market would suffice in those scenarios. Any medium-to-large business will probably not be able to avoid using Oracle database. I don’t think there is an ROI to calculate, but rather a sunk cost in doing business. My advice would be to limit the number of options and features and go with the bare minimum needed to support the needed applications.Other Advice:The technology behind the base RDBMS is excellent, probably the best on the market, but its cost and complexity are negatives. The personnel who will support need to get formal training and need to be dedicated database administrators. A part-time DBA will not be sufficient for anything more than a trivial deployment.Disclaimer: I am a real user, and this review is based on my own experience and opinions. October 3, 2016
Rated 4 out of 5 by Review about Oracle Database Valuable Features:Data Encrypton, Easy ConnectivityDisclaimer: I am a real user, and this review is based on my own experience and opinions. October 2, 2016
Rated 4 out of 5 by Review about Oracle Database Valuable Features:Scalability, security, concurrencyImprovements to My Organization:As the data was growing it was still able to deliver the performanceDisclaimer: I am a real user, and this review is based on my own experience and opinions. October 1, 2016
  • 2017-01-16 T10:16:36.476-06:00
  • bvseo_lps, prod_bvrr, vn_prr_5.6
  • cp-1, bvpage1
  • co_hasreviews, tv_37, tr_37
  • loc_en_US, sid_3844289, prod, sort_default
2 3 4 5next>>
 
Adding to Cart...
1/17/2017 11:22:00 AM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.

Error!

Something went wrong.

Please try again later.

License Selector

    The license selector is not currently available. Please try again later.