Category: OCM 12c Preparation

This topic is almost the same we had in 11g OCM. In this topic, what I understand is that you need to practice the following items: Alter the ASM parameters (like initially automounted DGs / power limit / diag / etc) Change the spfile place by using spset / spcopy inside "asmcmd" tool. Start / …

Continue reading

This is a totally new feature in 12c. Now you can have your X RAC database nodes running less than X ASM instances. This means that the ASM traffic will be transferred via the private network adapter. Practice here: Ho to convert you environment from non-Flex to Flex ASM. Resizing the number of ASM instances. …

Continue reading

Creating ASM disk groups is a easy task. You have several ways of doing it, like: asmca (Preferable) sqlplus asmcmd Enterprise Manager (Yes, don’t forget him!) Even though not said, I would also practice altering / dropping / renaming and playing with rebalace power on diskgroups using all the tools. one very important thing is …

Continue reading

Grid control along with data guard are within my favorite topics. So here you must know how to install grid infrastructure in ways you are not used to (runInstaller interface). There are several ways of installing and you must be prepared to perform all of them: runInstaller using GUI (preferable and fastest). runInstaller using CLI …

Continue reading

SQL Plan Baselines is a feature introduced with Oracle DB 11g that enables the system to automatically control SQL plan evolution. With this enabled, a newly generated SQL plan can integrate a SQL plan baseline only if it has been proven that doing so will not result in performance regression. During execution of a SQL statement, only a …

Continue reading