Oracle DBA Tips and Techniques

By Arjun Raja

Posts Tagged ‘cloud control’

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 »

OPATCH FOR MEMORY SPIKE ON CLOUD CONTROL 12c OMS SERVER

Posted by Arjun Raja on May 14, 2013

Patch to stop the memory spike on the OMS server – caused by the 12c agent.

Bugs Fixed by This Patch
————————-
The following are the bugs fixed by this patch:

–         16273498 – AIX SERVER 5.3 CRASHED :EMDPROCSTATS.PL CONSUMES 10GIG MEM

Installation Procedure
———————-

Download and apply Patch 16273498  (p16273498_121020_Generic.zip)

1) Download the patch  to /u01/oracle/stage

$ cd /u01/oracle/stage

$unzip p16273498_121020_Generic.zip

$ cd /u01/oracle/stage/16273498

2) Stop agent and apply the patch

$ export ORACLE_HOME=/u01/oracle/agent12c/core/12.1.0.2.0

opatch lsinventory – confirm inventory is of the agent home – Oracle Home: /u01/oracle/agent12c/core/12.1.0.2.0

$ $ORACLE_HOME/bin/emctl stop agent

$ cd /u01/oracle/stage/16273498

emrep:/u01/oracle/stage/16273498> opatch lsinventory -detail |grep 16273498

Patch not applied so proceed.

emrep:/u01/oracle/stage/16273498> opatch apply
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/agent12c/core/12.1.0.2.0
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/agent12c/core/12.1.0.2.0/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/agent12c/core/12.1.0.2.0/cfgtoollogs/opatch/16273498_May_14_2013_08_02_41/apply2013-05-14_08-02-41AM_1.log

Applying interim patch ‘16273498’ to OH ‘/u01/oracle/agent12c/core/12.1.0.2.0’
Verifying environment and performing prerequisite checks…
All checks passed.
Backing up files…

Patching component oracle.sysman.top.agent, 12.1.0.2.0…

Verifying the update…
Patch 16273498 successfully applied
Log file location: /u01/oracle/agent12c/core/12.1.0.2.0/cfgtoollogs/opatch/16273498_May_14_2013_08_02_41/apply2013-05-14_08-02-41AM_1.log

OPatch succeeded.
emrep:/u01/oracle/stage/16273498>

emrep:/u01/oracle/stage/16273498> opatch lsinventory -detail |grep 16273498
Patch  16273498     : applied on Tue May 14 08:02:46 WST 2013
16273498
emdprocesschars.pl –> ORACLE_HOME/16273498/files/sysman/admin/scripts/emdprocesschars.pl
emdprocstats.pl –> ORACLE_HOME/16273498/files/sysman/admin/scripts/emdprocstats.pl
/u01/oracle/agent12c/core/12.1.0.2.0/inventory/oneoffs/16273498
/u01/oracle/agent12c/core/12.1.0.2.0/.patch_storage/16273498_Mar_4_2013_01_36_13
emrep:/u01/oracle/stage/16273498>

emrep:/u01/oracle/stage/16273498> cd $ORACLE_HOME/bin

emrep:/u01/oracle/agent12c/core/12.1.0.2.0/bin> ./emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting agent …………………….. started.

emrep:/u01/oracle/agent12c/core/12.1.0.2.0/bin> ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
—————————————————————
Agent Version     : 12.1.0.2.0
OMS Version       : 12.1.0.2.0
Protocol Version  : 12.1.0.1.0
Agent Home        : /u01/oracle/agent12c/agent_inst
Agent Binaries    : /u01/oracle/agent12c/core/12.1.0.2.0
Agent Process ID  : 23462106
Parent Process ID : 28377322
Agent URL         : https://xxxxxx.yyyyyyy.com:3872/emd/main/
Repository URL    : https://xxxxxx.yyyyy.com:4900/empbs/upload
Started at        : 2013-05-14 08:04:08
Started by user   : oracle
Last Reload       : (none)
Last successful upload                       : 2013-05-14 08:04:29
Last attempted upload                        : 2013-05-14 08:04:29
Total Megabytes of XML files uploaded so far : 0.01
Number of XML files pending upload           : 5
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 58.74%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2013-05-14 08:04:23
Last successful heartbeat to OMS             : 2013-05-14 08:04:23
Next scheduled heartbeat to OMS              : 2013-05-14 08:05:27

