DBLINK ISSUE
From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Thu, 24 Mar 2011 10:27:19 +0530
Message-ID: <AANLkTi=hvP3yjvQzWEBBv0Ra8U0M+tSxHmkWctiz5=vE_at_mail.gmail.com>
Hello Gurus,
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
Date: Thu, 24 Mar 2011 10:27:19 +0530
Message-ID: <AANLkTi=hvP3yjvQzWEBBv0Ra8U0M+tSxHmkWctiz5=vE_at_mail.gmail.com>
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 Wed Mar 23 2011 - 23:57:19 CDT