Set up network tracing is very important when some client complains "I'm having troubles when trying to connect in the DB and the application logs are inaccessible". It's also important for OCM if we need to find the RC of some network problem. So, how to enable it? Probably touching the network configuration files listener.ora …
Category: OCM 11g Preparation
OCM 11g Preparation
May 11
OCM 11g Preparation - Configure the database instance to support shared server connections
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 …