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

Nov 21

OCM 11g Preparation – Create and manage database configuration files

So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and how to use the 260 parameters (not including the hidden ones)? Off course not. You are studying for OCM, not for any memorization championship. But what you must know is …

Continue reading