OCM 12c Preparation – Configure the network environment to allow connections to multiple databases

> 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. < You can run multiple listeners in the same server. Thus, it’s possible to: Have 1 listener pointing to multiple databases services. Have multiple listeners pointing to …

Continue reading

OCM 12c Preparation – Create and manage users, roles, and privileges

Creating users, roles and give them privileges are one of the most basic thing a DBA must know. If you need to create any in the exam, you need to memorialize the syntax because this type of task is so basic that you can’t lose time on it. As in 12c we have now common …

Continue reading

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

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

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