List DBs on AIX

select target_name
     , host_name 
  from mgmt$target 
 where target_type='oracle_database'
   and host_name in (select target_name 
                       from mgmt$target 
                      where target_type='host'
                        and type_qualifier1='AIX')
order by host_name, target_name;

A variation of this which works for me as our hostname always follows the convention servername-dot-domainname and our database target name always follows the convention sid-dot-servername. This version puts both the host details and database details together and in this case I'm not filtering by the type of host i.e. AIX.

select b.target_name database_name
     , b.type_qualifier1 database_version
     , a.target_name host_name
     , a.type_qualifier1 || ' ' || a.type_qualifier2 host_version
  from mgmt$target a
     , mgmt$target b
 where a.target_type='host'
   and b.target_type='oracle_database'
   and upper(trim(substr(a.target_name,1,instr(a.target_name,'.')-1))) = upper(trim(substr(b.target_name,instr(b.target_name,'.')+1,15)))
order by a.target_name, b.target_name;