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

UNIX :

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

6.1.0.0

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

6100-06

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

DBA :

perform oracle product install  – AIX_Grid_Control_agent_download_11_1_0_1_0.zip

UNIX :

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

AIX_Grid_Control_agent_download_11_1_0_1_0.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.

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

INSTALL_UPDATES_SELECTION=”skip”

ORACLE_AGENT_HOME_LOCATION=”/u01/oracle/”

b_silentInstall=true

OMS_HOST=”prdu010.greatwest.com”

OMS_PORT=”4889″

AGENT_REGISTRATION_PASSWORD=”xxxxxxx”

FROM_LOCATION=”/u01/oracle/stage/GA11/aix/agent/stage/products.xml”

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 ***

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

Summary

Global Settings

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

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

Installation Type: Complete

Product Languages

English

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 11.1.0.1.0

Agent Virtualization 11.1.0.1.0

Enterprise Manager Agent 11.1.0.1.0

Enterprise Manager Agent Core Files 11.1.0.1.0

Secure Socket Layer 11.1.0.7.0

Oracle Recovery Manager 11.1.0.7.0

Enterprise Manager Common Files 11.1.0.1.0

Enterprise Manager Common Core Files 11.1.0.1.0

Required Support Files 11.1.0.7.0

Oracle RAC Required Support Files-HAS 11.1.0.7.0

Oracle JDBC/THIN Interfaces 11.1.0.7.0

Oracle JDBC/OCI Instant Client 11.1.0.7.0

Oracle Globalization Support 11.1.0.7.0

Oracle Net Required Support Files 11.1.0.7.0

SSL Required Support Files for InstantClient 11.1.0.7.0

LDAP Required Support Files 11.1.0.7.0

Oracle Globalization Support 11.1.0.7.0

Perl Interpreter 5.10.0.0.1

Perl Modules 5.10.0.0.1

Expat libraries 2.0.1.0.1

XML Parser for Java 11.1.0.7.0

Precompiler Required Support Files 11.1.0.7.0

RDBMS Required Support Files 11.1.0.7.0

RDBMS Required Support Files for Instant Client 11.1.0.7.0

Parser Generator Required Support Files 11.1.0.7.0

Platform Required Support Files 11.1.0.7.0a

Patch for Oracle Process Management Notification 10.1.3.4.0

Oracle Process Management Notification 10.1.3.0.0

Agent Required Support Files 10.2.0.4.1

XDK Required Support Files 11.1.0.7.0

SQL*Plus Required Support Files 11.1.0.7.0

Secure Socket Layer 11.1.0.7.0

Oracle Core Required Support Files 11.1.0.7.0

Enterprise Manager Agent for Grid Control 11.1.0.1.0

Installation Common Files 11.1.0.7.0

Oracle Configuration Manager 10.3.2.1.0

Oracle Bali Share 11.1.1.2.0

Enterprise Manager Application Server Integrator Plugin — Agent Support 11.1.0.2.0

Oracle Dynamic Monitoring Service Patch 10.1.2.3.0

Oracle Dynamic Monitoring Service 10.1.2.1.0

Enterprise Manager Application Server Plugin — Agent Support 11.1.0.1.0

Enterprise Manager Application Server Plugin — Common Support 11.1.0.1.0

Enterprise Manager Database Plugin — Agent Support 11.1.0.1.0

Enterprise Manager Siebel Plugin — Agent Support 11.1.0.1.0

Provisioning Advisor Framework Common Files For Agent and OMS 11.1.0.1.0

Common component for  Virtualization 11.1.0.1.0

Oracle Notification Service (eONS) 11.2.0.1.0

Enterprise Manager Collaboration Suite Plugin — Agent Support 11.1.0.1.0

Oracle Notification Service 10.1.3.0.0

Oracle Required Support Files 32 bit 11.1.0.7.0

OracleAS HTTP Client 11.1.1.2.0

OracleAS J2EE BULKOPS 11.0.0.0.0

Oracle Wallet Manager 11.1.0.7.0

Oracle Security Developer Tools 11.1.0.7.0

Oracle Universal Installer 11.1.0.8.0

Oracle One-Off Patch Installer 11.1.0.8.0

Installer SDK Component 11.1.0.8.0

Sun JDK 1.6.0.6.0

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

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

/u01/oracle/agent11g/root.sh

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 11.1.0.1.0

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

—————————————————————

Agent Version     : 11.1.0.1.0

OMS Version       : 10.2.0.5.0

Protocol Version  : 10.2.0.5.0

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

[UAT]ofsax:/u01/ofsax/agent11g/bin>

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

/tmp/OraInstall2011-02-23_01-35-04PM

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

Advertisements

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

/u01/oracle/agent10g/sysman/emd

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>

<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>

<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”/>

</Target>

</Targets>

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

http://srdu010.subiaco.com:4889/em/console/logon/logon

sysman

********

– 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 »