Real User
Top 10
The solution is stable and scalable, but it is very expensive, and the setup is a bit complex
Pros and Cons
  • "Oracle is a stable database."
  • "The setup is a bit complex."

What is our primary use case?

We use the solution for our enterprise applications.

What is most valuable?

Oracle is a stable database.

What needs improvement?

The setup is a bit complex.

For how long have I used the solution?

I have been using the solution for many years.

Buyer's Guide
Oracle Database Appliance
April 2024
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.

What do I think about the stability of the solution?

The tool is stable.

What do I think about the scalability of the solution?

The tool is scalable. All my key applications are on Oracle. We might increase the usage depending on the business growth.

How are customer service and support?

I have contacted support. We have a good relationship with the team.

Which solution did I use previously and why did I switch?

We have used MySQL and PostgreSQL.

What about the implementation team?

The solution can be deployed in-house.

What was our ROI?

We have seen some value in the solution.

What's my experience with pricing, setup cost, and licensing?

Oracle’s pricing is ridiculously high.

What other advice do I have?

I would recommend the product if someone is using very data-sensitive applications. Overall, I rate the product a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Andrei Popescu - PeerSpot reviewer
MIS Coordinator at IDEA BANK
Real User
Top 20
A legacy solution for operational purposes with easy setup

What is our primary use case?

We use the solution for operational purposes. It is the core app built on top of it.

What is most valuable?

I like the solution’s performance.

What needs improvement?

The solution requires improvement regarding scalability and artificial intelligence.

For how long have I used the solution?

I have been using Oracle Database Appliance as a customer for eight years.

What do I think about the stability of the solution?

I rate the solution’s stability an eight out of ten.

What do I think about the scalability of the solution?

Around 100 people are using this solution daily.

I rate the solution’s scalability a four or five out of ten.

How was the initial setup?

The initial setup is easy.
I rate the solution’s setup an eight out of ten.

What about the implementation team?

The solution requires six or seven in-house people to deploy.

What's my experience with pricing, setup cost, and licensing?

I rate the solution’s pricing a seven out of ten, where one is cheap, and ten is expensive.

What other advice do I have?

We need three people, including a Linux expert, for the solution’s maintenance.
I recommend the solution for operational purposes with performance on-prem.

Overall, I rate the solution an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Oracle Database Appliance
April 2024
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
it_user689538 - PeerSpot reviewer
Senior Consultant at a tech services company with 501-1,000 employees
Consultant
We value the appliance architecture with its “everything-in-a-box” highly standardized setup.
Pros and Cons
  • "We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
  • "In my opinion only one single command should be used for all ODA models, as it’s confusing."

What is our primary use case?

Database consolidation and for X6-2L also database performance improvement due to NVMe storage being used, which dramatically increases I/O performance

What is most valuable?

We value the appliance architecture with its “everything-in-a-box” highly standardized setup.

For the new ODA X6-2 models there is a possibility to deploy also SE/SE2 databases in a bare-metal deployment as well as the boosted I/O performance due to NVMe Flash disks.

How has it helped my organization?

For one customer it consolidated several databases from several Windows physical servers into one single ODA and resulted in increased stability.

For another customer it was used to “isolate” the last Oracle database system on one single ODA, thereby freeing-up SAN storage and rack server slots used by an old Linux cluster.

What needs improvement?

The following issues need some attention:

  • Ease of administration and deployment. With ODA X6-2 there are different “OAK” administration commands for the S/M/L models (e.g. “odacli”) compared to the HA model ("oakcli").
  • In my opinion only one single command should be used for all ODA models, as it’s confusing.
  • Some of the new commands have limitations/restrictions, though I assume they’ll be improved over time.

For how long have I used the solution?

We have been using the solution since 2012. We implemented 2x ODA V1 systems.

What was my experience with deployment of the solution?

With the X6-2L we had a couple of early replacements, e.g. PCI card and battery

What do I think about the stability of the solution?

We only had a stability issue with the ODA V1 due to an ASM disk mount issue (“ORA-600 [KFDJOIN3]”, bug). This issue delayed the go-live for production databases, but was fixed with the assistance of Oracle Support relatively fast.

What do I think about the scalability of the solution?

We only had a scalability issue regarding local storage, especially on the ODA V1.

How are customer service and technical support?

I would rate the technical support as six out of 10. Over the past couple of years, I’ve found that the quality of Oracle Support first-level has decreased.

Which solution did I use previously and why did I switch?

