Nov 07

Rename schema in Oracle 11g with Loopback DBLink

In this article, we will deal a very common situation where the DBA is tasked to rename or clone a user into the same database. In the following lines, I will explain how to make this copy without higher complexities and with no need to generate intermediate dump files, using DataPump import utility with a …

Continue reading

Oct 30

OCM 11g Preparation – Create and manage temporary, permanent, and undo tablespaces

Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace to use as a template. …

Continue reading

Oct 28

OCM 11g Preparation – Determine and set sizing parameters for database structures

In this topic, you must be able to: Alter all the DB parameters that define any kind of memory or disk sizing. I would recommend you to run “show parameters size” and play with all of them. Create datafiles with different block sizes and check the usage of the db_NK_cache_size areas. Path to Documentation: Administrator’s …

Continue reading

Oct 24

OCM 11g Preparation – Deploy Enterprise Manager Grid Control agents

For OCM Preparation, in this topic you must be able to easily deploy an EM Grid Control agent. Although the term “deploy” let us think that we need to do it using the DB Console, I recommend also practicing the manual agent deployment. So, do the following scenarios: Install and deploy EM Agent in a new server …

Continue reading

Oct 23

OCM 11g Preparation – Install and Patch Enterprise Manager Grid Control software

Oracle 11g EM installation is divided in WebLogic and OMS. I gave the link to both files here. There is no mysterious in installing the WebLogic. As it is a binary file, all you can do is call the user interface and go through the steps. Do not try Oracle WebLogic Server 10.3.6 with the Enterprise …

Continue reading