Re: ORA-2019: DBLINK not found (in Ora v8.1.7 on Win2KPro)

Just a thought ( since it happened to me) - Be sure the TNSNAMES.ORA file ON THE SERVER has the correct entries...The database uses this file for resolving DB Links....

"Barry P. Grove" <grovebg_at_istar.ca> wrote:

>Hi,
>
>I must be tired.
>
>I did what appeared to be a successful install of Oracle v8.1.7 on Win2000 Pro
>using the typical install (creating a seed database) on a Dell 620 workstation.
>It has 4 x 18GB 150000rpm HD as single array, 512MB memory, 2 x 933MHz P3.
>Tested database performance by loading a complete PeopleSoft v7.51 HRMS
>export from older Oracle v8.0.4. The .DMP file was 12GB of uncompressed
>data. Impressed with speed of refresh, took just over 4 hours, beating the
>refresh
>time of the Compaq Alpha 4100 servers of over 8 hours.
>
>Now the unhappy part, I created some database links to remote databases that
>I configured using the Net8 Config assistant. I can connect to these databases
>using the names specified in TNSNAMES.ORA, but the database links that
>refer to same are giving me an:
> ORA-02019 error: connection description for remote database not found.
>Meaning that it can't see the link names that I've just created. I can see them
>
>in the DBA_DB_LINKS, USER_DB_LINKS, but it's as if the database can't
>see them. I can drop the links, recreate, no problem. But Oracle can't see
>them.
>
> create database link pshrms connect to userid identified by password using
>'name';
>ok.
> select * from ps_job_at_pshrms where rownum<=2;
>ORA-02019 error:
>
>Rechecked Win2000 installation notes, searched Oracle, and can't
>find anything about this.
>
>What incredibly obvious thing am I missing? Any ideas out there?
Received on Wed Jan 24 2001 - 13:12:38 CST