We used custom-built single-server or cluster solutions. The ODA provides a high degree of standardization.

How was the initial setup?

The initial deployment of 2x ODA V1s was accomplished in one day, including unpacking and rack-mounting.

What's my experience with pricing, setup cost, and licensing?

Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE.

Which other solutions did I evaluate?

We evaluated Exadata, which often is overkill for many small and medium sized databases.

What other advice do I have?

If you go with 1x ODA then at least establish a Data Guard standby system on a Linux server, e.g. Public Cloud. I suggest to use 2x ODAs in each DR setup.

Disclosure: My company has a business relationship with this vendor other than being a customer: Trivadis is an Oracle Platinum Partner.
PeerSpot user
PeerSpot user
Sr. Director, Systems & Databases at GTech
Real User
Capacity on Demand enables us to configure CPU cores according to licenses, increasing or decreasing as needed
Pros and Cons
  • "NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
  • "Virtualization features could also be improved. A web-based GUI would be a good start."

How has it helped my organization?

Nowadays, we migrate midsize EBS environments (EBS 11i, 12.1 and 12.2) to these machines. We use the machine as a consolidation environment and we also see a performance increase in the database layer.

Customers with limited licenses prefer this machine, as it has capacity-on-demand features which are completely aligned with Oracle licensing policies.

It is an easy-to-deploy database environment, which does not need much maintenance work. A DBA with knowledge of Oracle technologies, such as ASM and database, can manage it.

The system resources of this machine are quite enough for running midsize Oracle databases but, if there is a need, customers can expand their disk and memory resources.

This machine is also used as a standby database environment, especially for customers who have ODA HA or Exadata in their primary sites, and want to have an affordable engineered system for their standby sites.

What is most valuable?

  • Capacity on Demand: Valuable because we can configure the machine according to our licenses. When there is a need, we can directly increase or decrease the CPU cores of this machine.
  • NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying.
  • Virtualization: Using the KVM (Kernel-based Virtual Machine), we can virtualize this machine and run both databases and applications on it.
  • Affordable price: When we think about the technology and the features that this machine delivers, the price seems to provide a lot of value.
  • Engineered system: This machine is a 1U engineered system optimized, tested and delivered by Oracle. It is a ready-to-use, easy-to-deploy environment for running Oracle products.
  • Support for multiple database versions: Both 11.2.0.4 and 12c databases are supported with this machine.
  • Support for multiple database editions: Both Standard edition and Enterprise edition databases are supported with this machine.
  • ODA X6-2 is easy to manage: It delivers management utilities such as odacli and virt-manager (for virtualization management).

What needs improvement?

Oracle ODA is a fixed server appliance. It would be improved if it were an engineered system with scale-out capabilities.

Virtualization features could also be improved. A web-based GUI would be a good start.

Also VM-specific features, which provide VM-level fault tolerancy, could be added to this product. (This improvement would depends on the scale-out capabilities).

For how long have I used the solution?

I have used ODA X3, X4 and X5 models for three years. This ODA X6-2M is a new ODA model and I have used it the last six months.

What do I think about the stability of the solution?

None.

What do I think about the scalability of the solution?

No issues, but there is room for improvement here. Currently, there is no scale-out option for any of the models in ODA family.

How are customer service and technical support?

Quite good. When you buy this machine it is registered with Oracle. Any service request is created using this registration. SR creation and updates are fast.

Which solution did I use previously and why did I switch?

Conventional systems. Most of the time, the reasons for switching are the optimal price and the promising features.

How was the initial setup?

Straightforward. The whole environment is built in one hour by following the Oracle documentation and using the related utilities.

What's my experience with pricing, setup cost, and licensing?

Get benefit from the capacity-on-demand features. License your cores according to your licenses.

Which other solutions did I evaluate?

Standard HP servers and other members of the ODA family (such as ODA X6-2S, L and HA).

What other advice do I have?

To others looking into this product I would recommend they take a look at ODA X7, which has been released.

ODA X7 delivers more system resources and it also delivers Standard Edition Oracle Database support for the HA (High Availability) model.

Disclosure: My company has a business relationship with this vendor other than being a customer: Oracle Gold Partner.
PeerSpot user
Lead Oracle DBA at a healthcare company with 5,001-10,000 employees
Real User
Affordable, user-friendly, and offers good technical support
Pros and Cons
  • "The solution is pretty automated, which takes out the possibility of human error."
  • "The product is quite complex to set up, initially. It would be ideal if it was simpler."

