SQL> select password from dba_users where username='TEST; PASSWORD ------------------------------ EXTERNAL On Thu, Mar 24, 2011 at 10:55 AM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote: > Your right Jack. As you said password for "zing" is same on both > enviroments. Now i want to access the dblink as "test" user which is > identified by externally on both enviroments. I could not able to connect > the dblink as "test" user which is a external user. > > -Naga > > On Thu, Mar 24, 2011 at 10:49 AM, Jack van Zanen <jack@xxxxxxxxxxxx>wrote: > >> Then the passwords for the users between the 2 environments most likely >> don't match for the other users. zing user has same password in both >> environments >> >> >> Jack van Zanen >> >> ------------------------- >> This e-mail and any attachments may contain confidential material for the >> sole use of the intended recipient. If you are not the intended recipient, >> please be aware that any disclosure, copying, distribution or use of this >> e-mail or any attachment is prohibited. If you have received this e-mail in >> error, please contact the sender and delete all copies. >> Thank you for your cooperation >> >> >> On Thu, Mar 24, 2011 at 4:08 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx>wrote: >> >>> yes it was set up to use the current credentials. However "zing" user >>> able to access the link were as other users getting error. >>> >>> -Naga >>> >>> On Thu, Mar 24, 2011 at 10:37 AM, Jack van Zanen <jack@xxxxxxxxxxxx>wrote: >>> >>>> Was the link possibly setup so that the current credentials are used? >>>> >>>> >>>> Jack van Zanen >>>> >>>> ------------------------- >>>> This e-mail and any attachments may contain confidential material for >>>> the sole use of the intended recipient. If you are not the intended >>>> recipient, please be aware that any disclosure, copying, distribution or >>>> use >>>> of this e-mail or any attachment is prohibited. If you have received this >>>> e-mail in error, please contact the sender and delete all copies. >>>> Thank you for your cooperation >>>> >>>> >>>> On Thu, Mar 24, 2011 at 3:57 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx>wrote: >>>> >>>>> Hello Gurus, >>>>> >>>>> DBLINK is working for one particular user, were as it is not working >>>>> for other users. Kindly help me to sort out the problem >>>>> >>>>> >>>>> SQL> select name from v$database; >>>>> NAME >>>>> --------- >>>>> A >>>>> SQL> show user >>>>> USER is "zing" >>>>> SQL> select * from dual@xxxxxxxxxxxxx; >>>>> D >>>>> - >>>>> X >>>>> where as if i select as sys or any other user i am getting below error >>>>> SQL> connect / as sysdba >>>>> Connected. >>>>> SQL> select * from dual@xxxxxxxxxxxxx; >>>>> select * from dual@xxxxxxxxxxxxx >>>>> * >>>>> ERROR at line 1: >>>>> ORA-01017: invalid username/password; logon denied >>>>> ORA-02063: preceding line from B >>>>> >>>>> -Naga >>>>> >>>>> >>>>> >>>> >>>> >>> >> >