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

DA Morgan wrote:
> Sybrand Bakker wrote:
> > On Mon, 12 Jun 2006 12:14:02 -0700, DA Morgan <damorgan_at_psoug.org>
> > wrote:
> >
> >> Try this:
> >>
> >> select name, value from v$parameter
> >> where name like '%domain%';
> >>
> >> On the remote server.
> >
> >
> > Daniel,
> > In my experience the db_domain parameter is used to determine the
> > global database name at creation time, and subsequent changes are
> > ignored, if you don't issue alter database rename global_name to etc.
> >
> > The op needs to have the global_name(s?) view at the remote server.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> Agreed.
> --
> 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

I probably didn't explain myself very well. db_domain is not set on the remote server, and because that db is not controlled by my company we can't get one set up easily. I was looking for a way to connect to that database via a dblink while I have global_names=true on my db. Received on Tue Jun 13 2006 - 04:16:08 CDT