The things to say here are pretty much the same as the last topic. For listener, you can also use netca / netmgr (much faster approaches if the exam does not constraint). But you may also know how to do w/o GUI. Consider yourself ready when you are able to easily create a static listener using …
Apr 15
OCM 11g Preparation – Use Recovery Manager to perform database backups
Creating an efficient backup strategy is important to reduce your recover time. If your system is critical, the backup procedure must be setup accordingly to meet the SLA requirements. For OCM exam, I have no idea what they will ask. Keep in mind to trace some plan to restore/recover what you need in the most …
Apr 14
OCM 11g Preparation – Create and manage LOB segments
In OCM exam they can ask you to do all sort of operations using LOBs. So, be prepared for them. In the docs there are some example PL/SQL blocks that can be used as template. However, read everything and keep in mind: Differences between Empty and Null LOB Inline and Out-of-Line LOB Storage How to …
Apr 09
Oracle Data Guard error – Force closing the keystore for standby rekey.
I have a Primary 11g Oracle Database with a single Physical Standby. Those days I tried to create an encrypted column inside one table for testing purposes. I end up accidentally messing the things: Force closing the keystore for standby rekey. Please re-copy the keystore from primary before re-open as needed. Apply redo for database master …
Apr 08
OCM 11g Preparation – Implement securefile LOB
Securefile LOBs are a new way of storing LOBs that allows us to enable compression, deduplication, or encryption. In the exam, we need to know how to manage them: Using CREATE TABLE with SecureFiles LOBs Using ALTER TABLE with SecureFiles LOBs Initialization Parameter db_securefile for SecureFiles LOBs PL/SQL Packages for SecureFiles LOBs “Database File System …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
