{"id":3111,"date":"2013-05-27T06:59:00","date_gmt":"2013-05-27T04:59:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/use-of-oracle-entreprise-manager-grid-control-11g-to-monitor-microsoft-sql-server\/"},"modified":"2013-05-27T06:59:00","modified_gmt":"2013-05-27T04:59:00","slug":"use-of-oracle-entreprise-manager-grid-control-11g-to-monitor-microsoft-sql-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/use-of-oracle-entreprise-manager-grid-control-11g-to-monitor-microsoft-sql-server\/","title":{"rendered":"Monitoring SQL Server with Oracle OEM Grid Control 11g"},"content":{"rendered":"

Recently, I had the chance to install the SQL Server Plug-in for Oracle Entreprise Management Grid Control 11g to monitor a SQL Server instance based on a windows host. Our client, who monitors these Oracle databases via OEM Grid Control 11g, wanted to use the same tool to also monitor SQL Server databases.<\/p>\n

In this blog posting, I will describe how to install the 11g agent on a Windows host and how to import as well as use the SQL Server plug-in on Grid Control 11g.<\/p>\n

Installation Agent 11g on windows host<\/h3>\n

First, we have to download the 11g agent here<\/a>. Note that we have to use a 64 bit platform.<\/p>\n

\"b2ap3_thumbnail_pic1.jpg\"<\/a><\/p>\n

Unzip this file on the Windows host, for example in c:temp.<\/p>\n

\"b2ap3_thumbnail_pic2.jpg\"<\/a><\/p>\n

Create a one-time registration password on the grid for our Windows host.
\nGo to Grid Control 11g, open the Setup menu and Registration Passwords<\/p>\n

\"b2ap3_thumbnail_pic3.jpg\"<\/a><\/p>\n

Click on Add Registration Password<\/p>\n

\"b2ap3_thumbnail_pic4.jpg\"<\/a><\/p>\n

Enter a password, confirm it, enter a description, select the type One-time, enter the expiration date of today and click OK<\/p>\n

\"b2ap3_thumbnail_pic5.jpg\"<\/a><\/p>\n

We will use this password to establish a secure connection to the OMS in the additional_agent.rsp file just below.<\/p>\n

Now go to C:Temp where we have unzipped our 11g agent and open c:Windows_X64_Grid_Control_agent_download_11_1_0_1_0windows_x64responseadditional_agent.rsp file to modify it as follow – then save and close it:<\/p>\n

\n

####################################################################<\/span><\/p>\n

## copyright (c) 1999, 2010 Oracle. All rights reserved.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## Specify values for the variables listed below to customize\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## your installation.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## Each variable is associated with a comment. The comment\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## identifies the variable type.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## Please specify the values in the following format:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Example\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 “Sample Value”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Boolean\u00a0\u00a0\u00a0\u00a0 True or False\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0Number\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 StringList\u00a0\u00a0 {“String value 1″,”String Value 2”}\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## The values that are given as need to be\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## specified for a silent installation to be successful.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

##\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## This response file is generated by Oracle Software\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

## Packager.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ##<\/span><\/p>\n

###################################################################<\/span><\/p>\n

\u00a0<\/span><\/p>\n

RESPONSEFILE_VERSION=2.2.1.0.0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

#################################################################################<\/span><\/p>\n

#Inputs for Oracle Configuration Manager<\/span><\/p>\n

#################################################################################<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#SECURITY_UPDATES_VIA_MYORACLESUPPORT: Whether security updates are reqi-<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 uired via My Oracle Support<\/span><\/p>\n

#DECLINE_SECURITY_UPDATES: Whether security updates should be declined.<\/span><\/p>\n

#MYORACLESUPPORT_USERNAME & MYORACLESUPPORT_PASSWORD: User name and passw-<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ord for My Oracle Support access, these will be effected only when SECU-<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RITY_UPDATES_VIA_MYORACLESUPPORT=true<\/span><\/p>\n

#COLLECTOR_SUPPORTHUB_URL: If there is not direct connection and Support<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hub is deployed. Need to specify that URL. <\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

SECURITY_UPDATES_VIA_MYORACLESUPPORT=FALSE<\/span><\/b><\/p>\n

DECLINE_SECURITY_UPDATES=TRUE<\/span><\/b><\/b><\/p>\n

MYORACLESUPPORT_USERNAME=<\/span><\/p>\n

MYORACLESUPPORT_PASSWORD=<\/span><\/p>\n

COLLECTOR_SUPPORTHUB_URL=<\/span><\/p>\n

\u00a0<\/span><\/p>\n

################################################################################<\/span><\/p>\n

#PARAMETERS FOR SOFTWARE UPDATES <\/span><\/p>\n

################################################################################<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#INSTALL_UPDATES_SELECTION: <\/span><\/p>\n

# Option 1. If you want to skip the software updates, provide <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 INSTALL_UPDATES_SELECTION=”skip”<\/span><\/p>\n

# Option 2. If you have already downloaded the updates then provide <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 INSTALL_UPDATES_SELECTION=”staged”<\/span><\/p>\n

# If you choose the Option 2 then make sure you also provide STAGE_LOCATION.<\/span><\/p>\n

#STAGE_LOCATION: Stage location for software updates. It will be effected<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 only when INSTALL_UPDATES_SELECTION is set to “staged”<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

INSTALL_UPDATES_SELECTION=”skip”<\/span><\/p>\n

STAGE_LOCATION=<\/span><\/p>\n

\u00a0<\/span><\/p>\n

################################################################################<\/span><\/p>\n

#PROXY DETAILS FOR SECURITY UPDATES\/ SOFTWARE UPDATES <\/span><\/p>\n

################################################################################<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#PROXY_USER: User name for proxy access.<\/span><\/p>\n

#PROXY_PWD: Password for proxy access.<\/span><\/p>\n

#PROXY_HOST: Server providing proxy access.<\/span><\/p>\n

#PROXY_PORT: Port for proxy access.<\/span><\/p>\n

#——————————————————————————<\/span><\/p>\n

PROXY_USER=<\/span><\/p>\n

PROXY_PWD=<\/span><\/p>\n

PROXY_HOST=<\/span><\/p>\n

PROXY_PORT=<\/span><\/p>\n

\u00a0<\/span><\/p>\n

################################################################################<\/span><\/p>\n

#Various inputs required for Installation and Configuration<\/span><\/p>\n

################################################################################<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#ORACLE_AGENT_HOME_LOCATION: The location of oracle agent home.<\/span><\/p>\n

#Agent home “agent11g” would be created under the directory specified by<\/span><\/p>\n

#ORACLE_AGENT_HOME_LOCATION.<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

ORACLE_AGENT_HOME_LOCATION=c:oracleagent11g<\/span><\/b><\/b><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#DEINSTALL_LIST: List of components to be deinstalled during a <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 deinstall session.The following choices are available. The value should <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 contain only one of these choices.The choices are of the form <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 Internal Name, Version : External name. Please use the internal name and <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 version while specifying the value.<\/span><\/p>\n

#\u00a0\u00a0 oracle.sysman.top.agent, 10.2.0.0.0 : Oracle Management Agent 10.2.0.0.0 <\/span><\/p>\n

#\u00a0\u00a0 oracle.sysman.top.em_seed, 10.2.0.0.0 : Oracle Enterprise Manager Repository Database 10.2.0.0.0 <\/span><\/p>\n

#\u00a0\u00a0 oracle.sysman.top.oms, 10.2.0.0.0 : Oracle Enterprise Manager Grid Console 10.2.0.0.0 <\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

DEINSTALL_LIST={“oracle.sysman.top.agent”,”11.1.0.1.0″}<\/span><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#b_silentInstall: The user should not change this value<\/span><\/p>\n

#CLUSTER_NODES: This variable represents the cluster node names<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 selected by the user for installation.<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

b_silentInstall=true<\/span><\/p>\n

#CLUSTER_NODES=<\/span><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#TOPLEVEL_COMPONENT: The top level component to be installed in the <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 current session.Value should contain only one of the following available <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 choices.The choices are of the form Internal Name, Version : External name. <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 Please use the internal name and version while specifying the value.<\/span><\/p>\n

#\u00a0\u00a0 oracle.sysman.top.agent, 10.3.0.0.0 : Oracle Management Agent 10.3.0.0.0 <\/span><\/p>\n

#\u00a0\u00a0 Example: TOPLEVEL_COMPONENT = {“oracle.sysman.top.agent”,”10.3.0.0.0″}<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

TOPLEVEL_COMPONENT={“oracle.sysman.top.agent”,”11.1.0.1.0″}<\/span><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#SELECTED_LANGUAGES: Languages in which the components will be installed.<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 The following choices are available. The value should contain only one of <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 these choices.The choices are of the form Internal Name : External name. <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 Please use the internal name while specifying the value.<\/span><\/p>\n

#\u00a0\u00a0 en,\u00a0\u00a0 : English<\/span><\/p>\n

#\u00a0\u00a0 de,\u00a0\u00a0 : German<\/span><\/p>\n

#\u00a0\u00a0 es,\u00a0\u00a0 : Latin American Spanish<\/span><\/p>\n

#\u00a0\u00a0 es_MX,\u00a0\u00a0 : Mexican Spanish<\/span><\/p>\n

#\u00a0\u00a0 es_ES,\u00a0\u00a0 : Spanish<\/span><\/p>\n

#\u00a0\u00a0 fr,\u00a0\u00a0 : French<\/span><\/p>\n

#\u00a0\u00a0 fr_CA,\u00a0\u00a0 : Canadian French<\/span><\/p>\n

#\u00a0\u00a0 it,\u00a0\u00a0 : Italian<\/span><\/p>\n

#\u00a0\u00a0 iw,\u00a0\u00a0 : Hebrew<\/span><\/p>\n

#\u00a0\u00a0 ja,\u00a0\u00a0 : Japanese<\/span><\/p>\n

#\u00a0\u00a0 ko,\u00a0\u00a0 : Korean<\/span><\/p>\n

#\u00a0\u00a0 pt_BR,\u00a0\u00a0 : Brazilian Portuguese<\/span><\/p>\n

#\u00a0\u00a0 zh_CN,\u00a0\u00a0 : Simplified Chinese<\/span><\/p>\n

#\u00a0\u00a0 zh_TW,\u00a0\u00a0 : Traditional Chinese<\/span><\/p>\n

#Example: SELECTED_LANGUAGES = {“en”}<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

SELECTED_LANGUAGES={“en”}<\/span><\/b><\/b><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#COMPONENT_LANGUAGES: Languages in which the components will be installed.<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 The following choices are available. The value should contain only one of <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 these choices.The choices are of the form Internal Name : External name. <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 Please use the internal name while specifying the value.<\/span><\/p>\n

#\u00a0\u00a0 en,\u00a0\u00a0 : English<\/span><\/p>\n

#\u00a0\u00a0 de,\u00a0\u00a0 : German<\/span><\/p>\n

#\u00a0\u00a0 es,\u00a0\u00a0 : Latin American Spanish<\/span><\/p>\n

#\u00a0\u00a0 es_MX,\u00a0\u00a0 : Mexican Spanish<\/span><\/p>\n

#\u00a0\u00a0 es_ES,\u00a0\u00a0 : Spanish<\/span><\/p>\n

#\u00a0\u00a0 fr,\u00a0\u00a0 : French<\/span><\/p>\n

#\u00a0\u00a0 fr_CA,\u00a0\u00a0 : Canadian French<\/span><\/p>\n

#\u00a0\u00a0 it,\u00a0\u00a0 : Italian<\/span><\/p>\n

#\u00a0\u00a0 iw,\u00a0\u00a0 : Hebrew<\/span><\/p>\n

#\u00a0\u00a0 ja,\u00a0\u00a0 : Japanese<\/span><\/p>\n

#\u00a0\u00a0 ko,\u00a0\u00a0 : Korean<\/span><\/p>\n

#\u00a0\u00a0 pt_BR,\u00a0\u00a0 : Brazilian Portuguese<\/span><\/p>\n

#\u00a0\u00a0 zh_CN,\u00a0\u00a0 : Simplified Chinese<\/span><\/p>\n

#\u00a0\u00a0 zh_TW,\u00a0\u00a0 : Traditional Chinese<\/span><\/p>\n

#Example: COMPONENT_LANGUAGES = {“en”}<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

COMPONENT_LANGUAGES={“en”}<\/span><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#OMS_HOST: OMS host info required to connect to OMS<\/span><\/p>\n

#OMS_PORT: OMS port info required to connect to OMS<\/span><\/p>\n

#AGENT_REGISTRATION_PASSWORD: Agent Registration Password needed to <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 establish a secure connection to the OMS.<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

OMS_HOST=vmtestoraem1.it.dbi-services.com<\/span><\/b><\/p>\n

OMS_PORT=7799<\/span><\/b><\/p>\n

AGENT_REGISTRATION_PASSWORD=manager1<\/span><\/b><\/b><\/p>\n

\u00a0<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#s_agentSrvcName: Sets the agent Service Name and this variable can be<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 used to overrite the agent service name calculated by the install. This is<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 required for only Windows.<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 Example: <\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 s_agentSrvcName\u00a0\u00a0 = “Oracleagent11gAgent”\u00a0\u00a0\u00a0\u00a0 ; default value<\/span><\/p>\n

#\u00a0\u00a0\u00a0\u00a0 s_agentSrvcName = “GridAgent”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 ; User specified value <\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

#s_agentSrvcName=””<\/span><\/p>\n

\u00a0<\/span><\/p>\n

####################################################################################<\/span><\/p>\n

#Please Don’t change the values of these variables<\/span><\/p>\n

####################################################################################<\/p>\n

#——————————————————————————-<\/span><\/p>\n

#FROM_LOCATION: Complete path to the products.xml.<\/span><\/p>\n

#b_upgrade: “whether it is Upgrade or not”<\/span><\/p>\n

#EM_INSTALL_TYPE: install type<\/span><\/p>\n

#——————————————————————————-<\/span><\/p>\n

FROM_LOCATION=”C:\/Temp\/Windows_X64_Grid_Control_agent_download_11_1_0_1_0\/windows_x64\/agent\/stage\/products.xml”<\/span><\/b><\/b><\/p>\n

b_upgrade=false<\/span><\/p>\n

EM_INSTALL_TYPE=”AGENT”<\/span><\/p>\n<\/div>\n

Now, open a windows command prompt as administrator and go to C:TempWindows_X64_Grid_Control_agent_download_11_1_0_1_0windows_x64ouiDisk1 and execute \u201csetup.exe -silent -responseFile C:TempWindows_X64_Grid_Control_agent_download_11_1_0_1_0windows_x64responseadditional_agent.rsp\u201d<\/p>\n

\"b2ap3_thumbnail_pic6.jpg\"<\/a><\/p>\n

The installation is processing\u2026<\/p>\n

\"b2ap3_thumbnail_pic7.jpg\"<\/a><\/p>\n

When the screen disappears, the installation is finished. To see if the installation completes successfully, go to c:oracleagent11gagent11gbin and execute the command \u201cemctl status agent\u201d.
\nIf you want stop or restart the agent, you can use this command: \u201cemctl stop agent\u201d or \u201cemctl start agent\u201d.<\/p>\n

\"b2ap3_thumbnail_pic8.jpg\"<\/a><\/p>\n

The installation is done, the agent is running!<\/p>\n

Installation of SQL Server plug-in on Grid control 11g<\/h3>\n

First, download the plug-in by clicking here<\/a>.
\nGo to Grid Control 11g and open the Setup menu:<\/p>\n

\"b2ap3_thumbnail_Installation_PlugIn_SQLServer-1.jpg\"<\/a><\/p>\n

Go to Management Plug-ins<\/p>\n

\"b2ap3_thumbnail_pic9.jpg\"<\/a><\/p>\n

Click the Import button<\/p>\n

\"b2ap3_thumbnail_pic10.jpg\"<\/a><\/p>\n

And select the file we have downloaded before and click Open:<\/p>\n

\"b2ap3_thumbnail_pic11.jpg\"<\/a><\/p>\n

Click the button \u201cList Archive\u201d:<\/p>\n

\"b2ap3_thumbnail_pic12.jpg\"<\/a><\/p>\n

Select the Microsoft_sqlserver_database plug-in and click OK:<\/p>\n

\"b2ap3_thumbnail_pic13.jpg\"<\/a><\/p>\n

The plug-in is ready to be deployed:<\/p>\n

\"b2ap3_thumbnail_pic14.jpg\"<\/a><\/p>\n

Before deployment go to Preferences menu, preferred credentials:<\/p>\n

\"pic15.jpg\"<\/a><\/p>\n

Click on the \u201cSet credentials\u201d icon of the agent:<\/p>\n

\"b2ap3_thumbnail_pic16.jpg\"<\/a><\/p>\n

For our new host, enter the host username and his password and click apply:<\/p>\n

\"b2ap3_thumbnail_pic17.jpg\"<\/a><\/p>\n

The credentials have been applied:<\/p>\n

\"b2ap3_thumbnail_pic18.jpg\"<\/a><\/p>\n

Now go back to Setup, Management Plug-ins, select the Microsoft_sqlserver_database plug-ins and click on the Deploy button:<\/p>\n

\"b2ap3_thumbnail_pic19.jpg\"<\/a><\/p>\n

Click on Add agents, and do a search for Agent on the new screen. Select the new SQL Server Host and click on the button Select:<\/p>\n

\"b2ap3_thumbnail_pic20.jpg\"<\/a><\/p>\n

Click Next:<\/p>\n

\"b2ap3_thumbnail_pic21.jpg\"<\/a><\/p>\n

Click Finish:<\/p>\n

\"b2ap3_thumbnail_pic22.jpg\"<\/a><\/p>\n

Deployment complete!<\/p>\n

\"b2ap3_thumbnail_pic23.jpg\"<\/a><\/p>\n

Add an instance to an SQL Server host<\/h3>\n

Now, we will add an SQL Server instance to our new SQL Server host.<\/p>\n

Click on Setup:<\/p>\n

\"b2ap3_thumbnail_pic25.jpg\"<\/a><\/p>\n

Click on Agents<\/p>\n

\"b2ap3_thumbnail_pic26.jpg\"<\/a><\/p>\n

Click on the new SQL Server host:<\/p>\n

\"b2ap3_thumbnail_pic27.jpg\"<\/a><\/p>\n

On the dropdown list, select \u201cMicrosoft SQL Server\u201d and click Go:<\/p>\n

\"b2ap3_thumbnail_pic28.jpg\"<\/a><\/p>\n

Now, you have to enter:<\/p>\n