Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting to a remote db which has no domain name, but local db has global_names=true

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 12 Jun 2006 22:37:06 +0200
Message-ID: <40kr8255g5u0gb531ef4r55gikjfbpv4cs@4ax.com>


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
Received on Mon Jun 12 2006 - 15:37:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US