Feb 01

RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES

Many people still don’t get the difference between all that configuration parameters that can be set up during a backup. In this article, I will explain how to use each of them, their differences and the theory behind. First the theory:   Backup Set Logical structure where the backup is stored. It is a logical …

Continue reading

Jan 19

OCM 11g Preparation – Configure Enterprise Manager to modify database availability

In this topic, you must be able to startup and shutdown the database via Grid Control. Do this using the main database screen. Try to startup the database in restricted mode and change it later (only using the EM) to non restricted. This is a good practice! +2

Jan 19

OCM 11g Preparation – Use Enterprise Manager to modify a database configuration

Basically here, everything that you know how to do using SQL*Plus, you must be ready to do using the EM. For example: Everything that is in the “Server” tab of EM Everything that is in the “Schema” tab of EM Sometimes it is not easy to find where is located the link of the object …

Continue reading

Jan 16

Howto apply PSU on OEM 12.1.0.4

In this article I will show you how to upgrade your Oracle Enterprise Manager Cloud Control 12c Release 4 to the first Patch Set Update (PSU). First of all, you need to check the current version of you opatch utility. Patch 19218456 requires OPatch version 11.1.0.11.0 (or higher). [oem@oraem12ctrj001 ~]$ opatch version OPatch Version: 11.1.0.10.4 OPatch succeeded. …

Continue reading

Jan 15

OCM 11g Preparation – Configure the Enterprise Manager repository

The Enterprise Manager repository is automatically created and configured during the installation. So basically here, what Oracle wants you to know is change some of that configurations. Most of them can be done using the “emctl” binary on OMS Home. It’s too many things, but keep in mind that the most importants you should know, …

Continue reading