OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » help to me

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

help to me [message #68282]

Wed, 05 March 2003 22:55

k.subbu
Messages: 2
Registered: March 2003

Junior Member

1* create public database link hr_link connect to scott identified by tiger using 'orcl'
SQL> /

Database link created.

SQL> select * from emp@hr_link;
select * from emp@hr_link
*
ERROR at line 1:
ORA-02085: database link HR_LINK.US.ORACLE.COM connects to DATA.US.ORACLE.COM

Report message to a moderator

Re: help to me [message #68283 is a reply to message #68282]

Thu, 06 March 2003 06:12

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

Senior Member
Account Moderator

1. first make sure ur tnsconnectString 'orcl' is working fine.. by testing through sqlplus.
2. convention is to create a dblink with same Name as
   connect string.
3. and
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

Previous Topic:	backup/recovery plan for remote database
Next Topic:	Solution to DBA Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:22:37 CST 2024