Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Archive for the ‘EM10g Grid Control’ Category

Install Oracle Grid Agent 11g on IBM Aix 6.1

Posted by Hendry chinnapparaj on February 23, 2011

Install Oracle Grid Agent 11g on IBM Aix 6.1

Oracle 11g Grid Agent connecting to Oracle 10g Grid Control

There are issues installing this agent in Aix 6.1, hence a efix required in unix before install which can be removed after the install as below


zoeprd:/tmp/OraInstall2011-02-23_01-35-04PM> oslevel -g

zoeprd:/tmp/OraInstall2011-02-23_01-35-04PM> oslevel -r


Install efix:  emgr -e IZ88711SP2.101121.epkg.Z


perform oracle product install  – AIX_Grid_Control_agent_download_11_1_0_1_0.zip


remove efix : emgr -r -L IZ88711SP2

To install 11g grid agent you have to use the following options –


1. Push Method.

2. Pull Method.

3. Clone agent home

4. Silent install.

Example of silent install.

Download 11g grid control agent software and unzip it from technet.oracle.com –

cd /u01/oracle/stage –

ls -l *.zip


unzip AIX_Grid_Control_agent_download_11_1_0_1_0.zip

Creates a new directory aix.

cd /u01/oracle/stage/GA11/aix/response

zoeprd:/u01/oracle/stage/GA11/aix/response> l

total 48

-rwxrwxr-x    1 oracle   dba             489 Dec 23 2009  staticports.ini

-rwxrwxr-x    1 oracle   dba            5922 Feb  9 2010  upgrade_agent.rsp

-rwxrwxr-x    1 oracle   dba           10470 Feb 23 13:33 additional_agent.rsp

edit the file – additional_agent.rsp

Make the following changes- basic changes needed – no uploads to oracle support.










cd /u01/oracle/stage/aix/agent

./runInstaller -silent -responseFile /u01/oracle/stage/GA11/aix/response/additional_agent.rsp à check the path for rsp file

Starting Oracle Universal Installer…

Checking Temp space: must be greater than 150 MB.   Actual 1858 MB    Passed

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

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-02-02_08-14-12AM. Please wait …cpsoa1:/u01/oracle/stage/aix/agent> *** Check for updates ***

*** Select Installation Type ***

*** Check Prerequisites ***

*** Specify Oracle Management Service Location ***

*** Customize Ports ***

*** Review ***



Global Settings

Source: /u01/oracle/stage/aix/agent/stage/../stage/products.xml

Oracle Home: /u01/oracle/agent11g (agent11g1)

Installation Type: Complete

Product Languages


Space Requirements

/tmp/ Required 77MB (only as temporary space) : Available 1.59GB

/u01/ Required 2.54GB : Available 37.68GB

New Installations (58 products)

Oracle Management Agent

Agent Virtualization

Enterprise Manager Agent

Enterprise Manager Agent Core Files

Secure Socket Layer

Oracle Recovery Manager

Enterprise Manager Common Files

Enterprise Manager Common Core Files

Required Support Files

Oracle RAC Required Support Files-HAS

Oracle JDBC/THIN Interfaces

Oracle JDBC/OCI Instant Client

Oracle Globalization Support

Oracle Net Required Support Files

SSL Required Support Files for InstantClient

LDAP Required Support Files

Oracle Globalization Support

Perl Interpreter

Perl Modules

Expat libraries

XML Parser for Java

Precompiler Required Support Files

RDBMS Required Support Files

RDBMS Required Support Files for Instant Client

Parser Generator Required Support Files

Platform Required Support Files

Patch for Oracle Process Management Notification

Oracle Process Management Notification

Agent Required Support Files

XDK Required Support Files

SQL*Plus Required Support Files

Secure Socket Layer

Oracle Core Required Support Files

Enterprise Manager Agent for Grid Control

Installation Common Files

Oracle Configuration Manager

Oracle Bali Share

Enterprise Manager Application Server Integrator Plugin — Agent Support

Oracle Dynamic Monitoring Service Patch

Oracle Dynamic Monitoring Service

Enterprise Manager Application Server Plugin — Agent Support

Enterprise Manager Application Server Plugin — Common Support

Enterprise Manager Database Plugin — Agent Support

Enterprise Manager Siebel Plugin — Agent Support

Provisioning Advisor Framework Common Files For Agent and OMS

Common component for  Virtualization

Oracle Notification Service (eONS)

Enterprise Manager Collaboration Suite Plugin — Agent Support

Oracle Notification Service

Oracle Required Support Files 32 bit

OracleAS HTTP Client


Oracle Wallet Manager

Oracle Security Developer Tools

Oracle Universal Installer

Oracle One-Off Patch Installer

Installer SDK Component



Installation in progress

…………………………………Installation in progress


Install successful

Linking in progress

Setup in progress


Setup successful

Warning: The following configuration scripts needs to be executed as the “root” user


To execute the configuration scripts:

1. Open a new  terminal window

2. Login in as “root”

3. Run the scripts

To check progress – cd $AGENT_HOME/cfgtoollogs/cfgfw

cd /u01/oracle/agent11g/cfgtoollogs/cfgfw

tail –f CfmLogger_2011-02-03_08-55-32-AM.log

Final few lines –

