Sr. Oracle DBA, working as an Oracle DBA for 20+ years since Oracle 7.3.4
September 19, 2019

Sr. Oracle DBA, working as an Oracle DBA for 20+ years since Oracle 7.3.4

Tiesong Lu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

I upgraded all Oracle production databases (about 15 production databases) from 11g R2 to 12c R2. The Oracle 12c databases are used university-wide, and are really critical to the university business.
  • I believe other users have reviewed the pros already. I am addressing only the Cons of 12c R2.
  • SYSAUX tablespace grows rapidly. I didn't need to add space to SYSAUX last a few years in 11g. But after upgrading to 12c R2, SYSAUX grows daily, and I have to add space to SYSAUX regularly, about every 2 weeks. I am currently opening an Oracle SR and working with Oracle Support on this issue.
  • Some of our small databases only use about 5GB excluding SYSAUX. But SYSAUX uses 5GB alone!
  • Almost all universities (if not all) in the USA have been using Banner application. But Banner app users fail to log on 12c Release 2 databases after upgrading to 12c R2 from 11g because of an Oracle Bug related to password-protected profile. I applied an interim bug to work around this issue. However, since Oct 2018, the PSU patching will not work. I must rollback the interim bug, and then patch the PSU, and then apply the interim patch again to resolve the Oracle bug. I asked Oracle to include the interim in the PSU in Oct 2018. But up to PSU Jul 2019, Oracle didn't implement it yet!
  • Overall, the pros outweigh the cons.
Oracle database is the top one. As we have been using Oracle databases, we upgraded Oracle Database 11g to Oracle Database 12c R2.
One of the features that benefits me is that it is able to set up an audit on specific tables to specific users, via setup Audit policy.