—————————————————————
Agent is Running and Ready
emrep:/u01/oracle/agent12c/core/12.1.0.2.0/bin>

Posted in EM Grid Control | Tagged: , | Leave a Comment »

Oracle 12c cloud control installation on Linux

Posted by Arjun Raja on February 3, 2012

On LINUX X86 64 BIT

Download foll files from oracle.com :

1. 11g Rel 2 for LINUX.

1. linux.x64_11gR2_database_1of2
2. linux.x64_11gR2_database_2of2

2. 12c Cloud Control – Enterprise Manager.

1. em12_linux64_disk1of2
2. em12_linux64_disk2of2

Copy both sets of zip files into separate directories on linux server and unzip them.

Begin installation

1. Install 11g rel2 Linux software.

2. Create database using 11g rel2 Linux software

Before creating database, make sure /etc/hosts file has name of host :

Otherwise dbca database creation will fail with:

ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address ‘(ADDRESS=
(PROTOCOL=TCP)(HOST=cloud.control)(PORT=1521))

Ø Hostname

[oracle@cloud oradata]$ hostname

cloud.control

[oracle@cloud flash_recovery_area]$ cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

10.254.8.200 cloud.control cloud

[oracle@cloud flash_recovery_area]$

Also make sure ulimit –n is unlimited.

[oracle@cloud bin]$ ulimit -n

1024

[oracle@cloud bin]$

Get unix to change it to unlimited or 4096.

Once database is created , remove the dbcontrol repository created by dbca for enterprise manager.

emca -deconfig dbcontrol db -repos drop -SYS_PWD -SYSMAN_PWD

emca -deconfig dbcontrol db -repos drop -SYS_PWD oracle12c -SYSMAN_PWD oracle12c

ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;

Shutdown immediate;

Startup;

2. Cloud Control installation.

Create directory to hold Middleware ( Web Logic,etc)

cd /home/oracle

mkdir Middleware

cd /home/oracle/stage

[oracle@cloud stage]$ export DISPLAY=10.254.101.208:0.0

[oracle@cloud stage]$ ./runInstaller

Starting Oracle Universal Installer…

Checking Temp space: must be greater than 400 MB. Actual 98300 MB Passed

Checking swap space: must be greater than 150 MB. Actual 5951 MB Passed

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Preparing to launch Oracle Universal Installer
from /tmp/OraInstall2011-12-09_10-59-46AM. Please wait …[oracle@cloud stage]$

(Embedded image moved to file: pic27071.jpg)

(Embedded image moved to file: pic15429.jpg)

(Embedded image moved to file: pic29688.jpg)

(Embedded image moved to file: pic24633.jpg)

(Embedded image moved to file: pic21062.jpg)

Click on warning row and ignore

Click OK and then Ignore

(Embedded image moved to file: pic28246.jpg)

(Embedded image moved to file: pic03762.jpg)

Note down the administrator passwords.

(Embedded image moved to file: pic07873.jpg)

(Embedded image moved to file: pic02961.jpg)

(Embedded image moved to file: pic02230.jpg)

(Embedded image moved to file: pic06947.jpg)

(Embedded image moved to file: pic10203.jpg)

Carry out checks

Agent checks

cd /home/oracle/Middleware/agent/agent_inst/bin

./emctl status agent

[oracle@cloud bin]$ ./emctl status agent

Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0

Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.

Posted in EM Grid Control, Uncategorized | Tagged: , | Leave a Comment »