Re: DBLINK ISSUE

  • From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
  • To: Jack van Zanen <jack@xxxxxxxxxxxx>
  • Date: Thu, 24 Mar 2011 10:58:30 +0530

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

Other related posts: