Re: DBlink errors

Posted by satish on Aug 03, 2020; 10:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DBlink-errors-tp8543p8545.html

We have added these parameters in 12.2 database

When we tried to connect with dblink,we are facing below error but the password is correct

SQL> drop database link APPS_TO_UATNEW;

Database link dropped.

SQL> create database link APPS_TO_UATNEW connect to "system" identified by "pass" using '10.0.5.0:1521/CATSTG';

Database link created.

SQL> select sysdate from dual@APPS_TO_UATNEW;
select sysdate from dual@APPS_TO_UATNEW
                         *
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from APPS_TO_UATNEW


Please suggest