Re: Hopefully stupid db link question

Thanks for the help.

As I said I thought it was a stupid question. I've only just taken over the db from someone else, and stupidly assumed that they had got everything correct, but after checking teh server tnsnames files, I found that they only referenced themselves.

Thanks again

Bryan

In article <WgId6.633$i54.900262_at_newsr1.u-net.net>,   "RS" <rs_at_rshome.u-net.com> wrote:
> Bryan,
>
> First of all, does the TNSNAMES.ORA file on the database server
 itself have
> the same entries as shown below. It may be that the client (if you
 are using
> one) machine has them but not the server.
>
> Secondly, just a hunch, but try putting '.WORLD' on then end of your
 'using'
> string, this may be need to qualify the connection, depending on what
> settings are in the SQLNET.ORA file.
>
> Also, do you have global_naming turning on in your init.ora file ?
>
> Hope this helps,
>
> RS
>
> <mundayb_at_my-deja.com> wrote in message news:955ae0
 $2ij$1_at_nnrp1.deja.com...
> > Hi,
> >
> > Hopefully I am just making an elementary mistake, but I can't seem
 to
> > find it. I'm trying to create a dabatase link, and even though it
> > appears as though the link is created, when I try to use it I keep
> > getting a 12154 TNS:could not resolve service name error.
> >
> > My tnsnames.ora file contains:
> > CT42A.WORLD =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = p3apbtk3)(PORT = 1521))
> > (CONNECT_DATA = (SID = ct42))
> > )
> > CT42JTEST1.WORLD =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = ct42jtest)(PORT = 1521))
> > (CONNECT_DATA = (SID = ct42))
> > )
> >
> > and I've been using the syntax
> >
> > create public database link ct42a
> > connect to USERNAME identified by PASSWORD
> > using 'CT42A';
> >
> > Does anyone have any ideas what;s wrong. I can connect to both
> > databases without any trouble using SQL+ and Net*.
> >
> > Thanks in advance
> >
> > Bryan
> > bryan.munday_at_parexel.com
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 30 2001 - 23:58:29 CST