My Oracle 12c Experience
October 29, 2018

My Oracle 12c Experience

Kenneth Sparano | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

We use Oracle 12c across our entire organization on all our SAP applications.
  • Upgrade: Oracle 12c allowed us to upgrade 45 databases with no issues from 11.2 to 12.2 using DBUA.
  • RAC: We were able to implement two 4 nodes Oracle 12c RACs on linux. The implementation was straight forward and similar to Oracle 11 but with fewer issues.
  • Multitenant: Oracle 12c multitenant feature will allow us to run many more databases on the same hardware.
  • After upgrading to 12.2 we started receiving many ORA 600s. The fix was required us to reorg the offending table/indexes.
  • Stablility: Oracle 12c stability (besides some ORA-600 errrors) has been great. The ORA-600 required us to reorg some tables.
  • Easy upgrade: The upgrade process to Oracle 12c using DBUA has worked flawlessly.
  • OEM: Integration of our Oracle 12c databases with OEM has been great. No issues or patches needed with OEM 13.2.
  • We performed a hardware refresh in conjunction with our Oracle 12c upgrades. We upgraded to Redhat Linux 7, consolidated to less (but more powerful hardware), and upgraded to Oracle 12c. We also moved to new flash storage in the process.
Oracle 12c is superior to SQL Server for large mission critical databases and applications.

We also used DB2 in the past. We migrated many of our SAP applications from DB2 to Oracle 11.2 several years ago. These applications are now on Oracle 12c.
We upgraded to Oracle 12c to stay in support. This is especially critical for our SAP applications that run on the Oracle database. The upgrade process is pretty straight forward using DBUA (database upgrade assistant). Also, Oracle 12c Multi-tenant will allow us to run more databases on less hardware.

We didn't have any scenarios where Oracle 12c was not suited. We have upgraded all our Oracle 11 databases to Oracle 12c.