Oracle DBA Tips and Techniques

By Arjun Raja

Archive for the ‘EM Grid 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 »

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 »

“ENTERPRISE MANAGER BASE PLATFORM – OMS 12.1.0.2.2 PSU (GENERIC)” PATCH INSTALLATION

Posted by Arjun Raja on April 26, 2013

Installation of PSU path for OMS Cloud Control to upgrade OMS from  12.1.0.2.0 to 12.1.0.2.2

Download patch from My Oracle Support and unzip it in staging area on OMS server.

p16236221_121020_Generic.zip

emrep:/u01/oracle/Middleware/oms/OPatch> echo $ORACLE_HOME
/u01/oracle/Middleware/oms

emrep:/u01/oracle/Middleware/oms/OPatch> which opatch
/u01/oracle/Middleware/oms/OPatch/opatch

emrep:/u01/oracle/Middleware/oms/OPatch> which unzip
/u01/oracle/Middleware/oms/bin/unzip

emrep:/u01/oracle/Middleware/oms/OPatch> opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-04-26_07-57-22AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Lsinventory Output file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/lsinv/lsinventory2013-04-26_07-57-22AM.txt

——————————————————————————–
Installed Top-level Products (1):

EM Platform (OMS)                                                    12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch  14149721     : applied on Thu Dec 06 09:39:16 WST 2012
Unique Patch ID:  15496341
Created on 20 Sep 2012, 07:18:10 hrs PST8PDT
Bugs fixed:
14149721

Patch  13983293     : applied on Fri Nov 23 08:32:41 WST 2012
Unique Patch ID:  14779750
Created on 25 Apr 2012, 02:18:06 hrs PST8PDT
Bugs fixed:
13587457, 13425845, 11822929

Patch  12742388     : applied on Fri Nov 23 08:32:39 WST 2012
Unique Patch ID:  13995252
Created on 3 Aug 2011, 03:35:00 hrs US/Pacific
Bugs fixed:
12742388

——————————————————————————–

OPatch succeeded.
emrep:/u01/oracle/Middleware/oms/OPatch>

cd /u01/oracle/stage/omspatch/16236221

(Prerequisite Only for Patch Installation) Ensure that the PSU does not conflict with the already-installed one-off patches. To do so, run the following command to generate a report that lists all conflicting patches.

cd /u01/oracle/stage/omspatch/16236221>

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/oracle/stage/omspatch/16236221

Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-04-26_07-59-29AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.
emrep:/u01/oracle/stage/omspatch/16236221>

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

emrep:/u01/oracle/Middleware/oms/bin> ./emctl stop oms
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 Successfully Stopped
Oracle Management Server is Down

APPLY PATCH

cd /u01/oracle/stage/omspatch/16236221

opatch lsinventory

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

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/16236221_Apr_26_2013_08_35_36/apply2013-04-26_08-35-36AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Applying interim patch ‘16236221’ to OH ‘/u01/oracle/Middleware/oms’
Verifying environment and performing prerequisite checks…
All checks passed.
Backing up files…
Patching component oracle.sysman.oms.core, 12.1.0.2.0…
Verifying the update…
Patch 16236221 successfully applied
Log file location: /u01/oracle/Middleware/oms/cfgtoollogs/opatch/16236221_Apr_26_2013_08_35_36/apply2013-04-26_08-35-36AM_1.log

OPatch succeeded.
emrep:/u01/oracle/stage/omspatch/16236221>

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

Oracle Home       : /u01/oracle/Middleware/oms
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-04-26_08-38-44AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/Middleware”

Lsinventory Output file location : /u01/oracle/Middleware/oms/cfgtoollogs/opatch/lsinv/lsinventory2013-04-26_08-38-44AM.txt

——————————————————————————–
Installed Top-level Products (1):

EM Platform (OMS)                                                    12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (4) :

