Re: problem with CREATE DATABASE LINK

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Thu, 21 Dec 2000 05:40:29 GMT
Message-ID: <91s54d$el2$1@nnrp1.deja.com>

In article <91qf54$54$1_at_nnrp1.deja.com>,   tshbedford_at_my-deja.com wrote:
> In article <91q9ch$res$1_at_nnrp1.deja.com>,
> Lev Smirnov <leo_at_dionis.sura.com.ru> wrote:
> > In article <91q67a$pa9$1_at_nnrp1.deja.com>,
> > tshbedford_at_my-deja.com wrote:
> > > In article <91q51k$og6$1_at_nnrp1.deja.com>,
> > > Lev Smirnov <leo_at_dionis.sura.com.ru> wrote:
> > > > In article <91q3co$n9r$1_at_nnrp1.deja.com>,
> > > > tshbedford_at_my-deja.com wrote:
> > > > > Hi,
> > > > > I must be doing something stupid. I can access a table on
 another
 PC
> > > > > from SQL*Plus by typing 'connect scott/tiger @OtherPC'.
 Then 'SELECT
 *
> > > > > FROM tablename' shows the expected results.
> > > > > I want to do a search of a table on my PC with data taken from
 the
 table
> > > > > on the other PC but I can't get a link to work. I can only
 ever
> > > > > seem to be connected to one database or the other. Typing
 CREATE
> > > > > DATABASE LINK linkname USING 'connect scott/tiger @OtherPC'
 says
 the
> > > > > link is created but doing a 'SELECT * FROM tablename_at_linkname'
 it
 says
> > > > > ORA-12154 :TNS:could not resolve service name.
> > > > >
> > > > > I'm an Oracle newbie, could someone tell me exactly what's
 wrong.
 Is
> > > > > anything to do with both Oracle copies being Personal Edition?
> > > > >
> > > > > thanks,
> > > > >
> > > > > Tim
> > > > >
> > > > > Sent via Deja.com
> > > > > http://www.deja.com/
> > > > >
> > > > Try this:
> > > > CREATE DATABASE LINK linkname CONNECT TO scott IDENTIFIED BY
 tiger
> > > > USING OtherPC.
> > > >
> > > > If the GLOBAL_NAMES parameter is set to TRUE, linkname should
 matches
> > > > the global name of your remote database.
> > > >
> > > > Lev Smirnov
> > > > Brainbench MVP for Oracle Admin
> > > > http://www.brainbench.com
> > > >
> > > > Sent via Deja.com
> > > > http://www.deja.com/
> > > >
> > > How do I find out what GLOBAL_NAMES is set to? And how do I change
 it?
> > > Both databases have the default ORCL name. Surely that can't be
 the
> > > problem.
> > > I tried the '.....USING otherPC' command but get back 'Not
 connected'.
> > >
> > > Tim
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> > If you can select from v$parameter view then:
> >
> > SELECT value FROM v$parameter WHERE name='global_names';
> >
> > or you can check your initORCL.ora file.
> >
> > Lev Smirnov
> > Brainbench MVP for Oracle Admin
> > http://www.brainbench.com
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >

>

> I can't. And gloabl names isn't mentioned in initORCL.ora.
> Is the view literally called "v$parameter"

>

> Tim

>

> Sent via Deja.com
> http://www.deja.com/

>
Are your sure you can connect to 'OtherPC' from SQL*Plus by typing 'connect scott/tiger @OtherPC' from your Oracle server (not from your workstation)? 'OtherPC' should be set correctly in TNSNAMES.ORA file on the server where you create database link.

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 23:40:29 CST