Dec 03

OCM 11g Preparation - Configure the Observer

The Fast-Start Failover Observer is an Oracle Data Guard Broker component that allows the DBA automate failover tasks. Having it set up is a requirement to have more peaceful nights of sleep as well as a good OCM exam score. For this topic, I recommend exercising the following points: Keep in your brain all requisites prior starting …

Continue reading

Dec 03

Oracle Data Guard Fast-Start Failover and Oracle Wallet

The Fast-Start Failover Observer is an Oracle Data Guard Broker component that allows the DBA automate failover tasks and have more peaceful nights of sleep. What a few DBA know, however, is that it can work in conjunction with the Oracle Wallet, so that you can remove the password of your scripts. Consider the scenario …

Continue reading

Nov 28

OCM 11g Preparation - Create Physical Standby Database with real-time apply

Creating an physical standby database is not an easy task. It involves a lot of steps, as duplicating the primary database, changing some parameters and database configuration. Than you need to create the standby database and finally synchronize and enable it with real-time apply. For this topic, I recommend exercising the following points: Duplicate from …

Continue reading

Nov 28

ORA-12853, ORA-04031 and ORA-06512: at "SYS.UTL_RECOMP", line 865

Those days I created a really small 11.2.0.4 database in a very powerful Sun Sparc 64 processors server. I've set up the database to use as memory_target the minimal possible: 524M. I planed to increase this size later after preparing the DB Server. When I started enabling the Database Vault, I received the following error …

Continue reading

Nov 21

OCM 11g Preparation - Create and manage bigfile tablespaces

We already talked about creating tablespaces in the other exam topic "OCM 11g Preparation – Create and manage temporary, permanent, and undo tablespaces". For OCM, to have a topic about Big File Tablespace (BST) set aside, is because they want you to fully understand it. The advantages of BST are more related to the hardware, OS …

Continue reading