Patch  16236221     : applied on Fri Apr 26 08:37:58 WST 2013
Unique Patch ID:  16246314
Patch description:  “ENTERPRISE MANAGER BASE PLATFORM – OMS 12.1.0.2.2 PSU (GENERIC)”
Created on 4 Apr 2013, 04:37:26 hrs PST8PDT
Bugs fixed:
16249001, 15882400, 16050320, 14550814, 14763575, 14761108, 14845582
14541496, 14342208, 15845393, 14666763, 14580616, 14598372, 14735169
14010647, 14345046, 10096491, 14749579, 14838874, 14587300, 15830769
14804073, 14235923, 16195634, 14299157, 15872430, 14306214, 14762857
13079372, 14727947, 14285253, 14687246, 13508023, 14745153, 16036046
15887936, 14495973, 14304836, 14336237, 16173939, 14630733, 14594247
14833587, 14508416, 14526341, 14394014, 15890511, 14521115, 14728398
14096173, 13849711, 14557951, 14846905, 14377038, 14794550, 14788062
14588625, 13894390, 14355479, 14408052, 14461107, 14786608, 14335511
14563656, 14519924, 14709740, 13564862, 14756522, 13923303, 14208766
16201338, 15943462, 14315126, 14685375, 14672991, 14646978, 15897575
14623310, 16295882, 15962488, 14777653, 14385641, 16236221, 14480859
14812404, 14568969, 13038747, 14636925, 14685307, 14559710, 14791371
14463440, 14351499, 10367113, 14270937, 14473422, 14763683, 14543562
14691873, 14475316, 14695367, 14697257, 14585884, 14544587, 14594990
14763611, 16194290, 15875808, 14693191, 14807598, 15955206, 13588621
14807230, 14562085, 14032756, 14357531, 14508734, 14258259, 14473509
14520274, 14769075, 14728061, 16384695, 14527469, 14776583, 14793497
16060571, 14673451, 14397242, 14761661, 14360903, 15939396, 14681479
10422783, 14326585, 14293602, 14586919, 14651399, 16399409, 14693204
14571497, 14485604, 14791323, 14693208, 14763632, 14235906, 16162621
13891094, 14729169, 14477373, 14356241, 16007962, 14582201, 14708698
14795109, 14681848, 14767273, 15964986, 14683668, 15861782, 14840279
15859144, 14775943, 14673182, 14182184, 14604267, 14571792

Patch  14149721     : applied on Thu Dec 06 09:39:16 WST 2012
Unique Patch ID:  15496341
Created on 20 Sep 2012, 07:18:10 hrs PST8PDT
Bugs fixed:
14149721

Patch  13983293     : applied on Fri Nov 23 08:32:41 WST 2012
Unique Patch ID:  14779750
Created on 25 Apr 2012, 02:18:06 hrs PST8PDT
Bugs fixed:
13587457, 13425845, 11822929

Patch  12742388     : applied on Fri Nov 23 08:32:39 WST 2012
Unique Patch ID:  13995252
Created on 3 Aug 2011, 03:35:00 hrs US/Pacific
Bugs fixed:
12742388

——————————————————————————–

OPatch succeeded.
emrep:/u01/oracle/stage/omspatch/16236221>

emrep:/u01/oracle/stage/omspatch/16236221> sh ./post_deploy.sh

Post deploy OMS automation script [Version: 11.1.0.9.9, Build date: November 12, 2012]
_______________________________________________________________________________________

Please enter Patch Location: /u01/oracle/stage/omspatch/16236221/
Please enter SYSMAN password:

The script will run the following command(s):

/u01/oracle/Middleware/oms/bin/emctl applypatch repos -patchHome /u01/oracle/stage/omspatch/16236221/
/u01/oracle/Middleware/oms/bin/emctl register oms metadata -service namedsql -file /u01/oracle/Middleware/oms/sysman/metadata/namedsql/loader_report_sql.xml -core
/u01/oracle/Middleware/oms/bin/emctl register oms metadata  -service report -file /u01/oracle/Middleware/oms/sysman/metadata/reports/Loader_Statistic.xml -core
/u01/oracle/Middleware/oms/bin/emctl register oms metadata -service swlib -file /u01/oracle/Middleware/oms/sysman/metadata/swlib/multioms -core
/u01/oracle/Middleware/oms/bin/emctl register oms metadata -service swlib -file /u01/oracle/Middleware/oms/sysman/metadata/swlib/patch -core

Please monitor log file “/u01/oracle/stage/omspatch/16236221/log/2013-04-26-08-47-52.log”…

Script completed successfully.
emrep:/u01/oracle/stage/omspatch/16236221>

Script completed successfully.
emrep:/u01/oracle/stage/omspatch/16236221> cd $ORACLE_HOME/bin
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
emrep:/u01/oracle/Middleware/oms/bin>

