May 2017 archive

May 31

OCM 12c Preparation - Create and manage pluggable databases

Creating the CDB database is one of the most elementary tasks a DBA must do in 12c. For OCM exam, you must create the container DB easily in all the ways imaginable. I can think on the following ways of creating it: Create database using dbca via GUI (the fastest and recommended if the exam …

Continue reading

May 26

OCM 12c Preparation - Where to take the exam

The place to take the exam is one of the most difficult things to decide if you do not live near a test center. The OCM exam is very expensive. You need also to add to this cost hotel + flight + anything else during your exam trip. So, first of all, the most important …

Continue reading

May 25

Oracle 12.1.0.2 CDB creation - catcdb.sql returning ORA-22288 or ORA-29548

Those days I was trying to create an Oracle Database 12.1.0.2 CDB using only sqlplus in a Oracle Linux 6.5 64 bits. So after issuing the CREATE DATABASE command, it was time to create all the dictionary: $ sqlplus / as sysdba @?/rdbms/admin/catcdb.sql However, something was going wrong because both Oracle Java and Oracle Multimedia …

Continue reading

May 24

OCM 12c Preparation - Course requirements

There are 3 things to remember here that are very important: "Courses used to fulfill the OCP training requirement may not be used again to fulfill the OCM training requirement." "Courses can be instructor-led in-class (ILT), a live virtual class (LVC), training on demand (TOD), or Unlimited Learning Subscription. Self-study CD and online courses are …

Continue reading

May 24

OCM 12c Preparation - Prepare your Environment

As we have many situations to deal with in the topics, my recommendation is creating 6 VMs using Virtualbox: Oracle DB Single Instance + Oracle Data Guard RAM: 4G / = 10G ; SWAP = 8G ; /u01 = 40G (Ora Binaries + Datafiles) Oracle Enterprise Manager + Oracle Data Guard RAM: 6G / = 10G ; …

Continue reading