Re: DB link testing
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: shrekdba@xxxxxxxxx
- Date: Mon, 23 Jul 2007 08:46:44 -0400
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@xxxxxxxxx,V$DATABASE@xxxxxxxxx
UNION ALL
SELECT 'FO1.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM
V$INSTANCE@xxxxxxxxx,V$DATABASE@xxxxxxxxx
UNION ALL
SELECT 'FO2.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM
V$INSTANCE@xxxxxxxxx,V$DATABASE@xxxxxxxxx
UNION ALL
SELECT 'FO3.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM
V$INSTANCE@xxxxxxxxx,V$DATABASE@xxxxxxxxx
UNION ALL
SELECT 'FO4.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM
V$INSTANCE@xxxxxxxxx,V$DATABASE@xxxxxxxxx
UNION ALL
SELECT 'FO5.WORLD' BD, HOST_NAME,INSTANCE_NAME,STATUS,LOG_MODE FROM
V$INSTANCE@xxxxxxxxx,V$DATABASE@xxxxxxxxx
ORDER BY 1)
WHERE BD(+)=DB_LINK
ORDER BY 2;
Other related posts:
