It's hard to find servers that use shared server option. Usually in my customers, the database is connected by a middleware that manage the client connections and only make a few connections to the database. Anyway, for OCM you may need to think in a DB that is accessed by 4k clients connections and only …
May 09
OCM 11g Preparation - Create and manage multiple network configuration files
You may think: I know how to create and manage network configuration files. I simply run netca or netmgr and setup my needs. And what if they ask you to set this up using no GUI ? So, doing it manually is not hard also. Personally, after many years of oracle experience I don't know …
May 09
OCM 11g Preparation - Create and configure a listener
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 …
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
