Where is the object (DBLINK) suffix come from?
Kin Ng
the dblink name. Where is this suffix come from and how can I get rid
of it?
Thanks for any help.
NetComrade
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Jack Wang
"Kin Ng" <kin...@yahoo.com> wrote in message
news:d5b3f600.03072...@posting.google.com...
Sybrand Bakker
"Jack Wang" <nos...@nospam.com> wrote in message
news:U1XTa.28921$xn5.4...@news0.telusplanet.net...
NO, several features don't work using global_names = false
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
Quarkman
And the consequences of doing this would be....??
Why don't you try and help the guy actually resolve the issue (which is a
global database name error) rather than come up with whizz-kid quick-fixes
which cause untold problems later down the line??
To the original poster: look in the documentation, or on google archives,
as to how you rename your global database name. You didn't specify one when
you created the database, and Oracle has thoughtfully provided a default.
~QM
Lamjed
i have the same probleme , my solution is :
create database link Mylinkname connect to MynameUser identified by
Mypassword using '(DESCRIPTION=(ADDRESS=
(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=y))(CONNECT_DATA=(SID=MySID)))'
exemple of my use:
select Orders_Num from Orders@Mylinkname where Orders_Date
>to_date('01/01/2003');
Lamjed
"Kin Ng" <kin...@yahoo.com> a écrit dans le message news:
d5b3f600.03072...@posting.google.com...
Sybrand Bakker
wrote:
>hi,
>i have the same probleme , my solution is :
>create database link Mylinkname connect to MynameUser identified by
>Mypassword using '(DESCRIPTION=(ADDRESS=
>(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=y))(CONNECT_DATA=(SID=MySID)))'
>
>exemple of my use:
>
>select Orders_Num from Orders@Mylinkname where Orders_Date
>>to_date('01/01/2003');
>
>Lamjed
Perfect solution if you ever move the database from one host to
another. Never use hardcoded IP addresses. Why do you think DNS and
the hosts file was invented?
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
Kin Ng
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?
TurkBear
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.
Karsten Farrell
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]
Ana C. Dent
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.
Kin Ng
> It is the global_names setting on the remote server that controls things.
According to this:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/ds_admin.htm#20696
and actual experience, it is the local global_name that controls the
dblink's domain. This is strange as usually dblink links to another
domain. But that's how it works. But you can name your dblink anyway
you want as long as it has a domain name. The problem in my case is
my destination DB has no domain name and I can't make my dblink name
without a domain name.
Kin Ng
> names.default_domain entry? You can (usually) find the file in
> $ORACLE_HOME/network/admin.
I did check that and it was defaulted to my network's domain. But my
db (9.2 personal edition for testing only) has us.oracle.com as my
domain for the global_name. This is strange in itself.
Kin Ng
http://asktom.oracle.com/pls/ask/f?p=4950:8:3066530269688824203
In short, if you don't have 'global_names' checking enabled, you can
just use the DBLINK name with or without the domain. i.e.
select * from dual@dblink[.domain.com]
Though my original question still remains but at least I can get it
working (for testing).