Public Database link connected from a sys user
707714Jun 18 2009 — edited Jun 19 2009folks,pls aplogise me if this is a silly ques...
I am creating a public database link connected via "sys" user(sysdba role) on the source db
I am NOT using "connect to" clause and hence the default connected user "sys" will be taken out for connecting
sys users across both the source and target db have same password
Now,when I query select * from dual@linkname
from the source database ,it doesnt work..why?
Also tried connecting from a different user,same issue.
Error returned:
SQL> select * from dual@db4_jpnprd ;
select * from dual@db4_jpnprd
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DB4_JPNPRD
Please assist..as it's quite urgent..thnx