ora-01005 in 9i; not in 8i ?

[khussain]

I connect as "/" to DB1 (9.2.0) (os authentication-no password provided)

In DB1 there is a db_link for DB2 (9.2.0).
I am trying to select from TAB_A in DB2. There is a public synonym in DB1: TAB_B@DB2; I get this error:

ERROR at line 1:
ORA-01005: null password given; logon denied

I know this is because I am connecting as "/" - but why the error ? - it works fine in 8.1.5

What should I look into ???

[nabeel]

Kamran dear try this and see if that solves ya issue

CREATE SHARED DATABASE LINK link2sales
CONNECT TO scott IDENTIFIED BY tiger
AUTHENTICATED BY keith IDENTIFIED BY richards
USING 'sales';

Hope It could be of any help for you.
Regards,