Finally  emcli sync.

emrep:/u01/oracle/Middleware/oms/bin> emcli sync
Error: Session expired. Run emcli login to establish a session.
emrep:/u01/oracle/Middleware/oms/bin> emcli login -username=sysman -password=xxxxxxxxx
Login successful
emrep:/u01/oracle/Middleware/oms/bin> emcli sync
Synchronized successfully
emrep:/u01/oracle/Middleware/oms/bin>

Posted in EM Grid Control | Leave a Comment »

emctl config agent addinternaltargets – to discover targets manually in Oracle 12c Cloud Control

Posted by Arjun Raja on March 18, 2013

If for any reason you lose an agent in the cloud console area and want to discover targets manually from the command line- login to the agent server and run the following from the agent home/bin

This is a replacement for the agentca -d command issued in Oracle 10g and 11g grid control.

cd $AGENT_HOME/bin

1. Stop and start the OMS:

./emctl stop oms

./emctl start oms

2. Secure the Management Agent:

./emctl secure agent

3. Add the targets:

./emctl config agent addinternaltargets

4. Upload the targets:

./emctl upload agent

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

ORACLE 12C AGENT INSTALL

Posted by Arjun Raja on July 24, 2012

ORACLE 12C LATEST BUNDLE PATCH AGENT INSTALL

Download and unzip patch from technet.oradcle.com –
12.1.0.1.0_AgentCore_212.zip to staging area on server where agent is being installed.

cd :/u01/oracle/stage/12cagent

unzip 12.1.0.1.0_AgentCore_212.zip

Unzips and creates a few files.

Edit the agent.rsp file – make a copy of it before making changes.

vi agent.rsp

Make the following changes –

#??????????????????????????-
#OMS_HOST: OMS host info required to connect to OMS
#EM_UPLOAD_PORT: OMS port info required to connect to OMS
#AGENT_REGISTRATION_PASSWORD: Agent Registration Password needed to # establish a secure connection to the OMS.
#AGENT_INSTANCE_HOME: Agent instance home is the location of agent state directory.
#AGENT_PORT: Agent port on which the agent process should be started. #b_startAgent: Agent will not be started after configuration if the value specified is false.
#ORACLE_HOSTNAME: Fully qualified domain name of host where is the agent is deployed.
#s_agentHomeName:Customized Oracle home name for the agent home. Example: s_agentHomeName=”agent12gR1″
#??????????????????????????-
OMS_HOST=”middba3″
EM_UPLOAD_PORT=”4900″
AGENT_REGISTRATION_PASSWORD=”oracle12c”
AGENT_INSTANCE_HOME=”/u01/oracle/agent12c”
AGENT_PORT=”3872″
b_startAgent=true
ORACLE_HOSTNAME=”xxxxx.xxxxxx.com”
s_agentHomeName=”agent12gR1″
#??????????????????????????-
#s_agentServiceName: Sets the agent Service Name and this variable can be # used to overrite the agent service name calculated by the install. This is
# required for only Windows.
# Example:
# s_agentServiceName = “Oracleagent12gAgent” ; default value # s_agentServiceName = “GridAgent” ; User specified value
#??????????????????????????-
#s_agentServiceName=””

####################################################################################

#Please Don’t change the values of these variables
####################################################################################

#??????????????????????????-
#EM_INSTALL_TYPE: install type
#??????????????????????????-
EM_INSTALL_TYPE=”AGENT”

Save the file agent.rsp –

Make sure the OMS server ip address and alias has an entry in the /etc/hosts if there is no dns entry.

xxxx.xxxx.xxx middba3

Create following directories.

/u01/oracle/agent12c

/u01/oracle/agent12c/install/

/u01/oracle/agent12c/install/logs

This is to avoid failure of plugin being installed with following error – in the /u01/oracle/agent12c/sysman/log/gcagent.log file – if you install without creating the directory above :

2012-07-23 14:41:50,056 [42:F5077C5B] INFO – >>> Dispatching request: PutFileRequest
(/u01/oracle/agent12c/install/logs/oracle.sysman.oh_12.1.0.1.0_DISCOVERY_52.zip len
gth=302837 BIN) <<<
2012-07-23 14:41:50,130 [89:68BCA6D1:JobReader-GCThread-36-89] WARN – JobReader encountered an exception:java.io.IOException: Broken pipe 2012-07-23 14:41:50,136 [42:F5077C5B] INFO – >>> Reporting exception: oracle.sysman.emSDK.agent.client.exception.PerformOperationException: Unable to create file /u01/o
racle/agent12c/install/logs/oracle.sysman.oh_12.1.0.1.0_DISCOVERY_52.zip: No such file or directory