Verifying the update…

Inventory check OK: Patch ID 9676134 is registered in Oracle Home inventory with proper meta-data.

Files check OK: Files from Patch ID 9676134 are present in Oracle Home.

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.

Finished one-offs apply…

Deleting the files…

Finished deleting the above files…

Configuration assistant “Agent Oneoff Patch Application” Succeeded

Running Configuration assistant “Agent Configuration Assistant”

Performing free port detection on host=oatu009n2.greatwest.com

Securing the agent

Performing targets discovery and agent configuration

Starting the agent

Configuration assistant “Agent Configuration Assistant” Succeeded

AgentPlugIn:agent configuration finished with status = true

Running Configuration assistant “Agent Add-on Plug-in”

Configuration assistant “Agent Add-on Plug-in” Succeeded

CONTROL C to quit –


cd /u01/oracle/agent11g/bin >  ./emctl status agent

Oracle Enterprise Manager 11g Release 1 Grid Control

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


Agent Version     :

OMS Version       :

Protocol Version  :

Agent Home        : /u01/oracle/agent11g

Agent binaries    : /u01/oracle/agent11g

Agent Process ID  : 1089764

Parent Process ID : 1581084

Agent URL         : https://uatu024.greatwest.com:3872/emd/main/

Repository URL    : https://prdu010.greatwest.com:1159/em/upload

Started at        : 2011-02-02 10:53:14

Started by user   : ofsax

Last Reload       : 2011-02-02 10:54:59

Last successful upload                       : 2011-02-02 10:55:01

Total Megabytes of XML files uploaded so far :    17.16

Number of XML files pending upload           :        0

Size of XML files pending upload(MB)         :     0.00

Available disk space on upload filesystem    :    49.58%

Last successful heartbeat to OMS             : 2011-02-02 10:55:20


Agent is Running and Ready


Get unix team to run root.sh from this area – /u01/oracle/agent11g

Then configure the dbsnmp user in database instances via Grid control.

Login to Grid control – Configure –Next Submit.

Troubleshoot for any install errors under the /tmp logs

zoeprd:/tmp/OraInstall2011-02-23_01-35-04PM> pwd


zoeprd:/tmp/OraInstall2011-02-23_01-35-04PM> l

-rw——-    1 oracle   dba               0 Feb 23 13:35 oraInstall2011-02-23_01-35-04PM.err

drwxr-xr-x    3 oracle   dba             256 Feb 23 13:35 install

-rw——-    1 oracle   dba             177 Feb 23 13:35 oraInstall2011-02-23_01-35-04PM.out


Posted in EM10g Grid Control | 1 Comment »

Listener Config in Target.xml file in Grid Control

Posted by Hendry chinnapparaj on August 23, 2010

Listener Config in Target.xml file in Grid Control

oracle@drou009n1 emd>pwd


oracle@drou009n1 emd>cat targets.xml

<Targets AGENT_TOKEN=”82267db0b7e27a46ce0e716dba8255e185355d32″>

<Target TYPE=”oracle_emd”/>

<Target TYPE=”host”/>

<Target TYPE=”oracle_listener”>

<Property VALUE=”10.777.61.69″/>

<Property VALUE=”1621″/>

<Property VALUE=”/u01/oracle/product/10.2/db_1/network/admin”/>

<Property VALUE=”mpsoa1_fc_dg”/>

<Property VALUE=”/u01/oracle/product/10.2/db_1″/>


<Target TYPE=”oracle_listener”>

<Property VALUE=”10.777.61.70″/>

<Property VALUE=”1521″/>

<Property VALUE=”/u01/oracle/product/10.2/db_1/network/admin”/>

<Property VALUE=”mpsoa1_public”/>

<Property VALUE=”/u01/oracle/product/10.2/db_1″/>


<Target TYPE=”oracle_database”>

<Property VALUE=”/u01/oracle/product/10.2/db_1″/>

<Property VALUE=”sys”/>

<Property VALUE=”10.777.61.69″/>

<Property VALUE=”1621″/>

<Property VALUE=”mpsoa1″/>

<Property VALUE=”mpsoa1_fc”/>

<Property VALUE=”0dd23bd9a4b3bedbc61e26cf4dfd4f6e” ENCRYPTED=”TRUE”/>

<Property VALUE=”SYSDBA”/>



Cd /u01/oracle/agent10g/bin

./emctl reload agent

./emctl status agent

Posted in EM10g Grid Control | Leave a Comment »

Failed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin).

Posted by Hendry chinnapparaj on June 23, 2010

Oracle Enterprise Manager 10g Grid Control Alert

MessageFailed to connect to database instance: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin).

SQL> select username, account_status from dba_users where username=’DBSNMP’;

USERNAME                       ACCOUNT_STATUS

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

DBSNMP                         EXPIRED

SQL> alter user dbsnmp identified by **** account unlock;

User altered.

And also update the dbsnmp password in the Grid control




– click setup

– agents

under search, type the server name and click go

– click the server

– select radio button for the database instance name

– click configure

– change password

– test connection

– should get “The connection test was successful”

– click next

– submit

– fixed

Also restart the Grid Agent if needed

./emctl stop agent

./emctl start agent

Posted in EM10g Grid Control | 2 Comments »