January 2015 - DBA - Rodrigo Jorge - Oracle Tips and Guides

January 2015 archive

Jan 19

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

By DBA RJ in OCM 11g Preparation

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

2 comments

Jan 19

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

By DBA RJ in OCM 11g Preparation

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 …

2 comments

Jan 16

Howto apply PSU on OEM 12.1.0.4

By DBA RJ in Enterprise Manager 12c

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. …

2 comments

Jan 15

OCM 11g Preparation - Configure the Enterprise Manager repository

By DBA RJ in OCM 11g Preparation

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, …

2 comments

Jan 15

OCM 11g Preparation - Create Enterprise Manager Grid Control users

By DBA RJ in OCM 11g Preparation

Basically here you can create Administrators or Super Administrators users that are "Repository-Based Authenticated". There are also the "SSO-Based Authentication" and the "Enterprise User Security Based Authentication", but those 2 methods are complex. You can read about them in the DOC below. I think those 2 methods are out of the scope for this exam, …