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.
Some items that I recommend studying and memorizing:
- 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
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