NOW INSTALL AGENT WITH SILENT INSTALL .

cd /u01/oracle/stage/archives >

./agentDeploy.sh AGENT_BASE_DIR=”/u01/oracle/agent12c”
RESPONSE_FILE=”/u01/oracle/stage/archives/agent.rsp”

Log below –

AGENT_BASE_DIR=/u01/oracle/agent12c

-e Validating the OMS_HOST & EM_UPLOAD_PORT
Executing command : /u01/oracle/agent12c/core/12.1.0.1.0/jdk/bin/java
-classpath /u01/oracle/agent12c/core/12.1.0.1.0/jlib/agentInstaller.jar:/u01/oracle/agent12c/core/12.1.0.1.0/oui/jlib/OraInstaller.jar

oracle.sysman.agent.installer.AgentInstaller /u01/oracle/agent12c/core/12.1.0.1.0 /u01/oracle/stage/12cagent /u01/oracle/agent12c -prereq

Validating oms host & port with url: http://xxxxxx:4900/empbs/genwallet Validating oms host & port with url: https://xxxxxxx:4900/empbs/genwallet Return status:3
Unzipping the agentcoreimage.zip to /u01/oracle/agent12c …. 12.1.0.1.0_PluginsOneoffs_212.zip
Executing command : /u01/oracle/agent12c/core/12.1.0.1.0/jdk/bin/java -d64
-classpath /u01/oracle/agent12c/core/12.1.0.1.0/oui/jlib/OraInstaller.jar:/u01/oracle/agent12c/core/12.1.0.1.0/oui/jlib/xmlparserv2.jar:/u01/oracle/agent12c/core/12.1.0.1.0/oui/jlib/srvm.jar:/u01/oracle/agent12c/core/12.1.0.1.0/oui/jlib/emCfg.jar:/u01/oracle/agent12c/core/12.1.0.1.0/jlib/agentInstaller.jar:/u01/oracle/agent12c/core/12.1.0.1.0/oui/jlib/share.jar

oracle.sysman.agent.installer.AgentInstaller /u01/oracle/agent12c/core/12.1.0.1.0 /u01/oracle/stage/12cagent /u01/oracle/agent12c AGENT_BASE_DIR=/u01/oracle/agent12c AGENT_BASE_DIR=/u01/oracle/agent12c RESPONSE_FILE=/u01/oracle/stage/12cagent/agent.rsp

Executing agent install prereqs…
Executing
command: /u01/oracle/agent12c/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSysPrereqs -prereqchecker -silent -ignoreSysPrereqs
-waitForCompletion
-prereqlogloc /u01/oracle/agent12c/core/12.1.0.1.0/cfgtoollogs/agentDeploy -entryPoint oracle.sysman.top.agent_Complete -detailedExitCodes PREREQ_CONFIG_LOCATION=/u01/oracle/agent12c/core/12.1.0.1.0/prereqs -J-DORACLE_HOSTNAME=xxxx.xxxxxxxx.com
-J-DAGENT_BASE_DIR=/u01/oracle/agent12c
Prereq Logs
Location:/u01/oracle/agent12c/core/12.1.0.1.0/cfgtoollogs/agentDeploy/prereq.log Agent install prereqs completed successfully

Cloning the agent home…
Executing
command: /u01/oracle/agent12c/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSysPrereqs -clone -forceClone -silent -waitForCompletion -nowait ORACLE_HOME=/u01/oracle/agent12c/core/12.1.0.1.0
-responseFile /u01/oracle/stage/12cagent/agent.rsp
AGENT_BASE_DIR=/u01/oracle/agent12c AGENT_BASE_DIR=/u01/oracle/agent12c RESPONSE_FILE=/u01/oracle/stage/12cagent/agent.rsp -noconfig ORACLE_HOME_NAME=agent12gr2 -force
Clone Action Logs
Location:/u01/oracle/oraInventory/logs/cloneActions.log Cloning of agent home completed successfully

