Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
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
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 DBAReceived on Mon Jun 12 2006 - 15:37:06 CDT