That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    1,650,000 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    11g Grid Control - how to change the OMS Repository Database Listener Port or Hostname

    In versions prioor to 11g Grid Control we had to update the emoms.properties file in case we needed to modify the Listener Port used to connect to the repository database. But in 11g OEM, it has been changed and we now have to use the emctl command.

    There are a lot of other options added to the emctl command which can be seen via the emctl -help command.

    To change the listener port or the hostname of the Repository Database we now have to use the emctl config oms command as shown below.

    emctl config oms -store_repos_details -repos_port 1528 -repos_sid emrep -repos_host wintest01 -repos_user SYSMAN -repos_pwd oracle11g

    To check what are the OMS Repository details we can use the emctl config oms -list_repos_details command.

    For example –

    D:\Oracle\Product\Middleware\oms11g\BIN>emctl config oms -list_repos_details

    Oracle Enterprise Manager 11g Release 1 Grid Control
    Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
    Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=wintest01)(PORT=1528)))(CONNECT_DATA=(SID=emrep)))
    Repository Host : wintest01
    Repository Port

    Continue reading 11g Grid Control – how to change the OMS Repository Database Listener Port or Hostname

    October 29th, 2010 | Tags: , , , | Category: EM Grid Control | One comment

    Some more 11g Grid Control Installation and Configuration Notes

    Some time back I had posted a few notes on the 11g Grid Control installation and configuration.

    11g Grid Control Installation Tips and Solutions

    11g Enterprise Manager Grid Control Installation Overview

    I would like to highlight an extremely good resource on all things related to the 11g Grid Control setup including the WebLogic and Agent installation.

    Here is the link –

    How to Build a Grid Control Environment (11g)

    Also, here is a very good presentation by Ray Smith “An Introduction to OEM 11g” which was also presented at the Oracle Open World 2010 recently held in San Francisco.

    Ray has been kind to share this with the community and it has a lot of information on what has changed in the Oracle 11g Grid Control environment and includes both a run through of the architecture and an overview of the installation.

    Presentation: An Introduction To OEM 11g

    October 29th, 2010 | Tags: , , , , | Category: EM Grid Control, Oracle 11g | 3 comments

    Oracle 11g Grid Control Agent Deployment

    The 11g management agent cannot be directly installed using the Oracle Universal Installer GUI as in the 10g version of the product. We can use any of the following methods to deploy the agent on target nodes.

    • Agent Pull method
    • Agent Push method
    • Agent clone.

    This note shows us how to deploy the agent from the EM Grid Control interface.

    From the Deployment tab in the EM Grid Console, click on Install Agent (under Agent Installation) and then Fresh Install.

    Enter the following details :

    • The host where we want to deploy the agent
    • The OS user account and password on the target machine
    • The top level path of the directory under which the ‘agent11g’ sub-directory will be created.
    • Management Server registration password

    Download document ….

    October 22nd, 2010 | Category: Administration | 3 comments

    11g Grid Control Installation - tips and solutions

    Here are some notes I put together after performing a couple of installations of 11g Grid Control on a Solaris SPARC 64 bit platform. I also encountered some issues with the 11g agent and 9i and 10g databases. There is not too much user experiences available online, so I thought that I would share a few of my observations and feedback of the issues encountered and how I managed to overcome those issues.

    Kindly provide feedback of your experience with the 11g Grid Control product for the good of all the user community.

    For installation on 64 bit platforms, WebLogic Server (WLS) 10.3.2 is supplied as a generic .jar file: wls1032_generic.jar.

    For example: java -d64 -jar wls1032_generic.jar

    The java from jdk 1.6 must be used to install WLS, but this java is not embedded in the WLS stage on the 64bit platforms and must be downloaded and installed separately. We need to use

    Continue reading 11g Grid Control Installation – tips and solutions

    October 21st, 2010 | Category: EM Grid Control | One comment

    Migrating data from DB2 to Oracle using SQL Developer

    This note will detail the steps required to move data from a DB2 9.7 UDB running on Linux to an Oracle 10g database also running on Linux using the migration capabilities provided by Oracle SQL Developer.

    I have used SQL Developer 2.1.1.64.45 which I think is the latest version available for download. I tested moving a 2 million row table which took about 50 minutes.

    Have a look at this note which shows all the steps taken for the operation including step by step screenshots.

    Appreciate your feedback and kindlly share your experiences in such heterogenous data load exercises with the rest of the community.

    Download the note …

    October 14th, 2010 | Tags: , , , | Category: Administration | 6 comments