Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB links on Oracle 8.1.7 EE
Somehow I remember this relating to the global_names = true|false init.ora
parameter. Try setting the init.ora file's global_names=false and try
again.
"Robert Reich" <reich_at_poh.cz> wrote in news:3ca46251$1_at_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
>
>
>
>
-- ----------------------------------------------------------------------- Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4Received on Fri Mar 29 2002 - 15:39:28 CST