ORACLE EM DBA

Problems, Solutions, Test Cases from my professional and personal experience in technologies like Oracle Enterprise Manager 13 c,Oracle Enterprise Manager 12c, Oracle Configuration Manager and some other stuff.

Month: September 2015

Add Cluster Database as target in OEM

In this blog I have explained in simple steps, how we can add a “Cluster Database” as target in OEM12c Cloud Control. Before you start make you have Oracle Agent installed and configured on the server where database instances exists.

Step1: Login to Oracle Enterprise Manager using your credentials.

login

Step 2: Navigate to Database homepage using “Targets” drop down on the top left corner of your screen, as shown in the screen-shot below.

navigation

Step 3: Click on “Add” button under Search box, to add the Cluster Database.

db_home

Step 4:  A New pop-up window will get open, specify the host name of the server where the cluster database exists and click on “Select” button.  

host_search

Step 5: If it is a cluster database, select the option as shown below, else if this is a standalone database select “only on the host xxxxxxxx”  option and click “Continue”:

add_database

Step 6: Once you click “Continue” as mentioned in the last step, the discovery of targets will start. This process is described in the below attached screen-shot. This will take some time to discover targets on this cluster/host:

discovery

Step 7: Once the targets are discovered on cluster, select that particular target, like in this example I have selected “PADMO” .

cluster_database

Step 8:  Please enter the DBSNMP password, if it is a standby instance then you have to enter the “SYS” password. This password will be used by the OMS to monitor the database and check its availability. You can additionally can also add the group name, in which you want the database to belong.

Please click on “Next” after putting all the details.

Step 9: Last step comes where you can put additionally the target properties if you want, this will act as advantage if you have set up Administration Group in your OEM application. Setting up global target properties will add your “cluster database” under “Administration Group”.

global_target

Once you are done setting up the Global Target Properties, you will be then navigated to discovering targets page on the cluster. Click on Save, once target is saved, click OK. Your Cluster database has been successfully added as target.

How to create blackout in OEM12c for “Generic Service Test”.

In this Blog I have shown the simple steps which one can follow to create Blackout for any of the Generic Service or be it any other target for any maintenance window to avoid unwanted alerts.

Step 1:  Login “Oracle Enterprise Manager” 12c console using your credentials.

1

Step 2: As shown below in the screenshot, please navigate to “Services” from the main home page.

2

Step 3: Filter the Appdev Application under “Services” using the method shown in the screenshot. Here you will find all the “Service Test” created for various Applications.

3

Step 4: Navigate to “Blackout” home page using the Navigation shown in the screenshot. Click on “Enterprise” on the top left corner and navigate to “Blackout” under “Monitoring”.

4

Step 5: Create blackout for the Applications to be included in the Maintenance Window.

5

Next step is to put details of the blackout to be created. Put all the details mentioned in the screenshot.

6

Step 6: Add Targets to be included in the Blackout.  Provide necessary details for Blackout, Click on “ADD” button as shown in the screen shot.

New “POP-UP” window will open, select “Generic Service” as the target type and under “Target Name” type “SLA” and press “GO”. Once  you have selected the required Applications to be included in the blackout HIT “Select”.

7

Click on “Next”.

8

Step 7: Schedule the Blackout.

9

Step 8:  Review the Blackout Details and click “Finish”.

10

I hope this would have made is simpler for you to understand how easily we can create blackout in OEM12c.

© 2017 ORACLE EM DBA

Theme by Anders NorenUp ↑