Re: database link with oracle8 when there is a global database name!

You can't...
The complete story is this:
If you are using the global names facility (global_names = true in init.ora) then the database link MUST have the same name as the global database name. This is beneficial, because in this setup connections are transparent as long as the same users exist with the same password. So either turn global_names off (which I wouldn't do if I would have a true global database name, using a dns domain instead of .world) or change the linkname.

Hth,

Sybrand Bakker, Oracle DBA

Ben Heuer <queerczarNOquSPAM_at_unforgettable.com.invalid> schreef in berichtnieuws 1b01f9f8.95a44983_at_usw-ex0102-084.remarq.com...
> hello all,
>
> i have been rooting my hair with this one.
>
> ok, until now, whenever i wanted to create a database link
> between 2 instances, i would use the service name of the connect-
> to database as the USING parameter.
>
> for example, lets say i have two databases:
>
> db1
> db2
>
> my tnsnames.ora looks like this:
>
> db1 {blah blah...SID=db1serv}
> db2 (blah blah...SID=db2serv}
>
>
> so the service names of the 2 databases are db1, db2
> respectively. the SID names of both the databases are db1serv
> and dbserv2 respectively.
>
> now i want to create a link from db1 to db2. here is what i use:
>
> --------------------------------------------------------------
> create public database link my_link
> connect to username identified by password using 'db2serv2'
> --------------------------------------------------------------
>
>
> this has worked for me in the past, but now i keep getting ORA-
> 02085 errors (database link name should be the same as the
> database name!!!
>
> why?
>
> after some investigation i found that the one main difference
> between all my previous instances (where i created database
> links successfully) and the new instances (where i am having
> problems) is that:
>
> the new instance was set up with a global database name.
>
> what can i do if i want the database link name to be diff from
> the SID and the global database name or whatever that is!!
>
> pls help..
>
> thanks,
> ben
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Sat Apr 15 2000 - 00:00:00 CDT