Re: Excessive ORA-2019 After Migration to 7.3.4.0

Error 2019 -

create synonym abcd for dual_at_pqrs;

• where I have not created a database link pqrs

select * from abcd

ERROR at line 1
ORA-02019: connection description for remote databsae not found

It looks as if some piece of your code is trying to use a database link name that does not exist in your database. Has someone been tidying up your db_links, or changing the security access to them ?

A bit of a heavy solution, but try putting the database into sql_trace mode for a while, and the look through all the trace files for error 02019 and examine the SQL statement that owns the error.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ann Burk wrote in message ...
>I get constant error message ORA-02019 in the alert file. I added an event
>for this message per
>our wonderful Oracle Support which caused my instance to become disabled.
I
>then sent the trace
>produced by the trace to Oracle Support and they could find nothing in the
>trace to tell me which of my
>~100 links is causing the problem. They had the nerve to tell me that
>applying the 7.3.4.3 patch MIGHT
>solve the problem or at least produce a useful dump.
Received on Fri May 14 1999 - 10:42:25 CDT