Attaching sbin home…
Executing
command: /u01/oracle/agent12c/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSysPrereqs -attachHome -waitForCompletion -nowait
ORACLE_HOME=/u01/oracle/agent12c/sbin ORACLE_HOME_NAME=sbin12c1 -force Attach Home Logs
Location:/u01/oracle/agent12c/core/12.1.0.1.0/cfgtoollogs/agentDeploy/AttachHome.log Attach home for sbin home completed successfully.

Updating home dependencies…
Executing
command: /u01/oracle/agent12c/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSysPrereqs -updateHomeDeps -waitForCompletion
HOME_DEPENDENCY_LIST=”{/u01/oracle/agent12c/sbin:/u01/oracle/agent12c/core/12.1.0.1.0}” -invPtrLoc /u01/oracle/agent12c/core/12.1.0.1.0/oraInst.loc -force Update Home Dependencies
Location:/u01/oracle/agent12c/core/12.1.0.1.0/cfgtoollogs/agentDeploy/UpdateHomeDeps.log Update home dependency completed successfully.

Performing the agent configuration…
Executing
command: /u01/oracle/agent12c/core/12.1.0.1.0/oui/bin/runConfig.sh ORACLE_HOME=/u01/oracle/agent12c/core/12.1.0.1.0
RESPONSE_FILE=/u01/oracle/agent12c/core/12.1.0.1.0/agent.rsp ACTION=configure MODE=perform COMPONENT_XML=
{oracle.sysman.top.agent.11_1_0_1_0.xml} RERUN=true
Configuration Log
Location:/u01/oracle/agent12c/core/12.1.0.1.0/cfgtoollogs/cfgfw/CfmLogger.log Agent Configuration completed successfully

The following configuration scripts need to be executed as the “root” user. #!/bin/sh
#Root script to run
/u01/oracle/agent12c/core/12.1.0.1.0/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as “root”
3. Run the scripts
Agent Deployment Successful.
Agent deployment log location:
/u01/oracle/agent12c/core/12.1.0.1.0/cfgtoollogs/agentDeploy/agentDeploy_.log Agent deployment completed successfully.
dgtest:/u01/oracle/stage/12cagent>

Get unix admin to run root.sh from /u01/oracle/agent12c/core/12.1.0.1.0

Ends.

Posted in EM Grid Control | Tagged: | 1 Comment »

Warning The database discovery finished with some warnings: Can’t resolve a non-optional query descriptor property DiscoveryRoots (DiscoveryRoots)

Posted by Arjun Raja on July 24, 2012

Warning The database discovery finished with some warnings: Can’t resolve a non-optional query descriptor property
[DiscoveryRoots] (DiscoveryRoots)

I installed the Oracle 12c agent using the silent mode – downloaded the zip file to the server where the agent was
being installed .

I noticed none of the databases or listeners had been discovered in the Cloud control web page even after the agent
install was successful.

While trying to manually discover them via Cloud control I received the message

Warning The database discovery finished with some warnings: Can’t resolve a non-optional query descriptor property
[DiscoveryRoots] (DiscoveryRoots)
I checked the log file on the agent server.

cd $AGENT_HOME/sysman/log

view gcagent.log

Noticed the following errors during installation –

2012-07-23 14:41:50,055 [42:F5077C5B:HTTP Listener-42 – /emd/main/ (DispatchRequests)] INFO – (begin processing requests for
OMS@6488096@middba3=>[134302570780001])
2012-07-23 14:41:50,056 [42:F5077C5B] INFO – >>> Dispatching request: PutFileRequest
(/u01/oracle/agent12c/install/logs/oracle.sysman.oh_12.1.0.1.0_DISCOVERY_52.zip len
gth=302837 BIN) <<<
2012-07-23 14:41:50,130 [89:68BCA6D1:JobReader-GCThread-36-89] WARN – JobReader encountered an exception:java.io.IOException: Broken pipe 2012-07-23 14:41:50,136 [42:F5077C5B] INFO – >>> Reporting exception: oracle.sysman.emSDK.agent.client.exception.PerformOperationException: Unable to create file /u01/oracle/agent12c/install/logs
/oracle.sysman.oh_12.1.0.1.0_DISCOVERY_52.zip: No such file or directory

I checked the path mentioned in the error and realised there was no directory install/logs under /u01/oracle/agent12c.

Created those directories and ran a discovery again and it worked.

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