-
I created a link from 817 to 805. The remote global_name has db_domain as WORLD;however, the local one(v. 817) db_domain is null. tnsping works fine but the link failed to do a simple desc on a table. Global_name is set to TRUE on both databases. The remote tnsnames entry is
PSTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= estwhp02)(Port= 1521))
(CONNECT_DATA = (SID = PSTEST))
)
On the local, run the followings.
1 create database link PSTEST
2 CONNECT TO SYSADM IDENTIFIED BY PEANUT
3* USING 'PSTEST'
SQL_PSDEV8>/
Database link created.
SQL_PSDEV8>select * from global_name@PSTEST;
select * from global_name@PSTEST
*
ERROR at line 1:
ORA-02085: database link PSTEST connects to PSTEST.WORLD
Any good ideas.
Thx.
goodhealth
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|