Re: DBLINK ISSUE

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Thu, 24 Mar 2011 10:55:27 +0530
Message-ID: <AANLkTikHqQ6TYGizR8bknxXxDFVXE_eT7XqzggSPVgbQ_at_mail.gmail.com>

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_at_vanzanen.com> 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_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:25:27 CDT