Hi,
On 10g, I create a DB_LINK but does not function :
SQL> CREATE PUBLIC DATABASE LINK REMDB.WORLD USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP)(PROTOCOL=TCP)(Host=Localho
st)(Port=1521)))(CONNECT_DATA=(SID=REMDB)))';
Database link created.
SQL> select count(*) from SCOTT.EMP@REMDB.WORLD;
select count(*) from SCOTT.EMP@REMDB.WORLD
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from REMDB
[/code]
How to authorize sys or other users? SYS has the same password on current DB and remote DB.
Thanks.