What is our primary use case?

We support their warehouse and we are looking into the network data warehouse product, which is tightly integrated. This is pretty much the go-to product for that process due to the fact that it's all in one box, and is pre-packaged. It's all Oracle servers, and Oracle hardware, and Oracle software and it's all in one.

How has it helped my organization?

We used to have different vendors and servers. Everything was all over the place. Now that we are on Oracle, everything is centralized, removing a lot of complexity.

What is most valuable?

The deployment is super-simple as everything is pre-packaged. There's very little configuration to worry about.

We manage everything through the appliance. It's easier to manage from our side of the managed databases and add more storage, et cetera. It's very easy to mimic what we need. we can easily add more storage whenever we want. The scalability is great.

We had Commodity servers - those bales servers on-premises - and there was a lot of maintenance going on with that. After moving to RDA, life is much easier because everything is managed through those deployed solutions. It's easier to manage this way.

From a maintenance point of view and from an upgrade and migration point of view, it is very easy because most of the upgrades are fast. We can take one down and finish the upgrade and move onto the next as necessary. It's easier to manage the patches and upgrades.

The solution is pretty automated, which takes out the possibility of human error.

The pricing is great. It's much better than what the competition is offering.

The product is pretty user-friendly.

What needs improvement?

There aren't really any features that the solution is lacking.

The product is quite complex to set up, initially. It would be ideal if it was simpler.

Any limitations within the solution are case by case. The solution may work for some, but it isn't for everyone.

The product is still evolving. It could still, for example, be more user-friendly. It's not quite perfect yet.

For how long have I used the solution?

I've been using this solution since last year.

What do I think about the stability of the solution?

The solution is pretty stable. I don't recall bugs or glitches. It doesn't crash. I find it pretty reliable overall.

What do I think about the scalability of the solution?

The solution can easily scale. We've found that if we need to add more storage, it's very straightforward to do so. If a company needs to scale, it's not a problem with Oracle.

In our case, because we are on-premises, there are some limitations due to the fact that we only have two servers. We understand our limitations and we know it will work well for us over the next five years or so. And then, if we need to expand, we can plan for that.

We have about 500 active users within our company on the solution. We have reporting applications and a lot of data manipulations, and all that going on, on this database. It's mostly IT personnel on it currently.

How are customer service and technical support?

We've worked with Oracle a lot, compared to other previous solutions. The company sells it with support and clients get account managers that they can reach out to. Overall, technical support has been good. I'd rate it a nine out of ten. They are very knowledgeable and responsive. They are very good. We've been satisfied with the service provided.

Which solution did I use previously and why did I switch?

We used to have similar databases on different servers, and we had to work through different vendors. We had different storage, then different servers, then different vendors and the backup solution was on another vendor as well. There was a lot of coordination required. It added a lot of complexity to everything. With this kind of a solution, everything is on one kind of a black box. We don't have to worry too much and the level of coordination required has dissipated.

How was the initial setup?

The initial setup is not straightforward. It's quite complex. Once you get the hang of it and get it going, it's easier for others on our application team. It's also easier to manage int he long run. The main problem is that it's quite different from what we used to do, so there's a bit of a learning curve during the setup.

What's my experience with pricing, setup cost, and licensing?

The pricing is really good for us. We have no complaints there. It's not as expensive as other products on the market. The excellent price point is one of the reasons we moved to RDA.

What other advice do I have?

We're just a customer. We don't have a business relationship with Oracle.

Due to the current contractual agreements, et cetera, within our organization, we are not doing or considering anything on the cloud - from the database side at least.

I'd rate the solution eight out of ten. There are still some limitations. That said, it did simplify a lot of things for us, compared to our old setup.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1396542 - PeerSpot reviewer
Senior Vice President IT Operations at ZTBL
Real User
Quick performance with all-flash memory, and good technical support
Pros and Cons
  • "The most valuable feature is the performance."
  • "We would like the ability to add more storage without having to upgrade to Oracle Exadata."

What is our primary use case?

End User response time for Core Banking Application

How has it helped my organization?

By adding ODA in our infrastructure, it helps to spare time for other Adminstration & Research activities..

What is most valuable?

The most valuable feature is the performance. Its a pre-configured device and you just plug and play..

What needs improvement?

It has limitations of Storage as well as network connectiivty over 10G Fiber. 

For how long have I used the solution?

We have been using the Oracle Database Appliance for about six years, since 2014.

What do I think about the stability of the solution?

The appliance is pretty stable.

