Oracle DBA Tips and Techniques

By Arjun Raja

Archive for the ‘Oracle 12c Cloud Control’ Category

Upgrade Cloud Control OMS and agent to 12.1.0.4.0

Posted by Arjun Raja on June 11, 2014

UPGRADE CLOUD CONTROL TO VERSION 12.1.0.4.0

Posted in Oracle 12c Cloud Control | Tagged: | Leave a Comment »

DELETE/REMOVE TARGET FROM CLOUD/GRID CONTROL REPOSITORY

Posted by Arjun Raja on February 11, 2014

To remove a target from the database repository –

Login as sysman

SQL> select target_name,target_type from mgmt_targets where target_name like ‘%LN%’;

TARGET_NAME
——————————————————————————–
TARGET_TYPE
—————————————————————-
LNAC_sys
oracle_dbsys

SQL> exec mgmt_admin.delete_target(‘LNAC_sys’,’oracle_dbsys’);

PL/SQL procedure successfully completed.

To delete agent :

SQL> select target_name from mgmt_targets where target_type=’oracle_emd’;
SQL> exec mgmt_admin.cleanup_agent(’Server1:3872′);

Posted in Oracle 12c Cloud Control, Uncategorized | Tagged: , | Leave a Comment »

Make sure email alerts work after upgrade to Cloud Control 12.1.0.3

Posted by Arjun Raja on November 19, 2013

After an upgrade of Cloud control from 12.1.0.2 to 12.1.0.3 we noticed that email alerts stopped coming through for ex – database instance down etc.

To restart email alerts.

Launch Cloud control.

Click on Setup – Incidents – Incident Rules

You will see NO under the Email me column for both rules….

Expand list under each rule name – choose all of them – click on Actions and then Email – Subscribe Me.

The Email Me will change to ‘Atleast One rule’ –

All good and alerts will appear from now on.

Posted in Oracle 12c Cloud Control | Leave a Comment »

Oracle Cloud Control 12c ( 12.1.0.2 with Plug-ins) Installation

Posted by Arjun Raja on October 10, 2013

OMS_12C_REL2_INSTALL

Posted in Oracle 12c Cloud Control, Uncategorized | Leave a Comment »

CHANGE SYSMAN PASSWORD IN ORACLE 12C CLOUD CONTROL

Posted by Arjun Raja on September 3, 2013

STEPS TO CHANGE SYSMAN PASSWORD IN ORACLE 12C CLOUD CONTROL.

These are the steps incase you are aware of the sysman password.

Login to Server as owner of OMS- usually oracle.

1. Stop the OMS:

export OMS_HOME=/u01/oracle/Middleware/oms

cd $OMS_HOME/bin

./emctl stop oms

Do not include ‘-all’ as the Admin Server needs to be up during this operation.

2. Modify the SYSMAN password:

cd $OMS_HOME/bin

./emctl config oms -change_repos_pwd

Note:

– The above command will prompt you for the current password of the SYSMAN user and the new password.

– The password will be modified at the Repository Database as well as the WLS Credential store and the monitoring credentials for the ‘OMS and Repository’ target.

– Along with the SYSMAN password, this command will modify the password for the EM users (SYSMAN_MDS, BIP, SYSMAN_OPSS, SYSMAN_APM, SYSMAN_RO) created in the Repository Database.

Example output:

emrep:/u01/oracle/Middleware/oms/bin> ./emctl config oms -change_repos_pwd
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Enter Repository User’s Current Password :
Enter Repository User’s New Password :

Changing passwords in backend …
Passwords changed in backend successfully.
Updating repository password in Credential Store…
Successfully updated Repository password in Credential Store.
Restart all the OMSs using ’emctl stop oms -all’ and ’emctl start oms’.
Successfully changed repository password.

Make sure you note down the new password.

3. Stop the Admin server on the primary OMS machine and re-start all the OMS:

emrep:/u01/oracle/Middleware/oms/bin> ./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Stopping WebTier…
WebTier Successfully Stopped
Stopping Oracle Management Server…
Oracle Management Server Already Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down

Start the OMS

emrep:/u01/oracle/Middleware/oms/bin> ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Starting Oracle Management Server…
Starting WebTier…
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

Login to webpage and make sure sysman password works :

https://xxxxxx.xxxxx.com:7800/em

MOS note 1365930.1 is the reference note and can be used for other scenarios too.

Posted in Oracle 12c Cloud Control | Leave a Comment »