Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with domain name in global_name and database links

user501988Apr 7 2006 — edited Apr 8 2006
I have to create a database link on Oracle 9i **without** a domain. Somehow whenever I create a database link, a domain is added. This domain seems to be the domain that is also added to the database global name (and is the same as my TCP/IP domain on my windows machine).

I tried to create the db link:

create database link "TEST"
connect to remotedb
identified by mypassword
using 'myservicename';

and get:

TEST.DOMAIN.COM instead of TEST.

I also tried to change my database global name:

alter database rename global_name to NEWNAME

and still the database name is NEWNAME.DOMAIN.COM

So there does not seem to be any way to remove the domain.

Note that:
- db_domain is not set in init.ora
- names.default_domain is not set in sqlnet.ora
- global_names = false

So... how to get rid of the domain part?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2006
Added on Apr 7 2006
2 comments
548 views