July 2017 archive

After install the RAC software, this topic asks to create a new RAC database. This means that if you fail to install, you will have no way to create a RAC DB or services (nex topic), resulting in a lot of lost points. So it's mandatory to do the previous topic and this with all …

Continue reading

So, this reminds me the first skillset but one thing that I’ve only noticed now is that there is no “Install Oracle Database software” there. Here, what I recommend you to practice is: Install Oracle DB using GUI (preferable, of course). Install Oracle DB using CLI (and RSP file). Do both of the above into local and …

Continue reading

As the last topic for OCM 12c Upgrade Exam, we need to know how to create services. You can only create Policy managed services in Policy managed databases. Thus, this topic is a good opportunity to practice the conversion between Admin <-> Policy Managed databases. Practice: Creating Policy managed services with both UNIFORM and SINGLETON …

Continue reading

Like 11g, configure and administer Grid Infrastructure can be done using the 2 main provided tools: “crsctl” and “srvctl”. srvctl start/stop -> Start/Stop the cluster services. srvctl realocate -> Move some service, like the scan listener. srvctl status -> Check if service is running. srvctl config -> Display configuration. srvctl modify -> Change configuration. crsctl start/stop crs -> …

Continue reading

This topic is similar to the one related to the Observer in 11g OCM Exam. The Fast-Start Failover Observer is an Oracle Data Guard Broker component that allows the DBA automate failover tasks. Having it set up is a requirement to have more peaceful nights of sleep as well as a good OCM exam score. For this …

Continue reading