November 2014 archive

High Space Usage From crfclust.bdb

I have a 2-node testbed running Oracle RAC 11.2.0.4 on OL6. Pretty much everything is in the system disk. This is just a testbed after all. The root partition has been filling up. I got an alert from EM about the disk space issue and went in and cleaned up some log files. As I …

Continue reading

InMemory DUPLICATE Confusion in Oracle RAC

Most people are probably aware of the new Oracle 12.1.0.2 feature, the InMemory database option. When using this option on Oracle RAC, the DBA can specify the DUPLICATE clause to have an object be duplicated among the InMemory column store in all instances. This clause is for Oracle’s Engineered Systems like Exadata. However, in non-Engineered …

Continue reading

ORA-00838

Ran into an interesting issue the other day that took me a while to fix. I was trying to start a non-production database and received this error: ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1428M ORA-01078: failure in processing system parameters For starters, the Oracle documentation for my version …

Continue reading