Re: Q: how in hell could i name the links?

Most likely the site you are connecting FROM has the "global_names = true" set in init.ora. This will prevent you creating any database links that do not obey the name scheme "TARGET_INSTANCE_NAME_at_ARBITRARY_QUALIFIER". To help you out, you have two choices in your situation:

1. Shutdown your source instance and startup with "global_names = false".
2. If you don't want to shutdown your database, use the database scheme mentioned above. Example: your target database instance may be named TRGT. Then you create the database link TRGT_at_abc with the usual "connect to", "identified by" and "using" clauses. If you need a second link, you just name it TRGT_at_blabla and so on. Worked fine for me.

Designer/2000, however, is using its own naming scheme. Therefore, you must use solution 1). That means, the database holding your repository must be started with "global_names = false". Oracle support explained this to me.

Martin Haltmayer

Uldis Pavuls wrote:
>
> Hi,
>
> What is rules to name dblinks. Sometimes there is your choice, but sometimes
> not. What does it mean : "ORA-02085: database link CDRF_LINK.WORLD connects
> to NT_KONTS.WORLD" (BTW, real message, and "konts" there has nothing common
> with possible English associations, somebody hadn' t the right dictionary in
> right moment, that's all, sorry). Well, please, without RTFM, i've already.
> Sorry, there's nothing plain there (except advice to use Network Manager -
> BTW, i have already some time ago, and outcome never works without manual
> corrections). From one side seems you could name link as you need and it
> works fine, from another - you could run into msg above in less desired
> moment. As this is. See, it's from DESIGNER/2000 and the name of the link
> seems hard coded, but it's reverse engineering, and there may be different
> databases as source ... I don't believe i should change database names every
> time i need to make a link. Could some guru explain where i'm wrong?
> What's about environment, it's Oracle 7.3.3 Enterprise under Solaris 2.6 and
> Oracle 7.3.2 under NT4.
> Any suggestions?
>
> TIA,
> Uldis Pavuls
> DBA
> U.Pavuls_at_konts.lv
Received on Sat Feb 14 1998 - 00:00:00 CST