Re: Where is the object (DBLINK) suffix come from?

kin_ng5_at_yahoo.com (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?

Are you sure you are checking the init<sid>.ora on the target server, not on the 'calling' one? It is the global_names setting on the remote server that controls things.   Received on Mon Jul 28 2003 - 15:32:41 CDT