Re: DBLINK ISSUE

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 24 Mar 2011 16:19:50 +1100
Message-ID: <AANLkTinBZwLbCSoJTxOyZiCQ=cHkC4CfPYxYWvtmrAnZ_at_mail.gmail.com>

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_at_gmail.com> 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_at_vanzanen.com>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_at_gmail.com>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_at_B.pln.gar.com;
>>> 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_at_B.pln.gar.com;
>>> select * from dual_at_B.pln.gar.com
>>> *
>>> ERROR at line 1:
>>> ORA-01017: invalid username/password; logon denied
>>> ORA-02063: preceding line from B
>>>
>>> -Naga
>>>
>>>
>>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 24 2011 - 00:19:50 CDT