Re: Connecting to a remote db which has no domain name, but local db has global_names=true

Rob Cowell wrote:
> I can't find anywhere that shows this is possible, but I'll ask just
> incase someone has a whizzy workaround.
>
> I have a 9.2.0.6 database with global_names=true, because we use
> streams and multimaster replication, and they seem to like that.
>
> I want to connect to a remote 9.2.0.6 database which has no domain
> name.
>
> When I create a dblink with the full db name of the remote db it gets
> the domain name from my db appended to it.
>
> All the "solutions" I can find for this involve either setting
> global_names=false, which I could do at a session level for the queries
> that use this dblink, probably via a logon trigger cos the app logs on
> all over the place.
>
> Or I could get a domain name on the remote db. But that's owned by
> another company and they're doing us a favour letting us connect and
> its a pain getting any changes on their db.
>
> But is it possible to create a dblink without turning off global_names
> that will connect to a remote db without a domain_name ?
>
> Thanks

Try this:

select name, value from v$parameter
where name like '%domain%';

On the remote server.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org