Re: database link

Hi Sybrand,

thanks to your help it works now!
All I had to do was to update table global_name from 'ORACLE.WORLD' to 'TEST_1.WORLD' respectively 'TEST_2.WORLD' on the remote DB.

Updating the init.ora file was not necessary.

Thank you and have a nice day, Michael

In article <928170457.20537.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Hi Michael
> The global name of the remote database is oracle.world
> you are using global_names = true in your init.ora
> In this case the name of the database link MUST equal the name of the
> database.
> If you set global_names to false (which in your case seems the way to
go)
> Oracle doesn't check. Probably the global name of both your databases
is
> oracle.world and then using global_names=true they will never connect
until
> you change the global name of one of them.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> michael_georg_at_my-deja.com wrote in message
<7itv06$ck8$1_at_nnrp1.deja.com>...
> >I hope someone will help me to solve my problem:
> >
> >I´d like to create a database link between two personal 8 databases
on
> >two different NT servers.
> >
> >I have registered them as test_1.world and test_2.world name_services
in
> >Net8 easy config.
> >
> >user scott created a database link as follow:
> >
> >create database link test_2.world connect to scott identified by
tiger
> >using 'test_2.world';
> >Database link created.
> >
> >When scott tries to query table emp_at_test_2.world I always get
following
> >error message:
> >
> >ERROR:
> >ORA-02085: database link TEST_2.WORLD connects to ORACLE.WORLD
> >
> >
> >I know this problem has something to do with the default domain in
> >global_name but I dont know what to do.
> >
> >Please give me some hints!
> >
> >Thank you, Michael
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 01 1999 - 04:19:06 CDT