Oracle Database Standard Edition 2 - subscription license (5 years) - 1 nam

Mfg.Part: L104655 | CDW Part: 3933335 | UNSPSC: 43232304
Availability: In Stock
Was $245.00
$189.99 Advertised Price
Advertised Price
Product Details
  • Subscription license (5 years)
  • 1 named user plus
  • Oracle 1-Click Ordering
  • Linux
  • Win
View Full Product Details
Better Together
Oracle Database Standard Edition 2 - subscription license (5 years) - 1 nam
Quick View
Total Price:

Product Overview

Main Features
  • Subscription license (5 years)
  • 1 named user plus
  • Oracle 1-Click Ordering
  • Linux
  • Win
Oracle Database Standard Edition 2 is an affordable, full-featured database built for unprecedented ease of use, power, and performance. From single-server environments for small business to highly distributed branch environments, Oracle Database Standard Edition 2 includes all the features necessary to build business applications.

Oracle Database Standard Edition 2 - subscription license (5 years) - 1 nam is rated 4.1 out of 5 by 38.
Rated 5 out of 5 by from The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource. What is our primary use case?I have been working with Oracle products for more than 10 years, and as a consultant, I did a lot of implementations that include different database vendors. To be honest, Oracle Database ( /products/oracle-database-reviews ) provides you with different features that don't exist in any database, or you can find relevant features in other vendors, but it will not give the same capability Oracle Database ( /products/oracle-database-reviews ) has. Let's take for example RAC or real application cluster that provides HA for Oracle Database, it's considered as one of the best solutions for the database.I have worked on different environments for different big client names since it's my job role, and Oracle provides a different solution for DR, performance tuning, security, and HA.How has it helped my organization?Talking about this will be unfair because regarding my experience (which is on related services), Oracle Database improved client solution by discussing what they want first, and then finding what database is the best solution for them. Most of the time an Oracle Database license is so expensive if you want to compare it with different vendors, but on the other hand, if you're looking for the best features that a database could provide to you, then Oracle is considered as the number one database of all time.What is most valuable?* The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource. On the other hand, I find security products that are provided by Oracle very strong and not in comparison with any database vendor.* The encryption, database reduction, audit vault, database firewall: All of these products provide an extra layer of security when they are implemented in the right way.* Let's also mention real application cluster, and disaster recovery solution.What needs improvement?The additional features that should be included in the database: I would like to see improvements for database security products.For how long have I used the solution?More than five years.What do I think about the stability of the solution?one of the most stable database i ever seen, but to be honest the Support when you will have a bug or something it will make your life very hard.What do I think about the scalability of the solution?The Performance for the database in general is good and the tools to analyze the performance in case you have some issue it's perfect and make it easier for you.If you previously used a different solution, which one did you use and why did you switch?Yes, I used a different solution. The migration was to Oracle because we had to find the best for the client. It was a production database, and we needed 24/7 HA which other databases provided, but not as good as Oracle Database.What's my experience with pricing, setup cost, and licensing?The cost of Oracle Database is so high if you compare it to other vendors. Therefore you have to study your solution and know exactly which features you want; this will minimize the cost and licensing price. For that, Oracle provides different types of DB such as EE, SE, SE1, etc. depending on what the clients want.Which other solutions did I evaluate?Yes, I worked on SQL Server ( /products/sql-server-reviews ), MongoDB ( /products/mongodb-reviews ), MySQL ( /products/mysql-reviews ), and MariaDB ( /products/mariadb-reviews ).Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2019-04-24
Rated 4 out of 5 by from The advantage of using Oracle's RDMS solution is that it is integrated with Oracle's other products, including our ERP and EPM solutions. Valuable Features:The best aspect of Oracle Database is that it allows integration of our ERP and EPM suite of applications and databases. It's integrated tightly together, and we prefer that, as we think it's best to stick with a single vendor as much as possible to avoid dealing with multiple vendors in case of any issue. We can scale it up, upgrade and it is supported by Oracle's customer support program. It is secure and reliable, which gives us peace of mind. If we went with a third-party tool, there's always the issues of compatibility. If we do upgrades and there are issues, we'd have to talk to both the third-party vendor and Oracle.I think that avoiding complications and compatibility issues is the biggest advantage of keeping our Oracle ERP and EPM products together. I work with a lot of the compatibility settings, and Oracle has done a great job with the matrix inter-dependencies and patch-up ligation. For example, I just upgraded our Hyperion system so I had to got through all the settings and configurations for databases, browsers, Java, OS, and servers. I, as an administrator, have to have enough technical knowledge to understand all the inter-dependencies.That's the advantage of using Oracle's RDMS solution -- we can use other Oracle products.Room for Improvement:It needs a better, less technical interface. I'm not an expert on our RDBMS as we have our own database administrator, so especially on a Linux environment Oracle needs to make progress on the user-friendliness of the UI.In my opinion, I've found Microsoft SQL Server to be more user-friendly than Oracle Database. Even though the latter is more complex, more robust, and has more capacity, from a user perspective, especially those who are naive or functional, it needs to be more user-friendly.I've asked my DBA to do something for me so I can try to learn from him, but if it were more user-friendly with a more graphical implementation that tells you all the variation criteria and failure messages, that would be much better.Deployment Issues:We've had no issues deploying it. It's quite simple.Stability Issues:It's quite stable for being capable of doing so many things. It's powerful, fast, reliable, and secure.Scalability Issues:We have had no issues scaling it for our needs.Other Advice:You should consider whether you're going to go physical or virtual, Windows or Linux, etc. You should do your due diligence and know what you want.We decided to put Essbase and Database on Linux. We put everything else on Windows, the reason being that our databases needed more resources and liability. Linux provides more security for databases, and it's a more robust setup for a Linux admin. So be sure to consider this before jumping into an implementation of the Oracle RDBMS solution.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-08-31
Rated 4 out of 5 by from It performs automatic backup recovery and database management, both of which are useful. Valuable Features:It's enterprise-wide and can handle big databases. Also, it performs automatic backup recovery and database management and monitoring, both of which are extremely useful.Improvements to My Organization:We've reduced our time monitoring the database and, instead, spent more time researching and improving our system.Room for Improvement:The portal site needs to be improved, as sometimes it's very slow. They also need to improve their critical problem resolution, especially error ORA-60000. I hoped that they'd be able to reduce those types of errors by now.Deployment Issues:We've had no issues with deployment.Stability Issues:We very seldom have stability issues. It's been really stable so far.Scalability Issues:It's a scalable solution that comes at a cost.Technical Support:Issues are registered through their portal where we login our tickets. Sometimes, it's a bit slow and their response is a bit average unless it's Severity One, in which case the response time is really quick, about 1 or 2 hours. Otherwise, if it's Severity Three or below, it can probably take up to one day. Sometimes the development team needs to look into the issues.Initial Setup:Database was already set up when I joined, but I haven't heard that it was particularly complex.Cost and Licensing Advice:Oracle needs to reduce the licensing cost as it's getting more expensive.Other Advice:You have to really know the Oracle version type that you're working on, especially with the new Oracle chassis which is running on multi-tenant architecture. That is very important if you are, just like our company, on MTA, multi-tenant architecture. We have to really know the inside out how it works before we can actually support and maintain it. So be well prepared for it.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-01-23
Rated 4 out of 5 by from We're operating an Oracle RAC system, so we can scale when required. Valuable Features:It's the only database you can operate at a very high professional level and that offers what the customers need from the product, ACID.Improvements to My Organization:It's a crucial and critical part of our everyday business. That's what it does.Room for Improvement:Real zero-downtime patching, that's what I want.When you have a fallback system with RAC and Data Guard, the autonomous help framework could support it, but collecting the logs and reading the logs is still a nightmare. Improving this would be very good. The way Oracle does it today is OK, with in-memory options, with NoSQL database integrated and so on, but it could be a really good feature for the future.Scalability Issues:We have scaled it, but not to a very high extent.I think as we start to get into the IT business more and more, we will see how we need it. We are now operating an Oracle RAC system, so we can scale when required.Technical Support:Technical support is kind of different because at some point, you reach the point where you can't proceed any further with stand-up processes. You need to have context and background information about the company. We're lucky that we can get in touch directly with the development team. We get help there.Normally we have very complex problems when we have them. When we communicate with them using the standard channels, it does not fit. But, as I’ve mentioned, we have the direct line of communication with the development.Previous Solutions:It's like, how do you decide that you need electricity at home? It’s a given requirement from the business. We've been working with Oracle for many, many years and using the product for many, many versions.Initial Setup:We did the initial setup ourselves. We have a huge framework in which we did the complete setup. We installed the clusters. It was not straightforward. For such as huge company like ours, it’s not straightforward. There are too many management processes around and too many specialties in the company.Other Solutions Considered:We do not have any other vendors on a shortlist at this time.We have three flavors of relational databases: MS SQL, Oracle, and MySQL. MySQL should fit the open-source aspect, and then we have two huge relational databases. Therefore, MS SQL is more for the smaller deployment and Oracle is for the huge deployments. SAP release 3 runs on Oracle, too. It was in the company. We didn't decide to use Oracle or not. It was there.We just offer it to our customers and they choose. The mission-critical stuff runs on Oracle.Other Advice:It's very professional and there are good structures implemented there. When you are willing to pay, you can get everything. Basically, what you pay for with Oracle is the maturity of the product, and that is something you can rely on.Know how Oracle works. They say it's always been like that: you first sell, then you fulfill. You have to know that and that it's okay. You have to know that the new features will not work immediately.When we're looking at a vendor like Oracle, we look at two areas. One is the technical part and the other is that it's a huge company. When we have problems, there is a huge organization behind it that can support it. We have a lot of ways to escalate issues. We look for a really huge company with a lot of people with whom we can get in contact. When we go to open-source projects or to smaller projects and we have problems, it's not as easy. Communicating with Oracle is easier to manage.Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2017-01-23
Rated 4 out of 5 by from 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.
Date published: 2016-12-24
Rated 4 out of 5 by from 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.
Date published: 2016-12-22
Rated 4 out of 5 by from 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.
Date published: 2016-12-12
Rated 5 out of 5 by from 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
Date published: 2016-11-19
  • y_2019, m_7, d_15, h_15
  • bvseo_bulk, prod_bvrr, vn_bulk_2.0.12
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_38
  • loc_en_US, sid_3933335, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw