Hi Patrice, why don't you try to test the link itself The error message will tell you , for example ORA-02019 (See ORA-02019.ora-code.com): says wrong conection description, or whatever it is.
declare x number :=0; begin execute immediate( 'select 1 from sys.dual@(protected)' ) 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@(protected)> 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 >
