RE: ??? strange database link problem

From: Narender Akula <narender.akula_at_terralinkltd.com>
Date: Wed, 16 May 2001 21:19:38 -0700
Message-ID: <F001.00305BC5.20010516203622@fatcity.com>

hi andrea,
create using connect_data as in Tnsnames.ora.

create database link test connect iccssowner indentified by icssowner using '(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(Host = XYZ)(Port = 1521))

    )(CONNECT_DATA = (SID = ORCL)))' then test...
select sysdate from dual_at_test;
HTH
reg
naren
ORACLE DBA
-----Original Message-----
Sent: Thursday, May 17, 2001 3:31 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I tried to create a database link like this:

create database link test connect icssowner identified by icssowner using 'AU40CNV';

when I used it, I got:
ERROR at line 1:
ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why?

Thanks

Andrea

---

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andrea Oracle
  INET: andreaoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Narender Akula
  INET: narender.akula_at_terralinkltd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 16 2001 - 23:19:38 CDT