This discussion is archived
6 Replies Latest reply: Nov 30, 2012 10:10 AM by 789987 RSS

what is the view to get the database type using oem grid

789987 Newbie
Currently Being Moderated
Currently i have oem grid 11g , and i want to query a view where i can get the database type like (standalone, cluster database type).

In OEM we have search option as database/cluster/clusterdatabase.....so for this type i want to check in database level in repository.Please provide me the view with in the grid repository.
  • 1. Re: what is the view to get the database type using oem grid
    Aman.... Oracle ACE
    Currently Being Moderated
    I am not sure that this kind of information is listed in either v$database or V$instnace views. Normally, we look for the parameter cluster_database which would be set to true if the database is a RAC db. So you may want to check that parameter to confirm if the database is a normal or a RAC db.

    Aman....
  • 2. Re: what is the view to get the database type using oem grid
    AndyKlock Journeyer
    Currently Being Moderated
    Some handy views can be found here:

    http://docs.oracle.com/cd/E11857_01/em.111/e12135/views.htm#BACCFCAB
    SQL> select target_type, count(*) from MGMT$TARGET group by target_type;
    
    TARGET_TYPE                      COUNT(*)
    ------------------------------ ----------
    osm_cluster                             3
    oracle_listener                        36
    oracle_exa_cisco_switch                 2
    oracle_exa_kvm                          2
    oracle_home                            68
    has                                    12
    rac_database                            3
    weblogic_j2eeserver                     2
    oracle_apache                           1
    oracle_ias_farm                         1
    oracle_exa_pdu                          2
    oracle_oms                              1
    cluster                                 3
    oracle_exadata_grid                     3
    oracle_exa_ilom                        12
    oracle_exadata_dbsys                    3
    oracle_oms_console                      1
    j2ee_application                        3
    metadata_repository                     2
    oracle_apm                              1
    oracle_exadata                         21
    oracle_ibswitch                         5
    oracle_dbmachine                        3
    oracle_ibnetwork                        2
    oracle_beacon                           1
    oracle_oms_pbs                          1
    oracle_em_service                       2
    oracle_dbsys                           18
    oracle_emd                             25
    osm_instance                           12
    oracle_database                        27
    host                                   25
    weblogic_domain                         1
    oracle_emrep                            1
    
    34 rows selected.
    Good luck.
  • 3. Re: what is the view to get the database type using oem grid
    789987 Newbie
    Currently Being Moderated
    Thnx Andy. your query gave me idea to work furthur.
  • 4. Re: what is the view to get the database type using oem grid
    789987 Newbie
    Currently Being Moderated
    Hi Andy,

    One more question.

    i have SID name with TEST and my target name is registered as TEST_servername.WORLD in OEM grid.

    I need to retrieve SID/Instance name from OEM grid using mgmt$ views. mgmt$target gives me only target_name which is TEST_servername.WORLD , but my requirment is to get the SID/database name .
  • 5. Re: what is the view to get the database type using oem grid
    sb92075 Guru
    Currently Being Moderated
    Sam wrote:
    Hi Andy,

    One more question.

    i have SID name with TEST and my target name is registered as TEST_servername.WORLD in OEM grid.

    I need to retrieve SID/Instance name from OEM grid using mgmt$ views. mgmt$target gives me only target_name which is TEST_servername.WORLD , but my requirment is to get the SID/database name .
    SQL> select name from v$database;
    
    NAME
    ---------
    ORCL
  • 6. Re: what is the view to get the database type using oem grid
    789987 Newbie
    Currently Being Moderated
    Thanks for responding.

    Im trying to pull the SID names from MGMT$ views from OEM repository, so help me to get the SID name/Instance name from MGMT$ views.

Legend

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