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
(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'
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.
Click Here to Expand Forum to Full Width