Re: DBLINK ISSUE

  • From: Jack van Zanen <jack@xxxxxxxxxxxx>
  • To: Nagaraj S <nagaraj.chk@xxxxxxxxx>
  • Date: Thu, 24 Mar 2011 16:19:50 +1100

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
>>>
>>>
>>>
>>
>>
>

Other related posts: