Re: DB link testing

Hi this is not too much,
I use this, you can generate from a procedure, the reason to use v$instance is to ensure the link goes where it must to go.

SELECT OWNER,DB_LINK ,USERNAME,HOST "AliasLocal",CREATED,'-->' SEP, HOST_NAME "BasedeDatosReal",
INSTANCE_NAME "InstanciaReal",LOG_MODE,STATUS FROM DBA_DB_LINKS ,
(
SELECT 'SOA.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM V$INSTANCE_at_SOA.WORLD,V$DATABASE_at_SOA.WORLD UNION ALL
SELECT 'FO1.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM V$INSTANCE_at_FO1.WORLD,V$DATABASE_at_FO1.WORLD UNION ALL
SELECT 'FO2.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM V$INSTANCE_at_FO2.WORLD,V$DATABASE_at_FO2.WORLD UNION ALL
SELECT 'FO3.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM V$INSTANCE_at_FO3.WORLD,V$DATABASE_at_FO3.WORLD UNION ALL
SELECT 'FO4.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM V$INSTANCE_at_FO4.WORLD,V$DATABASE_at_FO4.WORLD UNION ALL
SELECT 'FO5.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM V$INSTANCE_at_FO5.WORLD,V$DATABASE_at_FO5.WORLD ORDER BY 1)
WHERE BD(+)=DB_LINK
ORDER BY 2;

--
http://www.freelists.org/webpage/oracle-l