6 Replies Latest reply on Nov 30, 2012 6:10 PM by 789987

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

    789987
      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....
          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
            Andy Klock
            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
              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
                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
                  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
                    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.