Display database links with remote passwords

Connect to instance by using sys login (as sysdba)


Execute the following query

/* Formatted on 7/18/2014 10:54:33 AM (QP5 v5.115.810.9015) */
SELECT u.name owner,
       l.name "Dblink Name",
       l.HOST "Host Name",
       l.userid || '/' || l.password userpass
FROM sys.user$ u, sys.link$ l
WHERE l.owner# = u.user#;