What do I think about the scalability of the solution?

It is scalable, although it only has two storage shelves available.  The total usual storage after RAID dual parity is between 12 and 15 TB.

How are customer service and technical support?

Technical support is very good and the people are nice.

Which solution did I use previously and why did I switch?

Prior to using the appliance, we had our Oracle Database installed on a Dell server. We had some performance issues with the system, which is why we switched.

How was the initial setup?

The initial setup is okay. We just have to plug in the machine and set up the applications.

What about the implementation team?

Although, the purchase contract have engagement of the vendors for its deployment and in PAKISTAN we at ZTBL is the first who are deploying the ODA. since its a pre configured machine so no special training is required for its deployment. Moreover, the expertise level of the vendor is satisfied.

What was our ROI?

By deploying ODA in your infra, you can spare time for other activities instead of resolving issues of traditional system.

What's my experience with pricing, setup cost, and licensing?

Should go wiht ODA , breakup the cost of hardware, setup & Licensing, you will find that ODA is much cheaper than any other solution in terms of setup and operational cost

Which other solutions did I evaluate?

we had reviewed traditional system configuration like servers attached wiht any SAN storage. But the performance benchmarks we have with ODA is not avavilabe in other options.

What other advice do I have?

The Oracle Database Appliance is a product that I recommend. It is really good for small businesses where there are database-intensive applications that need high performance.

I would rate this solution a ten out of ten.

Which deployment model are you using for this solution?

On-premises

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Owner at a tech services company
Real User
​The solution has good stability and it is easy to work with.

What is most valuable?

The Oracle Database Appliance offers a pay-as-you grow model for Oracle licenses. This model allows you to only license the CPU count that you need, rather than the entire capacity. When virtualized, this is supported for both the database and the application tier.

How has it helped my organization?

The solution has good stability and it is easy to work with. We quickly deployed both database and application workloads in a single appliance on a virtualized platform, based on Oracle VM

What needs improvement?

Customers cannot cluster multiple appliances together to create a larger cluster (beyond two servers), nor can they expand the internal disk storage of the system beyond two storage trays. This area can be improved.

For how long have I used the solution?

I have used this solution for two years.

What do I think about the stability of the solution?

I did not encounter any issues with stability.

How are customer service and technical support?

I would rate the level of technical support 8/10.

Which solution did I use previously and why did I switch?

I previously used Fresh Install.

How was the initial setup?

The initial setup was quite straightforward.

What's my experience with pricing, setup cost, and licensing?

The pricing and licensing is worth it.

Which other solutions did I evaluate?

I did not really evaluate other options before choosing.

What other advice do I have?

In my opinion, if your organization is constantly evolving and looking for less infrastructure support/planning for virtualization, then this solution is a one-stop-shop and a nice product. If you are a mid-pace organization and can handle regular databases or Exacta, then you can skip this step.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
IT Director at a tech services company with 11-50 employees
Reseller
Top 10
An affordable solution offering a moderate level of scalability for its users
Pros and Cons
  • "The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
  • "Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."

What is our primary use case?

Oracle Database Appliance is for databases, specifically for Oracle databases.

How has it helped my organization?

My clients are experiencing benefits from the increase in functionality or productivity compared to their previous solution since they are running their RAC database on three dots. So, we migrated our referrals to Oracle Database Appliance as it is a good solution in terms of performance.

What is most valuable?

The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks. Additionally, regarding the graphical user interface, anybody can manage the VMs.

What needs improvement?

I feel that there are no features that need to be added to the tool since the tool is pretty much perfect the way it is.

For how long have I used the solution?

I have been using the solution for five years. I am using Oracle Database Appliance Version 6 or 7.

What do I think about the stability of the solution?

In terms of stability, I rate this solution an eight out of ten.

What do I think about the scalability of the solution?

Since we don't have the room to scale up, I rate this solution a six out of ten for scalability.

How are customer service and support?

My experience with the support team of Oracle Database Appliance has been very good.

What's my experience with pricing, setup cost, and licensing?

Compared to Oracle Exadata, Oracle Database Appliance is affordable. I don't think there are any extra features that you need to purchase to run the solution. Also, the solution is good for managing devices.

What other advice do I have?

We always propose Oracle Database Appliance to our small and medium customers, so that they can run their Oracle Workflow from the Oracle Database Appliance while benefiting from Oracle licensing. I rate this solution a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: implementer
PeerSpot user
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Data Warehouse
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros sharing their opinions.