IP / HOSTNAMES FROM | DB LINKS | CONFIG | ORACLE

select 
replace
( replace(
 replace(substr(host,(instr(host,'HOST',1,1))+4  , 12 ),')','' )  ,'(',''   )    ,'=','' )
from dba_db_links ;

Regards.K/.