November 2014 archive

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

Nov 14

OCM 11g Preparation - Configure the database environment to support optimal data access performance

This topic is not so specific as the others. It says "Support optimal data performance". This lead us to think in about 1000 items that are relates to performance in a DB. Basically, this means: study a lot of performance. Read the whole Oracle doc for Performance Tuning and get the OCE Performance Tuning. This is …

Continue reading