DB links on Oracle 8.1.7 EE

From: Robert Reich <reich_at_poh.cz>
Date: Fri, 29 Mar 2002 13:46:25 +0100
Message-ID: <3ca46251$1@news.mhogaming.com>

Hi Everyone
I exported user schema which uses db links from one 8.1.7 database to another 8.1.7 database. Link names are not SIDs and doesn't use global naming which is false at both databases. Source link is OK with name ORA_VHDCV.WORLD. Destination link is OK with name ORA_VHDCV. SQLNET.ORA files are the same:

TRACE_LEVEL_CLIENT = OFF
NAME.DEFAULT_ZONE = world
NAMES.DEFAULT_DOMAIN = world
AUTOMATIC_IPC = ON
SQLNET.EXPIRE_TIME = 1
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) Aliases in TNSNAMES.ORA are also in form <alias>.<domain> and are the same.

if I try to connect to destination DB when DB link is ORA_VHDCV.WORLD and try select:
select * from v$instance_at_ora_vhdcv;
error ORA-02019 connection description for remote database not found is generated.
When alias is ORA_VHDCV all is OK.
Where is problem. Thanks a lot.

Robert Received on Fri Mar 29 2002 - 06:46:25 CST