试下这个SQL看看

select a.INSTANCE_NAME,a."MODE$",b.MAL_INST_HOST,b.MAL_INST_PORT from v$instance a , "V$DM_MAL_INI" b
where a.INSTANCE_NAME=b.MAL_INST_NAME
and a."MODE$"='PRIMARY'
;