>> >but not the same as Pierre HIRTH's last post.
>> >First excuse me for my bad English language
>> >Always two data bases :
>> >The first one on Oracle 8.0.5 SID = ORCL and hosted by
>> >machine1.my_domain
>> >The second one on Oracle 8.1.7 service name = trieves hosted by
>> >machine2.my_domain
>> >SQL> create database link orcl connect to user1 identified by pass1
>> > 2 using 'orcl';
>> >Lien de base de donnes cr. (Database link created)
>> > *
>> >ERREUR la ligne 1 : (Error at line 1 :)
>> >ORA-02085: lien de base de donnes ORCL.US.ORACLE.COM se connecte
>> >ORCL.WORLD
>> > (database link ORCL.US.ORACLE.COM is connecting to
>> >ORCL.WORLD)
>> >Whereas in the same SQLplus windows
>> >Connect. (connected)
>> >SQL> select * from departement where num_dpt=4;
>> > NUM_DPT NOM_DPT
>> >---------- ----------------------------------------
>> > 4 Hautes Alpes
>> >Same problem, if the database link is created public
>> >The DB_DOMAIN parameter is set to my_domain.
>> >world is the value of NAME.DEFAULT_ZONE in sqlnet.ora file
>> >Could someone tell me why the database link tries a connection to
>> >US.ORACLE.COM when this string is not in the Oracle parameters and it is
>> >possible to connect to orcl ? (Obviously Tnsnames.ora seems right)
>> >Thanks in advance.
>> >R. Burnet.
>> I do not know the exact answer to your question, but I do know how I fixed
>> basically the same error in my 8.1.7 test db. Add the domain name,
>> my_domain, to the Net 8 alias in the database link, orcl.my_domain, and
the
>> tnsnames.ora entrty should also include the domain name. This should
>> eliminate the error.
>> -- Mark D. Powell --
>> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web
-----
>> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
>> NewsOne.Net prohibits users from posting spam. If this or other posts
>> made through NewsOne.Net violate posting guidelines, email
Quote:>Thanks for your reply, but the problem is the same.
>But I have done a mistake in the password in the database link creation,
>and when I send a select command this is the new error message :
>*ERROR at line 1:
>ORA-01017: invalid username/password; logon denied
>ORA-02063: preceding line from machine2.my_domain
>This new message seems to mean that the remote database was reached
>since the logon is denied. So I don't understand why the database is not
>responding when the password is correct.
I just tested a link from an 8.1.7 database to an 8.0.5.2 on the same machine
and to an 8.5.2.1 on a remote machine and they work fine. I have also tested
a link running from 8.0.5 to 8.1.7 and it worked so maybe you should delete
all the objects involved and recreate them. In the process perhaps you will
fix whatever is wrong. If it still is wrong you will either need to post all
the related code for another set of eyes to spot the problem or it could be
time to talk to support. Good luck.
-- Mark D. Powell --
----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
by