Hi Kin Ng, thanks for writing this:
> "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?
>
Just a thought. Have you looked in your sqlnet.ora for a
names.default_domain entry? You can (usually) find the file in
$ORACLE_HOME/network/admin.
--
[:%s/Karsten Farrell/Oracle DBA/g]
Received on Mon Jul 28 2003 - 15:35:05 CDT
