Re: Problem with database link

You might need to make sure your database link name matches the Oracle server you are trying to connect to. This is sometimes necessary depending on how your init.ora is configured.

Also you might need to watch out for case sensativity if you are on a UNIX platform.

AJ

ahsanudm <mdahsan_at_hotmail.com> wrote in message news:7r3uom$a7o$1_at_fizban.pprd.abbott.com...
> Helllo everyone..
> Version : Oracle 8.0.3 on Windows NT 4
>
> I am trying to create a private database link with the following statement
> CREATE DATABASE LINK abcd
> CONNECT TO 'username' IDENTIFIED BY 'password'
> USING 'abcd';
>
> I have a service name called 'abcd' too..but when I try to access a table
> through the database link I get a 12154 error ..i.e ORA-12154: TNS:could
not
> resolve service name.
>
> However I am able to connect to this service from SQL PLUS directly.
>
> I am not sure what I am doing wrong here..Is there any Init parameter
which
> I have to set before using database links..
>
> Any help will be highly appreciated...
>
> Thanks
> Ahsan
>
>
Received on Tue Sep 07 1999 - 20:58:05 CDT