I'm having a problem creating a db_link on a WIN2K machine with Oracle 8.1.6. When I create it using the following SQL:
CREATE DATABASE LINK dw_link
CONNECT TO dw1 IDENTIFIED BY dw1
I get the following error when I try to access it:
select count(*) from user_tables@dw_link;
ORA-02085: database link DW_LINK.LARRY connects to ORCL.LARRY
LARRY is the machine name that I'm doing this on. The Tnsnames.ora file has the following entry for ORCL:
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT=1521)))
(CONNECT_DATA = (SERVICE_NAME = orcl)
I don't encounter a problem when I do the same thing on solaris.
Thanks in advance!
// *Cause: a database link connected to a database with a different name.
// The connection is rejected.
// *Action: create a database link with the same name as the database it
// connects to, or set global_names=false.
Also, I would suggest , try establishing a normal connection and make sure that your connection is perfect. Then, check your database nameing convention and make sure you have done it correctly.
Life is a journey, not a destination!
Thanks for the help! Changing global_names to false worked. When I looked up the error message online, it dodn't mention that.
If you want to use global_names=true for another purposes,
the name of your link [dw_link] must match the name of the USING 'ORCL', so name the link with thee exact USING string(ORCL).
[QUOTE][i]Originally posted by m_d_marian [/i]
[B]If you want to use global_names=true for another purposes,
the name of your link [dw_link] must match the name of the USING 'ORCL', so name the link with thee exact USING string(ORCL). [/B][/QUOTE]
No, it is a litle bit different. If GLOBAL_NAMES=TRUE, what has to be the same as the remote database name is the *db link name*, not what you specify in the USING part of the db link creation command.
So if global name of your remote database is "ORCL.acme.com", and your local db server tnsnames.ora entry for that remote database is named "REMOTE_DB", your create db link command should be:
CREATE DATABASE LINK orcl.acme.com CONNECT TO user_a IDENTIFIED BY pwd_a USING 'remote_db';
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width