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 12.2.0.1, 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.