Script to ping all db links 2005-02-10 - By Juan Carlos Reyes Pacheco
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
>
--
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
|
|
