OCM 12c Preparation - Create and manage database configuration files

> This topic is pretty the same thing as we had in OCM 11g exam. But now as we have a container database scenario, we open more options. <

So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and how to use the 260 parameters (not including the hidden ones)?

Off course not. You are studying for OCM, not for any memorization championship. But what you must know is how to easily find their syntax, meaning and utilization in the Oracle Documentation. Memorize the top 50 main parameters (that you already may know) and just understand all the others. The more you know, the best for you for gaining time during the exam.

Now in a container database you can change a parameter in CDB or PDB level. So you can have the same parameter with different values on multiple PDBs. It's mandatory to understand those differences

Some items that I recommend studying and memorizing:

• New parameters in 12c and in CDB context.
• The basic parameters to start a instance (like the ones that DBCA set during a typical database creation)
• The parameters to set up a RAC.
• The parameters to set up a Data Guard.
• The parameters that I already commented in other topics, like the memory ones.
• How to create spfile from pfile and vice-versa. (I hope you already know that)
• How to check session, instance and spfile current parameter values.

Other oracle configuration files are: orapwfile, listener.ora, sqlnet.ora and tnsnames.ora. Do not forget to also read and study about them.

Path to Documentation:

Initialization Parameters

0