OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » database link

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database link [message #66444]

Thu, 13 June 2002 19:34

lyg
Messages: 2
Registered: February 2002

Junior Member

create database link lyg
connect to scott identified by tiger
using 'ora816';

select * from cat@lyg;

ORA--02085

WHY? HOW?

Report message to a moderator

Re: database link [message #66445 is a reply to message #66444]

Fri, 14 June 2002 08:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Hi,

You have to set global_names to false. did u do that?

SQL>ALTER SESSION SET global_names = false;

You can also set this in initSID.ora.

Report message to a moderator

Re: database link [message #66448 is a reply to message #66444]

Sun, 16 June 2002 11:20

K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore

Senior Member

SIR

i read your message.no problem .it is quite
easy.
i am giving one example for you.

for example take the first database
(
sid=orcl
database name=oracle
db_domain=uk.com
host string=ss1
)

first edit the parameter file for the following

db_domain=uk.com

then start the database

In the svrmgr30.exe or sqldba execute this command

alter database rename global_name orcl.uk.com;

(name should be sid.db_domain)
then you execute this command

select * from global_name;

then you got the global database name for that
database like

orcl.uk.com

then go to the second database

(sid=tan
databasename=tani
db_domain=usa.com
host string=ss2
)

edit the parameter file for that database
db_domain=usa.com

start the database

execute this command in the svrmgr30 or sqldba

alter database rename global_name tan.usa.com;

(if in this server also the sid is orcl
don't worry.but only thing is
you should have different
db_domain parameter in each database)

execute this query

select * from global_name;

tan.usa.com

go to the first database

then create the database link by following

(execute this command in the first database)

create database link tan.usa.com
conect to system identified by manager
using 'ss2';

note :

the database link name should be the global database
name for the another database

if you have any problem ,please mail to me.

regards
k.sreenivasan

Report message to a moderator

Re: database link [message #66701 is a reply to message #66444]

Thu, 07 November 2002 08:11

Coy
Messages: 1
Registered: November 2002

Junior Member

I was having this problem also. Mahesh, your answer was right on target.

Thanks for all your help!

Report message to a moderator

Re: database link [message #66725 is a reply to message #66444]

Wed, 20 November 2002 03:33

Javier González
Messages: 1
Registered: November 2002

Junior Member

T you very much, this was getting my crazy about a few weeks and this solution is so simple and effective: nice ;-).

The Mayor Rule for the IT people is:
To get the maximun with the minimun

Report message to a moderator

Re: database link [message #66842 is a reply to message #66444]

Fri, 31 January 2003 14:48

kamosa
Messages: 1
Registered: January 2003

Junior Member

Thank you, Thank you, the "ALTER SESSION SET global_names = false;" was exactly what I needed to fix the problem.

Report message to a moderator

Previous Topic:	Re: Where can I download SQL*Net/Net8?
Next Topic:	ORA-12154:TNS:Could not resolve service name.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 02:30:08 CST 2025