Re: DB links on Oracle 8.1.7 EE

Don't start the trial and error method, but set trace on. This is a parameter in SQLNET.ORA, something_TRACE_LEVEL I think. Then start plowing through the sqlnet.trc file until you find the error and the cause.

Jaap.

On Fri, 29 Mar 2002 13:46:25 +0100, "Robert Reich" <reich_at_poh.cz> wrote:

>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 - 16:28:19 CST