Re: Error 12514

12154 is 'failed to resolve servicename'. This means Oracle can't find linkname either tnsnames.ora _ON THE SERVER_ as database links are handled completely through the server
Your own tnsnames.ora and the tnsnames.ora on the server are not identical. You'll need to correct that.

Hth,

Sybrand Bakker, Oracle DBA

Howling Fang <howling_fang_at_hotmail.com> schreef in berichtnieuws 3904B212.12C878CE_at_hotmail.com...
> I am getting an error that is not documented in the Oracle Help docs.
>
> I get it when I am at my machine running Oracle Client. I use SQL Plus
> to connect to one of our databases, and then use the 'create database
> link' command to another database. It says that the link is
> successfully created.
>
> The db I am linking to has been configured on my machine using Easy
> Config, and I can access it using SQL Plus directly; but, when I try
> and run a select statement on the linked db, I get that stinky error
> message. (Something like: select count(*) from tablename_at_linkname.)
>
> Anyone have any ideas? Is it cuz my machine remote to both the dbs?
>
Received on Mon Apr 24 2000 - 00:00:00 CDT