Re: Script to ping all db links

Hi Patrice, why don't you try to test the link itself The error message will tell you , for example ORA-02019: says wrong conection description, or whatever it is.

declare
 x number :=0;
begin
execute immediate( 'select 1 from sys.dual_at_soax.world' ) into x; dbms_output.put_line(x);
exception when others then
dbms_output.put_line(x);
dbms_output.put_line(sqlerrm);
end;

0 not connected 1 connected

On Thu, 10 Feb 2005 16:27:36 -0400, Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca> wrote:
> Does anyone have a script that tnspings all db links to produce a list of
> the invalid ones?
>
> I did one in sqlplus, which hosts to the command line to run tnsping, but
> the output never appears in the spool file.
>
> Patrice.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l