SQL> create database link dblink1
2 connect to hr identified by hr
3 using 'rcat';
Database link created.
SQL> select salary from employees@dblink1 where employee_id=100;
select salary from employees@dblink1 where employee_id=100
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DBLINK1
SQL> select salary from employees@dblink1 where employee_id=100;
select salary from employees@dblink1 where employee_id=100
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DBLINK1
SQL> conn hr/oracle_4U
Connected.
SQL> select salary from employees@dblink1 where employee_id=100;
select salary from employees@dblink1 where employee_id=100
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DBLINK1
Warning: You are no longer connected to ORACLE.
SQL> conn hr/oracle_4U
Connected.
SQL> select salary from employees@dblink1 where employee_id=100;
select salary from employees@dblink1 where employee_id=100
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DBLINK1