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@xxxxxxxxxx' ) 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@xxxxxxxxxxxxxxxxx> 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

Other related posts: