Question about Database link

airlily

Hi All,

I have two databases, DB1 is installed on the HP-UX V11i and DB2 is installed on the W2K ADV SERVER SP4.

If I connect to DB2 and do:
create database link aaa connect to user identified by password using 'DB1'
I can use this DB link normally.

But if I connect to DB1 and do:
create database link bbb connect to user identified by password using 'DB2'
When I tried to do 'select * from table@bbb', the system returned 'oracle not available'.

Who can tell me why ?

Thanks.

txfy

using 'DB2'  
can you make sure you have make the right network connect string of DB2?the sid or service name of it is right?you should use sqlplus do the test sqlplus username/pwd@db2 first.

airlily

多谢了！是我的DB1的TNS没有建立与DB2的连接。

beryee

hehe