Kin Ng wrote:
> "Jack Wang" <nospam_at_nospam.com> wrote in message news:<U1XTa.28921$xn5.4636499_at_news0.telusplanet.net>...
>
>>set global_names = false in init.ora
>>
>>"Kin Ng" <kin_ng5_at_yahoo.com> wrote in message
>>news:d5b3f600.0307241113.43baa05a_at_posting.google.com...
>>
>>>When I created a DBLINK, I got US.ORACLE.COM attached to the end of
>>>the dblink name. Where is this suffix come from and how can I get rid
>>>of it?
>>>
>>>Thanks for any help.
>
>
> I have tried ALL the suggestions and still I am having problems.
>
> Here's what I have:
>
> -- init.ora has no 'global_names' entry
> -- SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'global_names'
> returns 'FALSE'. Thus no global name checking enforced
> -- SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'db_domain'
> returns empty domain name.
> -- ALTER DATABASE RENAME GLOBAL_NAME To KINDB4 results in the same
> name
> i.e. if it was KINDB4.abc.com, then the result is the same.
>
> Real problem is I can't change the domain name of the database name to
> nothing. I am able to change the domain name to something else. From
> I have read, the DBlink name's domain name comes from the
> Global_name's domain name. Thus I need to change the Global_name to
> get rid of the domain name. But I can't. Any idea?
AFAIK, the "suffix" comes from the GLOBAL_NAME table.
Be aware that if/when you change the value of the GLOBAL_NAME,
more than likely all the DB_LINKS will stop functioning.
This will happen because the DB_LINKS contain the old suffix
which will/does not match the new suffix and therefore will fail.
Received on Mon Jul 28 2003 - 18:36:40 CDT
