This discussion is archived
8 Replies Latest reply: Oct 10, 2012 8:55 AM by BSalesRashid RSS

How to know if Grid Control is installed ?

BSalesRashid Explorer
Currently Being Moderated
Hi fellows,

The other DBA installed Oracle 11g in one machine here, i don't know what steps he proceeded in installation, he only told me that Enterprise manager works for this environment.

He told me that, to make enterprise manager work he had to install Grid Control, that was a requisite.

Since i never worked with grid, i don't know if the Grid is installed, how can i know if it is installed and working?

Thanks in advance.
  • 1. Re: How to know if Grid Control is installed ?
    BSalesRashid Explorer
    Currently Being Moderated
    This mean anything about GRID CONTROL ?


    oracle@gf:/home/oracle]$ emctl status agent

    Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
    Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
    ---------------------------------------------------------------
    Agent Version : 10.2.0.4.4
    OMS Version : 10.2.0.4.4
    Protocol Version : 10.2.0.4.4
    Agent Home : /u01/app/oracle/product/11.2.0/dbhome_1/gf.fastsolutions.com .br_gf
    Agent binaries : /u01/app/oracle/product/11.2.0/dbhome_1
    Agent Process ID : 14293
    Parent Process ID : 14235
    Agent URL : https://gf.xxxx.com.br:3938/emd/main
    Repository URL : https://gf.xxxx.com.br:1158/em/upload/
    Started at : 2012-08-21 18:11:33
    Started by user : oracle
    Last Reload : 2012-09-14 06:13:12
    Last successful upload : 2012-09-17 16:11:20
    Total Megabytes of XML files uploaded so far : 455.79
    Number of XML files pending upload : 0
    Size of XML files pending upload(MB) : 0.00
    Available disk space on upload filesystem : 89.15%
    Data channel upload directory : /u01/app/oracle/product/11.2.0/db home_1/gf.xxxx.com.br_gf/sysman/recv
    Last successful heartbeat to OMS : 2012-09-17 16:13:08
    ---------------------------------------------------------------
    Agent is Running and Ready



    Thanks
  • 2. Re: How to know if Grid Control is installed ?
    sxkumar Explorer
    Currently Being Moderated
    What you have installed is "DB Control" - not "Grid Control". It is a sub-product of the EM family that can only manage a single database. Grid/Cloud Control can manage multiple DBs from a single console and has lots of other features.
  • 3. Re: How to know if Grid Control is installed ?
    BSalesRashid Explorer
    Currently Being Moderated
    Fine, how can i know if Grid control is installed or not ?
  • 4. Re: How to know if Grid Control is installed ?
    EricvdS Expert
    Currently Being Moderated
    Check the disk(s) to find the file inventory.xml. If you post the HOME NAME entries from this file we can see if GC is installed.

    Eric
  • 5. Re: How to know if Grid Control is installed ?
    BSalesRashid Explorer
    Currently Being Moderated
    Hi,
    thanks for replying.

    I tryed to find it inside ORACLE_BASE directories and found:
    ./product/11.2.0/grid/oc4j/.patch_storage/9452259_Mar_18_2010_23_37_55/original_patch/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/.patch_storage/9452259_Mar_18_2010_23_37_55/backup/sainventory/oneoffs/7439847/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/.patch_storage/9452259_Mar_18_2010_23_37_55/backup/sainventory/oneoffs/8513914/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/.patch_storage/7439847_Feb_8_2009_20_36_24/original_patch/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/.patch_storage/8513914_Jun_5_2009_17_18_10/backup/sainventory/oneoffs/7439847/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/sainventory/oneoffs/7439847/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/sainventory/oneoffs/9452259/etc/config/inventory.xml
    ./product/11.2.0/grid/oc4j/sainventory/oneoffs/8513914/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/.patch_storage/9452259_Mar_18_2010_23_37_55/original_patch/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/.patch_storage/9452259_Mar_18_2010_23_37_55/backup/sainventory/oneoffs/7439847/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/.patch_storage/9452259_Mar_18_2010_23_37_55/backup/sainventory/oneoffs/8513914/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/.patch_storage/7439847_Feb_8_2009_20_36_24/original_patch/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/.patch_storage/8513914_Jun_5_2009_17_18_10/backup/sainventory/oneoffs/7439847/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/sainventory/oneoffs/7439847/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/sainventory/oneoffs/9452259/etc/config/inventory.xml
    ./product/11.2.0/dbhome_1/oc4j/sainventory/oneoffs/8513914/etc/config/inventory.xml



    I searched by 'HOME NAME' inside some inventory.xml and don't found nothing interesting.

    inventory.xml could be in an other directory different from ORACLE_BASE's directories ?

    Thanks!
  • 6. Re: How to know if Grid Control is installed ?
    BSalesRashid Explorer
    Currently Being Moderated
    Did not got any valid answer.
  • 7. Re: How to know if Grid Control is installed ?
    EricvdS Expert
    Currently Being Moderated
    Do a cat /etc/oraInst.loc (if you use Linux or /var/opt/oracle for Solaris) this should point you to one or more directories where you will find under the directory ContentsXM the file inventory.xml

    Eric
  • 8. Re: How to know if Grid Control is installed ?
    BSalesRashid Explorer
    Currently Being Moderated
    Hi,
    Thanks.
    <HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/>
    <HOME NAME="Ora11g_gridinfrahome1" LOC="/u01/app/oracle/product/11.2.0/grid" TYPE="O" IDX="2" CRS="true"/>

    This is the Home_name the you asked for, above.

    Regards,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points